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-03-02 03:44:00')
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
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
30783 Zephyren(ゼファレン) PAISLEY G.I BELT WHITE
55011 Zephyren(ゼファレン)SWITCHING LONG SHIRT L/S - Resolve - BLACK
55780 【バンドリ!×ゲキクロ 第2弾復刻】ZEPHYREN×湊友希那コラボ 限定 コーチJKT
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
55007 Zephyren(ゼファレン)PHOTO PRINT SHIRT L/S BLACK / variat omnia tempus
55006 Zephyren(ゼファレン)PHOTO PRINT SHIRT L/S WHITE / variat omnia tempus
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
54994 Zephyren(ゼファレン)EMBLEM SHIRT L/S BLACK / fiat lux
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
54999 Zephyren(ゼファレン)LONG SHIRT L/S FLOWER
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
32491 Zephyren(ゼファレン) NECK STRAP -VISIONARY- BARGUNDY
32493 Zephyren(ゼファレン) NECK STRAP -VISIONARY- WHITE
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
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
54489 【バンドリ!×ゲキクロ第1弾復刻】ZEPHYREN×湊友希那コラボ 限定 Tシャツ
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
52046 Zephyren(ゼファレン) CLASHED SKINNY BLACK.DENIM
52045 Zephyren(ゼファレン) CLASHED SKINNY BLACK
52059 Zephyren(ゼファレン) SAROUEL SWEAT SHORTS BLACK/Pagan
38432 Zephyren (ゼファレン) SAROUEL SWEAT SHORTS BLACK
50216 Zephyren(ゼファレン) BUCKET HAT - PROVE - WHITE
35971 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- NAVY
32299 Zephyren(ゼファレン)TRINITY METAL RING BLACK
32300 Zephyren(ゼファレン)TRINITY METAL RING ANTIQUE.GOLD
26608 Zephyren (ゼファレン) PAISLEY WATCH BLACK
36038 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- KHAKI
19748 Zephyren (ゼファレン) GYM SOX -VISIONARY - WHITE
15211 ZEPHYREN (ゼファレン) EMBROIDERY SHIRT -Charmed- GRAY/CHECK
15231 ZEPHYREN (ゼファレン) ZIP PARKA -SKULL HEAD- BLK
15618 ZEPHYREN (ゼファレン) TEE S/S -Determination- BLK
15662 ZEPHYREN (ゼファレン) SWEAT -VISIONARY- BLK
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&/
ブラック
グレー
ホワイト
ブラウン
カーキ
ベージュ
レッド
ピンク
オレンジ
イエロー
パープル
グリーン
ネイビー
ブルー
ゴールド
シルバー
カモ
ペイズリー
アニマル
タイダイ
チェック
ドット
ストライプ
