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 =571
)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-16 05:13:25')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
35件見つかりました
1ページ中1ページ目
1
¥9,900
PSYCHOLOGICAL METAMORPHOSIS
S/S Shirt
¥9,350
THRASHER
S/S Shirt
¥9,350
THRASHER
S/S Shirt
¥15,400
Zephyren
S/S Shirt
¥17,600
Subciety
S/S Shirt
¥14,300
Subciety
S/S Shirt
L 残り1点
¥14,300
Subciety
Shirt
S 残り1点
¥15,400
Subciety
Shirt
S 残り1点
¥14,300
Subciety
Shirt
L 残り1点
¥16,500
Subciety
S/S Shirt
M 残り1点
¥16,500
Subciety
S/S Shirt
L 残り1点
¥14,300
RUDIE'S
S/S Shirt
M 残り1点
¥16,280
Dezzn
S/S Shirt
S 残り1点
¥14,300
Zephyren
Shirt
S 残り1点
¥14,300
Zephyren
Shirt
S 残り1点
¥9,900
DOCAN!
Shirt
¥14,300
Zephyren
S/S Shirt
M 残り1点
¥9,350
ANIMALIA
S/S Shirt
L 残り1点
¥14,300
RUDIE'S
S/S Shirt
¥17,050
VIRGO
S/S Shirt
¥19,800
PLAYBOY×THE CRIMIE
S/S Shirt
¥8,250
DISTURBIA CLOTHING
S/S Shirt
¥15,400
Zephyren
S/S Shirt
¥11,394
RIPNDIP
S/S Shirt
¥12,980
SAMURAI CORE
S/S Shirt
¥15,180
SABBAT13
S/S Shirt
¥15,400
Zephyren
S/S Shirt
¥18,480
KONUS
S/S Shirt
¥9,185
MAGICAL MOSH MISFITS
S/S Shirt
S 残り1点
¥9,185
MAGICAL MOSH MISFITS
S/S Shirt
¥13,200
MISHKA
S/S Shirt
¥10,780
TOY MACHINE
S/S Shirt
¥10,780
TOY MACHINE
S/S Shirt
¥10,450
MAGICAL MOSH MISFITS
S/S Shirt
¥18,480
ANIMALIA
S/S Shirt
35件見つかりました
1ページ中1ページ目
1
54767 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS BLACK
55649 THRASHER TH5179 S/S WORK SHIRT BLACK
55647 THRASHER TH5178 SKATE AND DESTROY S/S Shirt BLACK
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
52762 Subciety MARIA WORK SHIRT BLACK
12817 Subciety SNAKE SHIRT S/S BLACK
16045 Subciety LIBERTY SHIRT S/S - BLACK
22997 Subciety BOWLING SHIRT S/S-NX- BLACK
23018 Subciety WORK SHIRT S/S-Reborn- BLACK
40747 Subciety (サブサエティ) WORK SHIRT-STORY- BLACK
48402 Subciety (サブサエティ) MILITARY SHIRT BLACK
54076 RUDIE'S TUSK OPEN COLLAR SHIRTS BLACK
54747 Dezzn Savior Shirt BLACK
24728 Zephyren (ゼファレン) BLOCK STRIPE SHIRT S/S -Charmed SQ Tone- BLACK
25099 Zephyren (ゼファレン) CAMOUFLAGE SHIRT -Charmed SQ Tone- CAMO IV
25266 DOCAN! ANARCHY workshirt
33077 Zephyren (ゼファレン) S/S SHIRT -CocaCola- BLACK
40434 ANIMALIA AN18U-SH03 BB PLAYER SHIRTS BLACK
47365 RUDIE'S STAB WORK SHIRTS BLACK
49053 VIRGO VG-SH-202 PULLOVER MILY ZIP SHIRTS BLACK
49473 CRIMIE CR01-01K3-SH71 PLAYBOY SHIRT BLACK
49488 DISTURBIA CLOTHING Beat Shirt
49883 Zephyren(ゼファレン)LONG SHIRT S/S -Resolve- BLACK / 如意宝珠
50692 RIPNDIP SUBANAERM BOTTON UP
51248 SAMURAI CORE SR-BS-01-B baseball st black
51738 SABBAT13 YOKAI TRUMP ALOHA (ブラック)
51915 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S BLACK / PAISLEY
53959 KONUS Color Blocked Cotton Twill Oversized Shirt BLACK
54084 SUICIDAL TENDENCIES x MxMxM “MAGICAL TENDENCIES” WORK SHIRT BLACK
54085 SUICIDAL TENDENCIES x MxMxM “MAGICAL TENDENCIES” WORK SHIRT DOKU
54195 MISHKA MSS200204F SHIRTS
54203 TOY MACHINE NEON PRINT SS SHIRT - BLACK
54204 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - BLACK
54553 MAGICAL MOSH MISFITS MxMxM TRUMP SHIRT DOKU
54611 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG BLACK
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[color] => 1
[cat] => 571
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&color=1&cat=571
--------
mb_parse_str
Array
(
[work] => new_arrival
[color] => 1
[cat] => 571
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&color=1&cat=571