SELECT SQL_CALC_FOUND_ROWS p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM dtb_products AS p
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2021-03-09 10:56:06')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 664)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
42件見つかりました
1ページ中1ページ目
1
¥16,060
RIPNDIP
Pullover
¥7,700
RIPNDIP
T-Shirt
¥11,000
RIPNDIP
L/S T-Shirt
¥8,250
RIPNDIP
T-Shirt
M 残り1点
¥5,995
RIPNDIP
T-Shirt
¥17,441
RIPNDIP
Coach Jacket
¥11,990
RIPNDIP
Shorts
S 残り1点
¥17,069
RIPNDIP
Pullover
¥16,060
RIPNDIP
Pullover
¥16,060
RIPNDIP
Pullover
S 残り1点
¥7,241
RIPNDIP
L/S T-Shirt
S 残り1点
¥7,241
RIPNDIP
L/S T-Shirt
フリー 残り1点
¥7,241
RIPNDIP
Cap
フリー 残り1点
¥7,241
RIPNDIP
Cap
フリー 残り1点
¥2,420
RIPNDIP
Socks
¥20,075
RIPNDIP
Jacket
¥22,091
RIPNDIP
Jacket
¥16,060
RIPNDIP
Jacket
¥11,055
RIPNDIP
Shorts
フリー 残り1点
¥7,458
RIPNDIP
Cap
フリー 残り1点
¥3,025
RIPNDIP
Necklace
M 残り1点
¥12,430
RIPNDIP
T-Shirt
¥20,075
RIPNDIP
Jacket
¥7,043
RIPNDIP
T-Shirt
¥7,043
RIPNDIP
T-Shirt
XL 残り1点
¥8,286
RIPNDIP
T-Shirt
¥11,394
RIPNDIP
Shorts
¥12,430
RIPNDIP
Shorts
M 残り1点
¥17,609
RIPNDIP
Pullover
XL 残り1点
¥16,574
RIPNDIP
Pullover
¥8,286
RIPNDIP
T-Shirt
¥8,286
RIPNDIP
T-Shirt
¥17,050
RIPNDIP
Pullover
M 残り1点
¥17,050
RIPNDIP
Pullover
フリー 残り1点
¥2,750
RIPNDIP
Accessory
M 残り1点
¥16,500
RIPNDIP
Pullover
¥12,100
RIPNDIP
Shorts
¥12,100
RIPNDIP
Shorts
S 残り1点
¥9,955
RIPNDIP
Shorts
¥6,078
RIPNDIP
T-Shirt
フリー 残り1点
¥2,420
RIPNDIP
Socks
フリー 残り1点
¥2,420
RIPNDIP
Socks
42件見つかりました
1ページ中1ページ目
1
47650 RIPNDIP RIPNTAIL Hoodie (Black)
55710 RIPNDIP Catch Em All Tee (Blue Spiral Dye)
55712 RIPNDIP Embroidered Logo L/S (Multi)
55713 RIPNDIP Rock & Nerm Tee (Black)
41086 RIPNDIP LORD NERMAL POCKET TEE GRAY
45752 RIPNDIP Boobcuzzi Coaches Jacket (White)
45761 RIPNDIP Peek A Nermal Sweat Shorts (Navy)
47323 RIPNDIP Color Block Multi Panel Hoodie (Multi)
47324 RIPNDIP Rubber Logo Hoodie (Orange)
47325 RIPNDIP Multi Hoodie (White)
47328 RIPNDIP RIPNTAIL L/S (Peach)
47329 RIPNDIP RIPNTAIL L/S (Safety Green)
47340 RIPNDIP Prisma Corduroy 6 Panel (Black)
47344 RIPNDIP RIPNTAIL Corduroy 6 Panel (White)
47349 RIPNDIP Lord Nermal Socks (Royal)
47644 RIPNDIP Nerm Camo Packable Anorak Jacket (Desert Camo)
47645 RIPNDIP Repeat Cotton Twill Jacket (Black)
47647 RIPNDIP Run It Nylon Track Jacket (Watermelon)
47652 RIPNDIP Black Out Nylon Shorts (Black Out Camo)
48320 RIPNDIP Color Block Two Tone 6 Panel (Tan / Burgundy)
48323 RIPNDIP Nerm Camo Lanyard (Choc Chip Camo)
50691 RIPNDIP MBN STRIPE SOCCER JERSEY
50693 RIPNDIP NERM CAMO FANORAK JACKET
50694 RIPNDIP MNB JACQUARD RIB TEE SLATE
50695 RIPNDIP MNB JACQUARD RIB TEE TEAL
50696 RIPNDIP PEEKING NRMAL KNIT TEE LAVENDER
50698 RIPNDIP MNB STRIPE SOCCER SHORTS
50699 RIPNDIP NERM CAMO SWEATSHORTS
50702 RIPNDIP MBN STRIPE HOODIE NEON
50703 RIPNDIP TONAL LOOPBACK HOODIE BLUE
50704 RIPNDIP COLOR BLOCK TEE BLACK
50705 RIPNDIP COLOR BLOCK TEE TAN
52706 RIPNDIP Rock N Nerm Hoodie (Black)
52707 RIPNDIP Catch Em All Hoodie (Multi)
52712 RIPNDIP Catch Em All Lanyard (Multi)
52957 RIPNDIP Catch Em All Hoodie (Tan)
52958 RIPNDIP Peek A Nermal Sweat Shorts (Multi Tie Dye)
52959 RIPNDIP Rock N Nermal Sweat Shorts (Multi)
52960 RIPNDIP Peek A Nermal Sweat Shorts (Black)
52961 RIPNDIP Nermhog Tee (Black)
52966 RIPNDIP Pill Socks (Black Tie Dye)
52969 RIPNDIP Lord Nermal Socks (Navy Speckle)
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => ripndip
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/ripndip/
--------
mb_parse_str
Array
(
[brand_name] => ripndip
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=ripndip&/