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-05-04 16:49:49')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 12,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
22718 ザ・チャレンジ カラフルBOXロゴ Tシャツ BLK
24261 UNDEAD CORPORATION LOGO Tshirt BLK×RED
37836 Xmas Eileen DIS IS LOVE EYE Tシャツ(黒)
13900 NEW BREED The DIVIDE TEE
42595 Bentham Chicago Tシャツ ブラック
41079 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / BLACK
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
62572 Survive Said The Prophet TRADITIONAL TEE
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
25132 SEAWAY Colour Blind Logo Black - T-Shirt
25307 CHIODOS This is Love CRAIG Black - T-Shirt
28295 THE BROWNING Skull Black
28569 EXODUS HORNED SKUL
28026 ATTILA A T-Shirt
26543 UROBOROS TシャツB
28020 MYKA RELOCATE MYK-T01 TEE
52941 Survive Said The Prophet VERTICAL LOGO TEE
52942 Survive Said The Prophet MIA TOUR TEE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15601 TEXAS IN JULY Draw The Line Black Tie Dye
19881 TEXAS IN JULY Brain Black
36825 DEFTONES California Rider-Black t-shirt
37032 PANTERA Reinventing Band
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
35502 SLIPKNOT Blocks T-Shirt
35589 BRING ME THE HORIZON The H T-Shirts
35602 DISTURBED FIRE BEHIND T-SHIRTS
36657 FIVE FINGER DEATH PUNCH EAGLE PUNCH
36695 SLAYER LARGE BLACK EAGLE
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT 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
68607 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH GRADATION TEE YELLOW
68609 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) DORODORO MxMxM DRY TEE BLACK
39093 BABYMETAL CROSSBONE EYE SKELETON MENS SOFT TEE
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
59368 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE BLACK
64854 Wall Of Graphic(ウォールオブグラフィック)Ash2 Tシャツ
71304 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE BK/BLU
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
8372 FALLING IN REVERSE Lips T-Shirt BLACK
10233 METALLICA DORIS T-Shirt
10258 GUNS N' ROSES CROSS T-Shirt
11984 ANTHRAX WORSHIP MUSIC T-Shirt
12020 EVANESCENCE SHINE T-Shirt
24329 RUDIE'S DRAWING-T BLACK
28592 MARILYN MANSON CROWN T-Shirts
28694 AUGUST BURNS RED DOVE
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
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
37811 ALL TIME LOW UNISEX TEE: SCRATCH
43345 BRING ME THE HORIZON Sempiternal TEE
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
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
52928 RAGE AGAINST THE MACHINE UNISEX TEE: MOTOTOV (BACK PRINT)
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
54740 ANTHRAX UNISEX TEE: AMONG THE LIVING
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55732 SLAYER UNISEX TEE: REPENTLESS
55734 SLAYER UNISEX TEE: SILVER EAGLE
56810 AC/DC UNISEX TEE: ANGUS STATUE
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59255 NIRVANA Unisex Tee:White Happy Face
59257 NINE INCH NAILS Unisex Tee: Classic Logo
59258 Kurt Cobain Unisex Tee: Coloured Side View
59266 Ed Sheeran Unisex Tee: Divide
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
59278 BABYMETAL PENTAGRAM TEE
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
60189 MY CHEMICAL ROMANCE MY CHEMICAL ROMANCE UNISEX T-SHIRT: THE BLACK PARADE COVER
60191 MARILYN MANSON UNISEX T-SHIRT: WE ARE CHAOS (BACK PRINT)
66944 KORN UNISEX T-SHIRT: BLOCKS
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
66968 MEGADETH UNISEX T-SHIRT: PEACE SELLS… TRACK LIST (BACK PRINT)
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
67940 BRING ME THE HORIZON UNISEX T-SHIRT: WARRIOR
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
67953 FALL OUT BOY UNISEX T-SHIRT: TAKE THIS TO YOUR GRAVE
67954 FALL OUT BOY UNISEX T-SHIRT: POISONED YOUTH
67955 KORN UNISEX T-SHIRT: BLOCK PHOTO
67957 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY BLACK
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
67976 YUNGBLUD UNISEX T-SHIRT: WEIRD FLAMING SKELETONS (BACK PRINT)
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
68574 KORN UNISEX HI-BUILD T-SHIRT: LOGO
68575 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO BLACK