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 =329
)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 >= '2022-05-21 05:09:03')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
15件見つかりました
1ページ中1ページ目
1
フリー 残り1点
¥8,500
SLEEPING TABLET
Belt
¥30,800
Zephyren
Happy bag
¥4,950
若宮 イヴ×DI:VISION
Belt
フリー 残り1点
¥4,950
ANIMALIA
Belt
¥5,500
Zephyren
Belt
¥5,500
Zephyren
Belt
¥4,400
Zephyren
Belt
¥5,500
Zephyren
Belt
¥7,700
Anti Social Social Club
Belt
フリー 残り1点
¥7,700
Anti Social Social Club
Belt
¥5,500
Zephyren
Belt
¥4,400
Zephyren
Belt
¥6,050 → 4,235
MARILYN MANSON×KILL STAR CLOTHING
Belt
¥12,100
Artemis Classic
Belt
フリー 残り1点
¥4,950
ANIMALIA
Belt
15件見つかりました
1ページ中1ページ目
1
61348 SLEEPING TABLET BANDAGE [ W RING BELT ] WHITE
61271 Zephyren 2022 NEW YEAR BAG
52488 【バンドリ!×ゲキクロ 第4弾復刻】DI:VISION×若宮 イヴ コラボ 限定 ベルト
50365 ANIMALIA AN19M-AC02 ROPE-BELT BLACK
30782 Zephyren(ゼファレン) PAISLEY G.I BELT BLACK
30783 Zephyren(ゼファレン) PAISLEY G.I BELT WHITE
35969 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- WHITE
55226 Zephyren(ゼファレン)PAISLEY G.I BELT BEIGE
56217 Anti Social Social Club See Right Thru Me Pink Belt
56218 Anti Social Social Club See Right Thru Me Black Belt
30786 Zephyren(ゼファレン) PAISLEY G.I BELT NAVY
35972 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- BEIGE
37055 MARILYN MANSON×KILL STAR CLOTHING Deformography Belt [S]
43842 Artemis Classic ACBT0010 4ピース唐草ベルト
50366 ANIMALIA AN19M-AC02 ROPE-BELT RED
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 329
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=329
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 329
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=329