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 >= '2022-08-11 21:32:54')
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
¥6,050
glamb
Earrings
¥6,050
glamb
Earrings
¥6,600 → 3,300
ANIMALIA
Earrings
¥4,400 → 2,200
KILL STAR CLOTHING
Pierce
¥4,400 → 2,200
KILL STAR CLOTHING
Pierce
フリー 残り1点
¥4,950 → 2,475
KILL STAR CLOTHING
Pierce
¥7,700 → 3,850
ROLLING CRADLE
Pierce
¥7,700 → 3,850
ROLLING CRADLE
Pierce
¥7,700 → 3,850
ROLLING CRADLE
Earrings
¥7,700 → 3,850
ROLLING CRADLE
Earrings
¥3,795
RIP DESIGN WORXX
Earrings
フリー 残り1点
¥6,050 → 1,815
KILL STAR CLOTHING
Earrings
フリー 残り1点
¥4,070 → 1,221
KILL STAR CLOTHING
Earrings
¥7,700
Artemis Classic
Pierce
¥7,700
Artemis Classic
Pierce
¥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
フリー 残り1点
¥3,300 → 990
KILL STAR CLOTHING
Earrings
フリー 残り1点
¥3,630 → 1,089
KILL STAR CLOTHING
Accessory
22件見つかりました
1ページ中1ページ目
1
62067 glamb (グラム) Twisted Ear Cuff - Silver
62081 glamb (グラム) Loop Ear Cuff - Silver
60510 ANIMALIA AN21S-AC03 Ear Cuff - 1849 COIN SILVER
58673 KILL STAR CLOTHING Bad Faith Earrings
58675 KILL STAR CLOTHING Chiroptera Earrings
58677 KILL STAR CLOTHING Ave Satana Earrings
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
56192 RIP DESIGN WORXX オートグラフイヤーカフ
20100 KILL STAR CLOTHING PENTAGRAM EARRINGS[P]
23779 KILL STAR CLOTHING (キルスター・クロージング) Earthlings Earrings [S]
29536 Artemis Classic ミスティックシールドスタッドピアスRD[ACE0132]
29557 Artemis Classic ブラックスピネルスタッドピアス[ACE0128]
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