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-08-15 15:25:52')
AND pc.stock > 0
AND FIND_IN_SET(20, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
19件見つかりました
1ページ中1ページ目
1
¥2,200
RIPNDIP
Sticker
¥20,900
glamb
Cardigan
¥20,900
glamb
Cardigan
¥30,800
Zephyren
Happy bag
¥22,000
Subciety
Happy bag
¥22,000
RUDIE'S
Happy bag
フリー 残り1点
¥20,900 → 10,450
HEDWiNG
Jacket
M 残り1点
¥13,200 → 6,600
PUNK DRUNKERS
Shorts
¥14,300
Artemis Classic
WalletChain
¥8,250 → 4,125
KILL STAR CLOTHING
Skirt
フリー 残り1点
¥3,850 → 1,925
KILL STAR CLOTHING
Choker
¥17,600 → 8,800
Subciety
Bottoms
¥17,600 → 8,800
Subciety
Bottoms
M 残り1点
¥26,400 → 13,200
Subciety
Jacket
Ladies L 残り1点
¥10,450 → 3,135
DROP DEAD CLOTHING
Shirt
¥17,600
Artemis Classic
Wallet
フリー 残り1点
¥4,180 → 1,254
SQUARE
Sunglasses
¥2,750
MODERN DAY BABYLON
CD
¥2,750
MODERN DAY BABYLON
CD
19件見つかりました
1ページ中1ページ目
1
64304 RIPNDIP (リップンディップ) Summer Break Sticker Pack
63504 【予約商品】glamb (グラム) Fuzzy Leopard Cardigan - Wine
63505 【予約商品】glamb (グラム) Fuzzy Leopard Cardigan - Black
61271 Zephyren 2022 NEW YEAR BAG
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
60567 HEDWiNG R.A.M Leopard Fur Jacket
58178 PUNK DRUNKERS 豹柄ショーツ - GRAY
59363 Artemis Classic フックカラビナウォレットロープ[ACWR0027]
58363 KILL STAR CLOTHING Savage Mini Skirt [LEOPARD]
58356 KILL STAR CLOTHING Catnip Choker [LEOPARD]
54345 Subciety(サブサエティ) LEOPARD SLACKS BLACK
54346 Subciety(サブサエティ) LEOPARD SLACKS BEIGE
54228 Subciety LEOPARD SWING TOP BEIGE
7511 DROP DEAD CLOTHING LEOVEPARD TOP
29541 Artemis Classic ショートウォレットリザードスタイル[ACSW0002]
35049 SQUARE BOX LOGO SUNGLASS LEOPRAD
50417 MODERN DAY BABYLON 『Travelers』
50418 MODERN DAY BABYLON 『The Ocean Atlas』
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[color] => 20
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&color=20&
--------
mb_parse_str
Array
(
[work] => new_arrival
[color] => 20
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&color=20