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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-24 21:21:04')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
54381 Nine Microphones -walkin'mic- S/S - WHITE
56553 NineMicrophones 9MC Crew S/S White/Burgundy
56572 NineMicrophones 9MC Crew S/S Blue
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
53215 Zephyren(ゼファレン)PONCHO TEE S/S BLACK
11229 Nine Microphones HEAVEN S/S Gray
11285 Nine Microphones BE ON STAGE S/S BLACK
11287 Nine Microphones BE ON STAGE S/S DENIM
13399 ICECREAM FAST DOG TEE SU14 GRAY
14114 SLIPKNOT SICKNESS TEE
16714 ICECREAM CONES&BONES T-SHIRT T04 WHITE
17603 ICECREAM BALLERS T-SHIRT ROYAL
17655 ICECREAM RUNNING DOG GLOW IN THE DARK WHITE
17730 METALLICA KILL EM ALL ALL OVER TEE
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
20065 ICECREAM VARSITY GREY
20067 ICECREAM ICEFA HEATHER GREY
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20303 REBEL8 GR8FUL TEE
20483 FAR★STAR 百目♀鼠 T&ショートT
20485 FAR★STAR Sperm ショートT フリーサイズ
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
22098 FUZZ REZ ZWEEP MODULATION TEE BLK
22099 FUZZ REZ ZWEEP MODULATION TEE GRY
22102 FUZZ REZ ZWEEP BIT CRUSHER TEE BLK
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
23467 ICECREAM ICJP16T001 WHT
24348 ICECREAM ICJP16T006 WHT
24349 ICECREAM EVIL SUNDAE TEE
24537 ATTILA Bandana Black - T-Shirt
24677 SLEEPING WITH SIRENS If You Were A Movie.. Sublimation
24768 NORTHLANE All-Over Print Black - T-Shirt
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
24899 ANIMALIA GOLD WEST WHT
25311 THE DEVIL WEARS PRADA All Over Print Blue
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
28046 SPITFIRE Speed Kills T-Shirt - Camo/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
35669 BULLET FOR MY VALENTINE Werewolf all over print t-shirt
36268 THRASHER THSR-SST01 BLK
41049 OBEY x Misfits Legacy of Phenome Heavyweight Box Tee BLACK
41050 OBEY x Misfits Legacy of Phenome Heavyweight Box Tee TAPE
41051 OBEY x Misfits Legacy of Phenome Heavyweight Box Tee WHITE
41052 OBEY x Misfits Fiend Rocker Basic Tee RED
41053 OBEY x Misfits Fiend Rocker Basic Tee WHITE
41054 OBEY x Misfits Fiend Rocker Basic Tee BLACK
43487 KILL STAR CLOTHING Delish Relaxed Top [B]
44274 Maison book girl 「首の無い鳥」刺繍 T-shirts Black
44275 Maison book girl 「首の無い鳥」刺繍 T-shirts White
44277 Maison book girl Tshirt_MBG001
47105 NOT COMMON SENSE GENESIS SEAM TEE WHITE
48249 NOT COMMON SENSE WWF×NCS MM TEE WHITE
49764 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW ORANGE
49765 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW BLUE
49766 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW YELLOW
49767 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW GREEN
50185 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee WHITE
50186 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee BLACK
52506 【限定コラボ・アイテム】Merm4id × PLMP Collaboration S/S TEE
52961 RIPNDIP Nermhog Tee (Black)
53026 Subciety Guadalupe S/S WHITE
53030 SABBAT13 HODGE PODGE T PURPLE
53032 SABBAT13 FRIEND T PURPLE
53033 SABBAT13 FRIEND T WHITE
53040 SABBAT13 PARADISE T BLACK
53041 SABBAT13 PARADISE T BURGANDY
53042 SABBAT13 CASKET T BLACK
53044 SABBAT13 SKATE HAND T BLACK
53051 SABBAT13 PENNYWISE T YELLOW
53052 SABBAT13 PENNYWISE T BLACK
53053 SABBAT13 PENNYWISE T WHITE
53086 KAVANE Clothing "HYPOTHESIS"OVERSIZE CUTSEW(Blk)
53087 KAVANE Clothing "HYPOTHESIS"OVERSIZE CUTSEW(Red)
53099 PUNK DRUNKERS [PDS×仮面ライダー]仮面ライダーゼロワンTEE INDIGO
53102 PUNK DRUNKERS [PDS×仮面ライダー]仮面ライダーゼロワンTEE WHITE
53120 LILWHITE(dot) LW-20SS-T01 ANGERL TEE BLK
53121 LILWHITE(dot) LW-20SS-T01 ANGERL TEE WHT
53137 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt BLK×MINT type A
53138 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt BLK×MINT type B
53139 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type A
53140 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type B
53141 HEDWiNG HD1-018 “Pierre” Tie-dye T-shirt Black
53142 HEDWiNG HD1-018 “Pierre” Tie-dye T-shirt Navy
53144 HEDWiNG HD1-019 80’s Tropical T-shirt White
53146 HEDWiNG HD1-020 Drawstring 2020 T-shirt Black
53148 HEDWiNG HD1-020 Drawstring 2020 T-shirt White
53163 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE ORANGE
53241 Zephyren(ゼファレン)SWITCHING TEE S/S WHITE / BLACK
53253 Zephyren(ゼファレン)SWITCHING TEE S/S BLACK / GRAFFITI
53291 Zephyren(ゼファレン)S/S TEE - PROVE - BLACK
53868 MISHKA(ミシカ) MSS200069 T-SHIRTS WHITE
53869 MISHKA(ミシカ) MSS200069 T-SHIRTS BLACK
53871 MISHKA(ミシカ) MSS200085 T-SHIRTS BLACK
53872 MISHKA(ミシカ) MSS200086 T-SHIRTS
53876 MISHKA(ミシカ) MSS201102 T-SHIRTS WHITE
53877 MISHKA(ミシカ) MSS201102 T-SHIRTS BLACK
53900 TRAVAS TOKYO All Strawberry patternedビッグTシャツ Black×Red
53901 TRAVAS TOKYO All Strawberry patternedビッグTシャツ Black×Blue
53902 TRAVAS TOKYO Furry bearビッグTシャツ White
53903 TRAVAS TOKYO Furry bearビッグTシャツ Pink
53904 TRAVAS TOKYO Furry bearビッグTシャツ Black×Purple
53905 TRAVAS TOKYO Furry bearビッグTシャツ Black×Blue
53907 CIVARIZE【シヴァーライズ】 Lady's型 Tee WHITE
53908 CIVARIZE【シヴァーライズ】 Lady's型 Tee BLACK
53910 【ゲキクロ限定】HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirtBLK×WHT type A
53911 【ゲキクロ限定】HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirtBLK×WHT type B
53960 Civil Regime 20CV-SP01T REBEL YOUTH CO TEE
53961 Civil Regime 20CV-SP02T OUTSIDERS FOREVER TEE
53962 Civil Regime 20CV-SP04T BORN WILD TEE VINTAGE BLACK TEE
53963 TRAVAS TOKYO たれくまTシャツ
53964 SILLENT FROM ME 沈黙 BLACK
53965 SILLENT FROM ME 沈黙 WHITE
53970 TOY MACHINE SKATE DATE SST (BIG SIZE) - WHITE
53971 TOY MACHINE SKATE DATE SST (BIG SIZE) - BLACK