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 18:12:03')
AND pc.stock > 0
AND pc.point_rate >1
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
65079 glamb (グラム)GB0422/SH05 : Double Layered SH / ダブルレイヤードシャツ - Khaki×White
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
61440 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie White
61945 glamb (グラム) Paisley Pajamas SH - White
63518 glamb (グラム) Lips and Song Turtle Knit - White
64096 SLEEPING TABLET(スリーピング・タブレット) RECIPE [ BAND COLLAR SHIRTS ] WHITE
61278 LONELY論理 CHRYSANTHEMUM HOODIE WHITE
61285 LONELY論理 KAMIKAZE HOODIE WHITE
63082 MISHKA (ミシカ) M21100201 SHIRT
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
54612 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG WHITE
61092 VIRGO CLOTH CARRYING SHIRTS WHITE
61568 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE CREAM
58109 MISHKA M21000404 Pullover WHITE
57032 VIRGO Upright zip swt WHITE
62566 NineMicrophones CRAZY SHIRT BLACK/WHITE
62567 NineMicrophones CRAZY SHIRT MULTI
57332 Subciety×仮面ライダードライブ MACH PARKA WHITE
59498 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - WHITE
57073 SLIGHTLY NUMB×Kappa shoes WHITE
61416 VIRGO KITE ZIPPER CUTSHIRTS WHITE
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
59492 Zephyren(ゼファレン) EMBLEM SHIRT L/S WHITE
61867 glamb (グラム) Military Remake CS - White×Khaki
63103 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT WHITE
53075 SAMURAI CORE 釈迦 HOODIE WHITE
55130 Zephyren(ゼファレン)PARKA - variat omnia tempus - WHITE
59299 Subciety (サブサエティ) CORDUROY CHEF PANTS IVORY
60418 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE WHITE
61404 NineMicrophones SWEAT-Wanderer- WHITE
64941 A FEW GOOD KIDS (アフューグッドキッズ) DATING CLUB LONG SLEEVE WHITE
56195 NOT COMMON SENSE BRAIN LAYERED L/S TEE WHITE
56213 Anti Social Social Club Headrush All Over White Tee
29197 Subciety (サブサエティ) PAISLEY JACQUARD P/O S/S OFF_WHITE
32632 Subciety (サブサエティ) EMBLEM SHIRT S/S-STRIPE- OFF-WHITE
52915 FILA × STAPLE FM9880 WHITE
56525 SILLENT FROM ME VEIN -Cable Knit Snood- WHITE
61819 acOlaSia (アコレイジア) VxC hoodie WHITE
62184 acOlaSia (アコレイジア) GAMING hoodie WHITE
53958 KONUS Color Blocked Oversized Short Sleeve TEAL
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
58161 NOT COMMON SENSE FLAME L/S TEE WHITE
61848 A FEW GOOD KIDS DRIP CIRCLE LOGO LONG SLEEVE WHITE
60165 Anti Social Social Club THE REAL ME WHITE TEE
48288 Subciety (サブサエティ) SUKA SOUVENIR S/S WHITE
50019 FILA F0431-0147 DISRUPTOR Ⅱ ICE
50847 FILA F0430-0156 DISRUPTOR 2 NO-SEW WHITE
56210 Anti Social Social Club Enrique White Vneck Tee
59239 LONELY論理 LONELY UNIV SWEAT SHORTS white
63723 over print (オーバープリント) Aurora CAP
56291 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (WHITE)
63771 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - OFF WHITE
64937 A FEW GOOD KIDS (アフューグッドキッズ) STARRY SKY LOGO TEE WHITE
64939 A FEW GOOD KIDS (アフューグッドキッズ) POPULAR CARTOON TEE WHITE
64943 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE WHITE
65005 TRAVAS TOKYO【トラバストーキョー】 配色ニットポロシャツ/White×Blue(ホワイト×ブルー)
60844 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカー WHITE
48233 Zephyren(ゼファレン)PONCHO HOODY S/S WHITE / 如意宝珠
49746 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 戸山香澄ver.
49748 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 牛込りみver.
53888 FILA F0494-1092 DISRUPTOR2 ICE ORANGE
59955 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE WHITE
60330 LONELY論理 KAZAGURUMA HEARTS LONG SLEEVE WHITE
60339 RUDIE'S (ルーディーズ) PHAT EMBROIDERY HOOD SWEAT WHITE
60372 GoneR GR30PK001 Chalice Parka White
62625 LONELY論理 LONELISM6 LONG SLEEVE WHITE
62629 LONELY論理 OROCHI TAIJI LONG SLEEVE WHITE
65161 BAD BOY (バッドボーイ) AMECOMI LOGO JQD P/O KNIT O.WHITE
53068 SAMURAI CORE 地震ー雷ー火事ーオヤジ LONG TEE WHITE
59162 VIRGO TY MOCK NECK WHITE
61853 A FEW GOOD KIDS ICECREAM TEE WHITE
64863 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE WHITE
58453 Subciety×NARUTO-ナルト- 疾風伝 JIRAIYA L/S WHITE
63092 HYPER CORE Swallowスウェット WHITE
63602 glamb (グラム) Behind Mosaic Long Sleeve T - White
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
47105 NOT COMMON SENSE GENESIS SEAM TEE WHITE
57312 【ゲキクロ限定】 HEDWiNG Creepy-ART Big shilhouette L/S T-shirt White
58286 ANIMALIA AN21S-CS02 Calamity Jane L/S - SKUNK PAW WHITE
60101 LONELY論理 COTTON FRINGE HIPPIE HAT SAND
64963 ROLLING CRADLE RC x KUDAN LOGO TEE / WHITE
56038 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE WHITE
61547 ZERO EVOKE ZENON Graphic Logo SWEAT WHITE
56424 Subciety (サブサエティ) SERVER L/S - WHITE
54071 FILA DISRUPTOR SD WHITE
61205 XrossOver XOver K logo LongT (White)
52285 あゆみくりかまき×ゲキクロ×ripdw AKM STAR HOODIE
61711 HEDWiNG College logo C/C Longsleeve T-shirt White
56220 Anti Social Social Club Sadness Is Happiness
58165 NOT COMMON SENSE DEAD TUDE TEE WHITE
59233 LONELY論理 LONELY UNIV TEE white
59405 SUPPLIER (サプライヤー) SPIDER WEB TEE
60047 SAMURAI CORE リンガーTEE RED
60048 SAMURAI CORE リンガーTEE BLUE
60049 SAMURAI CORE リンガーTEE BLACK
60333 LONELY論理 COTTON DAMAGED CLASSIC LOGO CAP BIEGE
62608 HYPER CORE SICKS MUTE BEARロングスリーブTシャツ WHITE
63296 Anti Social Social Club Playboy x ASSC Bunny White Socks
64359 DI:VISION (ディヴィジョン) FICTION LS TEE WHITE
61436 glamb (グラム)×攻殻機動隊 SAC_2045 T White
61533 ZERO EVOKE Logo First SWEAT WHITE×BLACK
64140 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ LONG SLEEVE ] WHITE
53149 SAMURAI CORE 釈迦 TEE WHITE
54527 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE WHITE
56755 エルフリーデ×ゲキクロ×DI:VISION限定ロング・スリーブTシャツ WHITE/BLACK
57322 Subciety×仮面ライダードライブ DRIVE S/S WHITE
58461 Subciety×NARUTO-ナルト- 疾風伝 NARUTO S/S WHITE
61207 XrossOver XOver K logo T (White)
60240 acOlaSia VICTIM TEE WHITE
60246 acOlaSia MEDAMAYAKI TEE WHITE
57306 HEDWiNG Pocket “MOJYAPON” T-shirt White
64309 Subciety (サブサエティ) LEAGUE TEE WHITE/BLUE
64312 Subciety (サブサエティ) Monogram TEE WHITE
64314 Subciety (サブサエティ) SUPPORTER TEE WHITE
65016 ハッピーハンバーグ レーシングチームメカニックシャツ WHITE
59117 ANIMALIA AN21U-TE11 FALLING WHITE
64357 DI:VISION (ディヴィジョン) WATERGUN Tee WHITE
62535 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE TOYMONSTER - WHITE
63211 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - WHITE