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 =392
)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-01-17 02:38:52')
AND pc.stock > 0
AND FIND_IN_SET(14, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
24件見つかりました
1ページ中1ページ目
1
¥26,180
SALUTE
Jacket
¥19,800
MISHKA
Jacket
¥19,800
MISHKA
Jacket
M 残り1点
¥25,080
ROLLING CRADLE
Jacket
¥25,080
ROLLING CRADLE
Jacket
¥27,500
Subciety
Jacket
L 残り1点
¥26,950
PUNK DRUNKERS
Jacket
Ladies XS 残り1点
¥17,600
REBEL8
Jacket
M 残り1点
¥13,200 → 9,240
Subciety
Jacket
M 残り1点
¥26,400 → 18,480
Zephyren
Jacket
¥30,250
VIRGO
Jacket
¥20,166
RIPNDIP
Jacket
¥18,480
FILA
Jacket
¥35,200
MUSIC SAVED MY LIFE
Jacket
L 残り1点
¥18,480
FILA
Jacket
¥18,700
mnml
Jacket
フリー 残り1点
¥33,880
NOT COMMON SENSE
Jacket
¥20,075
RIPNDIP
Jacket
¥23,980 → 16,786
SABBAT13
Jacket
¥24,200
FILA
Jacket
¥21,780
FILA
Jacket
¥27,500
STAPLE
Jacket
¥15,180
GALFY
Jacket
¥21,780
GoneR
Jacket
24件見つかりました
1ページ中1ページ目
1
57067 SALUTE DENIM HANDCUFFS JACKET
56885 MISHKA(ミシカ) MAW200508 JACKET
55976 MISHKA(ミシカ) MAW200511 JACKET
56538 ROLLING CRADLE FLIGHT JACKET / DENIM
56799 ROLLING CRADLE CHECK HOOD JACKET BLUE
54235 Subciety BANDANA QUILTING JKT BLACK/NAVY
54772 PUNK DRUNKERS [PDSxPAC-MAN]名人コーデュロイJKT - BLUE
23261 REBEL8 WOMENS INSTROSPECTIVE RAIN JACKET
41407 Subciety (サブサエティ) CAMO FLEECE JKT NAVY
41968 Zephyren(ゼファレン) DENIM JACKET HARD WASH II / BANNDANNA
43468 VIRGO VG-JKT-197 VGW COVERALLS カバーオール INDIGO
44245 RIPNDIP Eat Me Denim Jacket (Blue)
46753 FILA FM9546 Jacket Flame red
47469 MUSIC SAVED MY LIFE (MSML) M1K1K-JK02 BALLOON DENIM JACKET(加工) L.BLUE
50022 FILA FM9677 Jacket BLUE
50446 mnml HOODED DENIM JACKET BLUE
50689 NOT COMMON SENSE ”Blaze” customize denim jkt INDIGO①
50693 RIPNDIP NERM CAMO FANORAK JACKET
51378 SABBAT13 HOOD SHIRTS JKT(ブルー)
51441 FILA FM9673 JACKET
51443 FILA FM9695 JACKET BLUE
52440 STAPLE Neo Sport Puffer Jacket
52461 GALFY 野良犬カバーオール 青野良犬
52607 GoneR -La Neta- Chemical Wash Denim Jacket INDIGO
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 392
[color] => 14
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=392&color=14
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 392
[color] => 14
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=392&color=14