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 19:42:12')
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
LIMIT 0, 25
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress
37055 MARILYN MANSON×KILL STAR CLOTHING Deformography Belt [S]
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]
7072 KILL STAR CLOTHING NO JOY T-SHIRT [B]
7076 KILL STAR CLOTHING KILL BEANIE [B]
7079 KILL STAR CLOTHING BLACK MAGIC VEST [B]
7103 KILL STAR CLOTHING NOCTEM VEST [B]
7104 KILL STAR CLOTHING BLACK MAGIC T-SHIRT [B]
7106 KILL STAR CLOTHING TAROT T-SHIRT [B]
7276 KILL STAR CLOTHING OCCULT RACERBACK DRESS [B]
7303 KILL STAR CLOTHING OCCULT T SHIRT [B]
7304 KILL STAR CLOTHING OCCULT SWEATSHIRT [B]
8060 KILL STAR CLOTHING GO TO HELL T-SHIRT [B]
8061 KILL STAR CLOTHING SACRIFICE VEST [B]
9861 KILL STAR CLOTHING GRUMPY VEST [B]
9862 KILL STAR CLOTHING MAGICK SWEATSHIRT [B]
9866 KILL STAR CLOTHING BATS VEST [B]
9868 KILL STAR CLOTHING LUNA SLOUCHY GIRLS SWEATSHIRT
9872 KILL STAR CLOTHING BATS SWEATSHIRT [B]
9873 KILL STAR CLOTHING BONE SWEATSHIRT [CAMO]
9877 KILL STAR CLOTHING NO SWEETHEART SWEATSHIRT
9879 KILL STAR CLOTHING LUCIFER SWEATSHIRT [CAMO]