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-27 00:07:10')
AND pc.price02 > 2727
AND price02 <= 4545
AND pc.stock > 0
AND pc.classcategory_id1 IN( 159)
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 7
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
71777 RADIOHEAD UNISEX T-SHIRT: CARBON PATCH
71778 RADIOHEAD UNISEX T-SHIRT: GAWPS
71779 RADIOHEAD UNISEX T-SHIRT: NOTE PAD (DEBOSSED)
585 RED HOT CHILI PEPPERS Asterisk Logo Black
1097 RED HOT CHILI PEPPERS Asterisk Logo White
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
4598 NIRVANA Happy Face T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
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
28592 MARILYN MANSON CROWN T-Shirts
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
35642 MARILYN MANSON RED LIPS T-SHIRTS
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
36830 GREEN DAY American Idiot Black T-shirt
41960 BABYMETAL Unisex Tee: Skull Sword
43345 BRING ME THE HORIZON Sempiternal TEE
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
45953 Crossfaith ORNAMENT TEE BLACK
49512 SLIPKNOT .5 THE GRAY CHAPTER
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
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
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
52907 KORN UNISEX TEE: DEATH DREAM
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
53189 BLACK VEIL BRIDES UNISEX TEE: INFERNO
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
55734 SLAYER UNISEX TEE: SILVER EAGLE
56820 THE 1975 UNISEX TEE: BLACK TOUR
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
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
59273 IRON MAIDEN Unisex Tee: Eddie Chained Legacy
59274 IRON MAIDEN Unisex Tee: Duality
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
66944 KORN UNISEX T-SHIRT: BLOCKS
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
67506 SUM41 UNISEX T-SHIRT: GRINNING SKULL
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
67955 KORN UNISEX T-SHIRT: BLOCK PHOTO
67956 KORN UNISEX T-SHIRT: STILL A FREAK (BACK PRINT)
67958 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY WHITE
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
67965 MARILYN MANSON UNISEX T-SHIRT: AMERICAN FAMILY (BACK PRINT)
67966 NIRVANA UNISEX T-SHIRT: ANGELIC
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
67974 YUNGBLUD LADIES T-SHIRT: RAVER SMILE (BACK PRINT)
67975 YUNGBLUD UNISEX T-SHIRT: FACE (BACK PRINT)
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
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
68576 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO WHITE
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
68579 NIRVANA UNISEX T-SHIRT: HEART (WASH COLLECTION)
68580 SLIPKNOT UNISEX T-SHIRT: ALIEN (BACK PRINT)
68581 SLIPKNOT UNISEX T-SHIRT: SKELETON & PENTAGRAM (BACK PRINT)
68582 SLIPKNOT UNISEX T-SHIRT: ADDERALL FACEBACK (BACK PRINT)
68583 SLIPKNOT UNISEX T-SHIRT: THE END (BACK PRINT)
68584 SYSTEM OF A DOWN UNISEX T-SHIRT: TOXICITY
68833 SLIPKNOT UNISEX T-SHIRT: ZOMBIE (BACK PRINT)
68835 SLIPKNOT UNISEX T-SHIRT: DEVIL SINGLE - LOGO BLUR (BACK PRINT)
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
69158 DEF LEPPARD UNISEX T-SHIRT: CLASSIC TRIANGLE
69159 DEF LEPPARD UNISEX T-SHIRT: TRIANGLE LOGO
69161 DEF LEPPARD UNISEX T-SHIRT: HYSTERIA WORLD TOUR (BACK PRINT)
69162 MOTLEY CRUE UNISEX T-SHIRT: TOO FAST CYCLE
69354 BRING ME THE HORIZON UNISEX T-SHIRT: FLAMING HEX BLACK
69356 BAD OMENS UNISEX T-SHIRT: RAM SKULL BLACK
69442 BRING ME THE HORIZON UNISEX T-SHIRT: ALL HAIL (BACK PRINT)
69765 BAD OMENS UNISEX T-SHIRT: TAKE ME
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
70554 BRING ME THE HORIZON UNISEX T-SHIRT: WHY...?
70557 SUM41 UNISEX T-SHIRT: REAPER
70685 LINKIN PARK UNISEX T-SHIRT: METEORA PORTRAITS
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
70819 POLYPHIA UNISEX T-SHIRT: RITUAL
70820 POLYPHIA UNISEX T-SHIRT: SKULL CIRCLE P
70935 BLINK-182 UNISEX T-SHIRT: OVERBOARD EVENT
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
70945 SLEEP TOKEN UNISEX T-SHIRT: TAKE ME BACK TO EDEN
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
71249 MÅNESKIN UNISEX T-SHIRT: TEATRO D'IRA DOODLES (BACK PRINT & EX-TOUR)
71313 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 FACES
71430 SKINDRED UNISEX T-SHIRT: LOUD MUSIC
71431 SKINDRED UNISEX T-SHIRT: RASTA LOGO
71494 AVRIL LAVIGNE UNISEX T-SHIRT: LOVE SUX (BACK PRINT)
71495 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: WOLFMAN
71496 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: DETROIT (BACK PRINT)
71497 BAD OMENS UNISEX T-SHIRT: SUNFLOWER
71498 DEFTONES UNISEX T-SHIRT: SPHYNX
71499 DEFTONES UNISEX T-SHIRT: STATIC SKULL (BACK PRINT)