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 =6
)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-15 16:20:22')
AND pc.stock > 0
AND FIND_IN_SET(22, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
40件見つかりました
1ページ中1ページ目
1
¥24,200
glamb
L/S Shirt
¥24,200
glamb
L/S Shirt
¥29,700
Anti Social Social Club
L/S Shirt
¥29,700
Anti Social Social Club
L/S Shirt
¥29,700
Anti Social Social Club
L/S Shirt
L 残り1点
¥17,600
MISHKA
L/S T-Shirt
¥30,800
Zephyren
Happy bag
¥17,600
Zephyren
L/S Shirt
¥17,600
Zephyren
L/S Shirt
L 残り1点
¥17,800 → 8,900
ROLLING CRADLE
L/S Shirt
¥17,800 → 8,900
ROLLING CRADLE
L/S Shirt
¥19,800 → 9,900
SLEEPING TABLET
L/S Shirt
M 残り1点
¥16,280 → 8,140
ROLLING CRADLE
L/S Shirt
M 残り1点
¥15,180 → 7,590
SABBAT13
L/S Shirt
M 残り1点
¥15,180 → 7,590
SABBAT13
L/S Shirt
L 残り1点
¥19,800 → 9,900
MISHKA
L/S Shirt
¥15,400 → 4,620
ANIMALIA
L/S Shirt
M 残り1点
¥15,400 → 4,620
ANIMALIA
L/S Shirt
M 残り1点
¥18,480 → 9,240
NOT COMMON SENSE
L/S Shirt
M 残り1点
¥17,600 → 8,800
Zephyren
L/S Shirt
M 残り1点
¥18,700 → 9,350
PARADOX
L/S Shirt
¥31,680
Anti Social Social Club
L/S Shirt
¥31,680
Anti Social Social Club
L/S Shirt
S 残り1点
¥17,380 → 5,214
ROLLING CRADLE
Shirt
M 残り1点
¥14,300 → 4,290
Subciety
Shirt
L 残り1点
¥15,400 → 4,620
Subciety
Shirt
¥15,400 → 4,620
Subciety
Shirt
¥19,580 → 5,874
VIRGO
L/S Shirt
¥16,280 → 4,884
SABBAT13
L/S Shirt
XL 残り1点
¥9,900 → 2,970
mnml
L/S Shirt
¥9,900 → 2,970
mnml
L/S Shirt
XL 残り1点
¥9,900 → 2,970
mnml
L/S Shirt
M 残り1点
¥17,600 → 5,280
Subciety
L/S Shirt
L 残り1点
¥17,600 → 5,280
Subciety
L/S Shirt
M 残り1点
¥17,380 → 5,214
ROLLING CRADLE
L/S Shirt
M 残り1点
¥10,450 → 3,135
DISTURBIA CLOTHING
L/S Shirt
M 残り1点
¥15,400 → 4,620
Subciety
L/S Shirt
M 残り1点
¥16,280 → 4,884
VIRGO
L/S Shirt
M 残り1点
¥16,280 → 4,884
VIRGO
L/S Shirt
フリー 残り1点
¥19,800 → 5,940
LILWHITE(dot)
L/S Shirt
40件見つかりました
1ページ中1ページ目
1
63594 glamb (グラム) Heavy Damaged SH - Blue
63593 glamb (グラム) Heavy Damaged SH - Black
63386 Anti Social Social Club Dialtone Black Tie Dye Flannel
63384 Anti Social Social Club Dialtone Olive Tie Dye Flannel
63385 Anti Social Social Club Chromey Red Tie Dye Flannel
60560 MISHKA M61000251 CHECK SHIRT
61271 Zephyren 2022 NEW YEAR BAG
59537 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S BLACK / GREEN
59538 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S YELLOW / BLACK
60454 ROLLING CRADLE CHECK NELSHIRT / YELLOW
60455 ROLLING CRADLE CHECK NELSHIRT / BLUE
58303 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] PINK
58311 ROLLING CRADLE BIG CHECK SHIRT / BLACK
57123 SABBAT13 BLACK HEART CHECK SHIRTS BEIGE
57125 SABBAT13 BLACK HEART CHECK SHIRTS GRAY
58108 MISHKA M21000251 SHIRT
56857 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” BLACK CHECK
56858 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” GRAY CHECK
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
55012 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - RED
56033 PARADOX PRINTED CHECK SHIRTS (BLUE)
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
15843 ROLLING CRADLE SWALLOW TAIL SHIRTL / Black/Yellow
15898 Subciety CHECK SHIRTS L/S-Conductor- GRAY
25647 Subciety DOBBY CHECK SHIRT L/S-Praha- KHAKI
25649 Subciety OMBRE CHECK SHIRT L/S-THRON- RED
40007 VIRGO GUITARIST DOLMAN SHIRTS RED
40555 SABBAT13 S-BONE BIG NEL SHIRTS YELLOW
44088 mnml(ミニマル) VINTAGE FLANNEL SHIRT Navy/Natural
44089 mnml(ミニマル) VINTAGE FLANNEL SHIRT Blue/Black/Red
44090 mnml(ミニマル) VINTAGE FLANNEL SHIRT Blue/Natural/Red
45547 Subciety (サブサエティ) CHECK SHIRT YELLOW
45548 Subciety (サブサエティ) CHECK SHIRT PURPLE
46192 ROLLING CRADLE CHECK!CHECK!CHECK! SHIRT / Red-Yellow
49492 DISTURBIA CLOTHING Lazarus Shirt
50905 Subciety (サブサエティ) CHECK SHIRT -TAG- RED
52984 VIRGO VG-SH-215 NOSTALGIC CHECK TOP BLACK
52985 VIRGO VG-SH-215 NOSTALGIC CHECK TOP RED
53115 LILWHITE(dot) LW-20SS-SH01CHARLIE FRINGE EMBROIDERY SHIRT RED
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 6
[color] => 22
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=6&color=22&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 6
[color] => 22
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=6&color=22