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 dtb_products AS p
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-04-30 17:22:59')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 359)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 200, 100
16527 KILL STAR CLOTHING Occult X-Long T-Shirt Gloss
16528 KILL STAR CLOTHING Rune X-Long T-shirt Black
16531 KILL STAR CLOTHING Tartan X-Long T-Shirt
16532 KILL STAR CLOTHING Tartan Sweatshirt
16533 KILL STAR CLOTHING Unsocial Tie Dye T-Shirt Multi
16588 KILL STAR CLOTHING ANKH NECKLACE [S]
16590 KILL STAR CLOTHING KABBALAH HOOD DRESS [B]
16591 KILL STAR CLOTHING LUNAR SKATER DRESS [B]
16592 KILL STAR CLOTHING MOONCHILD SKATER DRESS [B]
16593 KILL STAR CLOTHING OCCULT REVERSIBLE BOMBER JACKET
16595 KILL STAR CLOTHING RITUAL HOODIE [B]
16600 KILL STAR CLOTHING ZERO TUNIC DRESS [B]
16601 KILL STAR CLOTHING OUIJA WOOL VARSITY JACKET [B]
17553 KILL STAR CLOTHING TUTANKHAMUN T-SHIRT [B] DIGITAL
17554 KILL STAR CLOTHING THIRD EYE SKATER DRESS [B]
17555 KILL STAR CLOTHING GOETIA HOOD DRESS [B]
17942 KILL STAR CLOTHING GIZA SWEATSHIRT [B]
17943 KILL STAR CLOTHING(キルスター・クロージング) LUNAR SWEATSHIRT [B]
17944 KILL STAR CLOTHING PIZZA ORDER SWEATSHIRT [B]
17945 KILL STAR CLOTHING RUNE SWEATSHIRT [GLOSS]
17946 KILL STAR CLOTHING SERPENTINE SWEATSHIRT [B]
17947 KILL STAR CLOTHING SPACE GRASS SWEATSHIRT
17948 KILL STAR CLOTHING SUCK MY SYMBOL SWEATSHIRT [B]
17949 KILL STAR CLOTHING(キルスター・クロージング) UNICORN TAROT SWEATSHIRT [B]
17950 KILL STAR CLOTHING OUIJA HOODIE [B]
17955 KILL STAR CLOTHING SERPENTINE T-SHIRT [B]
17956 KILL STAR CLOTHING UNICORN TAROT T-SHIRT [B]
18054 KILL STAR CLOTHING THELEMA T-SHIRT [B]
18055 KILL STAR CLOTHING THELEMA T-SHIRT [W]
18056 KILL STAR CLOTHING DOLL DRESS [B]
18057 KILL STAR CLOTHING TOO WEIRD TO LIVE VEST DRESS[B]
18058 KILL STAR CLOTHING TIED TUNIC DRESS [B]
18059 KILL STAR CLOTHING SKELETOR MAXI DRESS [LACE]
18060 KILL STAR CLOTHING NOBODY CARES T-SHIRT [B]
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
18104 KILL STAR CLOTHING OM T-SHIRT [B]
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
18106 KILL STAR CLOTHING ZERO T-SHIRT [B]
18107 KILL STAR CLOTHING WEIRDO TANK [B]
18108 KILL STAR CLOTHING CLUB 27 MUSCLE TANK [B]
18109 KILL STAR CLOTHING FUNERAL MUSCLE TANK [B]
18110 KILL STAR CLOTHING RAIDER CLOAK [B]
18111 KILL STAR CLOTHING COZMIC DEATH SOCKS
18112 KILL STAR CLOTHING THELEMA SOCKS
18113 KILL STAR CLOTHING RAVEN CLAW NECKLACE [B]
18114 KILL STAR CLOTHING MIDNIGHT NECKLACE [S]
18115 KILL STAR CLOTHING BAST NECKLACE [S]
18116 KILL STAR CLOTHING MOON GLASS VIAL NECKLACE [S]
18117 KILL STAR CLOTHING WITCH BEANIE [B]
18118 KILL STAR CLOTHING TOO WEIRD TO LIVE T-SHIRT [B]
18686 KILL STAR CLOTHING WEIRDO T-shirt
18828 KILL STAR CLOTHING WEED T-SHIRT [B]
18829 KILL STAR CLOTHING DEATH TANK [B]
18830 KILL STAR CLOTHING PIZZAGRAM TANK [B]
18831 KILL STAR CLOTHING PIZZA ORDER MUSCLE TANK [B]
18833 KILL STAR CLOTHING EARTHLINGS NECKLACE [S]
18834 KILL STAR CLOTHING PENTAGRAM HOOP EARRINGS [B]
18835 KILL STAR CLOTHING PENTAGRAM HOOP EARRINGS [S]
18836 KILL STAR CLOTHING PENTAGRAM HOOP EARRINGS [14K]
18837 KILL STAR CLOTHING(キルスター・クロージング) SERPENT NECKLACE [S]
18838 KILL STAR CLOTHING DREAMCATCHER EARRINGS [B]
18839 KILL STAR CLOTHING COZMIC DEATH BACKPACK [B]
19885 KILL STAR CLOTHING SCARAB T-SHIRT [XLONG]
19886 KILL STAR CLOTHING NASTY PERFORATED T-SHIRT [B]
19887 KILL STAR CLOTHING SPIRITUS T-SHIRT [XLONG]
19888 KILL STAR CLOTHING THE LIGHT PERFORATED T-SHIRT
19889 KILL STAR CLOTHING SPIRITUS VEST [B]
19890 KILL STAR CLOTHING KALI MUSCLE TANK [B]
19891 KILL STAR CLOTHING KALI SWEATSHIRT [B]
19892 KILL STAR CLOTHING NASTY SWEATSHIRT [B]
19893 KILL STAR CLOTHING SPELL BEANIE [B]
20096 KILL STAR CLOTHING DRAGON CLAW NECKLACE [S]
20097 KILL STAR CLOTHING CTHULHU NECKLACE [S]
20098 KILL STAR CLOTHING DREAMCATCHER EARRINGS[S]
20099 KILL STAR CLOTHING SWORD EARRINGS[S]
20100 KILL STAR CLOTHING PENTAGRAM EARRINGS[P]
20101 KILL STAR CLOTHING CRYSTAL CHOKER
20102 KILL STAR CLOTHING CRYSTAL CUFF
20108 KILL STAR CLOTHING PENTAGRAM RING [S]
20109 KILL STAR CLOTHING DRAGON CLAW RING [S]
20110 KILL STAR CLOTHING LUNA RING [S]
20111 KILL STAR CLOTHING ENNEAGRAM HOOP EARRINGS [S]
20112 KILL STAR CLOTHING HAMSA EARRINGS [S]
20113 KILL STAR CLOTHING KALI DENIM VEST [B]
20114 KILL STAR CLOTHING RA ZIP HOODIE [B]
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20116 KILL STAR CLOTHING CRUE DENIM JEANS [B]
20117 KILL STAR CLOTHING ADDAMS CROP TOP [MESH]
20118 KILL STAR CLOTHING CREEP KNIT SWEATER [B]
20119 KILL STAR CLOTHING OM TUNIC DRESS [B]
20120 KILL STAR CLOTHING PYRAMID HANDBAG [B]
20121 KILL STAR CLOTHING RA SKATER DRESS [B]
20122 KILL STAR CLOTHING PENTAGRAM VELVET SKATER DRESS
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20124 KILL STAR CLOTHING SPIRITUS L/S MAXI DRESS [B]
20141 KILL STAR CLOTHING SACRIFICE T-SHIRT [B]
22179 KILL STAR CLOTHING Azrael Zip Hoodie
22180 KILL STAR CLOTHING Bony Sweatshirt X-LONG
22181 KILL STAR CLOTHING Bony T-Shirt X-LONG
22182 KILL STAR CLOTHING Fancy T-Shirt