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 =588
)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-23 23:10:40')
AND pc.stock > 0
AND FIND_IN_SET(14, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
16件見つかりました
1ページ中1ページ目
1
¥18,480
SALUTE
Pullover
¥19,800
MUSIC SAVED MY LIFE
Pullover
¥25,000
Anti Social Social Club
Pullover
¥14,300
RUDIE'S
Pullover
¥27,500
Anti Social Social Club
Pullover
¥17,069 → 8,535
RIPNDIP
Pullover
S 残り1点
¥16,060 → 8,030
RIPNDIP
Pullover
¥10,780 → 5,390
FILA
Pullover
¥17,380
ROLLING CRADLE
Pullover
L 残り1点
¥12,980
GALFY
Pullover
¥16,574 → 8,287
RIPNDIP
Pullover
L 残り1点
¥17,600 → 8,800
FILA
Pullover
¥13,200
STAPLE
Pullover
M 残り1点
¥17,050 → 8,525
RIPNDIP
Pullover
XL 残り1点
¥11,000
PSYCHOLOGICAL METAMORPHOSIS
Pullover
¥9,800
THRASHER
Pullover
16件見つかりました
1ページ中1ページ目
1
56484 SALUTE Flower Anarchy Hoodie BLUE
56287 MUSIC SAVED MY LIFE (MSML) TIE DYE SWEAT PARKA
56204 Anti Social Social Club Headrush All Over White Hoodie
56028 RUDIE'S PHAT HIGHNECK HOOD SWEAT BLUE
55628 Anti Social Social Club SAMSIES BLUE HOODIE
47323 RIPNDIP Color Block Multi Panel Hoodie (Multi)
47649 RIPNDIP RIPNTAIL Hoodie (Royal Blue)
50480 FILA FM9685 HOOD BLUE
50556 ROLLING CRADLE LOOSE HOODIE / Crazy
50604 GALFY 野良犬ダブダブパーカー 青野良犬
50703 RIPNDIP TONAL LOOPBACK HOODIE BLUE
51436 FILA FM9696 JACKET BLUE
52443 STAPLE Neo Sport Nylon Hoodie
52707 RIPNDIP Catch Em All Hoodie (Multi)
53915 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLUE
54430 THRASHER GONZ HOODIE
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 588
[color] => 14
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=588&color=14
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 588
[color] => 14
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=588&color=14