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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =16
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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 >= '2022-05-22 03:08:24')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
27件見つかりました
1ページ中1ページ目
1
¥3,630
PUNK DRUNKERS
Shoes
¥3,630
PUNK DRUNKERS
Shoes
¥17,600
KILL STAR
Shoes
¥41,800
glamb
Shoes
¥7,370
RIPNDIP
Shoes
¥5,280
acOlaSia
Shoes
¥19,800
VIRGO
Shoes
¥11,900
acOlaSia
Shoes
26.5cm 残り1点
¥5,280
WASTED PARIS
Shoes
¥15,400
KILL STAR CLOTHING
Shoes
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
¥19,800
KILL STAR CLOTHING
Shoes
28cm 残り1点
¥17,600 → 12,320
Zephyren
Shoes
23cm 残り1点
¥8,140
FILA
Shoes
23.5cm 残り1点
¥10,450
FILA
Shoes
22.5cm 残り1点
¥10,450
FILA
Shoes
¥3,871 → 2,709
Xmas Eileen
Shoes
US 5 (22.5cm) 残り1点
¥10,890 → 7,623
SLEEPING WITH SIRENS x T.U.K. SHOES
Shoes
UK6(25.0) 残り1点
¥15,278 → 10,694
DISTURBIA CLOTHING
Boot
M 残り1点
¥29,480 → 20,636
VIRGO
Shoes
¥3,190 → 2,233
RIP DESIGN WORXX
Shoes
¥19,800 → 13,860
DISTURBIA CLOTHING
Shoes
¥19,800 → 13,860
DISTURBIA CLOTHING
Shoes
24cm 残り1点
¥7,920 → 5,544
KILL STAR CLOTHING
Shoes
25cm 残り1点
¥7,700 → 5,390
KILL STAR CLOTHING
Shoes
23cm 残り1点
¥9,680 → 6,776
KILL STAR CLOTHING
Shoes
23cm 残り1点
¥15,400
DISTURBIA CLOTHING
Shoes
27件見つかりました
1ページ中1ページ目
1
62755 【予約商品】PUNK DRUNKERS 心電図サンダル - BLUE
62756 【予約商品】PUNK DRUNKERS 心電図サンダル - RED
62523 KILL STAR Fall Out Combat Boots
61474 glamb (グラム) Big Sole Sneakers BLACK
60646 RIPNDIP Welcome to Heck Slides (Black/Blue)
60027 acOlaSia ロゴ シャワーサンダル
59224 VIRGO VIRTALIA BRAID KICKS BLACK
54736 acOlaSia “LOT””SKULL”ハイカットスニーカー BLACK
59214 WASTED PARIS Flip Flop Columbia Bridge Black
58354 KILL STAR CLOTHING Crossbones Creepers
57074 SLIGHTLY NUMB×Kappa shoes BLACK
58352 KILL STAR CLOTHING Lock Me Up Boots
45158 Zephyren(ゼファレン)MID CUT SNEAKER BLACK
54220 FILA DISRUPTOR SD BLACK
55655 FILA F0581-3196 DISRUPTOR2 NEW TAPEY TAPE BLACK
46938 FILA F0215-1073 DISRUPTOR2 BLACK
28113 Xmas Eileen ビーチサンダル&ビニールバッグSET BLK
29691 T.U.K. SHOES A9230 Sleeping With Sirens Core
36779 DISTURBIA CLOTHING TRYALS BOOT
40563 VIRGO SNEAKERS SOLE MIDDLE BOOTS ミドルブーツ BLACK
42513 RIP DESIGN WORXX BEACH SANDAL LADIES
42560 DISTURBIA CLOTHING Sweet Jane Shoes
42561 DISTURBIA CLOTHING Violet Shoes
44814 KILL STAR CLOTHING Ceremony Flat [B]
44832 KILL STAR CLOTHING Keiko Kitty Flats [B]
44836 KILL STAR CLOTHING Dark Moon Slides [B]
52551 DISTURBIA CLOTHING Archetype Sneaker
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 16
[color] => 1
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=16&color=1&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 16
[color] => 1
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=16&color=1