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 =395
)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 20:30:05')
AND pc.stock > 0
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
30件見つかりました
1ページ中1ページ目
1
¥17,600
glamb
Sweatshirt
¥18,480
glamb×チェンソーマン
Sweatshirt
¥9,350
HYPER CORE
Sweatshirt
¥19,800
LONELY論理
Sweatshirt
2XL 残り1点
¥12,100
Subciety
Sweatshirt
¥7,590
ZERO EVOKE
Sweatshirt
¥7,590
ZERO EVOKE
Sweatshirt
¥8,580
ZERO EVOKE ZENON
Sweatshirt
L 残り1点
¥6,490
THRASHER
Sweatshirt
¥9,350
HYPER CORE
Sweatshirt
¥30,800
Zephyren
Happy bag
¥14,300
NineMicrophones
Sweatshirt
フリー 残り1点
¥11,550 → 5,775
HEDWiNG
Sweatshirt
L 残り1点
¥9,900 → 4,950
SILLENT FROM ME
Sweatshirt
¥17,600 → 8,800
MISHKA
Sweatshirt
¥17,380 → 8,690
VIRGO
Zip Hoodie
¥7,480
THRASHER
Sweatshirt
M 残り1点
¥7,480
THRASHER
Sweatshirt
¥8,690
FILA
Sweatshirt
XL 残り1点
¥11,000
Subciety
Sweatshirt
L 残り1点
¥27,500
FOG ESSENTIALS
Sweatshirt
¥11,000 → 5,500
ANIMALIA
Sweatshirt
S 残り1点
¥9,900 → 2,970
KILL STAR CLOTHING
Sweatshirt
¥4,074
HER NAME IN BLOOD
Sweatshirts
S 残り1点
¥12,100 → 3,630
MISHKA
Sweatshirt
¥9,900
戸山香澄×ゲキクロ
Sweatshirt
M 残り1点
¥9,900
花園たえ×ゲキクロ
Sweatshirt
¥9,900
牛込りみ×ゲキクロ
Sweatshirt
M 残り1点
¥12,100 → 3,630
STAPLE
Sweatshirt
XL 残り1点
¥20,680 → 10,340
KONUS
Sweatshirt
30件見つかりました
1ページ中1ページ目
1
63570 【予約商品】glamb (グラム) Retro Future Sweat - White
61340 glamb (グラム)×チェンソーマン Aki Sweat White
63092 HYPER CORE Swallowスウェット WHITE
62631 LONELY論理 MEID NAGISA ASSASIN HALF ZIP WHITE
61843 Subciety (サブサエティ) SLUGGER SWEAT WHITE
61532 ZERO EVOKE Logo First SWEAT WHITE×WHITE
61533 ZERO EVOKE Logo First SWEAT WHITE×BLACK
61547 ZERO EVOKE ZENON Graphic Logo SWEAT WHITE
61645 THRASHER (スラッシャー) TH94329VPL Collage by M.Sieben CREW SWEAT WHITE
61600 HYPER CORE BOOSTスウェット WHITE
61271 Zephyren 2022 NEW YEAR BAG
61404 NineMicrophones SWEAT-Wanderer- WHITE
60036 HEDWiNG Reflector Sweat White
57827 SILLENT FROM ME WORDS -Crew Sweat- WHITE
58113 MISHKA M21000414M WHITE
57032 VIRGO Upright zip swt WHITE
57417 THRASHER (スラッシャー) TH8401PL MAG LOGO SWEAT WHITE
57422 THRASHER (スラッシャー) TH8428PLGONZ SWEAT WHITE
57386 FILA FS3026 CREW WHITE
56441 Subciety (サブサエティ) SWEAT-SERVER-WHITE
56768 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts WHITE
55975 ANIMALIA AN20A-SW06 “BLACKFOOT” Big silhouette Crew Neck Sweat WHITE
22402 KILL STAR CLOTHING Cult Sweatshirt
23452 HER NAME IN BLOOD ダンベル・クルーネック WHITE
30108 MISHKA (ミシカ) EAD END CREWNECK WHITE
49746 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 戸山香澄ver.
49747 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 花園たえver.
49748 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 牛込りみver.
52446 STAPLE Ski Crewneck
53956 KONUS Sweatshirt With Zipper chest pocket WHITE
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 395
[color] => 3
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=395&color=3&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 395
[color] => 3
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=395&color=3