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-04-28 06:52:11')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
56572 NineMicrophones 9MC Crew S/S Blue
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
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
16714 ICECREAM CONES&BONES T-SHIRT T04 WHITE
17603 ICECREAM BALLERS T-SHIRT ROYAL
17655 ICECREAM RUNNING DOG GLOW IN THE DARK WHITE
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
24768 NORTHLANE All-Over Print Black - T-Shirt
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
24899 ANIMALIA GOLD WEST WHT
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
29109 KILL STAR CLOTHING (キルスター・クロージング) Cozmic Death Crop Top [B]
29589 ICECREAM ICJP16T034 T-SHIRT GRAY
31647 ANIMALIA AN17S-TE05 RUSTICLOTHES DEPT. olive
36268 THRASHER THSR-SST01 BLK
43487 KILL STAR CLOTHING Delish Relaxed Top [B]
47103 NOT COMMON SENSE FUXX THE POLICE SEAM TEE BLACK
47105 NOT COMMON SENSE GENESIS SEAM 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
51362 KILL STAR CLOTHING Diablerie T-Shirt
53161 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE WHITE
54641 ROLLING CRADLE JUDGEMENT TEE GREEN
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
54674 FILA FFM9802 ユニセックス クルーネックシャツ RED
54675 FILA FFM9802 ユニセックス クルーネックシャツ NAVY
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
17678 Subciety 15th GLORIOUS S/S BLACK/WHITE
17668 Subciety TIE DYE TEE-GLORIOUS- GREY
23125 Subciety COLLEGE S/S NAVY/WHITE
23124 Subciety COLLEGE S/S BLACK/BURGUNDY
23111 Subciety SALOON S/S NAVY/YELLOW
23090 Subciety(サブサエティ) THRON S/S BLACK
20758 Subciety POCKET TEE S/S-GLORIOUS- GRAY
38026 Subciety (サブサエティ) ザ・ベース S/S WHITE
42882 Subciety THE BASE S/S - ORANGE/WHITE
55652 THRASHER (スラッシャー) TH91214US FLAME OUTLINE S/S T-SHIRTS WHITE/YELLOW
54046 NOT COMMON SENSE ”KC ALTERNATIVE SOUND” TEE 03
57390 FILA FS3008 T-Shirt WHITE
57391 FILA FS3008 T-Shirt BLACK
57392 FILA FS3021 T-Shirt CHARCOAL
57798 CRADLE OF FILTH Krampus T-shirt + ornament
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
58096 WASTED PARIS T-shirt Marble Dye Nebula Gray
58095 WASTED PARIS T-shirt Marble Dye Nebula Green
57306 HEDWiNG Pocket “MOJYAPON” T-shirt White
57322 Subciety×仮面ライダードライブ DRIVE S/S WHITE
57324 Subciety×仮面ライダードライブ DRIVE S/S BLACK
58163 NOT COMMON SENSE HARD CORE TEE BLACK
58164 NOT COMMON SENSE DEAD TUDE TEE BLACK
58165 NOT COMMON SENSE DEAD TUDE TEE WHITE
58287 ANIMALIA AN21S-CS06 Wild Bill S/S
57885 Subciety (サブサエティ) WEEKENDER S/S- RED
58053 XrossOver XOver logoT (White)
57913 Subciety (サブサエティ) DRUNKER S/S- BLACK
58198 PUNK DRUNKERS [PDSxBLACK PEARLS]PDSロードTEE - BLACK
58789 HYPER CORE PINK SNIPER Tシャツ WHITE
58813 HYPER CORE PiSTOLTシャツ WHITE
59120 ANIMALIA AN21U-TE10 DIVING BLACK
59117 ANIMALIA AN21U-TE11 FALLING WHITE
59233 LONELY論理 LONELY UNIV TEE white
59235 LONELY論理 LONELY UNIV TEE black
15222 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- BLK×WHT
15225 ZEPHYREN (ゼファレン) TEE S/S -BEYOND- WHT
59405 SUPPLIER (サプライヤー) SPIDER WEB TEE
59844 HYPER CORE T-367 承認欲求がぁる2 -I need your Reply, Retweet & いいね- Tシャツ ブルー×パープル
58461 Subciety×NARUTO-ナルト- 疾風伝 NARUTO S/S WHITE
58460 NARUTO-ナルト- 疾風伝 ×Subciety NARUTO S/S ORANGE
58463 NARUTO-ナルト- 疾風伝 ×Subciety SASUKE S/S PURPLE
60030 SUPPLIER (サプライヤー) ANGEL TEE PINK
60055 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE SS TEE ORG-BLK
59955 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE WHITE
60223 NieR (ニーア) 襟付きGRAY RIB CUTSEW【ネクタイセット】
60128 HYPER CORE HTC-372 ぴえんICE BEAR Tシャツ L.BLUE
60127 HYPER CORE HTC-372 ぴえんICE BEAR Tシャツ WHITE
60239 acOlaSia VICTIM TEE BLACK
60240 acOlaSia VICTIM TEE WHITE
60246 acOlaSia MEDAMAYAKI TEE WHITE
53149 SAMURAI CORE 釈迦 TEE WHITE
53151 SAMURAI CORE 釈迦 TEE RED
54527 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE WHITE
54529 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE RED
56038 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE WHITE
60049 SAMURAI CORE リンガーTEE BLACK
60047 SAMURAI CORE リンガーTEE RED
60048 SAMURAI CORE リンガーTEE BLUE
60463 NieR (ニーア) BACK RABBIT CHECKERED CUTSEW 【RED PINK】
60717 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / RED
61207 XrossOver XOver K logo T (White)
61419 VIRGO (ヴァルゴ) GLOWING EYES WHITE
61420 VIRGO (ヴァルゴ) GLOWING EYES BLACK
61637 STAPLE×Sesame Street Crew Tee