SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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-28 22:32:08')
AND pc.price02 > 9090
AND price02 <= 13636
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 720, 120
31997 FAR★STAR 夏の終わり パーカー
35279 FAR★STAR F@R SHORTS
40781 Artemis Classic ACP0311 ファイブスターベルペンダント
40782 Artemis Classic ACP0312 スモールバラードベルペンダント
40784 Artemis Classic ACP0314 ナイトチェスペンダント
40792 Artemis Classic ACB0107 フェニックスコンビブレスレット
43805 Artemis Classic ACP0317 ホイッスルキングチェスペンダント
43806 Artemis Classic ACP0318 ホイッスルクイーンチェスペンダント
43807 Artemis Classic ACP0319 キングダムキーペンダント
47643 SANTA CRUZ CLASSIC DOT HEAVYWEIGHT P/O HOODED SWEATSHIRT BLACK
49756 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW ORANGE
49758 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW YELLOW
49759 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW GREEN
50678 mnml(ミニマル) SNAP ZIPPER II CARGO PANTS Olive
50755 mnml(ミニマル) BAGGY TRACK SWEATPANTS BLACK
50847 FILA F0430-0156 DISRUPTOR 2 NO-SEW WHITE
51173 brokker “METALLICA” フィギュア
52915 FILA × STAPLE FM9880 WHITE
53892 PARADOX PX17-SP-PK02 INSIDE OUT PARKA「FACE TO FACE」 BLACK
53917 PSYCHOLOGICAL METAMORPHOSIS PLMP PILE WAPPEN PARKA GREEN
53957 KONUS Color Blocked Oversized Short Sleeve BLACK
53958 KONUS Color Blocked Oversized Short Sleeve TEAL
54205 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - YELLOW
54221 ANIMALIA S/S SIDE ZIP HOODIE GRAY
54222 ANIMALIA S/S SIDE ZIP HOODIE RED
52946 Survive Said The Prophet CONCRETE COACH JKT WHITE
52447 STAPLE Neo Sport Nylon Crew