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 >= '2022-07-04 00:13:58')
AND pc.stock > 0
AND FIND_IN_SET(19, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
32件見つかりました
1ページ中1ページ目
1
¥2,200
RIPNDIP
Sticker
予約受付
¥74,800
glamb
Jacket
予約受付
¥74,800
glamb
Jacket
予約受付
¥41,800
glamb
Jacket
予約受付
¥41,800
glamb
Jacket
予約受付
¥33,000
glamb
Bottoms
予約受付
¥33,000
glamb
Bottoms
¥7,920
ZENON
T-Shirt
¥7,920
ZENON
T-Shirt
¥1,980
ZENON
Bandana
XL 残り1点
¥11,000
Zephyren
T-Shirt
¥16,500
Zephyren
S/S Shirt
¥16,500
Zephyren
S/S Shirt
¥18,480
VIRGO
L/S Shirt
¥30,800
Zephyren
Happy bag
¥22,000
Subciety
Happy bag
¥22,000
RUDIE'S
Happy bag
¥37,400
Subciety
Jacket
¥25,300
Zephyren
Jacket
XL 残り1点
¥16,500
Zephyren
L/S Shirt
XL 残り1点
¥16,500
Zephyren
L/S Shirt
¥14,300
Zephyren
Watch
¥16,500
Zephyren
Shorts
L 残り1点
¥15,400
Zephyren
Shorts
¥12,100
MUSIC SAVED MY LIFE
L/S T-Shirt
フリー 残り1点
¥6,600
Zephyren (ゼファレン)
Goods
S 残り1点
¥16,500 → 11,550
Subciety
ZIP Hoodie
S 残り1点
¥16,500
Subciety
Bottoms
S 残り1点
¥8,800 → 6,160
Zephyren
T-Shirt
S 残り1点
¥6,050 → 4,235
Zephyren
T-Shirt
フリー 残り1点
¥8,250 → 5,775
Subciety
Skirt
¥8,250 → 5,775
Subciety
Skirt
32件見つかりました
1ページ中1ページ目
1
64304 RIPNDIP (リップンディップ) Summer Break Sticker Pack
64225 【予約商品】glamb (グラム) Corduroy Mods Coat Paisley black
64226 【予約商品】glamb (グラム) Corduroy Mods Coat Paisley brown
64229 【予約商品】glamb (グラム) Corduroy Classic JKT Paisley black
64230 【予約商品】glamb (グラム) Corduroy Classic JKT Paisley brown
64233 【予約商品】glamb (グラム) Corduroy Cargo Jodhpurs Paisley black
64234 【予約商品】glamb (グラム) Corduroy Cargo Jodhpurs Paisley brown
63434 ZENON(ゼノン) Embroidery & bandana patchwork S/S big BLACK
63435 ZENON(ゼノン) Embroidery & bandana patchwork S/S big WHITE
63436 ZENON(ゼノン) Cursive logo bandana
62239 Zephyren(ゼファレン) SWITCHING TEE PAISLEY
62214 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - PAISLEY
57457 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - PAISLEY
61092 VIRGO CLOTH CARRYING SHIRTS WHITE
61271 Zephyren 2022 NEW YEAR BAG
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
60862 Subciety (サブサエティ) DOWN JKT BLACK/PAISLEY
59442 Zephyren(ゼファレン) MA-1 Type BLOUSON BROWN / PAISLEY
59535 Zephyren(ゼファレン) BIG SHIRT L/S NAVY / PAISLEY
59507 Zephyren(ゼファレン) SHIRT L/S - Resolve - BLACK / PAISLEY
26608 Zephyren (ゼファレン) PAISLEY WATCH BLACK
57598 Zephyren(ゼファレン) DOUBLE POCKET SHORTS PAISLEY
57596 Zephyren(ゼファレン) SHORTS PAISLEY
56156 MUSIC SAVED MY LIFE (MSML) BANDANA LONG SLEEVE SLIT CUTSEW BLACK
34372 Zephyren (ゼファレン) UMBRELLA -PAISLEY-
16686 Subciety ZIP PARKA-PATTERNED ALL OVER- GRAY
23049 Subciety TAPERED WORK PANTS-PAISLEY- BEIGE
24394 Zephyren (ゼファレン) SWITCHING S/S TEE -VISIONARY- BLACK
25105 Zephyren (ゼファレン) PAISLEY POCKET S/S TEE -Flow- BLACKxNAVY PAISLEY
25854 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- BLACK
25855 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- NAVY
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[color] => 19
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&color=19&
--------
mb_parse_str
Array
(
[work] => new_arrival
[color] => 19
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&color=19