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-13 08:22:25')
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 0, 60
25266 DOCAN! ANARCHY workshirt
70012 glamb (グラム) marquee club(R) Tank Top / マーキークラブタンクトップ Black
18984 WE CAME AS ROMANS Varsity Custom Heather Grey Crew
61525 ANIMALIA AN22SP-PT02 EASY PANTS - Sanskrit Logo BEIGE
64115 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ CREW SWEAT ] BLACK
19014 REVOCATION Deathless Album Black
24655 NECK DEEP Hero Quest Black - Crewneck
25135 SEAWAY Colour Blind Logo Grey - Pullover
25144 CITY LIGHTS Arrows Black - Crewneck Sweatshirt
25161 WE CAME AS ROMANS Cracked Hope Heather Grey - Crewneck
25484 PIERCE THE VEIL San Diego Navy - Pullover
26281 DROPKICK MURPHYS Drinking Skeleton Cross Zip Hood
27377 DEEZ NUTS Bout It Sweatshirt
60407 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Orange
64287 RIPNDIP (リップンディップ) Aloha Nerm Swim Shorts (Black)
65932 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -100g- BLACK
65933 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -12g- BLACK
68125 SLEEPING TABLET(スリーピング・タブレット) MADOROMI [ HEAVY WAIGHT LONG SLEEVE ] BLACK
11210 THE FACELESS Autotheism Hoodie Black
11215 LIKE MOTHS TO FLAMES Demon Black Hoodie
17668 Subciety TIE DYE TEE-GLORIOUS- GREY
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
17695 Subciety TIE DYE TANK TOP-GLORIOUS- NAVY
26134 BRING ME THE HORIZON Sickle Zip Hoodie
26144 ARCHITECTS Daybreaker Crewneck
26152 I KILLED THE PROM QUEEN Monogram Zip Hoodie
26230 OPETH Morningrise Hoodie
58363 KILL STAR CLOTHING Savage Mini Skirt [LEOPARD]
70745 攻殻機動隊 STAND ALONE COMPLEX x Subciety SECTION9 TEE WHITE
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
67415 日高さおり × GoneR コラボ限定ロンT
68520 over print (オーバープリント) CAPTAIN Tee WHITE
68777 旭 那由多×RUDIE'S コラボ限定ロングTシャツ
64140 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ LONG SLEEVE ] WHITE
20751 Subciety BASEBALL TEE 7/S-COLLEGE- GRAY
15410 MEMPHIS MAY FIRE Skulls & Arrows Black Crewneck
20115 KILL STAR CLOTHING RA T-SHIRT [B]
58460 NARUTO-ナルト- 疾風伝 ×Subciety NARUTO S/S ORANGE
61365 SLEEPING TABLET (スリーピングタブレット) ORDER [ LONG SLEEVE ] BLACK
28055 SPITFIRE Bloodshot Premium T-Shirt - Rainbow Tie Dye
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
68012 【BanG Dream! ×ゲキクロ 2023 ver.】今井リサ×RIP DESIGN WORXX コラボ Tシャツ
17678 Subciety 15th GLORIOUS S/S BLACK/WHITE
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE