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-04-20 01:48:29')
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 240, 120
18109 KILL STAR CLOTHING FUNERAL MUSCLE TANK [B]
18110 KILL STAR CLOTHING RAIDER CLOAK [B]
18111 KILL STAR CLOTHING COZMIC DEATH SOCKS
18112 KILL STAR CLOTHING THELEMA SOCKS
18113 KILL STAR CLOTHING RAVEN CLAW NECKLACE [B]
18114 KILL STAR CLOTHING MIDNIGHT NECKLACE [S]
18115 KILL STAR CLOTHING BAST NECKLACE [S]
18116 KILL STAR CLOTHING MOON GLASS VIAL NECKLACE [S]
18117 KILL STAR CLOTHING WITCH BEANIE [B]
18118 KILL STAR CLOTHING TOO WEIRD TO LIVE T-SHIRT [B]
18686 KILL STAR CLOTHING WEIRDO T-shirt
18828 KILL STAR CLOTHING WEED T-SHIRT [B]
18829 KILL STAR CLOTHING DEATH TANK [B]
18830 KILL STAR CLOTHING PIZZAGRAM TANK [B]
18831 KILL STAR CLOTHING PIZZA ORDER MUSCLE TANK [B]
18833 KILL STAR CLOTHING EARTHLINGS NECKLACE [S]
18834 KILL STAR CLOTHING PENTAGRAM HOOP EARRINGS [B]
18835 KILL STAR CLOTHING PENTAGRAM HOOP EARRINGS [S]
18836 KILL STAR CLOTHING PENTAGRAM HOOP EARRINGS [14K]
18837 KILL STAR CLOTHING(キルスター・クロージング) SERPENT NECKLACE [S]
18838 KILL STAR CLOTHING DREAMCATCHER EARRINGS [B]
18839 KILL STAR CLOTHING COZMIC DEATH BACKPACK [B]
19885 KILL STAR CLOTHING SCARAB T-SHIRT [XLONG]
19886 KILL STAR CLOTHING NASTY PERFORATED T-SHIRT [B]
19887 KILL STAR CLOTHING SPIRITUS T-SHIRT [XLONG]
19888 KILL STAR CLOTHING THE LIGHT PERFORATED T-SHIRT
19889 KILL STAR CLOTHING SPIRITUS VEST [B]
19890 KILL STAR CLOTHING KALI MUSCLE TANK [B]
19891 KILL STAR CLOTHING KALI SWEATSHIRT [B]
19892 KILL STAR CLOTHING NASTY SWEATSHIRT [B]
19893 KILL STAR CLOTHING SPELL BEANIE [B]
20096 KILL STAR CLOTHING DRAGON CLAW NECKLACE [S]
20097 KILL STAR CLOTHING CTHULHU NECKLACE [S]
20098 KILL STAR CLOTHING DREAMCATCHER EARRINGS[S]
20099 KILL STAR CLOTHING SWORD EARRINGS[S]
20100 KILL STAR CLOTHING PENTAGRAM EARRINGS[P]
20101 KILL STAR CLOTHING CRYSTAL CHOKER
20102 KILL STAR CLOTHING CRYSTAL CUFF
20108 KILL STAR CLOTHING PENTAGRAM RING [S]
20109 KILL STAR CLOTHING DRAGON CLAW RING [S]
20110 KILL STAR CLOTHING LUNA RING [S]
20111 KILL STAR CLOTHING ENNEAGRAM HOOP EARRINGS [S]
20112 KILL STAR CLOTHING HAMSA EARRINGS [S]
20113 KILL STAR CLOTHING KALI DENIM VEST [B]
20114 KILL STAR CLOTHING RA ZIP HOODIE [B]
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20116 KILL STAR CLOTHING CRUE DENIM JEANS [B]
20117 KILL STAR CLOTHING ADDAMS CROP TOP [MESH]
20118 KILL STAR CLOTHING CREEP KNIT SWEATER [B]
20119 KILL STAR CLOTHING OM TUNIC DRESS [B]
20120 KILL STAR CLOTHING PYRAMID HANDBAG [B]
20121 KILL STAR CLOTHING RA SKATER DRESS [B]
20122 KILL STAR CLOTHING PENTAGRAM VELVET SKATER DRESS
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20124 KILL STAR CLOTHING SPIRITUS L/S MAXI DRESS [B]
20141 KILL STAR CLOTHING SACRIFICE T-SHIRT [B]
22179 KILL STAR CLOTHING Azrael Zip Hoodie
22180 KILL STAR CLOTHING Bony Sweatshirt X-LONG
22181 KILL STAR CLOTHING Bony T-Shirt X-LONG
22182 KILL STAR CLOTHING Fancy T-Shirt
22183 KILL STAR CLOTHING Dino Sweatshirt
22184 KILL STAR CLOTHING Dino T-shirts
22185 KILL STAR CLOTHING Happy T-Shirt
22186 KILL STAR CLOTHING Skeletor Knit Sweater RED
22187 KILL STAR CLOTHING Skeletor Knit Sweater WHITE
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
22189 KILL STAR CLOTHING F* Monday Vest Dress [B]
22190 KILL STAR CLOTHING Dollar Sweatpants [B]
22220 KILL STAR CLOTHING Already Dead iPhone 6 Case
22221 KILL STAR CLOTHING McGoth iPhone 6 Case
22222 KILL STAR CLOTHING Purr Evil iPhone 6 Case
22223 KILL STAR CLOTHING Azrael Leggings [B]
22224 KILL STAR CLOTHING Bony Collar Top [B]
22246 KILL STAR CLOTHING(キルスター・クロージング) F Monday T-Shirt
22248 KILL STAR CLOTHING How About No T-Shirt
22249 KILL STAR CLOTHING Sabbath T-Shirt
22250 KILL STAR CLOTHING Scrabble T-Shirt
22251 KILL STAR CLOTHING Season T-Shirt
22252 KILL STAR CLOTHING Season T-Shirt Enzyme
22253 KILL STAR CLOTHING Wicked T-Shirt
22254 KILL STAR CLOTHING Sad T-Shirt X-LONG
22255 KILL STAR CLOTHING The Light T-Shirt X-LONG
22256 KILL STAR CLOTHING(キルスター・クロージング) Dark Side Sweatshirt
22257 KILL STAR CLOTHING(キルスター・クロージング) Hex Sweatshirt
22258 KILL STAR CLOTHING(キルスター・クロージング) Sabbath Sweatshirt
22259 KILL STAR CLOTHING(キルスター・クロージング) Sad Sweatshirt
22260 KILL STAR CLOTHING(キルスター・クロージング) Forever Knit Sweater
22261 KILL STAR CLOTHING(キルスター・クロージング) Ouija Knit Sweater
22262 KILL STAR CLOTHING Azrael Skater Dress
22263 KILL STAR CLOTHING Bony Skater Dress
22264 KILL STAR CLOTHING Horny Skater Dress
22265 KILL STAR CLOTHING Ouija Skater Dress
22266 KILL STAR CLOTHING Sad Skater Dress
22267 KILL STAR CLOTHING Witchy & Bitchy Skater Dress
22268 KILL STAR CLOTHING Wicked Skater Dress
22269 KILL STAR CLOTHING Dye Fast Dress
22270 KILL STAR CLOTHING(キルスター・クロージング) Cozmic Death Ribbon Dress
22271 KILL STAR CLOTHING Bony Leggings
22272 KILL STAR CLOTHING Cozmic Death Leggings
22273 KILL STAR CLOTHING Mendes Leggings
22274 KILL STAR CLOTHING Occult Leggings
22275 KILL STAR CLOTHING Wicked Leggings
22276 KILL STAR CLOTHING Dropout Dead Crop Sweater
22277 KILL STAR CLOTHING Dropout Pentagram Crop Sweater
22278 KILL STAR CLOTHING Harry Collar Top
22279 KILL STAR CLOTHING Wicked Collar Top
22280 KILL STAR CLOTHING Sad Socks
22281 KILL STAR CLOTHING Cozmic Death Skater Skirt
22282 KILL STAR CLOTHING Pentagram Velvet Skater Skirt
22283 KILL STAR CLOTHING Pin Pack1
22284 KILL STAR CLOTHING Pin Pack2
22285 KILL STAR CLOTHING Pin Pack3
22286 KILL STAR CLOTHING Ankh Earrings
22287 KILL STAR CLOTHING Luna Earrings
22289 KILL STAR CLOTHING Sator Necklace
22350 KILL STAR CLOTHING(キルスター・クロージング) Club 27 T-Shirt
22391 KILL STAR CLOTHING(キルスター・クロージング) Certain Death T-Shirt
22392 KILL STAR CLOTHING Cult T-Shirt
22393 KILL STAR CLOTHING Dark Side T-Shirt
22394 KILL STAR CLOTHING(キルスター・クロージング) Fact T-Shirt