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-05-14 03:09:15')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 447)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
57451 Zephyren(ゼファレン) SHIRT S/S - Resolve - FLOWER
57583 Zephyren(ゼファレン) EASY PANTS BROWN CHECK
57597 Zephyren(ゼファレン) DOUBLE POCKET SHORTS BLACK
57598 Zephyren(ゼファレン) DOUBLE POCKET SHORTS PAISLEY
57437 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - WHITE
57438 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BLACK
57439 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BURGUNDY
57443 Zephyren(ゼファレン) EMBLEM SHIRT S/S WHITE / You are hare
57444 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK / You are hare
57587 Zephyren(ゼファレン) EASY PANTS 8/S BROWN CHECK
57594 Zephyren(ゼファレン) SHORTS BROWN CHECK
57596 Zephyren(ゼファレン) SHORTS PAISLEY
57457 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - PAISLEY
57458 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - FLOWER
57455 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - NAVY CHECK
57456 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - RED CHECK
57461 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - WHITE
57463 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - BLACK / PAISLEY
57468 Zephyren(ゼファレン) DOLMAN BIG TEE S/S WHITE / NEVER say NEVER
57469 Zephyren(ゼファレン) DOLMAN BIG TEE S/S BLACK / NEVER say NEVER
57496 Zephyren(ゼファレン) SWITCHING TEE BLACK / FLOWER
57494 Zephyren(ゼファレン) SWITCHING TEE BLACK / BORDER
57484 Zephyren(ゼファレン) DOLMAN BIG TEE S/S - 冥 - BLACK
30783 Zephyren(ゼファレン) PAISLEY G.I BELT WHITE
35969 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- WHITE
57495 Zephyren(ゼファレン) SWITCHING TEE BLACK / PYTHON
57590 Zephyren(ゼファレン) SAROUEL SWEAT SHORTS BLACK
52048 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK
52049 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK.DENIM
57752 Zephyren(ゼファレン) SHOWER SANDALS - Decadence - BLACK
17231 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- - BLACK/WHITE
17236 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BLACK/GRAY
15222 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- BLK×WHT
15225 ZEPHYREN (ゼファレン) TEE S/S -BEYOND- WHT
15637 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- WHT
15638 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- BLK
33267 Zephyren (ゼファレン) RUBBER RING -VISIONARY- WHITE
33268 Zephyren (ゼファレン) RUBBER RING -VISIONARY- BLACK
36037 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- BLACK
36038 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- KHAKI
42101 Zephyren(ゼファレン) S/S TEE -BEYOND- STONE
45602 Zephyren(ゼファレン)LO CAP - PROVE - BLACK
50216 Zephyren(ゼファレン) BUCKET HAT - PROVE - WHITE
55063 Zephyren(ゼファレン)S/S TEE - BEYOND - AQUA
57102 Zephyren 2021 NEW YEAR BAG
54986 Zephyren(ゼファレン)TRENCH COAT TWEED
54968 Zephyren(ゼファレン)WIDE TAILORD JACKET TWEED
55156 Zephyren(ゼファレン)WIDE SLACKS TWEED
54985 Zephyren(ゼファレン)TRENCH COAT BLACK
54967 Zephyren(ゼファレン)WIDE TAILORD JACKET BLACK
55040 Zephyren(ゼファレン)FUR PARKA BLACK
54983 Zephyren(ゼファレン)FUR JACKET BLACK
55021 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - MUSTARD
55020 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - GREEN
55019 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - BLACK
55022 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - WHITE
55023 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - BLACK
55025 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - MUSTARD
54956 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - ZEBRA
54953 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - BLACK
54954 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - KHAKI
54970 Zephyren(ゼファレン)SKA JUMPER - Kaleidoscope - BLACK
54973 Zephyren(ゼファレン)SWITCHING MA-1 - Resolve - MIX I
54974 Zephyren(ゼファレン)SWITCHING MA-1 - Resolve - MIX II
54988 Zephyren(ゼファレン)STUDIUM JACKET - As above,So below - BLACK / WHITE
54989 Zephyren(ゼファレン)STUDIUM JACKET - As above,So below - BLACK / BLACK
55106 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - WHITE
55078 Zephyren(ゼファレン)L/S TEE - fiat lux - BLACK
55077 Zephyren(ゼファレン)L/S TEE - fiat lux - WHITE
54952 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - COLORFUL
54951 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - BLACK
54964 Zephyren(ゼファレン)REVERSIBLE JACKET BLACK
55034 Zephyren(ゼファレン)KNIT CHECK
54978 Zephyren(ゼファレン)COACH JACKET - fiat lux - BURGUNDY
54976 Zephyren(ゼファレン)COACH JACKET - fiat lux - BLACK
55130 Zephyren(ゼファレン)PARKA - variat omnia tempus - WHITE
55133 Zephyren(ゼファレン)PARKA - variat omnia tempus - YELLOW
55135 Zephyren(ゼファレン)PARKA - variat omnia tempus - PINK
55134 Zephyren(ゼファレン)PARKA - variat omnia tempus - PURPLE
55131 Zephyren(ゼファレン)PARKA - variat omnia tempus - BLACK
45600 Zephyren(ゼファレン)LO CAP - PROVE - WHITE
54982 Zephyren(ゼファレン)FUR JACKET WHITE
55015 Zephyren(ゼファレン)LINE PARKA - Resolve - BLACK
55016 Zephyren(ゼファレン)LINE PARKA - Resolve - NAVY
55017 Zephyren(ゼファレン)LINE PARKA - Resolve - MUSTARD
55026 Zephyren(ゼファレン)PEINTED SWEAT BLACK
55028 Zephyren(ゼファレン)PEINTED SWEAT MUSTARD
55012 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - RED
55013 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - GREEN
30210 Zephyren(ゼファレン) LONG SHIRT L/S -Resolve- WHITE
55024 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - GREEN
30211 Zephyren(ゼファレン) LONG SHIRT L/S -Resolve- BLACK
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
15226 ZEPHYREN (ゼファレン) TEE S/S -BEYOND- BLK×WHT
30810 Zephyren(ゼファレン) NECK STRAP -VISIONARY- BLACK
32491 Zephyren(ゼファレン) NECK STRAP -VISIONARY- BARGUNDY
32493 Zephyren(ゼファレン) NECK STRAP -VISIONARY- WHITE
34372 Zephyren (ゼファレン) UMBRELLA -PAISLEY-
38450 Zephyren (ゼファレン) LONG STRAP LO CAP -ENGRAVE- WHITE
55047 Zephyren(ゼファレン)S/S TEE - VISIONARY - SKY
55066 Zephyren(ゼファレン)S/S TEE - fiat lux - WHITE
55067 Zephyren(ゼファレン)S/S TEE - fiat lux - BLACK
55071 Zephyren(ゼファレン)BIG TEE - VISIONARY / Kaleidoscope - WHITE
55072 Zephyren(ゼファレン)BIG TEE - VISIONARY / Kaleidoscope - BLACK
55073 Zephyren(ゼファレン)L/S TEE - As above,So below - WHITE
55074 Zephyren(ゼファレン)L/S TEE - As above,So below - BLACK
55081 Zephyren(ゼファレン)BIG L/S TEE - VISIONARY / Kaleidoscope - WHITE
55082 Zephyren(ゼファレン)BIG L/S TEE - VISIONARY / Kaleidoscope - BLACK
55099 Zephyren(ゼファレン)ZIP PARKA - As above,So below - BLACK
55142 Zephyren(ゼファレン)PARKA - VISIONARY / Kaleidoscope - WHITE
55143 Zephyren(ゼファレン)PARKA - VISIONARY / Kaleidoscope - BLACK
55217 Zephyren(ゼファレン)WIDEBRIM FELT HAT BEIGE
55261 Zephyren(ゼファレン)BUFF FACE MASK BLACK
45158 Zephyren(ゼファレン)MID CUT SNEAKER BLACK
53266 Zephyren(ゼファレン)BIG SHIRT S/S BROWN / WAGARA
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
53213 Zephyren(ゼファレン)LONG SHIRT S/S BLACK / pagan
53268 Zephyren(ゼファレン)DOLMAN BIG HOODY S/S BLACK
48229 Zephyren(ゼファレン)PONCHO HOODY S/S BLACK
51894 Zephyren(ゼファレン) PONCHO TEE S/S WHITE / pagan
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => zephyren
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/zephyren/
--------
mb_parse_str
Array
(
[brand_name] => zephyren
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=zephyren&/
ブラック
グレー
ホワイト
ブラウン
カーキ
ベージュ
レッド
ピンク
オレンジ
イエロー
パープル
グリーン
ネイビー
ブルー
ゴールド
シルバー
カモ
ペイズリー
アニマル
タイダイ
チェック
ドット
ストライプ
