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 dtb_products AS p
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-03-02 04:38:06')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 390)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
37件見つかりました
1ページ中1ページ目
1
S 残り1点
¥12,650
市ヶ谷有咲×SQUARE
Coach Jacket
S 残り1点
¥6,270
市ヶ谷有咲×SQUARE
L/S T-Shirt
¥4,950
市ヶ谷有咲×SQUARE
Beanie
M 残り1点
¥6,050
SQUARE
T-Shirt
¥5,280
SQUARE
Tank Top
¥5,280
SQUARE
Tank Top
M 残り1点
¥7,480
SQUARE
T-Shirt
M 残り1点
¥6,050
SQUARE
Tank Top
M 残り1点
¥18,480
SQUARE
Hoodie
¥6,380
SQUARE
iPhone6 case
M 残り1点
¥16,280
SQUARE
Hoodie
M 残り1点
¥6,050
SQUARE
T-Shirt
¥6,380
SQUARE
Sunglasses
¥16,280
SQUARE
Shorts
L 残り1点
¥16,280
SQUARE
Shorts
M 残り1点
¥16,280
SQUARE
Shorts
M 残り1点
¥9,680
SQUARE
Tank Top
M 残り1点
¥10,780
SQUARE
Zip Hoodie
L 残り1点
¥7,480
SQUARE
Tank Top
¥3,080
SQUARE
iPhone7 Case
¥3,080
SQUARE
iPhone7 Case
iPhone7 残り1点
¥3,080
SQUARE
iPhone7 Case
¥4,180
SQUARE
Sunglasses
フリー 残り1点
¥4,180
SQUARE
Sunglasses
L 残り1点
¥15,180
SQUARE
Shirt
M 残り1点
¥6,380
SQUARE
T-Shirt
¥14,080
SQUARE
Bottoms
¥14,080
SQUARE
Bottoms
¥12,980
SQUARE
Shorts
¥12,980
SQUARE
Shorts
¥12,980
SQUARE
Shorts
M 残り1点
¥8,580
SQUARE
Shorts
XL 残り1点
¥6,050
SQUARE
T-Shirt
¥6,050
SQUARE
T-Shirt
M 残り1点
¥12,980
SQUARE
Shorts
¥12,980
SQUARE
Shorts
L 残り1点
¥12,980
SQUARE
Shorts
37件見つかりました
1ページ中1ページ目
1
55784 【バンドリ!×ゲキクロ 第2弾復刻】SQUARE×市ヶ谷有咲コラボ 限定 コーチJKT
55783 【バンドリ!×ゲキクロ 第2弾復刻】SQUARE×市ヶ谷有咲コラボ 限定 L/S Tシャツ
55782 【バンドリ!×ゲキクロ 第2弾復刻】SQUARE×市ヶ谷有咲コラボ 限定 ニットキャップ
18211 SQUARE SQAR T-SHIRTS BLACK
19868 SQUARE FLOWER TANKTOP RED
19869 SQUARE FLOWER TANKTOP BLUE
19933 SQUARE SQUARE EYE T-SHIRTS
19934 SQUARE EYE TANKTOP
22363 SQUARE SETUP 2WAY SWEAT HOODY INDIGO/GRAY
25396 SQUARE (スクエア) i-PHONE CASE PINUP ALOHA GREEN iPhone6/6s case
25422 SQUARE (スクエア) ALOHA 13 4/3 HOODY NAVY
25433 SQUARE (スクエア) THE ROOTS Ts BLACK
27354 SQUARE PSYCHO SKULL SUNGLASS WHITE
27357 SQUARE CARGO SHORT PANTS D TIGER CAMO
27358 SQUARE CARGO SHORT PANTS BEIGE
27359 SQUARE CARGO SHORT PANTS OLIVE
27365 SQUARE FAMOUS ICONS TANK TOP BLACK
29015 SQUARE ARM PRINT ZIPUP LIGHT HOODY GRAY
34318 SQUARE JUNK PATTERN MESH TANKTOP White
34447 SQUARE GYD i-PHONE CASE BLACK
34448 SQUARE GYD i-PHONE CASE WHITE
34449 SQUARE GYD i-PHONE CASE RED
35049 SQUARE BOX LOGO SUNGLASS LEOPRAD
35052 SQUARE BOX LOGO SUNGLASS YELLOW
35632 SQUARE CAMO-FLA SHIRTS BLACK
36208 SQUARE WAVE BORDER Ts WHITE
36280 SQUARE CARGO SHORT PANTS CAMO&ROSE
36281 SQUARE CARGO SHORT PANTS CAMO&FLAG
36388 SQUARE VARIOUS SHORT PANTS WHITE
36389 SQUARE VARIOUS SHORT PANTS CAMO
36390 SQUARE VARIOUS SHORT PANTS INDIGO
41727 SQUARE SWEAT SHORTS "SQAR" BLACK/YELLOW
42429 SQUARE DISINTEGRATION T-Shirts YELLOW
42430 SQUARE DISINTEGRATION T-Shirts GRAY
42529 SQUARE VARIOUS SHORT PANTS FLOWER
42530 SQUARE VARIOUS SHORT PANTS ORANGE
42531 SQUARE VARIOUS SHORT PANTS LIME GREEN
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => square
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/square/
--------
mb_parse_str
Array
(
[brand_name] => square
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=square&/