SELECT SQL_CALC_FOUND_ROWS 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-25 04:44:08')
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 840, 120
44855 ROB ZOMBIE×KILL STAR CLOTHING Superbeast T-Shirt
44856 ROB ZOMBIE×KILL STAR CLOTHING The End T-Shirt
44857 ROB ZOMBIE×KILL STAR CLOTHING Magick Long Sleeve Top
44858 ROB ZOMBIE×KILL STAR CLOTHING Superbeast Long Sleeve Top
44859 ROB ZOMBIE×KILL STAR CLOTHING The End Long Sleeve Top [B]
44860 ROB ZOMBIE×KILL STAR CLOTHING Spookshow Backpack
44861 ROB ZOMBIE×KILL STAR CLOTHING Lords Of Salem Knit Sweater
44862 ROB ZOMBIE×KILL STAR CLOTHING Baby Death Skater Skirt
44863 ROB ZOMBIE×KILL STAR CLOTHING Mrs Zombie Wallet
44864 ROB ZOMBIE×KILL STAR CLOTHING Mrs Zombie Tote Bag
44865 ROB ZOMBIE×KILL STAR CLOTHING Call Of The Zombie Choker
44866 ROB ZOMBIE×KILL STAR CLOTHING Living Dead Girl Choker
44867 ROB ZOMBIE×KILL STAR CLOTHING Monster Deluxe Messenger Bag
44868 KILL STAR CLOTHING Dead 4Ever Platform Trainers
44869 KILL STAR CLOTHING Starmap High Tops
44870 KILL STAR CLOTHING Handshake T-Shirt
44924 KILL STAR CLOTHING(キルスター・クロージング) IDOL BATWING VELVET HOODIE [B]
44973 KILL STAR CLOTHING (キルスター・クロージング) Got Plans Snapback [B]
45705 KILL STAR CLOTHING Stick It! Pack 5
45707 KILL STAR CLOTHING Wicked High Tops
45708 KILL STAR CLOTHING Malice Platform Trainers
45710 KILL STAR CLOTHING Baal Knit Cardi [B]
45711 KILL STAR CLOTHING Yvil Spike Choker [B]
45712 KILL STAR CLOTHING Bone Yard Hoodie [B]
45713 KILL STAR CLOTHING Killmore Knit Sweater
45714 KILL STAR CLOTHING Feri Doll Dress
45715 KILL STAR CLOTHING Ash Distress Knit Sweater [B]
45716 KILL STAR CLOTHING Bibliomancy Hooded Top [B]
47886 KILL STAR CLOTHING Anika Jeans
47887 KILL STAR CLOTHING Astoria Leggings
47888 KILL STAR CLOTHING Raise The Dead Long Sleeve Top
47889 KILL STAR CLOTHING Black Cats Long Sleeve Top
48113 KILL STAR CLOTHING Cat Lady Lace-Up Tunic
48114 KILL STAR CLOTHING Fortuna Ring Stand
48115 KILL STAR CLOTHING Grady Knit Sweater
48116 KILL STAR CLOTHING Hexagram Choker
48117 KILL STAR CLOTHING Release My Spirit Relaxed Top
48119 KILL STAR CLOTHING Sacred Sixx Backpack
48120 KILL STAR CLOTHING Samona Overalls
48121 KILL STAR CLOTHING Triangle Wall Shelf
48181 KILL STAR CLOTHING Under The Stars Backpack
48182 KILL STAR CLOTHING Under The Stars Long Socks
48183 KILL STAR CLOTHING Under The Stars Skater Skirt
48184 KILL STAR CLOTHING Under The Stars Wallet
49213 KILL STAR CLOTHING Omen Kimono Dress [B]
49816 KILL STAR CLOTHING Carmen Necklace
49818 KILL STAR CLOTHING Crypt Hoodie
49819 KILL STAR CLOTHING Crypt T-Shirt
49820 KILL STAR CLOTHING Cyra Earrings
49821 KILL STAR CLOTHING Cyra Ring
49822 KILL STAR CLOTHING Dione Ring
49823 KILL STAR CLOTHING Dust T-Shirt
49824 KILL STAR CLOTHING Kyra Ring
49825 KILL STAR CLOTHING Mica Handbag
49826 KILL STAR CLOTHING Never Surrender Long Sleeve Top
49827 KILL STAR CLOTHING Never Surrender T-Shirt
49828 KILL STAR CLOTHING Playtime Relaxed Top
49829 KILL STAR CLOTHING Playtime T-Shirt
51312 KILL STAR CLOTHING Darklands Knit Sweater [TARTAN]
51313 KILL STAR CLOTHING Detention Long Sleeve Top
51314 KILL STAR CLOTHING Detention T-Shirt
51315 KILL STAR CLOTHING Karma Relaxed Top
51317 KILL STAR CLOTHING Moonbeam Beret
51318 KILL STAR CLOTHING Moonbeam Long Socks
51319 KILL STAR CLOTHING Myth Handbag
51320 KILL STAR CLOTHING Playtime Hoodie
51321 KILL STAR CLOTHING Shadow Long Sleeve Top
51322 KILL STAR CLOTHING Shadow T-Shirt
51323 KILL STAR CLOTHING Sucker Long Sleeve Top
51324 KILL STAR CLOTHING Sucker Relaxed Top
51325 KILL STAR CLOTHING Sucker T-Shirt
51351 KILL STAR CLOTHING Ariel Ring
51352 KILL STAR CLOTHING Eris Ring
51353 KILL STAR CLOTHING Juliet Ring
51354 KILL STAR CLOTHING Titania Ring
51355 KILL STAR CLOTHING Kain Necklace
51356 KILL STAR CLOTHING Skeleton Key Necklace
51357 KILL STAR CLOTHING Midnight Earrings
51358 KILL STAR CLOTHING Serpentine Earrings
51359 KILL STAR CLOTHING Witching Hour Earrings
51360 KILL STAR CLOTHING Descent Handbag
51361 KILL STAR CLOTHING Nyah Backpack
51362 KILL STAR CLOTHING Diablerie T-Shirt
51363 KILL STAR CLOTHING Love Devil Distress Top
51364 KILL STAR CLOTHING Moon Child Distress Top
51365 KILL STAR CLOTHING Religion Distress Top
51366 KILL STAR CLOTHING Possessed T-Shirt
51367 KILL STAR CLOTHING Grim Moon Leggings
51368 KILL STAR CLOTHING Umbra Leggings
51399 KILL STAR CLOTHING Gothel Hoodie
51400 KILL STAR CLOTHING Lita Hooded Coat
51401 KILL STAR CLOTHING Salem City Shearling Coat
53921 KILL STAR CLOTHING Pentagram Handbag
8059 KILL STAR CLOTHING METAL T-SHIRT [B]
9874 KILL STAR CLOTHING ABRACADABRA TANK [B]
11582 KILL STAR CLOTHING LUCIFER TANK [B]
12661 KILL STAR CLOTHING WISH DRESS [B]
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress
37055 MARILYN MANSON×KILL STAR CLOTHING Deformography Belt [S]