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 =588
)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 05:20:27')
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
31件見つかりました
1ページ中1ページ目
1
フリー 残り1点
¥12,980
TRAVAS TOKYO
Pullover
XL 残り1点
¥13,200
RIPNDIP
Pullover
¥5,999
NieR
Pullover
¥12,980
TRAVAS TOKYO
Pullover
¥5,200
Meltyglow
Pullover
¥11,550
PUNK DRUNKERS
Pullover
L/XL 残り1点
¥18,700
MISHKA
Pullover
M 残り1点
¥15,400
MISHKA
Pullover
¥14,850
ANIMALIA
Pullover
¥9,900
RUDIE'S
Pullover
¥17,380
SUPPLIER
Pullover
¥30,800
Zephyren
Happy bag
¥22,000
Subciety
Happy bag
¥22,000
RUDIE'S
Happy bag
L 残り1点
¥11,880
SABBAT13
Pullover
¥15,290 → 10,703
RIPNDIP
Pullover
XL 残り1点
¥16,500
Subciety
Pullover
¥16,500
Subciety
Pullover
¥11,550
PSYCHOLOGICAL METAMORPHOSIS
Pullover
¥11,550 → 8,085
MAGICAL MOSH MISFITS
Hoodie
¥9,900 → 6,930
四星球×GEKIROCK CLOTHING
Pullover
¥16,500
ANIMALIA
Pullover
¥16,500
ANIMALIA
Pullover
¥9,900
RUDIE'S
Pullover
2XL 残り1点
¥25,000
Anti Social Social Club
Pullover
¥27,500
Anti Social Social Club
Pullover
¥17,380 → 8,690
ROLLING CRADLE
Pullover
¥13,200 → 6,600
STAPLE
Pullover
L 残り1点
¥11,000 → 5,500
PSYCHOLOGICAL METAMORPHOSIS
Pullover
L 残り1点
¥9,800
THRASHER
Pullover
XL 残り1点
¥12,980 → 6,490
GALFY
Pullover
31件見つかりました
1ページ中1ページ目
1
64376 TRAVAS TOKYO【トラバストーキョー】 Punkish bear shoulder zip H/S hoodie A
64273 RIPNDIP (リップンディップ) Nikola Hoodie (Black/Blue)
64320 NieR (ニーア) 夏用BLUE CHECKERED HALF ZIP HOODIE
61727 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー マルチカラー
63328 Meltyglow (メルティグロウ) 総柄半袖PARKA【Fall melty】
60929 PUNK DRUNKERS [PDSx太鼓の達人]パーカーだドン!パーカー - LT.BLUE
61758 MISHKA (ミシカ) M21100462 HOODIE
61814 MISHKA (ミシカ) M21100404 HOODIE
63066 ANIMALIA AN22SP-SW07 DOUBLE KNIT HOODIE-Overlap Logo BLUE
62163 RUDIE'S (ルーディーズ) HELLO HOOD SWEAT LIGHT BLUE
61571 SUPPLIER (サプライヤー) CROSS HOODIE LIGHT BLUE
61271 Zephyren 2022 NEW YEAR BAG
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
60708 SABBAT13 WIND PRANK HOODIE BLUE
60589 RIPNDIP Stellar Hoodie (Purple/Blue Spiral Dye)
59010 Subciety (サブサエティ) Robin PARKA - BLUE
59013 Subciety (サブサエティ) PIGMENT PARKA - BLUE
58414 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA SAX-ORG
59392 MAGICAL MOSH MISFITS MxMxM パイル PARKA TEE BLUE
57818 四星球×ゲキクロ 限定コラボ・パーカー ライトブルー
58328 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO L.BLUE
58327 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO INDIGO
58002 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT BLUE
56204 Anti Social Social Club Headrush All Over White Hoodie
55628 Anti Social Social Club SAMSIES BLUE HOODIE
50556 ROLLING CRADLE LOOSE HOODIE / Crazy
52443 STAPLE Neo Sport Nylon Hoodie
53915 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLUE
54430 THRASHER GONZ HOODIE
50604 GALFY (ガルフィー) 野良犬ダブダブパーカー 青野良犬
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 588
[color] => 14
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=588&color=14&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 588
[color] => 14
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=588&color=14