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-25 16:47:35')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 240, 120
25491 THE SUMMER SET Legendary Black - T-Shirt
36238 SLAYER No Mercy-Black T-shirt
36784 DISTURBEDMusic As A Weapon 06-07 Tour T-shirt
36825 DEFTONES California Rider-Black t-shirt
37032 PANTERA Reinventing Band
37034 PANTERA Band Flames T-Shirt
37586 MEGADETH -Dystopia-Black t-shirt
14988 Agape Attire SON OF THE MOST HIGH TEE
16679 【ゲキクロ限定カラー】lynch. ツアーTシャツ BLUE
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
35515 ALL OFF×LILWHITE. SEEKER T-shirt Black×Red
58357 KILL STAR CLOTHING Lock Me Up Choker
61604 HYPER CORE VACCINATEDニーハイ
61605 HYPER CORE BOOSTニーハイ
61606 HYPER CORE GRUDGEニーハイ
61607 HYPER CORE MUMMYディザイアニーハイ
66484 MAGICAL MOSH MISFITS ネズミニット帽 BLACK
70716 Survive Said The Prophet OMEN TEE
70719 Survive Said The Prophet CIRCLE BUCKET HAT BLACK
70722 Survive Said The Prophet UNIVERSE BUCKET HAT
28113 Xmas Eileen ビーチサンダル&ビニールバッグSET BLK
10236 METALLICA JUSTICE FOR ALL T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
28627 GUNS N' ROSES HEADS VINTAGE
35292 SLIPKNOT PAUL GRAY
35502 SLIPKNOT Blocks T-Shirt
35589 BRING ME THE HORIZON The H T-Shirts
35602 DISTURBED FIRE BEHIND T-SHIRTS
35609 FIVE FINGER DEATH PUNCH SGT MAJOR
35619 GUNS N' ROSES 30th Photo T-Shrts
36537 FIVE FINGER DEATH PUNCH Purgatory 2014 Tour-
36657 FIVE FINGER DEATH PUNCH EAGLE PUNCH
36664 GUNS N' ROSES APPETITE LOGO Beanie
36665 GUNS N' ROSES BULLET LOGO Beanie
36668 IRON MAIDEN BOOK OF SOULS EDDIE
36673 JUDAS PRIEST PAINKILLER SOLO
36681 MEGADETH MEGADETH YAMAHA DRUMS
36695 SLAYER LARGE BLACK EAGLE
51190 SLIPKNOT UNISEX FINGERLESS GLOVES: LOGO
69945 ROLLING CRADLE (ローリングクレイドル) HEART CRADLE CAP CHARCOAL
14880 SO SO HAPPY You Make Me Melt
69913 PUNK DRUNKERS(パンクドランカーズ) あみだボクサーパンツ - BLACK
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
4449 THRASHER (スラッシャー) TH8101 Mag LogoTee BK/WH
12162 SPITFIRE MASSACRE S/S Tee BLACK
28235 SRH TRIBE WOMENS TEE BLACK
41142 HOLDTUBE ANS1706 SACOSH ORIJINAL DENIM
54042 THRASHER (スラッシャー) FLAME LOGO S/S TEE BLACK
55679 RIP DESIGN WORXX アンノウンクラウンTシャツ BLACK
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BLACK
63195 ANIMALIA (アニマリア) TANK TOP - logo BLACK
63197 ANIMALIA (アニマリア) Double Cutaway - logo BLACK
63318 GoneR (ゴナー) GR33TK001 Rose Maria Tank-Top Black
63699 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Black
68210 LOVE KILLER(ラブキラー) KILLER HAND WARMER BLACK
68212 LOVE KILLER(ラブキラー) KILLER HAND WARMER BLACK×WHITE
69473 LOVE KILLER(ラブキラー) killer border muffler ブラック
70714 Survive Said The Prophet MAKE / BREAK TEE (BLACK)
63407 Meltyglow (メルティグロウ) Melty総柄デザイン CUTSEW
64093 Meltyglow (メルティグロウ) 刺繍入り配色LOGO CAP【ORANGE×BLACK】
68158 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE WHITE
68159 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE YELLOW
68606 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH GRADATION TEE COLD
68607 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH GRADATION TEE YELLOW
68609 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) DORODORO MxMxM DRY TEE BLACK
69487 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) ニット帽 BLACKxWHITE
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
18831 KILL STAR CLOTHING PIZZA ORDER MUSCLE TANK [B]
36878 DISTURBED Up Your Fist T-Shirts RED
39093 BABYMETAL CROSSBONE EYE SKELETON MENS SOFT TEE
49846 DISTURBED LOST SOULS
63444 BAD BOY (バッドボーイ) RAINBOW EMBROIDERY TEE BLACK
63447 BAD BOY (バッドボーイ) FIREPATTERN LOGO PRINT Tee BLACK
63820 BAD BOY (バッドボーイ) TEAM LOGO EMBROIDERY TEE BLACK
63825 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY TEE BLACK
67781 TRAVAS TOKYO【トラバストーキョー】 Loose leg warmer BLACK×WHITE
3211 RUDIE'S SPARK MESH CAP BLACK/BLACK/WHITE
9644 SLIP&Co. BAMBINX TEE BLACK
12066 OF MICE & MEN SNAKE Raglan T-Shirt
26173 PARKWAY DRIVE PWD Black-Gray Beanie
28047 SPITFIRE Bighead Fill T-Shirt - Black/Red
35489 RUDIE'S (ルーディーズ) SPARK-Tee BLK/WHT
36701 RUDIE'S (ルーディーズ) SPARK GALAXY iQOS PROTECTOR
37316 RUDIE'S HEAD GEAR SPARK MESH CAP
42988 RUDIE'S SPARK iQOS PROTECTOR BLACK/WHITE
56814 AC/DC UNISEX BEANIE HAT: OVAL LOGO (CABLE-KNIT)
56815 AC/DC TURNTABLE SLIPMAT SET: LET THERE BE ROCK/ROCK & ROLL (RETAIL PACK)
58673 KILL STAR CLOTHING Bad Faith Earrings
58675 KILL STAR CLOTHING Chiroptera Earrings
59368 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE BLACK
59867 PSYCHOLOGICAL METAMORPHOSIS NOT TEE BLACK
65146 ANIMALIA VELCRO WALLET - SKUNK SCOUT
66259 ANIMALIA (アニマリア) ROLL UP BEANIE BLACK
68453 RUDIE'S (ルーディーズ) PHAT POUCH BLACK
68482 over print (オーバープリント) Visor BLACK
68793 界川 深幸×CMP LABEL コラボ限定トートバッグ
69453 PUNK DRUNKERS (パンクドランカーズ) ひとりぼっちニットCAP
71316 MÅNESKIN UNISEX MESH BACK CAP: LOUD KIDS ON TOUR
71423 Subciety (サブサエティ) CREST TANK TOP BLACK
56902 Anti Social Social Club SAFE AND SOUND BLACK (LUGGAUGE STRAP)
60084 NieR (ニーア) GRAPHIC CUTSEW【きぐるみミケ】
64854 Wall Of Graphic(ウォールオブグラフィック)Ash2 Tシャツ
71304 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE BK/BLU
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
27392 THRASHER 16TH-C25 WASH CAP BLACK
55646 Anti Social Social Club MEDICAL MASK
59311 Anti Social Social Club Sweet And Sour Rainbow Mask
63238 DXMOUVE(ドゥモーヴェ) ストレンジトイ切替半袖プルオーバー カラフル
23453 HER NAME IN BLOOD NEON HOODIE
39529 KILL STAR CLOTHING Nikky Choker [B]
41070 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 BLACK / RED
41072 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 BLACK / PURPLE
70520 DXMOUVE(ドゥモーヴェ) 変形フラップ付きワイドパンツ
70623 DXMOUVE (ドゥモーヴェ) リングZIP付パーカー
585 RED HOT CHILI PEPPERS Asterisk Logo Black
700 METALLICA-KILL EM ALL
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
4598 NIRVANA Happy Face T-Shirt