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 =62
)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 >= '2021-01-25 00:52:07')
AND p.sales_end_datetime IS NULL
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 628)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
29件見つかりました
1ページ中1ページ目
1
完売
¥9,680
VIRGO
Accessory
完売
¥9,680
VIRGO
Accessory
完売
¥9,680
VIRGO
Accessory
完売
¥2,750
VIRGO
Accessory
完売
¥9,680
VIRGO
Accessory
完売
¥4,950
VIRGO
Accessory
完売
¥4,950
VIRGO
Accessory
完売
¥6,050
VIRGO
Belt
完売
¥6,050
VIRGO
Belt
完売
¥3,850
VIRGO
Accessory
完売
¥3,850
VIRGO
Accessory
完売
¥3,850
VIRGO
Accessory
完売
¥3,850
VIRGO
Accessory
完売
¥7,480
VIRGO
Accessory
フリー 残り1点
¥8,580
VIRGO
Accessory
完売
¥3,850
VIRGO
Accessory
フリー 残り1点
¥3,850
VIRGO
Accessory
フリー 残り1点
¥3,850
VIRGO
Accessory
完売
¥3,850
VIRGO
Accessory
完売
¥9,680
VIRGO
Accessory
完売
¥9,680
VIRGO
Accessory
完売
¥9,680
VIRGO
Accessory
完売
¥4,950
VIRGO
Accessory
フリー 残り1点
¥9,680
VIRGO
Accessory
完売
¥9,680
VIRGO
Accessory
¥9,680
VIRGO
Accessory
完売
¥9,680
VIRGO
Accessory
¥9,680
VIRGO
Accessory
フリー 残り1点
¥9,680
VIRGO
Accessory
29件見つかりました
1ページ中1ページ目
1
57052 VIRGO 2Face crust stole BLK×BLK
57050 VIRGO 2Face crust stole BLK×BLU
57049 VIRGO 2Face crust stole BLK×RED
28782 VIRGO 4FACE ASHTRA WHITE
29585 VIRGO BABY CHEEK STALL BLACK
29943 VIRGO MARS GLOOVE PUP/BLK
29944 VIRGO MARS GLOOVE YEL/BLK
36087 VIRGO W FACE BELT BLACK
36088 VIRGO W FACE BELT OLIVE
38559 VIRGO Layering groove YELLOW
38560 VIRGO Layering groove BLACK
38561 VIRGO Layering groove RED
38562 VIRGO Layering groove PURPLE
39118 VIRGO SUPERIOR 2WAY HAIR BAND BLACK
43948 VIRGO VG-GD-572 FLASH V HAIRBAND BLACK
43949 VIRGO FLOOD VG-GD-571 VG GLOVES BEIGE
43950 VIRGO FLOOD VG-GD-571 VG GLOVES BLACK
43951 VIRGO FLOOD VG-GD-571 VG GLOVES NAVY
43952 VIRGO FLOOD VG-GD-571 VG GLOVES RED
44805 VIRGO VG-GD-569 FAT V SNOOD BLACK
44806 VIRGO VG-GD-569 FAT V SNOOD RED
44807 VIRGO VG-GD-569 FAT V SNOOD GRAY
50724 VIRGO VG-GD-606 SOLID HAIRBAND BLACK
52369 VIRGO VG-GD-607 3WAY HEAD ROBE KHAKI
52370 VIRGO VG-GD-607 3WAY HEAD ROBE NAVY
52371 VIRGO VG-GD-607 3WAY HEAD ROBE BLACK
52372 VIRGO VG-GD-614A DARK CHECK STALL RED
52373 VIRGO VG-GD-614A DARK CHECK STALL NAVY
52374 VIRGO VG-GD-614A DARK CHECK STALL GREEN
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => virgo
[/] =>
[cat] => 62
[sellout] => 1
[presale] => false
)
--------
$_SERVER['REQUEST_URI']
/brand/virgo/&cat=62&sellout=1&presale=false
--------
mb_parse_str
Array
(
[brand_name] => virgo
[/] =>
[cat] => 62
[sellout] => 1
[presale] => false
)
--------
$_SERVER['QUERY_STRING']
brand_name=virgo&/&cat=62&sellout=1&presale=false