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-04-30 18:27:23')
AND pc.price02 > 2727
AND price02 <= 4545
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 120, 120
19001 WHITECHAPEL Pocket Blade Black
19004 WHITECHAPEL Simple Flag Black
19093 ATTILA South By Suck My Fuck Black
19095 ATTILA Biker Black T-Shirt
19107 ATTILA SLUGGER BLACK
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
19881 TEXAS IN JULY Brain Black
19884 WITHIN THE RUINS Agent Of Chaos Black
19894 FINCH Hand Heather RED T-Shirt
20553 PALISADES Wolves...TS Black
25482 PIERCE THE VEIL Orange Seal Black - T-Shirt
25491 THE SUMMER SET Legendary Black - T-Shirt
35603 DISTURBED Up Your Fist T-Shirts
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
36522 GoneR Dread Skull T-Shirts BLACK
70716 Survive Said The Prophet OMEN TEE
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
36668 IRON MAIDEN BOOK OF SOULS EDDIE
36670 IRON MAIDEN HIGHWAY
36673 JUDAS PRIEST PAINKILLER SOLO
36681 MEGADETH MEGADETH YAMAHA DRUMS
36695 SLAYER LARGE BLACK EAGLE
14880 SO SO HAPPY You Make Me Melt
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
54042 THRASHER (スラッシャー) FLAME LOGO S/S TEE BLACK
55679 RIP DESIGN WORXX アンノウンクラウンTシャツ BLACK
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BLACK
70714 Survive Said The Prophet MAKE / BREAK TEE (BLACK)
63407 Meltyglow (メルティグロウ) Melty総柄デザイン CUTSEW
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
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
36878 DISTURBED Up Your Fist T-Shirts RED
39093 BABYMETAL CROSSBONE EYE SKELETON MENS SOFT TEE
49846 DISTURBED LOST SOULS
54634 FILA FFM9841 ユニセックス クルーネックシャツ BLACK
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
9644 SLIP&Co. BAMBINX TEE BLACK
28047 SPITFIRE Bighead Fill T-Shirt - Black/Red
35489 RUDIE'S (ルーディーズ) SPARK-Tee BLK/WHT
36618 RIP DESIGN WORXX エレメントTシャツ GRAY
44842 KILL STAR CLOTHING She Devil Crop Top
59368 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE BLACK
59867 PSYCHOLOGICAL METAMORPHOSIS NOT TEE BLACK
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
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
4599 NIRVANA MANY Happy Face T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
8372 FALLING IN REVERSE Lips T-Shirt BLACK
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
12020 EVANESCENCE SHINE T-Shirt
21159 BLACK CRAFT Aquarius
24329 RUDIE'S DRAWING-T BLACK
28592 MARILYN MANSON CROWN T-Shirts
28694 AUGUST BURNS RED DOVE
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
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
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
36663 GUNS N' ROSES BULLET LOGO
36830 GREEN DAY American Idiot Black T-shirt
37810 BULLET FOR MY VALENTINE Logo T-shirt Black
37811 ALL TIME LOW UNISEX TEE: SCRATCH
41960 BABYMETAL Unisex Tee: Skull Sword
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
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