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-06-29 10:38:52')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 767)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
21件見つかりました
1ページ中1ページ目
1
フリー 残り1点
¥2,750
WASTED PARIS
Socks
¥2,750
WASTED PARIS
Socks
フリー 残り1点
¥2,750
WASTED PARIS
Socks
¥2,750
WASTED PARIS
Socks
26.5cm 残り1点
¥5,280
WASTED PARIS
Shoes
XL 残り1点
¥16,280
WASTED PARIS
Pullover
XL 残り1点
¥7,480
WASTED PARIS
T-Shirt
¥17,380
WASTED PARIS
Bottoms
¥14,080
WASTED PARIS
Cardigan
¥14,080
WASTED PARIS
Bottoms
¥7,480
WASTED PARIS
T-Shirt
¥7,480
WASTED PARIS
T-Shirt
¥8,800
WASTED PARIS
L/S T-Shirt
¥8,800
WASTED PARIS
L/S T-Shirt
¥15,400
WASTED PARIS
Pullover
¥15,400
WASTED PARIS
Pullover
¥15,400
WASTED PARIS
Pullover
¥8,800
WASTED PARIS
L/S T-Shirt
¥8,800
WASTED PARIS
L/S T-Shirt
¥8,800
WASTED PARIS
L/S T-Shirt
¥15,400
WASTED PARIS
Pullover
21件見つかりました
1ページ中1ページ目
1
59209 WASTED PARIS Socks Wasted x Jimbo Phillips Monster BLACK
59211 WASTED PARIS Columbia Bridge Socks Pink
59210 WASTED PARIS Columbia Bridge Socks Orange
59213 WASTED PARIS Columbia Bridge Socks Black
59214 WASTED PARIS Flip Flop Columbia Bridge Black
58369 WASTED PARIS Hoodie Essential Black
58371 WASTED PARIS T-shirt Essential Grey
58374 WASTED PARIS Worker Pants Houdstooth Brown
58375 WASTED PARIS Cardigan Knit Diaz Black
58376 WASTED PARIS Pants Knit Diaz Black
58095 WASTED PARIS T-shirt Marble Dye Nebula Green
58096 WASTED PARIS T-shirt Marble Dye Nebula Gray
58097 WASTED PARIS T-shirt LongsleeveNebula Black
58094 WASTED PARIS T-shirt Longsleeve Columbia Bridge Black
58101 WASTED PARIS Hoodie Columbia Bridge Pink
58099 WASTED PARIS Hoodie Columbia Bridge Lilac
58100 WASTED PARIS Hoodie Columbia Bridge Black
58092 WASTED PARIS T-shirt Longsleeve Columbia Bridge Yellow
58093 WASTED PARIS T-shirt Longsleeve Columbia Bridge Purple
58098 WASTED PARIS T-shirt LongsleeveNebula White
58102 WASTED PARIS Hoodie Faithless Black
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => wasted_paris
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/wasted_paris/
--------
mb_parse_str
Array
(
[brand_name] => wasted_paris
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=wasted_paris&/