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-20 21:57:51')
AND pc.price02 > 2727
AND price02 <= 4545
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 p.update_date
LIMIT 0, 120
52942 Survive Said The Prophet MIA TOUR TEE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
52941 Survive Said The Prophet VERTICAL LOGO TEE
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
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
21159 BLACK CRAFT Aquarius
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
25132 SEAWAY Colour Blind Logo Black - T-Shirt
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
25307 CHIODOS This is Love CRAIG Black - T-Shirt
26543 UROBOROS TシャツB
28020 MYKA RELOCATE MYK-T01 TEE
28026 ATTILA A T-Shirt
28295 THE BROWNING Skull Black
28569 EXODUS HORNED SKUL
28694 AUGUST BURNS RED DOVE
35602 DISTURBED FIRE BEHIND T-SHIRTS
36657 FIVE FINGER DEATH PUNCH EAGLE PUNCH
36695 SLAYER LARGE BLACK EAGLE
36825 DEFTONES California Rider-Black t-shirt
37032 PANTERA Reinventing Band
39093 BABYMETAL CROSSBONE EYE SKELETON MENS SOFT TEE
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52869 BILLIE EILISH UNISEX TEE: BLING BLACK
52928 RAGE AGAINST THE MACHINE UNISEX TEE: MOTOTOV (BACK PRINT)
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
11984 ANTHRAX WORSHIP MUSIC T-Shirt
12020 EVANESCENCE SHINE T-Shirt
54740 ANTHRAX UNISEX TEE: AMONG THE LIVING
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
55732 SLAYER UNISEX TEE: REPENTLESS
56810 AC/DC UNISEX TEE: ANGUS STATUE
58513 DESURABBITS × ゲキクロ × KAVANE Clothing 限定コラボ・Tシャツ
45953 Crossfaith ORNAMENT TEE BLACK
59278 BABYMETAL PENTAGRAM TEE
52713 BABYMETAL UNISEX TEE: LOGO
59368 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE BLACK
62572 Survive Said The Prophet TRADITIONAL TEE
62997 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 人類代表次鋒 アダム "拳骨主義" TEE
62995 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 人類先鋒 呂布奉先 "否" TEE
62994 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 神代表先鋒 トール "雷槌" TEE
62993 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ ブリュンヒルデ「ビビってるんですか?」TEE
62117 ROLLING CRADLE Mjolnir TEE / BLACK
63365 KEYTALK【Disney】Tシャツ (ステージ) BLACK
63444 BAD BOY (バッドボーイ) RAINBOW EMBROIDERY TEE BLACK
63447 BAD BOY (バッドボーイ) FIREPATTERN LOGO PRINT Tee BLACK
63193 ANIMALIA (アニマリア) HOODIE Tee S/S - logo BLACK
63825 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY TEE BLACK
63820 BAD BOY (バッドボーイ) TEAM LOGO EMBROIDERY TEE BLACK
64207 kirou school (キロウスクール) krs_07 club logo S/S T-shirts BLACK
64211 kirou school (キロウスクール) krs_08 JUST SLEEP S/S T-shirts BLACK
64854 Wall Of Graphic(ウォールオブグラフィック)Ash2 Tシャツ
64859 Wall Of Graphic(ウォールオブグラフィック)WG2 Tシャツ ブラック
64894 kirou school (キロウスクール) krs_09 "GSD" T-shirts BLACK
64936 kirou school (キロウスクール) krs_011 counter logo S/S T-shirts BLACK
65272 kirou school (キロウスクール) krs_012 cheat S/S T-shirts BLACK
67976 YUNGBLUD UNISEX T-SHIRT: WEIRD FLAMING SKELETONS (BACK PRINT)
68159 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE YELLOW
68158 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE WHITE
68584 SYSTEM OF A DOWN UNISEX T-SHIRT: TOXICITY
68586 SYSTEM OF A DOWN UNISEX T-SHIRT: BANNER MARCHES
37811 ALL TIME LOW UNISEX TEE: SCRATCH
66968 MEGADETH UNISEX T-SHIRT: PEACE SELLS… TRACK LIST (BACK PRINT)
35655 PANTERA Red Vulgar T-Shirts
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
68744 Gluttonous Slaughter(グラトナススローター) Feast of the Unbirthed T-shirt BLACK
68607 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH GRADATION TEE YELLOW
68609 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) DORODORO MxMxM DRY TEE BLACK
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
68545 THRASHER (スラッシャー) Gonz Thumbs Up S/S T-SHIRTS BLACK
4449 THRASHER (スラッシャー) TH8101 Mag LogoTee BK/WH
54042 THRASHER (スラッシャー) FLAME LOGO S/S TEE BLACK
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BLACK
67665 PUNK DRUNKERS(パンクドランカーズ)アイツ大佐TEE - SUMI
68890 FACT101(ファクト・イチマルイチ) 『Peace』 Tシャツ BLACK
68908 FACT101(ファクト・イチマルイチ) 『妖』 Tシャツ BLACK
68902 FACT101(ファクト・イチマルイチ) 『殺戮バニーガール』 Tシャツ BLACK
68741 Gluttonous Slaughter(グラトナススローター) The Monster Slayer Cat T-shirt BLACK
69065 Dogmatic Gourmet x over print x RIP DESIGN WORXX ラーメンガールTシャツ BLACK
69160 DEF LEPPARD UNISEX T-SHIRT: SHATTER
69159 DEF LEPPARD UNISEX T-SHIRT: TRIANGLE LOGO
69158 DEF LEPPARD UNISEX T-SHIRT: CLASSIC TRIANGLE
69164 MOTLEY CRUE UNISEX T-SHIRT: THEATRE OF PAIN CRY
69163 MOTLEY CRUE UNISEX T-SHIRT: FEELGOOD HOLLYWOOD REVISION
69162 MOTLEY CRUE UNISEX T-SHIRT: TOO FAST CYCLE
35589 BRING ME THE HORIZON The H T-Shirts
70714 Survive Said The Prophet MAKE / BREAK TEE (BLACK)
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
70946 SLEEP TOKEN UNISEX T-SHIRT: EUCLID
71304 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE BK/BLU
71313 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 FACES
67954 FALL OUT BOY UNISEX T-SHIRT: POISONED YOUTH
59266 Ed Sheeran Unisex Tee: Divide
59258 Kurt Cobain Unisex Tee: Coloured Side View
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
59255 NIRVANA Unisex Tee:White Happy Face
10258 GUNS N' ROSES CROSS T-Shirt
51426 GREEN DAY Unisex Tee: Hypno 4
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED