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-04-29 01:50:17')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 13,35,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
22681 ライブキッズあるある ライブ行きたいTシャツ
21977 セプテンバーミー YES! YES! YES! Tシャツ 黒
22718 ザ・チャレンジ カラフルBOXロゴ Tシャツ BLK
23454 HER NAME IN BLOOD BEAST MODE TOUR T-Shirts
24261 UNDEAD CORPORATION LOGO Tshirt BLK×RED
28367 ALL OFF おふくろ国旗Tシャツ Black
13900 NEW BREED The DIVIDE TEE
21141 BEFORE MY LIFE FAILS NEW LOGO TEE BLACK
31952 Bentham ExPツアーTシャツ BLACK
20126 激ロック×サボパン【激サボパンTシャツ】 BLACK
42587 Bentham ポケットTシャツ ブラック
42595 Bentham Chicago Tシャツ ブラック
41079 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / BLACK
36971 フクザワ 【まったり】 Tシャツ
42513 RIP DESIGN WORXX BEACH SANDAL LADIES
21086 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT BLK
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
9424 WHITECHAPEL Riot Black T-Shirt
11451 TEXAS IN JULY Without A Head! Black
12067 PANTERA HOSTILE SKULL T-Shirt
21124 ATTILA Dirty Black
24662 ISSUES I Have Issues Black - T-Shirt
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
24758 WHITECHAPEL Sawblade Camo on Black - T-Shirt
25127 THE STORY SO FAR Snakes Black - T-Shirt
25227 MISS FORTUNE Leader Black - T-Shirt
25257 CAPTURE THE CROWN We Are All Royalty Black - T-Shirt
25302 BEFORE THEIR EYES Cross Black - T-Shirt
26455 SLEEPING WITH SIRENS Red Chain
27374 THE USED VULNERABLE T
27794 LANDON TEWERS The Captain Black
28295 THE BROWNING Skull Black
28310 FRONZILLA Party People's Anthem Black TankTop
28641 AMON AMARTH WOLFORD
31531 OF MICE AND MEN FLIP HAT DEMON TEE
55718 ASKING ALEXANDRIA UNISEX TEE: SKULL SHIELD (RETAIL PACK)
55722 CROWN THE EMPIRE UNISEX TEE: SACRIFICE (RETAIL PACK)
20216 【激ロック限定デザイン】NINJA KORE THE NINJA
20217 【激ロック限定デザイン】NINJA KORE MR.BOMB
52942 Survive Said The Prophet MIA TOUR TEE
52948 Survive Said The Prophet UNBALANCE TEE LIGHT BLUE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
7432 WOE IS ME Griffin Black
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
9428 THE WORD ALIVE Bullets Black T-Shirt
11283 CAPTURE THE CROWN Gargoyle Black
15342 WHITECHAPEL Doom Black
15383 WITHIN THE RUINS Red Crest Black Tank Top
15427 THE WORD ALIVE Lighthouse Black
15435 PIERCE THE VEIL Logo Black
15437 THE WORD ALIVE Poseiden Black
15496 ALL THAT REMAINS A War You Cannot Win Black
15509 WE CAME AS ROMANS Reasons Black
19001 WHITECHAPEL Pocket Blade Black
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
25491 THE SUMMER SET Legendary Black - T-Shirt
36784 DISTURBEDMusic As A Weapon 06-07 Tour T-shirt
36825 DEFTONES California Rider-Black t-shirt
37034 PANTERA Band Flames T-Shirt
36522 GoneR Dread Skull T-Shirts BLACK
70716 Survive Said The Prophet OMEN TEE
10236 METALLICA JUSTICE FOR ALL T-Shirt
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
35502 SLIPKNOT Blocks T-Shirt
35619 GUNS N' ROSES 30th Photo T-Shrts
36537 FIVE FINGER DEATH PUNCH Purgatory 2014 Tour-
36681 MEGADETH MEGADETH YAMAHA DRUMS
4449 THRASHER (スラッシャー) TH8101 Mag LogoTee BK/WH
54042 THRASHER (スラッシャー) FLAME LOGO S/S TEE BLACK
55679 RIP DESIGN WORXX アンノウンクラウンTシャツ BLACK
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BLACK
63197 ANIMALIA (アニマリア) Double Cutaway - logo BLACK
63318 GoneR (ゴナー) GR33TK001 Rose Maria Tank-Top Black
70714 Survive Said The Prophet MAKE / BREAK TEE (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
36878 DISTURBED Up Your Fist T-Shirts RED
39093 BABYMETAL CROSSBONE EYE SKELETON MENS SOFT TEE
54634 FILA FFM9841 ユニセックス クルーネックシャツ BLACK
32082 ライブキッズあるある フェス余韻パーカー
35489 RUDIE'S (ルーディーズ) SPARK-Tee BLK/WHT
59867 PSYCHOLOGICAL METAMORPHOSIS NOT TEE BLACK
71304 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE BK/BLU
585 RED HOT CHILI PEPPERS Asterisk Logo Black
700 METALLICA-KILL EM ALL
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
4598 NIRVANA Happy Face T-Shirt
10233 METALLICA DORIS T-Shirt
10235 METALLICA VINTAGE METAL UP T-Shirt
10258 GUNS N' ROSES CROSS T-Shirt
11984 ANTHRAX WORSHIP MUSIC T-Shirt
24329 RUDIE'S DRAWING-T BLACK
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
35289 SLIPKNOT UNISEX T-SHIRT: BAND FRAME
35296 SLIPKNOT UNISEX T-SHIRT: .5: THE GRAY CHAPTER (BACK PRINT)
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
35642 MARILYN MANSON RED LIPS T-SHIRTS
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
35655 PANTERA Red Vulgar T-Shirts
36830 GREEN DAY American Idiot Black T-shirt
37810 BULLET FOR MY VALENTINE Logo T-shirt Black
41960 BABYMETAL Unisex Tee: Skull Sword
45953 Crossfaith ORNAMENT TEE BLACK
51199 SLIPKNOT UNISEX TEE: WANYK LOGO (BACK PRINT)
51425 GREEN DAY Unisex Tee: Drips
51426 GREEN DAY Unisex Tee: Hypno 4
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
52713 BABYMETAL UNISEX TEE: LOGO
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52869 BILLIE EILISH UNISEX TEE: BLING BLACK
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
52907 KORN UNISEX TEE: DEATH DREAM
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES