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 >= '2022-05-21 06:05:37')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 685)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
23cm 残り1点
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
フリー 残り1点
¥13,037 → 9,126
SLIGHTLY NUMB
Sweater
¥6,926 → 4,848
SLIGHTLY NUMB
T-Shirt
¥7,480
SLIGHTLY NUMB
T-Shirt
M 残り1点
¥7,480
SLIGHTLY NUMB
T-Shirt
L 残り1点
¥8,580
SLIGHTLY NUMB
7/S T-Shirt
L 残り1点
¥9,680
SLIGHTLY NUMB
T-Shirt
S 残り1点
¥8,580
SLIGHTLY NUMB
L/S T-Shirt
¥17,380
SLIGHTLY NUMB
Skirt
L 残り1点
¥22,880
SLIGHTLY NUMB
Skirt
11件見つかりました
1ページ中1ページ目
1
57074 SLIGHTLY NUMB×Kappa shoes BLACK
57073 SLIGHTLY NUMB×Kappa shoes WHITE
44003 SLIGHTLY NUMB HYPNOTIZ KNIT SWEATER BLACK
44006 SLIGHTLY NUMB UGLYBOY TEE WHITE
51693 SLIGHTLY NUMB FLIP YOUR FACE TEE GRAY
51699 SLIGHTLY NUMB HELEN FORDSDALE TEE WHITE
51700 SLIGHTLY NUMB NO RIO 3/4SLEEVE TEE BLACK
51701 SLIGHTLY NUMB NOT MOVING TEE BLUE
51703 SLIGHTLY NUMB HONG KONG GARDEN TEE
51704 SLIGHTLY NUMB DOUBLE LIFE SKIRT
51705 SLIGHTLY NUMB SICK CHILD SKIRT
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => slightly_numb
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/slightly_numb/
--------
mb_parse_str
Array
(
[brand_name] => slightly_numb
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=slightly_numb&/