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 21:29:13')
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, 120
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]
9881 KILL STAR CLOTHING ABRACADABRA SWEATSHIRT
9882 KILL STAR CLOTHING CARE LESS T-SHIRT [B]
9883 KILL STAR CLOTHING 420 SWEATSHIRT
9887 KILL STAR CLOTHING 420 T-SHIRT [B]
9889 KILL STAR CLOTHING ABRACADABRA T-SHIRT [B]
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
9894 KILL STAR CLOTHING GOETIA SWEATSHIRT
9902 KILL STAR CLOTHING NO SWEETHEART T-SHIRT [B]
9903 KILL STAR CLOTHING PIZZAGRAM T-SHIRT [B]
9906 KILL STAR CLOTHING OCCULT T-SHIRT [W]
9912 KILL STAR CLOTHING GOTH BEANIE HAT [B]
10191 KILL STAR CLOTHING GOETIA LEGGINGS
10196 KILL STAR CLOTHING CREEP/FREAK POMPOM BEANIE
10197 KILL STAR CLOTHING FUCKED/WASTED POMPOM BEANIE
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]
11555 KILL STAR CLOTHING LOGO T-SHIRT [B]
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]
11573 KILL STAR CLOTHING SULFUR FOOTBALL TOP [B]
11576 KILL STAR CLOTHING CARE LESS VEST [B]
11578 KILL STAR CLOTHING GIZA TANK [B]
11580 KILL STAR CLOTHING ILLUMINATI TANK [B]
11583 KILL STAR CLOTHING OUIJA TANK [B]
11585 KILL STAR CLOTHING REPTILE TANK [B]
11587 KILL STAR CLOTHING SUCK MY SYMBOL TANK [B]
11588 KILL STAR CLOTHING WEDNESDAY TANK [B]
11589 KILL STAR CLOTHING CUNT BEANIE [B]
11591 KILL STAR CLOTHING BANDANA SWEATSHIRT [B]
11592 KILL STAR CLOTHING DARKROOM SWEATSHIRT [B]
11593 KILL STAR CLOTHING EARTHLINGS SWEATSHIRT [B]
11595 KILL STAR CLOTHING ILLUMINATI SWEATSHIRT [B]
11596 KILL STAR CLOTHING KABBALAH SWEATSHIRT [B]
11600 KILL STAR CLOTHING PIZZAGRAM SWEATSHIRT [B]
11601 KILL STAR CLOTHING PURRGATORY SWEATSHIRT [B]
11602 KILL STAR CLOTHING REPTILE SWEATSHIRT [B]
11604 KILL STAR CLOTHING SPELL SWEATSHIRT [B]
11606 KILL STAR CLOTHING ABRACADABRA 50/50 SWEATSHIRT
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]
11621 KILL STAR CLOTHING GET HIGH CREW [MULTI]
11622 KILL STAR CLOTHING MIDAS CREW [MULTI]
11623 KILL STAR CLOTHING PLZ DIE CREW [MULTI]
11625 KILL STAR CLOTHING KAWAII LEGGINGS
11626 KILL STAR CLOTHING SIAMESE LEGGINGS
12651 KILL STAR CLOTHING BLACK MAGIC GIRLS T-SHIRT [B]
12657 KILL STAR CLOTHING MORTEM TANK [B]
12662 KILL STAR CLOTHING WHATEVER TANK [B]
12666 KILL STAR CLOTHING TUTANKHAMUN 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
13230 KILL STAR CLOTHING BITCH CRAFT CROP TOP [B]
13233 KILL STAR CLOTHING WHATEVER CROP TOP [B]
13236 KILL STAR CLOTHING UNHOLY TANK [B]
13238 KILL STAR CLOTHING GOD T-SHIRT [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]
14337 KILL STAR CLOTHING COBRA SWEATSHIRT [MULTI]
14369 KILL STAR CLOTHING COBRA T-SHIRT [B]
14370 KILL STAR CLOTHING ZERO SWEATSHIRT [B]
14372 KILL STAR CLOTHING AS/IF SWEATSHIRT [MULTI]
14373 KILL STAR CLOTHING UNSOCIAL SWEATSHIRT [B]
14379 KILL STAR CLOTHING OCCULT BACKPACK [B]
14436 KILL STAR CLOTHING HELL YEAH ZIP HOODIE [B]
14462 KILL STAR CLOTHING COFFEE T-SHIRT [B]
14463 KILL STAR CLOTHING PIZZA ORDER T-SHIRT [B]
14464 KILL STAR CLOTHING MOTTO T-SHIRT [B]
14465 KILL STAR CLOTHING SPELL TUNIC DRESS [B]
14468 KILL STAR CLOTHING KITTYGRAM SWEATSHIRT [B]
14514 KILL STAR CLOTHING LUNAR T-SHIRT
14523 KILL STAR CLOTHING BABYLON ROSE SWEATSHIRT [MULTI]
14524 KILL STAR CLOTHING COFFEE SWEATSHIRT [B]
14652 KILL STAR CLOTHING MORTEM II SWEATSHIRT [B]
14653 KILL STAR CLOTHING UTOPIA SWEATSHIRT