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 >= '2021-04-16 07:49:12')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
68件見つかりました
1ページ中1ページ目
1
¥3,850
Zephyren
Shoes
¥3,410
PUNK DRUNKERS
Shoes
¥3,410
PUNK DRUNKERS
Shoes
¥19,800
KILL STAR CLOTHING
Shoes
¥17,600
KILL STAR CLOTHING
Shoes
¥15,400
KILL STAR CLOTHING
Shoes
¥19,800
Zephyren
Shoes
¥19,800
Zephyren
Shoes
¥9,900
RIP DESIGN WORXX
Happy bag
¥9,900
RIP DESIGN WORXX
Happy bag
¥24,200
RIP DESIGN WORXX
Happy bag
24.5cm 残り1点
¥12,100
FILA
Shoes
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
23cm 残り1点
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
¥33,000
MUSIC SAVED MY LIFE
Shoes
¥12,100
FILA
Shoes
28cm 残り1点
¥17,600
Zephyren
Shoes
¥8,140
FILA
Shoes
23cm 残り1点
¥8,140
FILA
Shoes
¥10,450
FILA
Shoes
¥10,450
FILA
Shoes
¥9,900
FILA
Shoes
¥10,450
FILA
Shoes
22.5cm 残り1点
¥10,450
FILA
Shoes
22.5cm 残り1点
¥11,000
FILA
Shoes
¥11,000
FILA
Shoes
26.5cm 残り1点
¥11,000
FILA
Shoes
¥9,900
FILA
Shoes
23.5cm 残り1点
¥9,900
FILA
Shoes
¥9,900
FILA
Shoes
¥4,950
RUDIE'S
Sandal
26.5cm 残り1点
¥14,080
MAGICAL MOSH MISFITS
Shoes
L 残り1点
¥11,900
acOlaSia
Shoes
¥11,900
acOlaSia
Shoes
¥3,871
Xmas Eileen
Shoes
¥3,871
Xmas Eileen
Shoes
US 5 (22.5cm) 残り1点
¥10,890
SLEEPING WITH SIRENS x T.U.K. SHOES
Shoes
UK6(25.0) 残り1点
¥15,278
DISTURBIA CLOTHING
Boot
UK10(28.5) 残り1点
¥16,500
DISTURBIA CLOTHING
Shoes
¥16,500
DISTURBIA CLOTHING
Shoes
¥3,190
ANIMALIA
Shoes
M 残り1点
¥3,190
ANIMALIA
Shoes
¥29,480
VIRGO
Shoes
¥13,200
MOTORHEAD×LAKAI
Shoes
¥3,190
RIP DESIGN WORXX
Shoes
US 4.5 (22.5cm) 残り1点
¥6,050
FILA
Shoes
¥20,350
DISTURBIA CLOTHING
Shoes
¥19,800
DISTURBIA CLOTHING
Shoes
¥19,800
DISTURBIA CLOTHING
Shoes
UK6(25.0) 残り1点
¥20,350
DISTURBIA CLOTHING
Shoes
XL 残り1点
¥25,080
VIRGO
Shoes
US 5 (23cm) 残り1点
¥14,300
MISHKA
US 7 (25cm) 残り1点
¥19,800
MISHKA
¥7,920
KILL STAR CLOTHING
Shoes
25cm 残り1点
¥7,700
KILL STAR CLOTHING
Shoes
23cm 残り1点
¥9,680
KILL STAR CLOTHING
Shoes
23cm 残り1点
¥16,500
KILL STAR CLOTHING
Shoes
¥16,500
DISTURBIA CLOTHING
Shoes
¥16,500
KILL STAR CLOTHING
Shoes
¥15,400
FILA
Shoes
22.5cm 残り1点
¥10,780
FILA
Shoes
22.5cm 残り1点
¥10,780
FILA
Shoes
28cm 残り1点
¥11,000
FILA
Shoes
23cm 残り1点
¥9,350
VISION STREET WEARxRHCP
Shoes
23cm 残り1点
¥8,250
VISION STREET WEARxRHCP
Shoes
¥11,000
FILA
Shoes
¥15,400
DISTURBIA CLOTHING
Shoes
24cm 残り1点
¥22,000
DISTURBIA CLOTHING
Shoes
68件見つかりました
1ページ中1ページ目
1
57752 Zephyren(ゼファレン) SHOWER SANDALS - Decadence - BLACK
58257 【予約商品】PUNK DRUNKERS ギザロゴサンダル - BLACK
58258 【予約商品】PUNK DRUNKERS ギザロゴサンダル - BLUE
58352 KILL STAR CLOTHING Lock Me Up Boots
58353 KILL STAR CLOTHING Death & Tonic Trainers
58354 KILL STAR CLOTHING Crossbones Creepers
36037 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- BLACK
36038 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- KHAKI
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
56087 FILA F04140125 Barricade XT 97 BLACK
57074 SLIGHTLY NUMB×Kappa shoes BLACK
57073 SLIGHTLY NUMB×Kappa shoes WHITE
51712 MUSIC SAVED MY LIFE M101-01K5-FW01 ZIP SNEAKER RED
55984 FILA F04140125 Barricade XT 97
45158 Zephyren(ゼファレン)MID CUT SNEAKER BLACK
54071 FILA DISRUPTOR SD WHITE
54220 FILA DISRUPTOR SD BLACK
55655 FILA F0581-3196 DISRUPTOR2 NEW TAPEY TAPE BLACK
55654 FILA F0581-0100 DISRUPTOR2 NEW TAPEY TAPE WHITE
55656 FILA F0492-0143 DISRUPTOR2 DUO WHITE
46937 FILA F0215-1072 DISRUPTOR2 WHITE
46938 FILA F0215-1073 DISRUPTOR2 BLACK
50019 FILA F0431-0147 DISRUPTOR Ⅱ ICE
50020 FILA F0431-0157 DISRUPTOR Ⅱ ICE
50845 FILA F0429-1072 DISRUPTOR 2 LAB WHITE/NAVY
53886 FILA F0494-1092 DISRUPTOR2 TAPYTAPE WHITE
53887 FILA F0494-1092 DISRUPTOR2 ICE BLUE
53888 FILA F0494-1092 DISRUPTOR2 ICE ORANGE
52620 RUDIE'S MIGHTY SHOWER SANDAL RED
54689 MAGICAL MOSH MISFITS AIRWALK x MxMxM “DOKU ONE”
54737 acOlaSia “LOT””SKULL”ハイカットスニーカー SKULL
54736 acOlaSia “LOT””SKULL”ハイカットスニーカー BLACK
28113 Xmas Eileen ビーチサンダル&ビニールバッグSET BLK
28114 Xmas Eileen ビーチサンダル&ビニールバッグSET WHT
29691 T.U.K. SHOES A9230 Sleeping With Sirens Core
36779 DISTURBIA CLOTHING TRYALS BOOT
39017 DISTURBIA CLOTHING All-Seeing Hi-Tops
39020 DISTURBIA CLOTHING All-Seeing Hi-Tops Silver
40453 ANIMALIA AN18U-AC19 FISHERMAN'S SANDALS WHITE
40454 ANIMALIA AN18U-AC19 FISHERMAN'S SANDALS YELLOW
40563 VIRGO SNEAKERS SOLE MIDDLE BOOTS ミドルブーツ BLACK
41577 MOTORHEAD×LAKAI Riley 2 x Motorhead WHITE
42513 RIP DESIGN WORXX BEACH SANDAL LADIES
42518 FILA F5020-0060 オリエンタルジョガー NAVY
42559 DISTURBIA CLOTHING Ammo Boots
42560 DISTURBIA CLOTHING Sweet Jane Shoes
42561 DISTURBIA CLOTHING Violet Shoes
42562 DISTURBIA CLOTHING Lolita Platform Shoes
43158 VIRGO VG-GD-558 MOUNTAIN MOTION SNEAKER BOOTS スニーカーブーツ BLACK
43381 MISHKA (ミシカ) EX18SH01 SHOES
43382 MISHKA (ミシカ) EX18SH02 SHOES
44814 KILL STAR CLOTHING Ceremony Flat [B]
44832 KILL STAR CLOTHING Keiko Kitty Flats [B]
44836 KILL STAR CLOTHING Dark Moon Slides [B]
44868 KILL STAR CLOTHING Dead 4Ever Platform Trainers
45420 DISTURBIA CLOTHING Creep Shoe
45708 KILL STAR CLOTHING Malice Platform Trainers
46933 FILA F0313-0125 GRANT HILL WHITE/NAVY/RED
47052 FILA F5070-0077 BOVEASORUS Dark Grey/Blue/Filared
47053 FILA F5070-0101 BOVEASORUS Wmns White/Beige
47574 FILA F0331-0100 DISRUPTOR 2 PATCHES WHITE
47873 VISION STREET WEAR VSW-9157 VISION CANVAS HI RHCP WHITE
47876 VISION STREET WEAR VSW-9158 VISION SLIP ON RHCP RED
50847 FILA F0430-0156 DISRUPTOR 2 NO-SEW WHITE
52551 DISTURBIA CLOTHING Archetype Sneaker
52552 DISTURBIA CLOTHING Nihilist Boot
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 16
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=16
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 16
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=16