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-18 12:11:38')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
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 DESC
LIMIT 0, 120
71727 SABBAT13(サバトサーティーン) SMOKY GIRL Tee BLACK
71728 SABBAT13(サバトサーティーン) SMOKY GIRL Tee WHITE
71729 SABBAT13(サバトサーティーン) SMOKY GIRL Tee SMOKY PINK
71730 SABBAT13(サバトサーティーン) SPOOK LOGO Tee BLACK
71731 SABBAT13(サバトサーティーン) SPOOK LOGO Tee WHITE
71732 SABBAT13(サバトサーティーン) SPOOK LOGO Tee GREEN
71634 SCENE TOKYO (シーントウキョウ) night girl Tee WHITE
71635 SCENE TOKYO (シーントウキョウ) night girl Tee BLACK
71636 SCENE TOKYO (シーントウキョウ) night girl Tee LAVENDER
71637 SCENE TOKYO (シーントウキョウ) space Tee WHITE
71638 SCENE TOKYO (シーントウキョウ) space Tee BLACK
71639 SCENE TOKYO (シーントウキョウ) aloha girl Tee WHITE
71640 SCENE TOKYO (シーントウキョウ) aloha girl Tee BLACK
71641 SCENE TOKYO (シーントウキョウ) girl Tee BLACK
71642 SCENE TOKYO (シーントウキョウ) girl Tee WHITE
71643 SCENE TOKYO (シーントウキョウ) ciger girl Tee WHITE
71644 SCENE TOKYO (シーントウキョウ) ciger girl Tee BLACK
70441 明石真秀×RUDIE'S コラボ限定Tシャツ
70455 月見山 渚×アマツカミ コラボ限定Tシャツ
71512 Subciety(サブサエティ) SCRATCHED PIGMENT TEE KHAKI
71513 Subciety(サブサエティ) SCRATCHED PIGMENT TEE NAVY
71320 over print (オーバープリント) EAT A PIZZA Tee black
71317 over print (オーバープリント) EAT A PIZZA Tee white
71318 over print (オーバープリント) EAT A PIZZA Tee ash gray
71319 over print (オーバープリント) EAT A PIZZA Tee dark green
71357 over print (オーバープリント) CHUCKY Tee 2
71344 over print (オーバープリント) GHOST BUSTERS Tee 6 black
71346 over print (オーバープリント) GHOST BUSTERS Tee 7 dark black
71347 over print (オーバープリント) GHOST BUSTERS Tee 8 white
71348 over print (オーバープリント) GHOST BUSTERS Tee 8 black
71041 over print (オーバープリント) PIZZA PRICE Tee ash gray
71042 over print (オーバープリント) PIZZA PRICE Tee yellow
71043 over print (オーバープリント) PIZZA PRICE Tee navy
71062 over print (オーバープリント) ANTI HEART Tee dark black
71059 over print (オーバープリント) ANTI HEART Tee white
71060 over print (オーバープリント) ANTI HEART Tee ash gray
71061 over print (オーバープリント) ANTI HEART Tee dark green
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
24330 RUDIE'S DRAWING-T WHITE
24329 RUDIE'S DRAWING-T BLACK
68294 RUDIE'S (ルーディーズ) EXTRA DRAWING-T BLACK
68459 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T WHITE
68458 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T BLACK
64193 Subciety (サブサエティ) THE BASE S/S NAVY
68445 Subciety (サブサエティ) PROVIDENCE TEE WHITE/BLACK
70725 Subciety (サブサエティ) Hard Days WHITE
70724 Subciety (サブサエティ) Hard Days TEE BURGUNDY
70723 Subciety (サブサエティ) Hard Days TEE BLACK
70728 Subciety (サブサエティ) SKULL FLOWER TEE WHITE
70726 Subciety (サブサエティ) SKULL FLOWER TEE BLACK
70730 Subciety (サブサエティ) GRACE TEE WHITE
70732 Subciety (サブサエティ) GARGOYLE TEE WHITE
70731 Subciety (サブサエティ) GARGOYLE TEE BLACK
70733 Subciety (サブサエティ) Pinup TEE BLACK
68169 Subciety (サブサエティ) Cereal TEE WHITE
68170 Subciety (サブサエティ) Cereal TEE GREEN
68168 Subciety (サブサエティ) Cereal TEE BLACK
68115 Subciety (サブサエティ) CREST TEE BLACK
67444 Subciety (サブサエティ) FRUITS STAND TEE WHITE
67445 Subciety (サブサエティ) FRUITS STAND TEE BLACK
64312 Subciety (サブサエティ) Monogram TEE WHITE
49739 NineMicrophones Pray with the microphone S/S WHITE
49740 NineMicrophones Pray with the microphone S/S BLACK
71533 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone TEE BURGUNDY
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
69765 BAD OMENS UNISEX T-SHIRT: TAKE ME
71498 DEFTONES UNISEX T-SHIRT: SPHYNX
71499 DEFTONES UNISEX T-SHIRT: STATIC SKULL (BACK PRINT)
71500 DEFTONES UNISEX T-SHIRT: STAR & PONY
71502 MOTIONLESS IN WHITE UNISEX T-SHIRT: GRAVEYARD SHIFT
71504 NINE INCH NAILS UNISEX T-SHIRT: HEAD LIKE A HOLE
69445 BRING ME THE HORIZON UNISEX T-SHIRT: GREEN NEX GEN
69446 BRING ME THE HORIZON UNISEX T-SHIRT: IMPRINT NEX GEN
69354 BRING ME THE HORIZON UNISEX T-SHIRT: FLAMING HEX BLACK
70554 BRING ME THE HORIZON UNISEX T-SHIRT: WHY...?
69441 BRING ME THE HORIZON UNISEX T-SHIRT: LOST (BACK PRINT)
69442 BRING ME THE HORIZON UNISEX T-SHIRT: ALL HAIL (BACK PRINT)
43345 BRING ME THE HORIZON Sempiternal TEE
71250 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 POSTER (EX-TOUR)
71249 MÅNESKIN UNISEX T-SHIRT: TEATRO D'IRA DOODLES (BACK PRINT & EX-TOUR)
70819 POLYPHIA UNISEX T-SHIRT: RITUAL
70821 POLYPHIA UNISEX T-SHIRT: SPEAR ANGEL
70820 POLYPHIA UNISEX T-SHIRT: SKULL CIRCLE P
71431 SKINDRED UNISEX T-SHIRT: RASTA LOGO
71430 SKINDRED UNISEX T-SHIRT: LOUD MUSIC
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
68833 SLIPKNOT UNISEX T-SHIRT: ZOMBIE (BACK PRINT)
68582 SLIPKNOT UNISEX T-SHIRT: ADDERALL FACEBACK (BACK PRINT)
68583 SLIPKNOT UNISEX T-SHIRT: THE END (BACK PRINT)
68835 SLIPKNOT UNISEX T-SHIRT: DEVIL SINGLE - LOGO BLUR (BACK PRINT)
68580 SLIPKNOT UNISEX T-SHIRT: ALIEN (BACK PRINT)
68581 SLIPKNOT UNISEX T-SHIRT: SKELETON & PENTAGRAM (BACK PRINT)
67958 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY WHITE
68577 LINKIN PARK UNISEX T-SHIRT: LIVING THINGS ALBUM
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
70685 LINKIN PARK UNISEX T-SHIRT: METEORA PORTRAITS
68575 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO BLACK
68576 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO WHITE
66944 KORN UNISEX T-SHIRT: BLOCKS
52907 KORN UNISEX TEE: DEATH DREAM
67955 KORN UNISEX T-SHIRT: BLOCK PHOTO
68574 KORN UNISEX HI-BUILD T-SHIRT: LOGO
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
67965 MARILYN MANSON UNISEX T-SHIRT: AMERICAN FAMILY (BACK PRINT)
28592 MARILYN MANSON CROWN T-Shirts
35642 MARILYN MANSON RED LIPS T-SHIRTS
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
59257 NINE INCH NAILS Unisex Tee: Classic Logo
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
10233 METALLICA DORIS T-Shirt
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
10235 METALLICA VINTAGE METAL UP T-Shirt