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-28 22:11:56')
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 900, 75
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]