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 20:22:19')
AND pc.price02 > 2727
AND price02 <= 4545
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
36971 フクザワ 【まったり】 Tシャツ
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
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
9428 THE WORD ALIVE Bullets Black T-Shirt
11283 CAPTURE THE CROWN Gargoyle Black
15342 WHITECHAPEL Doom Black
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
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
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
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
54740 ANTHRAX UNISEX TEE: AMONG THE LIVING
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
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
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
60191 MARILYN MANSON UNISEX T-SHIRT: WE ARE CHAOS (BACK PRINT)
60194 TWENTY ONE PILOTS UNISEX T-SHIRT: BANDITO BIRD
60195 TWENTY ONE PILOTS UNISEX T-SHIRT: TRENCH CLIFF
60196 TWENTY ONE PILOTS UNISEX T-SHIRT: TORCH BEARERS
66941 BAD RELIGION UNISEX T-SHIRT: BURNING BLACK
66944 KORN UNISEX T-SHIRT: BLOCKS
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
66967 MEGADETH UNISEX T-SHIRT: KILLING IS MY BUSINESS (BACK PRINT)