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-27 22:43:51')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 693)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
19件見つかりました
1ページ中1ページ目
1
¥7,590
ZERO EVOKE
Sweatshirt
¥8,690
ZERO EVOKE
Pullover
¥7,590
ZERO EVOKE
Sweatshirt
¥7,590
ZERO EVOKE
Sweatshirt
¥7,590
ZERO EVOKE
Sweatshirt
¥8,690
ZERO EVOKE
Pullover
M 残り1点
¥5,390
ZERO EVOKE
L/S T-Shirt
M 残り1点
¥5,390
ZERO EVOKE
L/S T-Shirt
¥4,950
ZERO EVOKE
T-Shirt
¥4,620
ZERO EVOKE
T-Shirt
XL 残り1点
¥4,290
ZERO EVOKE
T-Shirt
M 残り1点
¥4,290
ZERO EVOKE
T-Shirt
¥4,290
ZERO EVOKE
T-Shirt
¥4,290
ZERO EVOKE
T-Shirt
¥4,950
ZERO EVOKE
T-Shirt
XL 残り1点
¥4,620
ZERO EVOKE
T-Shirt
M 残り1点
¥4,620
ZERO EVOKE
T-Shirt
¥8,140
ZERO EVOKE
Sweat
L 残り1点
¥8,690
ZERO EVOKE
Pullover
19件見つかりました
1ページ中1ページ目
1
57314 ZERO EVOKE Three Needles Sweat 【WHITE】
57316 ZERO EVOKE ZE Logo Second Pullover Parka 【WHITE×WHITE】
57343 ZERO EVOKE ZE Logo First Sweat 【WHITE×WHITE】
57344 ZERO EVOKE ZE Logo First Sweat 【BLACK×BLACK】
57313 ZERO EVOKE Three Needles Sweat 【BLACK】
57315 ZERO EVOKE ZE Logo Second Pullover Parka 【BLACK×BLACK】
47260 ZERO EVOKE fragilistic L/S Tee(BLACK)
47261 ZERO EVOKE fragilistic L/S Tee(WHITE)
47263 ZERO EVOKE ZE Horror Tee (BLACK)
47755 ZERO EVOKE Apostle Tee(BLACK)
47757 ZERO EVOKE Six life Tee(WHITE)
49200 ZERO EVOKE Campanella Tee (BLACK)
49202 ZERO EVOKE Point Circus Logo Tee (BLACK)
49203 ZERO EVOKE Point Circus Logo Tee (WHITE)
49205 ZERO EVOKE Show Time Tee (WHITE)
49206 ZERO EVOKE Catharsis Tee (BLACK)
49207 ZERO EVOKE Catharsis Tee (WHITE)
52332 ZERO EVOKE ZE Style Skull Sweat - BLACK
52335 ZERO EVOKE Logo Second Pullover Parka BLACK
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => zero_evoke
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/zero_evoke/
--------
mb_parse_str
Array
(
[brand_name] => zero_evoke
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=zero_evoke&/