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 =96
)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-09 04:45:56')
AND pc.stock > 0
AND FIND_IN_SET(14, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
35件見つかりました
1ページ中1ページ目
1
¥15,400
Subciety
Bottoms
¥15,180
TRAVAS TOKYO
Bottoms
L 残り1点
¥14,520
PUNK DRUNKERS
Bottoms
¥18,800
ROLLING CRADLE
Bottoms
S 残り1点
¥15,400
MISHKA
Bottoms
¥6,800
Wall Of Graphic
Bottoms
フリー 残り1点
¥6,300
NieR
Bottoms
¥22,000
glamb
Bottoms
¥9,900
PSYCHOLOGICAL METAMORPHOSIS
Bottoms
L 残り1点
¥29,480
VIRGO
Bottoms
¥19,580
VIRGO
Bottoms
¥16,500
glamb
Bottoms
¥19,580
SUPPLIER
Bottoms
¥19,800
glamb
Bottoms
¥30,800
Zephyren
Happy bag
L 残り1点
¥16,999
SLEEPING TABLET
Bottoms
¥5,669 → 3,969
NieR
Bottoms
XL 残り1点
¥17,800 → 12,460
ROLLING CRADLE
Bottoms
L 残り1点
¥20,680
SUPPLIER
Bottoms
M 残り1点
¥19,580 → 9,790
ROLLING CRADLE
Bottoms
¥17,600 → 12,320
SLEEPING TABLET
Bottoms
¥16,500 → 11,550
SLEEPING TABLET
Bottoms
L 残り1点
¥14,300
N.B.O.
Bottoms
S 残り1点
¥18,480
ROLLING CRADLE
Bottoms
¥18,480
ROLLING CRADLE
Bottoms
¥13,200
mnml
Bottoms
¥24,200 → 16,940
SALUTE
Bottoms
¥15,400
RUDIE'S
Bottoms
¥28,380 → 14,190
NOVE
Bottoms
30 残り1点
¥30,580 → 15,290
NOVE
Bottoms
¥15,180 → 7,590
NOVE
Bottoms
30 残り1点
¥23,100 → 11,550
NOVE
Bottoms
32 残り1点
¥30,800 → 15,400
NOVE
Bottoms
S 残り1点
¥23,100 → 11,550
ANIMALIA
Bottoms
¥11,000 → 5,500
MISHKA
Pants
35件見つかりました
1ページ中1ページ目
1
65173 Subciety(サブサエティ) PAINTER DENIM PANTS-INDIGO ONEWASH
64886 TRAVAS TOKYO【トラバストーキョー】Patch Denim Pants
62715 PUNK DRUNKERS PDルーズデニム - LT.BLUE
64972 ROLLING CRADLE RC x KUDAN PANTS / COLOR
61785 MISHKA (ミシカ) M21100936 PANTS
64861 Wall Of Graphic(ウォールオブグラフィック)W.O.G ワイドデニム
64338 NieR (ニーア) フラップ付きSARROUEL PANTS
63522 glamb (グラム) 4 Pocket Baggy Denim - Indigo
62909 PSYCHOLOGICAL METAMORPHOSIS CG SWEAT PANTS - BLUE
61130 VIRGO 90S VINTAGE FAT DENIME INDIGO(VINTAGE)
61109 VIRGO 90S FAT INDIGO(ONE WASH)
61494 glamb (グラム) Old School Jersey Pants BLUE
62131 SUPPLIER (サプライヤー) FIRE PATTERN STITCH LOGO DENIM LIGHT BLUE
61497 glamb (グラム) Semi Flare Denim INDIGO
61271 Zephyren 2022 NEW YEAR BAG
59333 SLEEPING TABLET GENE [ RAW DENIM PANTS ] INDIGO
60585 NieR (ニーア) リラックスガウチョパンツ
60457 ROLLING CRADLE CHECK FLARE PANTS / BLUE
59424 SUPPLIER (サプライヤー) SPLIT CORDUROY DENIM LIGHT BLUE
56608 ROLLING CRADLE THUNDER GATE DENIM -1st damage type- / BLUE
58595 SLEEPING TABLET REVERIE [ PATTERNED PAJAMA PANTS ] NAVY
58605 SLEEPING TABLET NOBLE [ SILKY PAJAMA PANTS ] LAVENDER
56122 N.B.O. BLUE FLARED DENIM PANTS
58013 ROLLING CRADLE THUNDER GATE SKINNY DENIM / INDIGO
58014 ROLLING CRADLE THUNDER GATE SKINNY DENIM / CHEMICAL
43214 mnml(ミニマル) M1 STRETCH DENIM BLUE
57068 SALUTE DENIM HANDCUFFS JEANS
37315 RUDIE'S (ルーディーズ) PHAT STRETCH PANTS INDIGO
43409 NOVE NV-001D 045 DENIM INDIGO
43410 NOVE NV-001D 048 DENIM INDIGO
43412 NOVE NV-009S70 DENIM INDIGO
47022 NOVE NV-009S110 DENIM IND
47024 NOVE NV-001N D060 DENIM IND
50360 ANIMALIA AN19M-PT01 JEANS BRONCO No.7 L.BLUE
51513 MISHKA MSS200910W31 PANTS
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 96
[color] => 14
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=96&color=14&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 96
[color] => 14
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=96&color=14