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 16:56:08')
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)
LIMIT 0, 60
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
71613 Forever 90s GALs(フォーエバーナインティーズギャルズ)LOVE GALs Ringer Tee Blue
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
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
23684 SPITFIRE Bighead Grey Spiral Black Rib
22786 ANGRY FROG REBIRTH メタルロゴ プルパーカー
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
22541 SANTA CRUZ SIEBEN HAND S/S T SHIRT WHITE
17678 Subciety 15th GLORIOUS S/S BLACK/WHITE
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
20758 Subciety POCKET TEE S/S-GLORIOUS- GRAY
23090 Subciety(サブサエティ) THRON S/S BLACK
23124 Subciety COLLEGE S/S BLACK/BURGUNDY
23125 Subciety COLLEGE S/S NAVY/WHITE
31647 ANIMALIA AN17S-TE05 RUSTICLOTHES DEPT. olive
68012 【BanG Dream! ×ゲキクロ 2023 ver.】今井リサ×RIP DESIGN WORXX コラボ Tシャツ
13399 ICECREAM FAST DOG TEE SU14 GRAY
15481 ATTILA Kings Black Crewneck
22664 ICECREAM BOXED DOG.TEE WHT/PP
23467 ICECREAM ICJP16T001 WHT
24348 ICECREAM ICJP16T006 WHT
24349 ICECREAM EVIL SUNDAE TEE
24768 NORTHLANE All-Over Print Black - T-Shirt
35660 PANTERA 101 Proof Sweatshirts
68560 ANIMALIA (アニマリア) EASY NYLON SHORTS BLACK
68561 ANIMALIA (アニマリア) EASY NYLON SHORTS OCEAN GREEN
68562 ANIMALIA (アニマリア) EASY NYLON SHORTS YELLOW
28055 SPITFIRE Bloodshot Premium T-Shirt - Rainbow Tie Dye
61365 SLEEPING TABLET (スリーピングタブレット) ORDER [ LONG SLEEVE ] BLACK
15410 MEMPHIS MAY FIRE Skulls & Arrows Black Crewneck
20115 KILL STAR CLOTHING RA T-SHIRT [B]
58460 NARUTO-ナルト- 疾風伝 ×Subciety NARUTO S/S ORANGE
20751 Subciety BASEBALL TEE 7/S-COLLEGE- GRAY
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
11162 MEMPHIS MAY FIRE Crest Black Hooded
16983 ZEPHYREN (ゼファレン) TANK TOP -BONEYARD- - BLACK
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19100 ATTILA Guilty Pleasure Black Crewneck
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
68520 over print (オーバープリント) CAPTAIN Tee WHITE
68777 旭 那由多×RUDIE'S コラボ限定ロングTシャツ