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-22 18:12:22')
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
70716 Survive Said The Prophet OMEN TEE
10236 METALLICA JUSTICE FOR ALL T-Shirt
25164 WE CAME AS ROMANS Regular Dudes Black - 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
35489 RUDIE'S (ルーディーズ) SPARK-Tee BLK/WHT
59867 PSYCHOLOGICAL METAMORPHOSIS NOT TEE BLACK
71304 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE BK/BLU
700 METALLICA-KILL EM ALL
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
10233 METALLICA DORIS T-Shirt
10235 METALLICA VINTAGE METAL UP T-Shirt
11984 ANTHRAX WORSHIP MUSIC T-Shirt
17951 AVENGED SEVENFOLD STELLAR
24672 SLEEPING WITH SIRENS Floral Black - T-Shirt
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
37810 BULLET FOR MY VALENTINE Logo T-shirt Black
41960 BABYMETAL Unisex Tee: Skull Sword
45953 Crossfaith ORNAMENT TEE BLACK
49512 SLIPKNOT .5 THE GRAY CHAPTER
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
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
56820 THE 1975 UNISEX TEE: BLACK TOUR
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
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
59265 Ed Sheeran Unisex Tee: Chords
59266 Ed Sheeran Unisex Tee: Divide
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
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)
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)
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
67940 BRING ME THE HORIZON UNISEX T-SHIRT: WARRIOR
67954 FALL OUT BOY UNISEX T-SHIRT: POISONED YOUTH