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 =6
)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-13 21:50:39')
AND pc.stock > 0
AND FIND_IN_SET(5, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
9件見つかりました
1ページ中1ページ目
1
¥29,700
Anti Social Social Club
L/S Shirt
¥19,580
VIRGO
L/S Shirt
¥30,800
Zephyren
Happy bag
フリー 残り1点
¥14,080 → 7,040
HYPER CORE
L/S Shirt
¥15,400 → 7,700
MISHKA
L/S Shirt
¥19,800 → 9,900
MISHKA
L/S Shirt
S 残り1点
¥10,780 → 3,234
THRASHER
Shirt
S 残り1点
¥17,380 → 5,214
SABBAT13
L/S Shirt
M 残り1点
¥19,580 → 5,874
VIRGO
L/S Shirt
9件見つかりました
1ページ中1ページ目
1
63384 Anti Social Social Club Dialtone Olive Tie Dye Flannel
61087 VIRGO MIXTURE LONG SHIRTS KHAKI
61271 Zephyren 2022 NEW YEAR BAG
59846 HYPER CORE SICKS BEAR 2WAYワークシャツ
58123 MISHKA M21000202 Shirt
58116 MISHKA MS21000504 L/S Shirt
23705 THRASHER SKATE AND DESTROY WORK SHIRT OD
42459 SABBAT13 SBT-SH-010 MORTAL PATCH NELSHIRTS (グリーン)
43944 VIRGO VG-SH-191 VA-1 SHIRTS KHAKI
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 6
[color] => 5
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=6&color=5&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 6
[color] => 5
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=6&color=5