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:47:19')
AND pc.classcategory_id1 IN( 11)
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 0, 75
62530 KILL STAR In A State Pull-Over Hoodie
62529 KILL STAR Bleak Hooded Cape
62169 KILL STAR Damned Hoodie
62170 KILL STAR Bellow Longline Hoodie
62168 KILL STAR Let's Dance Pull-Over Hoodie
62171 KILL STAR Deimos Long Sleeve Top
62528 KILL STAR Dark Forces Long Sleeve Top
62172 KILL STAR Deimos T-Shirt
62173 KILL STAR Dark Forces T-Shirt
62527 KILL STAR Blasphemia T-Shirt
58665 KILL STAR CLOTHING Paranoid T-Shirt
58666 KILL STAR CLOTHING Stay Weird T-Shirt White
58667 KILL STAR CLOTHING Stay Weird T-Shirt Black
58668 KILL STAR CLOTHING Paranoid Long Sleeve Top
58669 KILL STAR CLOTHING Rare To Die Long Sleeve Top
58670 KILL STAR CLOTHING Bloodpact Knit Sweater
58361 KILL STAR CLOTHING Mika Knit Sweater
58298 KILL STAR CLOTHING Unholy Sabbath Sweatshirt
58299 KILL STAR CLOTHING Unholy Sabbath T-Shirt
58300 KILL STAR CLOTHING Judgement Long Sleeve Top
58301 KILL STAR CLOTHING Judgement Kimono Tunic
58302 KILL STAR CLOTHING Magician Kimono Tunic
7072 KILL STAR CLOTHING NO JOY T-SHIRT [B]
7079 KILL STAR CLOTHING BLACK MAGIC VEST [B]
7104 KILL STAR CLOTHING BLACK MAGIC T-SHIRT [B]
7303 KILL STAR CLOTHING OCCULT T SHIRT [B]
7304 KILL STAR CLOTHING OCCULT SWEATSHIRT [B]
9862 KILL STAR CLOTHING MAGICK SWEATSHIRT [B]
9866 KILL STAR CLOTHING BATS VEST [B]
9881 KILL STAR CLOTHING ABRACADABRA SWEATSHIRT
9882 KILL STAR CLOTHING CARE LESS T-SHIRT [B]
9887 KILL STAR CLOTHING 420 T-SHIRT [B]
9889 KILL STAR CLOTHING ABRACADABRA T-SHIRT [B]
9894 KILL STAR CLOTHING GOETIA SWEATSHIRT
9902 KILL STAR CLOTHING NO SWEETHEART T-SHIRT [B]
9906 KILL STAR CLOTHING OCCULT T-SHIRT [W]
11548 KILL STAR CLOTHING BAST T-SHIRT [B]
11549 KILL STAR CLOTHING DEATH T-SHIRT [B]
11550 KILL STAR CLOTHING GIZA T-SHIRT [B]
11551 KILL STAR CLOTHING HEXAGRAM T-SHIRT [B/W]
11557 KILL STAR CLOTHING OUIJA T-SHIRT [B]
11558 KILL STAR CLOTHING PURRGATORY T SHIRT [B]
11559 KILL STAR CLOTHING REPTILE T-SHIRT [B]
11563 KILL STAR CLOTHING SPELL T-SHIRT [B]
11565 KILL STAR CLOTHING TERROR T-SHIRT [B]
11566 KILL STAR CLOTHING THIRD EYE T-SHIRT [B]
11569 KILL STAR CLOTHING WHATEVER T SHIRT [B]
11570 KILL STAR CLOTHING WHATEVER T-SHIRT [W]
11572 KILL STAR CLOTHING MENDES FOOTBALL TOP [B]
11578 KILL STAR CLOTHING GIZA TANK [B]
11585 KILL STAR CLOTHING REPTILE TANK [B]
11587 KILL STAR CLOTHING SUCK MY SYMBOL TANK [B]
11607 KILL STAR CLOTHING RIBCAGE 50/50 SWEATSHIRT
11612 KILL STAR CLOTHING CATS T-SHIRT [MULTI]
11614 KILL STAR CLOTHING FABLE T-SHIRT [MULTI]
11615 KILL STAR CLOTHING MONSTER T-SHIRT [MULTI]
11616 KILL STAR CLOTHING PALM SPRINGS T-SHIRT [MULTI]
11617 KILL STAR CLOTHING PASTEL MOON T-SHIRT [MULTI]
11618 KILL STAR CLOTHING PLZ DIE T-SHIRT [MULTI]
11619 KILL STAR CLOTHING UTOPIA T-SHIRT [MULTI]
11620 KILL STAR CLOTHING FABLE CREW [MULTI]
11623 KILL STAR CLOTHING PLZ DIE CREW [MULTI]
12657 KILL STAR CLOTHING MORTEM TANK [B]
12662 KILL STAR CLOTHING WHATEVER TANK [B]
12667 KILL STAR CLOTHING WHATEVER SWEATSHIRT [B]
12669 KILL STAR CLOTHING ANCIENT T-SHIRT [MULTI]
12672 KILL STAR CLOTHING ANCIENT SPACE CREW [MULTI]
12673 KILL STAR CLOTHING BLACK CATS CREW [MULTI]
12675 KILL STAR CLOTHING PASTEL MOON SWEATSHIRT
13236 KILL STAR CLOTHING UNHOLY TANK [B]
14332 KILL STAR CLOTHING HEX T-SHIRT
14333 KILL STAR CLOTHING EVERYTHING SUCKS T-SHIRT
14334 KILL STAR CLOTHING MORTEM II T-SHIRT
14336 KILL STAR CLOTHING ZODIAC T-SHIRT [B]
14370 KILL STAR CLOTHING ZERO SWEATSHIRT [B]