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 >= '2024-04-26 14:55:07')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 240)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 2280, 120
54664 MISHKA(ミシカ) MSS203225 BUCKET HAT
54665 MISHKA(ミシカ) MSS203224 BUCKET HAT
54666 MISHKA(ミシカ) MSS203214 CAP BLUE
54667 MISHKA(ミシカ) MSS203213 CAP BLACK
54668 MISHKA(ミシカ) MSS203209 CAP
54669 MISHKA(ミシカ) MSS203202 CAP
54699 MISHKA(ミシカ) MSS200030 T-SHIRTS ORANGE/PURPLE
54700 MISHKA(ミシカ) MSS200032 T-SHIRTS GREEN
54703 MISHKA MSS200005 T-SHIRTS GREEN
54704 MISHKA MSS200005 T-SHIRTS ORANGE
54707 MISHKA (ミシカ) KUMARA TEE
54708 MISHKA (ミシカ) BUTIGER TEE
54709 MISHKA (ミシカ) KUMARA HOODIE
54710 MISHKA (ミシカ) BUTIGER HOODIE
54451 MISHKA(ミシカ) MSS200906 SHORTS
53882 MISHKA(ミシカ) MSS200874 PANTS
53884 MISHKA(ミシカ) MSS200072 HOODIE WHITE
52681 MISHKA Incoming Transmission Longsleeve White
6616 MISHKA The Keep Watch or Die Tank in Navy
9306 MISHKA (ミシカ) KEEP WATCH CARDIGAN RED BERRY
10828 MISHKA (ミシカ) GHOST TO THE POST II TANK TOP BLACK
11084 MISHKA (ミシカ) PARTY ANIMAL T-SHIRT RED
27484 MISHKA (ミシカ) JV KEEP WATCH BASKETBALL JERSEY White
38833 MISHKA (ミシカ) LAMOUR SCUM LOVE T-SHIRT FL 171116 YEL
40647 MISHKA SP181303 FLYING TIGER KEEP WATCH TEE BLACK
42873 MISHKA x AIR JAM 2018 TEE WHITE
55658 MISHKA (ミシカ) KEEP WATCH SWIM SHORTS
51510 MISHKA MSS200055F12 L/S TEE SAFTY GREEN
60666 MISHKA M61000729 JACKET GRAY