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 >= '2020-11-28 10:16:30')
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
55780 【バンドリ!×ゲキクロ 第2弾復刻】ZEPHYREN×湊友希那コラボ 限定 コーチJKT
55779 【バンドリ!×ゲキクロ 第2弾復刻】ZEPHYREN×湊友希那コラボ 限定 L/S Tシャツ
55778 【バンドリ!×ゲキクロ 第2弾復刻】ZEPHYREN×湊友希那コラボ 限定 キャップ
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
54955 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - BLACK
54956 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - ZEBRA
54953 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - BLACK
54954 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - KHAKI
54970 Zephyren(ゼファレン)SKA JUMPER - Kaleidoscope - BLACK
54972 Zephyren(ゼファレン)SKA JUMPER - Kaleidoscope - MIX
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
54986 Zephyren(ゼファレン)TRENCH COAT TWEED
55004 Zephyren(ゼファレン)SHIRT L/S PAISLEY
55107 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - BLACK
55106 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - WHITE
55078 Zephyren(ゼファレン)L/S TEE - fiat lux - BLACK
54952 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - COLORFUL
54951 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - BLACK
54968 Zephyren(ゼファレン)WIDE TAILORD JACKET TWEED
55156 Zephyren(ゼファレン)WIDE SLACKS TWEED
54967 Zephyren(ゼファレン)WIDE TAILORD JACKET BLACK
54964 Zephyren(ゼファレン)REVERSIBLE JACKET BLACK
55034 Zephyren(ゼファレン)KNIT CHECK
55040 Zephyren(ゼファレン)FUR PARKA BLACK
54983 Zephyren(ゼファレン)FUR JACKET BLACK
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
54966 Zephyren(ゼファレン)REVERSIBLE JACKET PAINT
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
55007 Zephyren(ゼファレン)PHOTO PRINT SHIRT L/S BLACK / variat omnia tempus
55006 Zephyren(ゼファレン)PHOTO PRINT SHIRT L/S WHITE / variat omnia tempus
55008 Zephyren(ゼファレン)PHOTO PRINT SHIRT L/S WHITE / aurea mediocritas
54994 Zephyren(ゼファレン)EMBLEM SHIRT L/S BLACK / fiat lux
54993 Zephyren(ゼファレン)EMBLEM SHIRT L/S WHITE / fiat lux
54992 Zephyren(ゼファレン)EMBLEM SHIRT L/S MIX
19297 ZEPHYREN (ゼファレン) EMBLEM SHIRT L/S - WHITE
19298 ZEPHYREN (ゼファレン) EMBLEM SHIRT L/S - BLACK
30210 Zephyren(ゼファレン) LONG SHIRT L/S -Resolve- WHITE
30211 Zephyren(ゼファレン) LONG SHIRT L/S -Resolve- BLACK
55024 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - GREEN
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
54999 Zephyren(ゼファレン)LONG SHIRT L/S FLOWER
55019 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - BLACK
55020 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - GREEN
55021 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - MUSTARD
15221 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- WHT
15222 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- BLK×WHT
15225 ZEPHYREN (ゼファレン) TEE S/S -BEYOND- WHT
15226 ZEPHYREN (ゼファレン) TEE S/S -BEYOND- BLK×WHT
17236 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BLACK/GRAY
30810 Zephyren(ゼファレン) NECK STRAP -VISIONARY- BLACK
32491 Zephyren(ゼファレン) NECK STRAP -VISIONARY- BARGUNDY
32493 Zephyren(ゼファレン) NECK STRAP -VISIONARY- WHITE
33267 Zephyren (ゼファレン) RUBBER RING -VISIONARY- WHITE
33268 Zephyren (ゼファレン) RUBBER RING -VISIONARY- BLACK
34372 Zephyren (ゼファレン) UMBRELLA -PAISLEY-
38450 Zephyren (ゼファレン) LONG STRAP LO CAP -ENGRAVE- WHITE
42101 Zephyren(ゼファレン) S/S TEE -BEYOND- STONE
52048 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK
55047 Zephyren(ゼファレン)S/S TEE - VISIONARY - SKY
55063 Zephyren(ゼファレン)S/S TEE - BEYOND - AQUA
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
55259 Zephyren(ゼファレン)BLACK MASK-VISIONARY- BLACK02
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
16882 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - BLACK
16880 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - WHITE
53268 Zephyren(ゼファレン)DOLMAN BIG HOODY S/S BLACK
48229 Zephyren(ゼファレン)PONCHO HOODY S/S BLACK
51894 Zephyren(ゼファレン) PONCHO TEE S/S WHITE / pagan
51895 Zephyren(ゼファレン) PONCHO TEE S/S BLACK / pagan
53249 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE / BURGUNDY
53248 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE/BLACK
53252 Zephyren(ゼファレン)SWITCHING TEE S/S BLACK / TIGER
52023 Zephyren(ゼファレン) S/S TEE -Got lst Todi- BLACK
52036 Zephyren(ゼファレン) BIG S/S TEE -VISIONARY/zebra eye- WHITE
52037 Zephyren(ゼファレン) BIG S/S TEE -VISIONARY/zebra eye- BLACK
52034 Zephyren(ゼファレン) S/S TEE -Raw color- YELLOW
52035 Zephyren(ゼファレン) S/S TEE -Raw color- PURPLE
52033 Zephyren(ゼファレン) S/S TEE -Raw color- BLACK
53277 Zephyren(ゼファレン)BIG TANKTOP WHITE / pagan
53278 Zephyren(ゼファレン)BIG TANKTOP BLACK / pagan
15637 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- WHT
15638 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- BLK
19596 ZEPHYREN (ゼファレン) SKINNY - I.DENIM
52046 Zephyren(ゼファレン) CLASHED SKINNY BLACK.DENIM
52045 Zephyren(ゼファレン) CLASHED SKINNY BLACK
52059 Zephyren(ゼファレン) SAROUEL SWEAT SHORTS BLACK/Pagan
POST : Array
(
)
--------GET : Array
(
[brand_name] => zephyren
[/] =>
)
Array
(
[0] => /brand/zephyren/
)
Array
(
)
ブラック
グレー
ホワイト
ブラウン
カーキ
ベージュ
レッド
ピンク
オレンジ
イエロー
パープル
グリーン
ネイビー
ブルー
ゴールド
シルバー
カモ
ペイズリー
アニマル
タイダイ
チェック
ドット
ストライプ
