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 =587
)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-10 20:23:32')
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
8件見つかりました
1ページ中1ページ目
1
¥16,500
Subciety
Jacket
¥9,900
RIPNDIP
Tank Top
¥23,100
glamb
Jacket
¥9,900
東京初期衝動×GEKIROCK CLOTHING
Jacket
XS 残り1点
¥14,300 → 7,150
MISHKA
Shirt
M 残り1点
¥15,400 → 10,780
BLACK SCALE
tops
Ladies M 残り1点
¥7,150 → 5,005
DISTURBIA CLOTHING
Dress
¥9,900 → 4,950
DISTURBIA CLOTHING
Hoodie
8件見つかりました
1ページ中1ページ目
1
65187 Subciety (サブサエティ) TRACK JKT-BLACK
64269 RIPNDIP (リップンディップ) Nikola Basketball Jersey (Black/Blue)
61892 glamb (グラム) Old School Pile Jersey - Black
58750 東京初期衝動×GEKIROCK CLOTHING コラボ・ジャージ・ジャケット BLACK
22602 MISHKA (ミシカ) Brotherhood KW Jersey BLK
25386 BLACK SCALE GUADALUPE WARM UP JERSEY BLK
27860 DISTURBIA CLOTHING ALIEN NATION MESH CROP
31718 DISTURBIA CLOTHING Pris Mesh Hoody
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 587
[color] => 1
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=587&color=1&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 587
[color] => 1
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=587&color=1