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-05-27 17:41:16')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND pc.classcategory_id1 IN( 14,61,35)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 60, 60
23125 Subciety COLLEGE S/S NAVY/WHITE
31647 ANIMALIA AN17S-TE05 RUSTICLOTHES DEPT. olive
22541 SANTA CRUZ SIEBEN HAND S/S T SHIRT WHITE
16714 ICECREAM CONES&BONES T-SHIRT T04 WHITE
17603 ICECREAM BALLERS T-SHIRT ROYAL
17655 ICECREAM RUNNING DOG GLOW IN THE DARK WHITE
20065 ICECREAM VARSITY GREY
20067 ICECREAM ICEFA HEATHER GREY
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
25409 FINCH Flame Blue/White - Baseball Shirt
28301 UPON A BURNING BODY Logo All Over T-Shirt
22786 ANGRY FROG REBIRTH メタルロゴ プルパーカー
23684 SPITFIRE Bighead Grey Spiral Black Rib
22095 FUZZ REZ ZWEEP DELAY LONG SLEEVE TEE BLK
22098 FUZZ REZ ZWEEP MODULATION TEE BLK
22099 FUZZ REZ ZWEEP MODULATION TEE GRY
22103 FUZZ REZ ZWEEP BIT CRUSHER TEE WHT
18447 Subciety GLORIOUS S/S - BLACK/WHITE
19010 WHITECHAPEL Thirst Black
20303 REBEL8 GR8FUL TEE
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
23111 Subciety SALOON S/S NAVY/YELLOW
25188 IWRESTLEDABEARONCE W Paw Black - Long Sleeve Shirt
25228 LIKE MOTHS TO FLAMES TDTWLF Torch Black - Long Sleeve
71613 Forever 90s GALs(フォーエバーナインティーズギャルズ)LOVE GALs Ringer Tee Blue
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]