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 =2
)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-16 11:20:01')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
24件見つかりました
1ページ中1ページ目
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
M 残り1点
¥12,650
MAGICAL MOSH MISFITS
Tops
¥28,600
SILLENT FROM ME
Tops
フリー 残り1点
¥28,600
SILLENT FROM ME
Tops
¥9,680
ROLLING CRADLE
Vest
L 残り1点
¥17,380
VIRGO
Tops
¥9,680
ROLLING CRADLE
Vest
S 残り1点
¥7,480
ROLLING CRADLE
Tops
S 残り1点
¥16,500
Subciety
Vest
¥15,950
KILL STAR CLOTHING
Vest
S 残り1点
¥14,300
Subciety
Vest
Ladies M 残り1点
¥7,150
DISTURBIA CLOTHING
Dress
¥6,600
DISTURBIA CLOTHING
Tops
¥8,140
REBEL8
Tops
¥6,600
DISTURBIA CLOTHING
Tops
¥14,080
VIRGO
tops
L 残り1点
¥18,480
VIRGO
Tops
M 残り1点
¥9,680
ROLLING CRADLE
Vest
¥16,280
VIRGO
L/S Shirt
¥16,280
VIRGO
L/S Shirt
¥18,480
ANIMALIA
Vest
24件見つかりました
1ページ中1ページ目
1
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 ダウンベスト福袋
56956 MAGICAL MOSH MISFITS TEAM MxMxM JKT (ピステ) DOKU
56874 SILLENT FROM ME EVIDENCE -Extra Wide Poncho- GRAY
56875 SILLENT FROM ME EVIDENCE -Extra Wide Poncho- BLACK
56089 ROLLING CRADLE COMBI VEST / RED
55396 VIRGO VIRTALY CHANGE SHIRTS - BLACK
56088 ROLLING CRADLE COMBI VEST / BROWN
17961 ROLLING CRADLE 90's BIG POLO SHIRTS / Navy
18352 Subciety CORDUROY EMBLEM VEST - BLACK
20113 KILL STAR CLOTHING KALI DENIM VEST [B]
20654 Subciety EMBLEM VEST STRIPE
27860 DISTURBIA CLOTHING ALIEN NATION MESH CROP
27863 DISTURBIA CLOTHING ESOTERIC 3/4 CROP TOP
28139 REBEL8 BOVVER BLACK POLO
28243 DISTURBIA CLOTHING Midnight Crop
33428 VIRGO Airship dolmania BURGANDY
38668 VIRGO VG-JKT-178 UMA stretch boa vest black
52906 ROLLING CRADLE COMBI VEST / YELLOW
52984 VIRGO VG-SH-215 NOSTALGIC CHECK TOP BLACK
52985 VIRGO VG-SH-215 NOSTALGIC CHECK TOP RED
54610 ANIMALIA AN20U-JK01 HUNTING VEST
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 2
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=2
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 2
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=2