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 >= '2022-08-13 21:13:22')
AND pc.stock > 0
AND FIND_IN_SET(21, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
37件見つかりました
1ページ中1ページ目
1
¥22,000
Subciety
Happy bag
¥22,000
RUDIE'S
Happy bag
¥7,150
RIPNDIP
T-Shirt
¥6,490 → 3,245
RIPNDIP
T-Shirt
¥4,620
MARILYN MANSON
T-Shirt
¥6,600 → 3,300
PSYCHOLOGICAL METAMORPHOSIS
T-Shirt
¥6,600 → 3,300
PSYCHOLOGICAL METAMORPHOSIS
T-Shirt
¥4,950 → 2,475
GoneR
T-Shirt
¥6,490 → 3,245
TOY MACHINE
T-shirts
L 残り1点
¥6,490 → 3,245
TOY MACHINE
T-shirts
L 残り1点
¥6,490 → 3,245
TOY MACHINE
T-shirts
¥6,490 → 3,245
TOY MACHINE
T-shirts
L 残り1点
¥4,950 → 2,475
GoneR
T-Shirt
¥7,480
WASTED PARIS
T-Shirt
¥7,480
WASTED PARIS
T-Shirt
¥5,500 → 1,650
RUDIE'S
T-Shirt
XS 残り1点
¥8,250 → 2,475
Subciety
T-Shirt
S 残り1点
¥3,740 → 1,122
TEXAS IN JULY
T-Shirt
L 残り1点
¥3,740 → 1,122
TEXAS IN JULY
T-Shirt
S 残り1点
¥3,740 → 1,122
MAYDAY PARADE
T-Shirt
M 残り1点
¥3,850
激ロック×サボパン
T-Shirt
¥4,400 → 1,320
Stay Sick Clothing
T-Shirt
S 残り1点
¥3,056
BACK LIFT
T-shirt
¥3,850
BACKDATE NOVEMBER
T-Shirt
S 残り1点
¥4,510
MEMPHIS MAY FIRE
T-Shirts
S 残り1点
¥6,380
ANIMALIA
T-Shirt
S 残り1点
¥6,820 → 2,046
SPITFIRE
T-Shirt
¥6,050 → 1,815
STAY SICK CLOTHING
T-Shirts
¥4,180 → 1,254
UPON A BURNING
T-Shirt
M 残り1点
¥5,500 → 1,650
RUDIE'S
T-Shirt
M 残り1点
¥6,050 → 1,815
FILA
T-Shirt
¥7,150 → 2,145
REBEL8
T-Shirt
L 残り1点
¥6,490 → 3,245
TOY MACHINE
T-Shirt
L 残り1点
¥6,490 → 3,245
TOY MACHINE
T-Shirt
¥6,600 → 3,300
Civil Regime
T-Shirt
¥6,600 → 3,300
Civil Regime
T-Shirt
¥6,600 → 3,300
Civil Regime
T-Shirt
37件見つかりました
1ページ中1ページ目
1
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
60604 RIPNDIP OG Prisma Embroidered Tee (Red Tie Dye)
60598 RIPNDIP Far Far Away Tee (Black/Pink/Blue Spiral Dye)
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
60054 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE SS TEE BLU-BLK
60055 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE SS TEE ORG-BLK
57987 GoneR GR28CT002 Tie-dye Line T-Shirts Light Pink
58781 TOY MACHINE (トイマシーン) DESIGN PRINT TEE LEMON
58782 TOY MACHINE (トイマシーン) DESIGN PRINT TEE PINK
58784 TOY MACHINE (トイマシーン) DESIGN PRINT TEE FUNNEL CAKE
58785 TOY MACHINE (トイマシーン) DESIGN PRINT TEE COTTON CANDY
57988 GoneR GR28CT002 Tie-dye Line T-Shirts Dark Chocolate
58095 WASTED PARIS T-shirt Marble Dye Nebula Green
58096 WASTED PARIS T-shirt Marble Dye Nebula Gray
35571 RUDIE'S (ルーディーズ) PHAT DYED-T RAINBOW
12479 Subciety TIE DYE TEE S/S GRAY
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
15601 TEXAS IN JULY Draw The Line Black Tie Dye
19821 MAYDAY PARADE Label Crimson Tie Dye
20128 激ロック×サボパン【激サボパンTシャツ】 レインボー
21215 Stay Sick Clothing Rainbow Anchor Rainbow Sleeve
23847 BACK LIFT タイダイTシャツ TROPICAL
23859 BACKDATE NOVEMBER タイダイ Tee
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
24901 ANIMALIA DOWN TO TEXAS NAVY
28055 SPITFIRE Bloodshot Premium T-Shirt - Rainbow Tie Dye
28245 STAY SICK CLOTHING Pizza Eternity Tie Dye
28297 UPON A BURNING BODY Sharks Spider Black
40909 RUDIE'S PENGUIN DYED-T SPAIRAL RAINBOW
41795 FILA FM9491 GRAPHIC T-SHIRT BLACK
48292 REBEL8 HAIGHT SST MULTI
54209 TOY MACHINE SKATE SECT TIE-DYE SST - PINK
54210 TOY MACHINE SKATE SECT TIE-DYE SST - SATURN
54696 Civil Regime 20CV-SP05T NEW BLOOM TEE
54697 Civil Regime 20CV-SP07T 8 BALL TEE PASTEL SPIRAL
54698 Civil Regime 20CV-SP08T TIMES UP TEE PASTEL SPIRAL
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 1
[color] => 21
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=1&color=21&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 1
[color] => 21
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=1&color=21