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 =1
)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 >= '2021-01-17 03:39:46')
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
50件見つかりました
1ページ中1ページ目
1
¥13,500
Anti Social Social Club
T-Shirt
¥7,700
RIPNDIP
T-Shirt
M 残り1点
¥4,180
THRASHER
T-Shirt
¥4,400
PSYCHOLOGICAL METAMORPHOSIS
T-Shirt
XL 残り1点
¥4,400
PSYCHOLOGICAL METAMORPHOSIS
T-Shirt
¥4,400
MAGICAL MOSH MISFITS
T-Shirt
L 残り1点
¥4,180
FAMOUS STARS AND STRAPS
T-Shirt
¥8,800
アマツカミ
T-Shirt
S 残り1点
¥3,740
MEMPHIS MAY FIRE
T-Shirt
XS 残り1点
¥3,740
THE SUMMER SET
T-Shirt
¥2,853
BEFORE MY LIFE FAILS
T-Shirt
¥6,600
Stay Sick Clothing
T-Shirt
S 残り1点
¥2,547
9mm Parabellum Bullet
T-Shirt
M 残り1点
¥3,056
a flood of circle
T-Shirt
¥3,056
グッドモーニングアメリカ
T-shirt
S 残り1点
¥3,056
グッドモーニングアメリカ
T-shirt
S 残り1点
¥4,620
ROLLING CRADLE
T-Shirt
S 残り1点
¥4,180
MEMPHIS MAY FIRE
T-Shirts
¥2,547
モーモールルギャバン
T-Shirt
Ladies S 残り1点
¥5,603
DISTURBIA CLOTHING
T-Shirt
M 残り1点
¥4,620
RUDIE'S
T-Shirt
XL 残り1点
¥6,380
SQUARE
T-Shirt
L 残り1点
¥3,740
BRING ME THE HORIZON
T-Shirt
¥3,300
魔法少女になり隊×ハジメ☆ファンタジー
T-Shirt
M 残り1点
¥4,620
RUDIE'S
T-Shirt
M 残り1点
¥6,050
REBEL8
T-Shirt
¥6,380
UNUSUAL
T-Shirt
¥7,338
RIPNDIP
T-Shirt
L 残り1点
¥7,590
UNUSUAL
T-Shirt
L 残り1点
¥7,590
UNUSUAL
T-Shirt
XL 残り1点
¥6,839
RIPNDIP
T-Shirt
¥8,030
RIPNDIP
T-Shirt
L 残り1点
¥11,880
ROLLING CRADLE
T-Shirt
M 残り1点
¥9,680
ROLLING CRADLE
T-Shirt
M 残り1点
¥9,680
SALUTE
T-Shirt
M 残り1点
¥4,950
isxnot
T-Shirt
¥4,950
ROLLING CRADLE
T-Shirt
¥4,400
MODERN DAY BABYLON
T-Shirt
¥4,400
MODERN DAY BABYLON
T-Shirt
¥7,043
RIPNDIP
T-Shirt
Kids(140cm) 残り1点
¥3,300
HEDWiNG
T-Shirt
¥9,680
SLIGHTLY NUMB
T-Shirt
2XL 残り1点
¥6,050
MISHKA
T-Shirt
¥7,700
HEDWiNG
T-Shirt
フリー 残り1点
¥4,290
FILA
T-Shirt
¥4,290
FILA
T-Shirt
¥4,950
FILA
T-Shirt
¥4,400
mnml
T-Shirt
¥9,130
FILA
T-Shirt
¥9,350
MISHKA
T-Shirt
50件見つかりました
1ページ中1ページ目
1
56213 Anti Social Social Club Headrush All Over White Tee
55710 RIPNDIP Catch Em All Tee (Blue Spiral Dye)
42972 THRASHER TH8101 Mag LogoTee ROYAL/TURQUOISE
49861 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO 3 MT GREEN
49866 PSYCHOLOGICAL METAMORPHOSIS PLMP MARK 3 PURPLE
54684 MAGICAL MOSH MISFITS MxMxM ZOMBIES TEE BLUE
13035 FAMOUS STARS AND STRAPS MESSY FAMILY Tee BLUE
17935 アマツカミ Mice 恣 Tee
18969 MEMPHIS MAY FIRE Anchor Aqua
19835 THE SUMMER SET Floral Triangle Teal
21130 BEFORE MY LIFE FAILS BMLFCULT Color Tee NVY/PUR
21206 Stay Sick Clothing Cloud 9 Custom T-Shirt
23769 9mm Parabellum Bullet 9tee BLUE
23929 a flood of circle AFOC LOGO TEE BLUE
24155 グッドモーニングアメリカ 国旗Tシャツ(ブルー)
24159 グッドモーニングアメリカ アメコミTシャツ(ライトブルー)
24596 ROLLING CRADLE SD ROLICLE Tee / Blue
24740 MEMPHIS MAY FIRE Shield Royal Blue - T-Shirt
26399 【限定アイテム】モーモールルギャバン ロゴTシャツ(すしおデザイン)
27894 DISTURBIA CLOTHING (ディスタービア・クロージング) Nightmare Nightie
34341 RUDIE'S SOLID PHAT-T TURQUOISE BLUE
36209 SQUARE WAVE BORDER Ts BLUE
36773 BRING ME THE HORIZON Steel City on blue t-shirt
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
40897 RUDIE'S DRAWING BALL-T BLUE
42900 REBEL8 EIGHTH TEE LIGHT BLUE
43071 【ゲキクロ限定】UNUSUAL INDIVIDUAL MARCHING T-SHIRT BLUE
45767 RIPNDIP Relax Tee (Blue / White Cloud Wash)
46891 UNUSUAL REACH FOR THE HEAVEN T-SHIRT RAGOON BLUE
46907 UNUSUAL ASSAULT RIOT T-SHIRT RAGOON BLUE
47655 RIPNDIP Break Yo Self Pocket Tee (Cloud Wash)
47657 RIPNDIP Peek A Nermal Knit Tee (Baby Blue / Red)
49065 ROLLING CRADLE PILE TEE / Blue
49137 ROLLING CRADLE NEO TOKYO BIG TEE / Black
49238 SALUTE REMADE DYE TEE
49248 isxnot(イズノット) x_x tee Chambray
50040 ROLLING CRADLE MONSTER TEE/Mintgreen
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50369 MODERN DAY BABYLON Travelers T-shirt
50694 RIPNDIP MNB JACQUARD RIB TEE SLATE
50855 NAGAHAMA(世田谷店)×HEDWiNG コラボ T-shirt Kids(140サイズ) Light Blue
51701 SLIGHTLY NUMB NOT MOVING TEE BLUE
52262 MISHKA MSS200060M31 T-SHIRTS SLATE
53142 HEDWiNG HD1-018 “Pierre” Tie-dye T-shirt Navy
54423 【BTS着用モデル】 FILA FFM9357 T-shirts Turquoise
54427 【BTS着用モデル】 FILA FFM9357 T-shirts Navy
54631 FILA FFM9836 ユニセックス クルーネックシャツ NAVY
54649 mnml(ミニマル) STRIOED BOXY TEE BLUE/YELLOW
54675 FILA FFM9802 ユニセックス クルーネックシャツ NAVY
54699 MISHKA(ミシカ) MSS200030 T-SHIRTS ORANGE/PURPLE
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 1
[color] => 14
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=1&color=14
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 1
[color] => 14
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=1&color=14