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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =127
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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 >= '2022-08-13 22:13:45')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
13件見つかりました
1ページ中1ページ目
1
¥5,200
NieR
Skirt
¥8,800
KILL STAR
Skirt
フリー 残り1点
¥6,400 → 3,200
NieR
Skirt
¥8,250 → 4,125
KILL STAR CLOTHING
Skirt
¥11,000 → 3,300
アマツカミ
Skirt
フリー 残り1点
¥8,250 → 2,475
Subciety
Skirt
¥6,050 → 1,815
KILL STAR CLOTHING
Shirt
Ladies M 残り1点
¥10,175 → 3,053
DISTURBIA CLOTHING
Skirt
¥7,150 → 2,145
KILL STAR CLOTHING x ROB ZOMBIE
Skirt
UK8 残り1点
¥8,250 → 2,475
DISTURBIA CLOTHING
Skirt
¥9,900 → 2,970
DISTURBIA CLOTHING
Skirt
¥6,050 → 1,815
KILL STAR CLOTHING
Skirt
L 残り1点
¥22,880 → 6,864
SLIGHTLY NUMB
Skirt
13件見つかりました
1ページ中1ページ目
1
63711 NieR (ニーア) チュール付きGRADATION BUTTERFLY SKIRT
62174 KILL STAR Arya Maxi Skirt
60226 NieR (ニーア) チュール付きアシンメトリーフリルスカート【彼岸花赤】
58363 KILL STAR CLOTHING Savage Mini Skirt [LEOPARD]
49422 アマツカミ あまつかみ/AMTKM Skirt
25854 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- BLACK
28147 KILL STAR CLOTHING (キルスター・クロージング) Dye Fast Dirge Skirt [T/D]
39032 DISTURBIA CLOTHING ZIP Skirt
44862 ROB ZOMBIE×KILL STAR CLOTHING Baby Death Skater Skirt
45404 DISTURBIA CLOTHING Discord Skirt
45406 DISTURBIA CLOTHING Dislocate Skirt
48183 KILL STAR CLOTHING Under The Stars Skater Skirt
51705 SLIGHTLY NUMB SICK CHILD SKIRT
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 127
[color] => 1
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=127&color=1&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 127
[color] => 1
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=127&color=1