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 >= '2021-05-14 03:20:06')
AND pc.stock > 0
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, 120
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
58671 KILL STAR CLOTHING Bloodsucker Handbag
58672 KILL STAR CLOTHING Vlad Backpack
58673 KILL STAR CLOTHING Bad Faith Earrings
58674 KILL STAR CLOTHING Chiroptera Necklace
58675 KILL STAR CLOTHING Chiroptera Earrings
58676 KILL STAR CLOTHING Ave Satana Necklace
58677 KILL STAR CLOTHING Ave Satana Earrings
58361 KILL STAR CLOTHING Mika Knit Sweater
58355 KILL STAR CLOTHING Catnip Choker [BLACK]
58356 KILL STAR CLOTHING Catnip Choker [LEOPARD]
58357 KILL STAR CLOTHING Lock Me Up Choker
58358 KILL STAR CLOTHING Lock Me Up Necklace
58359 KILL STAR CLOTHING Unsacred Heart Chain Necklace
58360 KILL STAR CLOTHING Unsacred Heart Wallet
58352 KILL STAR CLOTHING Lock Me Up Boots
58353 KILL STAR CLOTHING Death & Tonic Trainers
58297 KILL STAR CLOTHING Unholy Sabbath Backpack
58296 KILL STAR CLOTHING Unholy Sabbath Wallet
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
7104 KILL STAR CLOTHING BLACK MAGIC T-SHIRT [B]
9862 KILL STAR CLOTHING MAGICK SWEATSHIRT [B]
9872 KILL STAR CLOTHING BATS SWEATSHIRT [B]
9887 KILL STAR CLOTHING 420 T-SHIRT [B]
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
9894 KILL STAR CLOTHING GOETIA SWEATSHIRT
10191 KILL STAR CLOTHING GOETIA LEGGINGS
11621 KILL STAR CLOTHING GET HIGH CREW [MULTI]
12651 KILL STAR CLOTHING BLACK MAGIC GIRLS T-SHIRT [B]
14333 KILL STAR CLOTHING EVERYTHING SUCKS T-SHIRT
14337 KILL STAR CLOTHING COBRA SWEATSHIRT [MULTI]
14524 KILL STAR CLOTHING COFFEE SWEATSHIRT [B]
14760 KILL STAR CLOTHING HEX VEST DRESS [B]
15361 KILL STAR CLOTHING OCCULT HOODIE [B]
16590 KILL STAR CLOTHING KABBALAH HOOD DRESS [B]
16592 KILL STAR CLOTHING MOONCHILD SKATER DRESS [B]
17553 KILL STAR CLOTHING TUTANKHAMUN T-SHIRT [B] DIGITAL
17945 KILL STAR CLOTHING RUNE SWEATSHIRT [GLOSS]
17947 KILL STAR CLOTHING SPACE GRASS SWEATSHIRT
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
19889 KILL STAR CLOTHING SPIRITUS VEST [B]
19891 KILL STAR CLOTHING KALI SWEATSHIRT [B]
20100 KILL STAR CLOTHING PENTAGRAM EARRINGS[P]
20113 KILL STAR CLOTHING KALI DENIM VEST [B]
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20119 KILL STAR CLOTHING OM TUNIC DRESS [B]
20121 KILL STAR CLOTHING RA SKATER DRESS [B]
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20124 KILL STAR CLOTHING SPIRITUS L/S MAXI DRESS [B]
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
22224 KILL STAR CLOTHING Bony Collar Top [B]
22246 KILL STAR CLOTHING(キルスター・クロージング) F Monday T-Shirt
22262 KILL STAR CLOTHING Azrael Skater Dress
22263 KILL STAR CLOTHING Bony Skater Dress
22268 KILL STAR CLOTHING Wicked Skater Dress
22274 KILL STAR CLOTHING Occult Leggings
22402 KILL STAR CLOTHING Cult Sweatshirt
22404 KILL STAR CLOTHING(キルスター・クロージング) Idol Sweatshirt TIEDYE
22405 KILL STAR CLOTHING(キルスター・クロージング) Idol Sweatshirt
23776 KILL STAR CLOTHING (キルスター・クロージング) Club 27 Sweatshirt [B}
23779 KILL STAR CLOTHING (キルスター・クロージング) Earthlings Earrings [S]
23784 KILL STAR CLOTHING (キルスター・クロージング) Midnight Bomber Jacket [B]
24337 KILL STAR CLOTHING (キルスター・クロージング) Cult Boxers
27502 KILL STAR CLOTHING (キルスター・クロージング) Voodoo Doll Dress [GREY]
27507 KILL STAR CLOTHING (キルスター・クロージング) Chill Out Sweatshirt [B]
27509 KILL STAR CLOTHING (キルスター・クロージング) Slumber Crop Sweatshirt [B]
27518 KILL STAR CLOTHING (キルスター・クロージング) Slay Sweatshirt [TIEDYE]
28134 KILL STAR CLOTHING (キルスター・クロージング) No Fun Snapback [B]
28143 KILL STAR CLOTHING (キルスター・クロージング) People Tank [B]
28144 KILL STAR CLOTHING (キルスター・クロージング) Dye Fast Woodstock Maxi Dress [B]
28146 KILL STAR CLOTHING (キルスター・クロージング) Dye Fast Dirge Skirt [BLOOD]
28147 KILL STAR CLOTHING (キルスター・クロージング) Dye Fast Dirge Skirt [T/D]
28152 KILL STAR CLOTHING (キルスター・クロージング) iScream Skater Dress [B]
29109 KILL STAR CLOTHING (キルスター・クロージング) Cozmic Death Crop Top [B]
29110 KILL STAR CLOTHING (キルスター・クロージング) Dark Side Tank [B]
29127 KILL STAR CLOTHING (キルスター・クロージング) Baphomet II Leggings [B]
31784 KILL STAR CLOTHING (キルスター・クロージング) Number 7 Hoop Earrings [B]
36352 KILL STAR CLOTHING(キルスター・クロージング) Full Moon Phone Case [Galaxy 7]
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress
37048 MARILYN MANSON×KILL STAR CLOTHING Bigger Than Satan Boxers
37055 MARILYN MANSON×KILL STAR CLOTHING Deformography Belt [S]
37256 KILL STAR CLOTHING(キルスター・クロージング) DON’T CALL T-Shirt [B]
37262 KILL STAR CLOTHING(キルスター・クロージング) FERAL T-Shirt [B]
37275 KILL STAR CLOTHING(キルスター・クロージング) SPYDA Lace-Me-Up Dress [B]
37276 KILL STAR CLOTHING(キルスター・クロージング) TODAY T-Shirt [B]
38525 KILL STAR CLOTHING(キルスター・クロージング) Thumper Gothic Kawaii Hoodie
38535 KILL STAR CLOTHING(キルスター・クロージング) Nostalgia Sweatshirt
38537 KILL STAR CLOTHING(キルスター・クロージング) Stoned Tshirt
38539 KILL STAR CLOTHING(キルスター・クロージング) Nu-Friends Tshirt
38540 KILL STAR CLOTHING(キルスター・クロージング) All The Things You Hate Sweatshirt
39527 KILL STAR CLOTHING Sweet Beams Ankle Socks
39529 KILL STAR CLOTHING Nikky Choker [B]
39530 KILL STAR CLOTHING (キルスター・クロージング) Sabbath Premium Incense [B]
39531 KILL STAR CLOTHING Tryals Cast-Out Vest Top [B]
39532 KILL STAR CLOTHING PICK A BONE T-Shirt [B]
39533 KILL STAR CLOTHING (キルスター・クロージング) NOTHING Skater Dress [B]
39537 KILL STAR CLOTHING Dagger Ok Bye Enamel Pin [B]
40546 KILL STAR CLOTHING Vicious Leggings [B]
43480 KILL STAR CLOTHING Algiz Rune Necklace [S]
43482 KILL STAR CLOTHING Wolf Cross Necklace [S]
43486 KILL STAR CLOTHING Coffin Relaxed Top [B]
43487 KILL STAR CLOTHING Delish Relaxed Top [B]
43495 KILL STAR CLOTHING Coffin Pull-Over Hoodie [B]
43496 KILL STAR CLOTHING Don't Belong Long Sleeve Top [B]
44321 KILL STAR SUCK MY SYMBOL TEE
44814 KILL STAR CLOTHING Ceremony Flat [B]
44818 KILL STAR CLOTHING Milky Way Chiffon Skirt
44823 KILL STAR CLOTHING Sigil Necklace [S]
44825 KILL STAR CLOTHING Screw You Tracksuit Bottoms [B]
44826 KILL STAR CLOTHING Spook N Destroy Knit Sweater [B]
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => kill_star_clothing
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/kill_star_clothing/
--------
mb_parse_str
Array
(
[brand_name] => kill_star_clothing
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=kill_star_clothing&/
ブラック
グレー
ホワイト
ブラウン
カーキ
ベージュ
レッド
ピンク
オレンジ
イエロー
パープル
グリーン
ネイビー
ブルー
ゴールド
シルバー
カモ
ペイズリー
アニマル
タイダイ
チェック
ドット
ストライプ
