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-01-16 12:21:15')
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
21件見つかりました
1ページ中1ページ目
1
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
L 残り1点
¥11,880
SLIGHTLY NUMB
S/S Shirt
フリー 残り1点
¥17,112
SLIGHTLY NUMB
Backpack
L 残り1点
¥16,093
SLIGHTLY NUMB
Cardigan
S 残り1点
¥13,037
SLIGHTLY NUMB
Shorts
S 残り1点
¥13,037
SLIGHTLY NUMB
Shorts
¥4,888
SLIGHTLY NUMB
Beanie
フリー 残り1点
¥13,037
SLIGHTLY NUMB
Sweater
¥6,926
SLIGHTLY NUMB
T-Shirt
XL 残り1点
¥6,926
SLIGHTLY NUMB
Tank Top
M 残り1点
¥32,780
SLIGHTLY NUMB
Jacket
¥20,680
SLIGHTLY NUMB
Bottoms
¥7,480
SLIGHTLY NUMB
T-Shirt
¥7,480
SLIGHTLY NUMB
T-Shirt
¥8,580
SLIGHTLY NUMB
7/S T-Shirt
¥9,680
SLIGHTLY NUMB
T-Shirt
¥25,080
SLIGHTLY NUMB
Bottoms
¥8,580
SLIGHTLY NUMB
L/S T-Shirt
¥17,380
SLIGHTLY NUMB
Skirt
L 残り1点
¥22,880
SLIGHTLY NUMB
Skirt
21件見つかりました
1ページ中1ページ目
1
57074 SLIGHTLY NUMB×Kappa shoes BLACK
57073 SLIGHTLY NUMB×Kappa shoes WHITE
57072 SLIGHTLY NUMB SAPPY ALOHA SHIRT
43973 SLIGHTLY NUMB METALHEAD BACKPACK
43975 SLIGHTLY NUMB YLOW CARDIGAN BLACK
43999 SLIGHTLY NUMB LA BLUES SHORTS BLUE
44000 SLIGHTLY NUMB LA BLUES SHORTS GRAY
44001 SLIGHTLY NUMB N.THREAT BEANIE
44003 SLIGHTLY NUMB HYPNOTIZ KNIT SWEATER BLACK
44006 SLIGHTLY NUMB UGLYBOY TEE WHITE
44008 SLIGHTLY NUMB LIBERATION SLEEVELESS TEE
47247 SLIGHTLY NUMB YAYU DENIM JKT
47253 SLIGHTLY NUMB LOT.1440-8 SKINNY PANTS
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
51702 SLIGHTLY NUMB LOT.720-3 WIDE PANTS
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&/