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-01 19:36:55')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
16714 ICECREAM CONES&BONES T-SHIRT T04 WHITE
17655 ICECREAM RUNNING DOG GLOW IN THE DARK WHITE
20119 KILL STAR CLOTHING OM TUNIC DRESS [B]
22103 FUZZ REZ ZWEEP BIT CRUSHER TEE WHT
22541 SANTA CRUZ SIEBEN HAND S/S T SHIRT WHITE
22664 ICECREAM BOXED DOG.TEE WHT/PP
23467 ICECREAM ICJP16T001 WHT
23684 SPITFIRE Bighead Grey Spiral Black Rib
24348 ICECREAM ICJP16T006 WHT
24349 ICECREAM EVIL SUNDAE TEE
24899 ANIMALIA GOLD WEST WHT
25409 FINCH Flame Blue/White - Baseball Shirt
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
47105 NOT COMMON SENSE GENESIS SEAM TEE WHITE
48233 Zephyren(ゼファレン)PONCHO HOODY S/S WHITE / 如意宝珠
49074 HOLDTUBE CARAVAN WP01 WHITE
49076 HOLDTUBE CARAVAN WP03 SMOKE BLUE
49746 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 戸山香澄ver.
49748 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 牛込りみver.
50185 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee WHITE
52285 あゆみくりかまき×ゲキクロ×ripdw AKM STAR HOODIE
52898 ANIMALIA AN20SP-CP01 '49Cap-LOGO WHITE x EMERALD
53068 SAMURAI CORE 地震ー雷ー火事ーオヤジ LONG TEE WHITE
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
38026 Subciety (サブサエティ) ザ・ベース S/S WHITE
53888 FILA F0494-1092 DISRUPTOR2 ICE ORANGE
55652 THRASHER (スラッシャー) TH91214US FLAME OUTLINE S/S T-SHIRTS WHITE/YELLOW
56220 Anti Social Social Club Sadness Is Happiness
56755 エルフリーデ×ゲキクロ×DI:VISION限定ロング・スリーブTシャツ WHITE/BLACK
54071 FILA DISRUPTOR SD WHITE
56424 Subciety (サブサエティ) SERVER L/S - WHITE
57390 FILA FS3008 T-Shirt WHITE
57414 THRASHER (スラッシャー) TH8528PLGONZ HOODIE WHITE
58059 ANIMALIA AN21S-TE03 Tokyo Disregard WHITE×BLACK
57312 【ゲキクロ限定】 HEDWiNG Creepy-ART Big shilhouette L/S T-shirt White
57306 HEDWiNG Pocket “MOJYAPON” T-shirt White
57322 Subciety×仮面ライダードライブ DRIVE S/S WHITE
58165 NOT COMMON SENSE DEAD TUDE TEE WHITE
58286 ANIMALIA AN21S-CS02 Calamity Jane L/S - SKUNK PAW WHITE
58789 HYPER CORE PINK SNIPER Tシャツ WHITE
58813 HYPER CORE PiSTOLTシャツ WHITE
59117 ANIMALIA AN21U-TE11 FALLING WHITE
59233 LONELY論理 LONELY UNIV TEE white
58453 Subciety×NARUTO-ナルト- 疾風伝 JIRAIYA L/S WHITE
59405 SUPPLIER (サプライヤー) SPIDER WEB TEE
58461 Subciety×NARUTO-ナルト- 疾風伝 NARUTO S/S WHITE
60101 LONELY論理 COTTON FRINGE HIPPIE HAT SAND
59955 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE WHITE
60127 HYPER CORE HTC-372 ぴえんICE BEAR Tシャツ WHITE
60240 acOlaSia VICTIM TEE WHITE
60246 acOlaSia MEDAMAYAKI TEE WHITE
53149 SAMURAI CORE 釈迦 TEE WHITE
54527 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE WHITE
56038 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE WHITE
60049 SAMURAI CORE リンガーTEE BLACK
60047 SAMURAI CORE リンガーTEE RED
60048 SAMURAI CORE リンガーTEE BLUE
60333 LONELY論理 COTTON DAMAGED CLASSIC LOGO CAP BIEGE
60330 LONELY論理 KAZAGURUMA HEARTS LONG SLEEVE WHITE
59162 VIRGO TY MOCK NECK WHITE
60372 GoneR GR30PK001 Chalice Parka White
60339 RUDIE'S (ルーディーズ) PHAT EMBROIDERY HOOD SWEAT WHITE
61207 XrossOver XOver K logo T (White)
61205 XrossOver XOver K logo LongT (White)
61419 VIRGO (ヴァルゴ) GLOWING EYES WHITE
20366 THRASHER (スラッシャー) TH8301 MAG LOGO L/S T-SHIRT WHT
61675 Ed Sheeran UNISEX LONG SLEEVED T-SHIRT: BAD HABITS STACK
61533 ZERO EVOKE Logo First SWEAT WHITE×BLACK
61547 ZERO EVOKE ZENON Graphic Logo SWEAT WHITE
61436 glamb (グラム)×攻殻機動隊 SAC_2045 T White
61853 A FEW GOOD KIDS ICECREAM TEE WHITE
62571 Survive Said The Prophet REDEFINE TOUR HOODIE WHITE
62608 HYPER CORE SICKS MUTE BEARロングスリーブTシャツ WHITE
62312 【予約商品】Zephyren(ゼファレン) TANKTOP - BEYOND - WHITE
61711 HEDWiNG College logo C/C Longsleeve T-shirt White
62625 LONELY論理 LONELISM6 LONG SLEEVE WHITE
62629 LONELY論理 OROCHI TAIJI LONG SLEEVE WHITE
63092 HYPER CORE Swallowスウェット WHITE
62830 PSYCHOLOGICAL METAMORPHOSIS SWITCHING 7 SLEEVE - BLACK / WHITE
63368 KEYTALK【Disney】ロングスリーブTシャツ (ステージ) WHITE
63370 KEYTALK【Disney】ロングスリーブTシャツ (縦割り) WHITE
56779 KEYTALK×GEKIROCK CLOTHING 限定コラボ・ロンT WHITE
62535 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE TOYMONSTER - WHITE
63211 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - WHITE
63186 ANIMALIA (アニマリア) SLUB Tee S/S - logo WHITE
63865 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ)×交響詩篇エウレカセブン“MAGICAL MOSH NIRVASH”WHITE
64198 Subciety (サブサエティ) MARIA TEE WHITE
63602 glamb (グラム) Behind Mosaic Long Sleeve T - White
63302 Anti Social Social Club Collapse White Socks
63387 Anti Social Social Club Down The Tube Pink/White Socks
63388 Anti Social Social Club Down The Tube Blue/White Socks
63300 Anti Social Social Club Down The Tube Black/White Socks
63296 Anti Social Social Club Playboy x ASSC Bunny White Socks
64309 Subciety (サブサエティ) LEAGUE TEE WHITE/BLUE
64314 Subciety (サブサエティ) SUPPORTER TEE WHITE
63258 沢城千春×SABBAT13×GEKIROCK CLOTHING Lying T-Shirt WHITE
64863 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE WHITE
64916 ANIMALIA (アニマリア) TITLE WHITE
64914 ANIMALIA (アニマリア) SCRIPT WHITE
64963 ROLLING CRADLE RC x KUDAN LOGO TEE / WHITE
65169 Subciety (サブサエティ) NOVEL GLORIOUS TEE-WHITE/BLACK
65179 Subciety(サブサエティ) BRACE TEE-WHITE/BLACK
65220 LONELY論理 LONELY論理×SANRIO KUROMI TAGGING CANVAS TOTE-OFF WHITE
65222 LONELY論理 LONELY論理×SANRIO SKATER CINAMOROLL CANVAS TOTE-OFF WHITE
65224 LONELY論理 LONELY論理×SANRIO KUROMI TAGGING T-SHIRTS-WHITE
65228 LONELY論理 LONELY論理×SANRIO ONIBI T-SHIRTS-WHITE
65226 LONELY論理 LONELY論理×SANRIO SKATER CINAMIROLL T-SHIRTS-WHITE
65279 SUPPLIER (サプライヤー) SPLR NECK LOGO TEE WHITE
64357 DI:VISION (ディヴィジョン) WATERGUN Tee WHITE
64353 【ゲキクロ限定】DI:VISION (ディヴィジョン) FICTION TEE WHITE
64359 DI:VISION (ディヴィジョン) FICTION LS TEE WHITE
65016 ハッピーハンバーグ レーシングチームメカニックシャツ WHITE
65333 Subciety (サブサエティ) LIBIDOS TEE WHITE
65549 over print (オーバープリント) over punx Pile Hoodie (white)
65161 BAD BOY (バッドボーイ) AMECOMI LOGO JQD P/O KNIT O.WHITE
65603 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S RAGLAN T" (NV/WH)
65800 RUDIE'S (ルーディーズ) COLLEGE LS-T-WHITE
65655 SAMURAI CORE(サムライコア) 初期衝動宣言BELT WHITE
65658 SAMURAI CORE(サムライコア) ガンズ&ザビエルTEE WHITE