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 19:11:07')
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 p.update_date
LIMIT 0, 60
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
11162 MEMPHIS MAY FIRE Crest Black Hooded
11210 THE FACELESS Autotheism Hoodie Black
11215 LIKE MOTHS TO FLAMES Demon Black Hoodie
13399 ICECREAM FAST DOG TEE SU14 GRAY
15410 MEMPHIS MAY FIRE Skulls & Arrows Black Crewneck
15481 ATTILA Kings Black Crewneck
16714 ICECREAM CONES&BONES T-SHIRT T04 WHITE
16983 ZEPHYREN (ゼファレン) TANK TOP -BONEYARD- - BLACK
17603 ICECREAM BALLERS T-SHIRT ROYAL
17655 ICECREAM RUNNING DOG GLOW IN THE DARK WHITE
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
18984 WE CAME AS ROMANS Varsity Custom Heather Grey Crew
19010 WHITECHAPEL Thirst Black
19014 REVOCATION Deathless Album Black
19100 ATTILA Guilty Pleasure Black Crewneck
20065 ICECREAM VARSITY GREY
20067 ICECREAM ICEFA HEATHER GREY
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20303 REBEL8 GR8FUL TEE
20751 Subciety BASEBALL TEE 7/S-COLLEGE- GRAY
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
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
22541 SANTA CRUZ SIEBEN HAND S/S T SHIRT WHITE
22664 ICECREAM BOXED DOG.TEE WHT/PP
22786 ANGRY FROG REBIRTH メタルロゴ プルパーカー
23467 ICECREAM ICJP16T001 WHT
23684 SPITFIRE Bighead Grey Spiral Black Rib
24348 ICECREAM ICJP16T006 WHT
24349 ICECREAM EVIL SUNDAE TEE
24655 NECK DEEP Hero Quest Black - Crewneck
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
24768 NORTHLANE All-Over Print Black - T-Shirt
24775 NORTHLANE Yin Yang Heather Blue - 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
25188 IWRESTLEDABEARONCE W Paw Black - Long Sleeve Shirt
25228 LIKE MOTHS TO FLAMES TDTWLF Torch Black - Long Sleeve
25266 DOCAN! ANARCHY workshirt
25409 FINCH Flame Blue/White - Baseball Shirt
25484 PIERCE THE VEIL San Diego Navy - Pullover
26144 ARCHITECTS Daybreaker Crewneck
26152 I KILLED THE PROM QUEEN Monogram Zip Hoodie
26230 OPETH Morningrise Hoodie
26281 DROPKICK MURPHYS Drinking Skeleton Cross Zip Hood
27377 DEEZ NUTS Bout It Sweatshirt
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
28055 SPITFIRE Bloodshot Premium T-Shirt - Rainbow Tie Dye
28301 UPON A BURNING BODY Logo All Over T-Shirt
31647 ANIMALIA AN17S-TE05 RUSTICLOTHES DEPT. olive
17695 Subciety TIE DYE TANK TOP-GLORIOUS- NAVY
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE