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-04 01:56:56')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 159)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 240, 120
70935 BLINK-182 UNISEX T-SHIRT: OVERBOARD EVENT
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
70557 SUM41 UNISEX T-SHIRT: REAPER
67506 SUM41 UNISEX T-SHIRT: GRINNING SKULL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
60192 RED HOT CHILI PEPPERS UNISEX T-SHIRT: GETAWAY ALBUM ASTERISK
585 RED HOT CHILI PEPPERS Asterisk Logo Black
1097 RED HOT CHILI PEPPERS Asterisk Logo White
10235 METALLICA VINTAGE METAL UP T-Shirt
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
10233 METALLICA DORIS T-Shirt
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
59257 NINE INCH NAILS Unisex Tee: Classic Logo
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
70279 BULLET FOR MY VALENTINE UNISEX T-SHIRT: FLORAL OMEN
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
35642 MARILYN MANSON RED LIPS T-SHIRTS
28592 MARILYN MANSON CROWN T-Shirts
67965 MARILYN MANSON UNISEX T-SHIRT: AMERICAN FAMILY (BACK PRINT)
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
68574 KORN UNISEX HI-BUILD T-SHIRT: LOGO
67955 KORN UNISEX T-SHIRT: BLOCK PHOTO
52907 KORN UNISEX TEE: DEATH DREAM
66944 KORN UNISEX T-SHIRT: BLOCKS
68576 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO WHITE
68575 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO BLACK
70685 LINKIN PARK UNISEX T-SHIRT: METEORA PORTRAITS
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
68577 LINKIN PARK UNISEX T-SHIRT: LIVING THINGS ALBUM
67957 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY BLACK
67958 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY WHITE
35502 SLIPKNOT Blocks T-Shirt
68581 SLIPKNOT UNISEX T-SHIRT: SKELETON & PENTAGRAM (BACK PRINT)
68580 SLIPKNOT UNISEX T-SHIRT: ALIEN (BACK PRINT)
68835 SLIPKNOT UNISEX T-SHIRT: DEVIL SINGLE - LOGO BLUR (BACK PRINT)
35289 SLIPKNOT UNISEX T-SHIRT: BAND FRAME
35296 SLIPKNOT UNISEX T-SHIRT: .5: THE GRAY CHAPTER (BACK PRINT)
68583 SLIPKNOT UNISEX T-SHIRT: THE END (BACK PRINT)
68582 SLIPKNOT UNISEX T-SHIRT: ADDERALL FACEBACK (BACK PRINT)
68833 SLIPKNOT UNISEX T-SHIRT: ZOMBIE (BACK PRINT)
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
71430 SKINDRED UNISEX T-SHIRT: LOUD MUSIC
71431 SKINDRED UNISEX T-SHIRT: RASTA LOGO
70818 POLYPHIA UNISEX T-SHIRT: CHERUB
70820 POLYPHIA UNISEX T-SHIRT: SKULL CIRCLE P
70821 POLYPHIA UNISEX T-SHIRT: SPEAR ANGEL
70819 POLYPHIA UNISEX T-SHIRT: RITUAL
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)
71251 MÅNESKIN UNISEX T-SHIRT: LOUD KIDS EUROPEAN TOUR '23 (BACK PRINT & EX-TOUR)
43345 BRING ME THE HORIZON Sempiternal TEE
69442 BRING ME THE HORIZON UNISEX T-SHIRT: ALL HAIL (BACK PRINT)
69441 BRING ME THE HORIZON UNISEX T-SHIRT: LOST (BACK PRINT)
70554 BRING ME THE HORIZON UNISEX T-SHIRT: WHY...?
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
68831 BRING ME THE HORIZON UNISEX T-SHIRT: BARBED WIRE (BACK PRINT)
69354 BRING ME THE HORIZON UNISEX T-SHIRT: FLAMING HEX BLACK
69446 BRING ME THE HORIZON UNISEX T-SHIRT: IMPRINT NEX GEN
69444 BRING ME THE HORIZON UNISEX T-SHIRT: DISTRESSED NEX GEN
69443 BRING ME THE HORIZON UNISEX T-SHIRT: NEX GEN COVER
69445 BRING ME THE HORIZON UNISEX T-SHIRT: GREEN NEX GEN
71504 NINE INCH NAILS UNISEX T-SHIRT: HEAD LIKE A HOLE
71502 MOTIONLESS IN WHITE UNISEX T-SHIRT: GRAVEYARD SHIFT
71500 DEFTONES UNISEX T-SHIRT: STAR & PONY
71499 DEFTONES UNISEX T-SHIRT: STATIC SKULL (BACK PRINT)
71498 DEFTONES UNISEX T-SHIRT: SPHYNX
69765 BAD OMENS UNISEX T-SHIRT: TAKE ME
71497 BAD OMENS UNISEX T-SHIRT: SUNFLOWER
71496 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: DETROIT (BACK PRINT)
71495 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: WOLFMAN
71494 AVRIL LAVIGNE UNISEX T-SHIRT: LOVE SUX (BACK PRINT)
71533 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone TEE BURGUNDY
64312 Subciety (サブサエティ) Monogram TEE WHITE
67445 Subciety (サブサエティ) FRUITS STAND TEE BLACK
67444 Subciety (サブサエティ) FRUITS STAND TEE WHITE
68115 Subciety (サブサエティ) CREST TEE BLACK
68168 Subciety (サブサエティ) Cereal TEE BLACK
68170 Subciety (サブサエティ) Cereal TEE GREEN
68169 Subciety (サブサエティ) Cereal TEE WHITE
70733 Subciety (サブサエティ) Pinup TEE BLACK
70734 Subciety (サブサエティ) Pinup TEE WHITE
70731 Subciety (サブサエティ) GARGOYLE TEE BLACK
70732 Subciety (サブサエティ) GARGOYLE TEE WHITE
70729 Subciety (サブサエティ) GRACE TEE BLACK
70730 Subciety (サブサエティ) GRACE TEE WHITE
70726 Subciety (サブサエティ) SKULL FLOWER TEE BLACK
70728 Subciety (サブサエティ) SKULL FLOWER TEE WHITE
70723 Subciety (サブサエティ) Hard Days TEE BLACK
70724 Subciety (サブサエティ) Hard Days TEE BURGUNDY
70725 Subciety (サブサエティ) Hard Days WHITE
68445 Subciety (サブサエティ) PROVIDENCE TEE WHITE/BLACK
64193 Subciety (サブサエティ) THE BASE S/S NAVY
68458 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T BLACK
68459 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T WHITE
68294 RUDIE'S (ルーディーズ) EXTRA DRAWING-T BLACK
24329 RUDIE'S DRAWING-T BLACK
24330 RUDIE'S DRAWING-T WHITE
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK
71061 over print (オーバープリント) ANTI HEART Tee dark green
71060 over print (オーバープリント) ANTI HEART Tee ash gray
71059 over print (オーバープリント) ANTI HEART Tee white
71062 over print (オーバープリント) ANTI HEART Tee dark black
71043 over print (オーバープリント) PIZZA PRICE Tee navy
71042 over print (オーバープリント) PIZZA PRICE Tee yellow
71041 over print (オーバープリント) PIZZA PRICE Tee ash gray
71348 over print (オーバープリント) GHOST BUSTERS Tee 8 black