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 =591
)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-27 22:03:17')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
22件見つかりました
1ページ中1ページ目
1
¥9,900
RIP DESIGN WORXX
Happy bag
¥9,900
RIP DESIGN WORXX
Happy bag
¥24,200
RIP DESIGN WORXX
Happy bag
L 残り1点
¥17,600
DI:VISION
Jacket
M 残り1点
¥27,500
MISHKA
Jacket
¥27,500
MISHKA
Jacket
S 残り1点
¥29,700
SLEEPING TABLET
Jacket
S 残り1点
¥22,000
SLEEPING TABLET
Jacket
S 残り1点
¥22,000
SLEEPING TABLET
Jacket
S 残り1点
¥17,600
PUNK DRUNKERS
Jacket
M 残り1点
¥20,900
REBEL8
Jacket
M 残り1点
¥26,400 → 13,200
RUDIE'S
Jacket
¥25,300 → 12,650
FILA
Jacket
L 残り1点
¥25,300 → 12,650
FILA
Jacket
L 残り1点
¥25,300 → 12,650
FILA
Jacket
L 残り1点
¥27,500
ANIMALIA
Jacket
¥27,500
ANIMALIA
Jacket
¥19,580
TOY MACHINE
Jacket
L 残り1点
¥18,480
TOY MACHINE
Jacket
¥14,300
RUDIE'S
Jacket
¥16,500
MISHKA
Jacket
¥16,500
MISHKA
Jacket
22件見つかりました
1ページ中1ページ目
1
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
56487 DI:VISION RELIEF FLUFFY ANORAK
55978 MISHKA(ミシカ) MAW200507 JACKET BLACK
55979 MISHKA(ミシカ) MAW200507 JACKET SAFTY GREEN
54219 SLEEPING TABLET TOY [ MOUNTAIN PARKA ] BLACK
54132 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] NAVY
54133 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] GRAY
24983 PUNK DRUNKERS ベスト30パッカブルパーカ BLACK
37581 REBEL8 Sect Hooded Parka
43253 RUDIE'S SPLASH GALAXY MOUNTAIN PARKA BLACK/SPLASH GALAXY
51430 FILA FM9675 JACKET BLACK
51432 FILA FM9675 JACKET YELLOW
51433 FILA FM9675 JACKET RED
51473 ANIMALIA AN19M-JK05 ECWCS PARKA 亜児磨吏我 BLACK
51474 ANIMALIA AN19M-JK05 ECWCS PARKA 亜児磨吏我 CAMO
52474 TOY MACHINE TMP20JK12 PATTERN PRINT ANORAK JACKET RED
52594 TOY MACHINE TMP20JK17 ANORAK JACKET BLACK
53131 RUDIE'S SLICK HALFZIPHOOD JACKET BLACK
53195 MISHKA (ミシカ) MSS200516F80 JACKET WHITE
53196 MISHKA (ミシカ) MSS200516F12 JACKET SAFTY GREEN
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 591
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=591
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 591
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=591