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 =596
)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-04-23 01:20:27')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
23件見つかりました
1ページ中1ページ目
1
¥7,700
ROLLING CRADLE
Pierce
¥7,700
ROLLING CRADLE
Pierce
¥7,700
ROLLING CRADLE
Earrings
¥7,700
ROLLING CRADLE
Earrings
フリー 残り1点
¥7,700
ROLLING CRADLE
Earrings
L 残り1点
¥29,700
Zephyren
Happy bag
¥9,900
RIP DESIGN WORXX
Happy bag
¥9,900
RIP DESIGN WORXX
Happy bag
¥24,200
RIP DESIGN WORXX
Happy bag
¥3,795
RIP DESIGN WORXX
Earrings
¥6,050
KILL STAR CLOTHING
Earrings
フリー 残り1点
¥4,070
KILL STAR CLOTHING
Earrings
¥7,150
Artemis Classic
Pierce
¥7,700
Artemis Classic
Pierce
¥7,700
Artemis Classic
Pierce
フリー 残り1点
¥4,180
KILL STAR CLOTHING
Earrings
¥7,700
Artemis Classic
Pierce
¥7,700
Artemis Classic
Pierce
¥8,800
Artemis Classic
Pierce
¥8,250
Artemis Classic
Earrings
¥9,350
Artemis Classic
Earrings
¥3,300
KILL STAR CLOTHING
Earrings
¥3,630
KILL STAR CLOTHING
Accessory
23件見つかりました
1ページ中1ページ目
1
57806 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / A-TYPE
57807 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / B-TYPE
57808 ROLLING CRADLE RCxHigh-Me TOKYO "EARRING -HEART-" / A-TYPE
57809 ROLLING CRADLE RCxHigh-Me TOKYO "EARRING -HEART-" / B-TYPE
57791 ROLLING CRADLE RCxHigh-Me TOKYO "EARCUFF" / RED
57102 Zephyren 2021 NEW YEAR BAG
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
56192 RIP DESIGN WORXX オートグラフイヤーカフ
20100 KILL STAR CLOTHING PENTAGRAM EARRINGS[P]
23779 KILL STAR CLOTHING (キルスター・クロージング) Earthlings Earrings [S]
29532 Artemis Classic ラブラドスタッドピアス[ACE0130]
29536 Artemis Classic ミスティックシールドスタッドピアスRD[ACE0132]
29557 Artemis Classic ブラックスピネルスタッドピアス[ACE0128]
31784 KILL STAR CLOTHING (キルスター・クロージング) Number 7 Hoop Earrings [B]
40791 Artemis Classic ACE0142 フェニックススタッドピアス
43822 Artemis Classic ACE0143 ウリエルブリッジピアス
43825 Artemis Classic ACE0144 ウリエルイヤージャケットピアス
43828 Artemis Classic ACE0145 ウリエルWリングイヤカフ
43830 Artemis Classic ACE0146 ウリエルトリッキーイヤカフ
49820 KILL STAR CLOTHING Cyra Earrings
51357 KILL STAR CLOTHING Midnight Earrings
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 596
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=596&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 596
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=596