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-01 17:33:42')
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) DESC
LIMIT 480, 120
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
70818 POLYPHIA UNISEX T-SHIRT: CHERUB
70819 POLYPHIA UNISEX T-SHIRT: RITUAL
70820 POLYPHIA UNISEX T-SHIRT: SKULL CIRCLE P
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
70938 RED HOT CHILI PEPPERS UNISEX HI-BUILD T-SHIRT: CLASSIC ASTERISK LOGO
70946 SLEEP TOKEN UNISEX T-SHIRT: EUCLID
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
70948 SUM41 UNISEX T-SHIRT: AKNF SKELETON EUROPEAN TOUR 2022 (BACK PRINT & EX-TOUR)
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
71249 MÅNESKIN UNISEX T-SHIRT: TEATRO D'IRA DOODLES (BACK PRINT & EX-TOUR)
71250 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 POSTER (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
71493 AVRIL LAVIGNE UNISEX T-SHIRT: LOVE SUX BALLOONS
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)
71500 DEFTONES UNISEX T-SHIRT: STAR & PONY
71501 MOTIONLESS IN WHITE UNISEX T-SHIRT: SPLIT SCREEN
71502 MOTIONLESS IN WHITE UNISEX T-SHIRT: GRAVEYARD SHIFT
71503 NINE INCH NAILS UNISEX T-SHIRT: DOWNWARD SPIRAL (BACK PRINT)
71504 NINE INCH NAILS UNISEX T-SHIRT: HEAD LIKE A HOLE
71505 SYSTEM OF A DOWN UNISEX T-SHIRT: DOVE OVERCOME
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
60084 NieR (ニーア) GRAPHIC CUTSEW【きぐるみミケ】
64854 Wall Of Graphic(ウォールオブグラフィック)Ash2 Tシャツ
71304 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE BK/BLU
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
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
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
63407 Meltyglow (メルティグロウ) Melty総柄デザイン CUTSEW
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)
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
14880 SO SO HAPPY You Make Me Melt
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
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
14988 Agape Attire SON OF THE MOST HIGH TEE
7432 WOE IS ME Griffin Black
9317 MEMPHIS MAY FIRE Challenger Black T-Shirt
9322 CAPTURE THE CROWN Walking Dead Black
9369 ATTILA Sugar Skull Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
11283 CAPTURE THE CROWN Gargoyle Black
11432 WHITECHAPEL Priest Black T-Shirt
11445 WHITECHAPEL Ouija Black Girl T-Shirt
11454 THE WORD ALIVE I'd Rather Die Black
15342 WHITECHAPEL Doom Black
15351 WHITECHAPEL Backfire Black
15386 NORTHLANE Snakes Black
15408 MEMPHIS MAY FIRE Red Logo Black
15409 MEMPHIS MAY FIRE Texas Torch Black
15427 THE WORD ALIVE Lighthouse Black
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15435 PIERCE THE VEIL Logo Black
15436 PIERCE THE VEIL Seal Black T-Shirt
15437 THE WORD ALIVE Poseiden Black
15464 MOTIONLESS IN WHITE Raven Black TEE
15467 CHIODOS This Is Love Band - T-Shirt
15496 ALL THAT REMAINS A War You Cannot Win Black
15508 WE CAME AS ROMANS Dave & Kyle Live Black T-Shirt
15509 WE CAME AS ROMANS Reasons Black
15510 WE CAME AS ROMANS Hope Crest Black
15532 MAYDAY PARADE Photo Black
15535 MAYDAY PARADE Broken Heart Black
15537 MAYDAY PARADE Chain Gang Black
15582 TEXAS IN JULY Vice Black
15601 TEXAS IN JULY Draw The Line Black Tie Dye
18979 MEMPHIS MAY FIRE Nautical Black
18981 MEMPHIS MAY FIRE Cartoon Matty Black
19001 WHITECHAPEL Pocket Blade Black