SELECT SQL_CALC_FOUND_ROWS 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-03-29 22:33:40')
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 120, 120
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
14656 KILL STAR CLOTHING NO PRINT
14746 KILL STAR CLOTHING THIRD EYE CROP TOP [TIEDYE]
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
15073 KILL STAR CLOTHING PATCH POM POM BEANIE
15074 KILL STAR CLOTHING(キルスター・クロージング) LUNA BEANIE [B]
15076 KILL STAR CLOTHING KILL BEANIE [B]
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
15361 KILL STAR CLOTHING OCCULT HOODIE [B]
15766 KILL STAR CLOTHING HATERS BEANIE [B]
15767 KILL STAR CLOTHING NO JOY TANK TOP
15768 KILL STAR CLOTHING ABRACADABRA LADIES T-SHIRT
15769 KILL STAR CLOTHING 420 WOMENST-SHIRT
15778 KILL STAR CLOTHING 420 TANK [B]
15779 KILL STAR CLOTHING SACRIFICE SWEATSHIRT [B]
15819 KILL STAR CLOTHING DEATH SWEATSHIRT [50/50]
15959 KILL STAR CLOTHING ZODIAC ZIP HOODIE [B]
16520 KILL STAR CLOTHING PLZDIE BACKPACK
16521 KILL STAR CLOTHING VULTURE BACKPACK [B]
16522 KILL STAR CLOTHING Tartan Backpack B/R
16527 KILL STAR CLOTHING Occult X-Long T-Shirt Gloss
16528 KILL STAR CLOTHING Rune X-Long T-shirt Black
16531 KILL STAR CLOTHING Tartan X-Long T-Shirt
16532 KILL STAR CLOTHING Tartan Sweatshirt
16533 KILL STAR CLOTHING Unsocial Tie Dye T-Shirt Multi
16588 KILL STAR CLOTHING ANKH NECKLACE [S]
16590 KILL STAR CLOTHING KABBALAH HOOD DRESS [B]
16591 KILL STAR CLOTHING LUNAR SKATER DRESS [B]
16592 KILL STAR CLOTHING MOONCHILD SKATER DRESS [B]
16593 KILL STAR CLOTHING OCCULT REVERSIBLE BOMBER JACKET
16595 KILL STAR CLOTHING RITUAL HOODIE [B]
16600 KILL STAR CLOTHING ZERO TUNIC DRESS [B]
16601 KILL STAR CLOTHING OUIJA WOOL VARSITY JACKET [B]
17553 KILL STAR CLOTHING TUTANKHAMUN T-SHIRT [B] DIGITAL
17554 KILL STAR CLOTHING THIRD EYE SKATER DRESS [B]
17555 KILL STAR CLOTHING GOETIA HOOD DRESS [B]
17942 KILL STAR CLOTHING GIZA SWEATSHIRT [B]
17943 KILL STAR CLOTHING(キルスター・クロージング) LUNAR SWEATSHIRT [B]
17944 KILL STAR CLOTHING PIZZA ORDER SWEATSHIRT [B]
17945 KILL STAR CLOTHING RUNE SWEATSHIRT [GLOSS]
17946 KILL STAR CLOTHING SERPENTINE SWEATSHIRT [B]
17947 KILL STAR CLOTHING SPACE GRASS SWEATSHIRT
17948 KILL STAR CLOTHING SUCK MY SYMBOL SWEATSHIRT [B]
17949 KILL STAR CLOTHING(キルスター・クロージング) UNICORN TAROT SWEATSHIRT [B]
17950 KILL STAR CLOTHING OUIJA HOODIE [B]
17955 KILL STAR CLOTHING SERPENTINE T-SHIRT [B]
17956 KILL STAR CLOTHING UNICORN TAROT T-SHIRT [B]
18054 KILL STAR CLOTHING THELEMA T-SHIRT [B]
18055 KILL STAR CLOTHING THELEMA T-SHIRT [W]
18056 KILL STAR CLOTHING DOLL DRESS [B]
18057 KILL STAR CLOTHING TOO WEIRD TO LIVE VEST DRESS[B]
18058 KILL STAR CLOTHING TIED TUNIC DRESS [B]
18059 KILL STAR CLOTHING SKELETOR MAXI DRESS [LACE]
18060 KILL STAR CLOTHING NOBODY CARES T-SHIRT [B]
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
18104 KILL STAR CLOTHING OM T-SHIRT [B]
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
18106 KILL STAR CLOTHING ZERO T-SHIRT [B]
18107 KILL STAR CLOTHING WEIRDO TANK [B]
18108 KILL STAR CLOTHING CLUB 27 MUSCLE TANK [B]