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 =97
)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-08-18 04:29:55')
AND pc.stock > 0
AND FIND_IN_SET(2, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
25件見つかりました
1ページ中1ページ目
1
¥7,700
DI:VISION
L/S T-Shirt
¥8,800
Subciety
L/S T-Shirt
¥7,480
RIPNDIP
L/S T-Shirt
¥4,180
AFFECTER
L/S T-Shirt
¥19,250
glamb
L/S T-Shirt
¥19,250
glamb
L/S T-Shirt
¥6,380
DI:VISION
L/S T-Shirt
¥4,950
over print
L/S T-Shirt
L 残り1点
¥4,950
over print
L/S T-Shirt
¥4,950
over print
L/S T-Shirt
¥4,950
over print
L/S T-Shirt
XL 残り1点
¥5,500
over print
L/S T-Shirt
¥13,200 → 6,600
SLEEPING TABLET
L/S T-Shirt
¥4,400
Survive Said The Prophet
L/S T-Shirt
¥8,690 → 4,345
GALFY
L/S T-Shirt
¥30,800
Zephyren
Happy bag
¥22,000
Subciety
Happy bag
¥22,000
RUDIE'S
Happy bag
S 残り1点
¥7,000
SLEEPING TABLET
L/S T-Shirt
L 残り1点
¥7,700
Subciety
L/S Shirts
S 残り1点
¥7,480
ROLLING CRADLE
Long T-Shirt
¥5,500
RIP DESIGN WORXX
Long T-Shirt
¥6,600 → 1,980
REBEL8
Long T-Shirt
M 残り1点
¥15,180 → 4,554
VIRGO
T-Shirt
¥6,600 → 1,980
isxnot
L/S T-Shirt
25件見つかりました
1ページ中1ページ目
1
64360 【予約商品】DI:VISION (ディヴィジョン) FICTION LS TEE CHACOAL
65165 Subciety (サブサエティ) NOVEL GLORIOUS TEE-GRAY/BLACK
64271 RIPNDIP (リップンディップ) Lullaby Long Sleeve (Black Mineral Wash)
63698 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Gray
63575 【予約商品】glamb (グラム) Damaged Layered CS - White
63574 【予約商品】glamb (グラム) Damaged Layered CS - Black
63174 DI:VISION (ディヴィジョン) SAD LS TEE WASHED
63361 over print (オーバープリント) plane 3/4S Tee (chacoal / ivory)
63356 over print (オーバープリント) PASS name LS Tee (light gray)
63358 over print (オーバープリント) PASS name LS Tee (chacoal)
63157 over print (オーバープリント) plane LS Tee (heather gray)
62976 over print (オーバープリント) 3codes LS Tee (heather gray)
58318 SLEEPING TABLET GRRL [ MULTI BORDER LONG SLEEVE ] GRAY
58433 Survive Said The Prophet MIXED LOGO L/S TEE GRAY
60422 GALFY (ガルフィー) わんわん大学ロンTee T.GRAY
61271 Zephyren 2022 NEW YEAR BAG
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
59343 SLEEPING TABLET FORMULA [ LONG SLEEVE ] SAX
59081 Subciety (サブサエティ) Separation L/S - GRAY
23738 ROLLING CRADLE FREAK OUT LONG Tee / Gray
28823 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(グレー)
38653 REBEL8 Offenders Mock Neck Longsleeve
39850 VIRGO DIAGONAL DAMAGED Charcoal
50176 isxnot(イズノット) Graffi tee
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 97
[color] => 2
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=97&color=2&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 97
[color] => 2
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=97&color=2