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:49:26')
AND pc.price02 > 4545
AND price02 <= 9090
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, 100
58363 KILL STAR CLOTHING Savage Mini Skirt [LEOPARD]
62170 KILL STAR Bellow Longline Hoodie
62168 KILL STAR Let's Dance Pull-Over Hoodie
62173 KILL STAR Dark Forces T-Shirt
62175 KILL STAR Ethos Backpack
58665 KILL STAR CLOTHING Paranoid T-Shirt
58362 KILL STAR CLOTHING Wild Side Work Shirt
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
58672 KILL STAR CLOTHING Vlad Backpack
58360 KILL STAR CLOTHING Unsacred Heart Wallet
58352 KILL STAR CLOTHING Lock Me Up Boots
58297 KILL STAR CLOTHING Unholy Sabbath Backpack
58298 KILL STAR CLOTHING Unholy Sabbath Sweatshirt
58300 KILL STAR CLOTHING Judgement Long Sleeve Top
58301 KILL STAR CLOTHING Judgement Kimono Tunic
7276 KILL STAR CLOTHING OCCULT RACERBACK DRESS [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]
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
9883 KILL STAR CLOTHING 420 SWEATSHIRT
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
9894 KILL STAR CLOTHING GOETIA SWEATSHIRT
11548 KILL STAR CLOTHING BAST T-SHIRT [B]
11551 KILL STAR CLOTHING HEXAGRAM T-SHIRT [B/W]
11565 KILL STAR CLOTHING TERROR 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]
11580 KILL STAR CLOTHING ILLUMINATI TANK [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
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]
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]
14465 KILL STAR CLOTHING SPELL TUNIC DRESS [B]
14468 KILL STAR CLOTHING KITTYGRAM SWEATSHIRT [B]
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
14656 KILL STAR CLOTHING NO PRINT
14756 KILL STAR CLOTHING DOLLAR T-SHIRT [B]
14757 KILL STAR CLOTHING NIGHTMARE SWEATSHIRT [B]
14758 KILL STAR CLOTHING DOLLAR PULLOVER HOODIE [B]
14759 KILL STAR CLOTHING DOLLAR CROP TOP [B]
14760 KILL STAR CLOTHING HEX VEST DRESS [B]
14761 KILL STAR CLOTHING HEX VEST DRESS [W]
14762 KILL STAR CLOTHING(キルスター・クロージング) ZODIAC SKATER DRESS
15109 KILL STAR CLOTHING DOLLAR SKATER DRESS [B]
15110 KILL STAR CLOTHING SIGILLUM DEI T-SHIRT [XLONG]
15354 KILL STAR CLOTHING FRACTAL T-SHIRT [XLONG]
15355 KILL STAR CLOTHING VULTURE T-SHIRT [B]
15357 KILL STAR CLOTHING BOARDGAME T-SHIRT [B]
15358 KILL STAR CLOTHING NIGHTMARE T-SHIRT [B]
15359 KILL STAR CLOTHING CHURCH KNIT SWEATER [B]
15360 KILL STAR CLOTHING TARTAN SKATER DRESS