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 >= '2024-03-29 09:22:41')
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 MAX(price02) DESC
LIMIT 0, 120
27077 Zephyren (ゼファレン) STUDIUM JKT -SPADE- BLACK
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
54987 Zephyren(ゼファレン)STUDIUM JACKET - As above,So below - WHITE
54989 Zephyren(ゼファレン)STUDIUM JACKET - As above,So below - BLACK / BLACK
50657 Zephyren(ゼファレン) STUDIUM JACKET BLACK 01
50658 Zephyren(ゼファレン) STUDIUM JACKET BLACK 02
54985 Zephyren(ゼファレン)TRENCH COAT BLACK
54986 Zephyren(ゼファレン)TRENCH COAT TWEED
50655 Zephyren(ゼファレン) LONG COAT GREEN
54955 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - BLACK
54956 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - ZEBRA
54967 Zephyren(ゼファレン)WIDE TAILORD JACKET BLACK
54968 Zephyren(ゼファレン)WIDE TAILORD JACKET TWEED
59459 Zephyren(ゼファレン) WIDE TAILORD JACKET BLACK / CHECK
59479 Zephyren(ゼファレン) STUDIUM JACKET MIX
59491 【予約商品】Zephyren(ゼファレン) LONG COAT RED / CHECK
50522 Zephyren(ゼファレン) MA-1 BLACK
59438 Zephyren(ゼファレン) DENIM JKT - Victoria - BLACK / BLACK
59440 Zephyren(ゼファレン) DENIM JKT - Victoria - INDIGO / BLACK
59480 Zephyren(ゼファレン) FUR COAT BLACK
59481 Zephyren(ゼファレン) FUR COAT BROWN
61271 Zephyren 2022 NEW YEAR BAG
19282 ZEPHYREN (ゼファレン) STUDIUM JKT -SKULL HEAD- BLACK
19285 ZEPHYREN (ゼファレン) STUDIUM JKT -EMBLEM- BLACK
19286 ZEPHYREN (ゼファレン) STUDIUM JKT -EMBLEM - BURGUNDY
57102 Zephyren 2021 NEW YEAR BAG
59428 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - BLACK
59429 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - NAVY / WHITE
59432 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - L.PINK
54973 Zephyren(ゼファレン)SWITCHING MA-1 - Resolve - MIX I
54974 Zephyren(ゼファレン)SWITCHING MA-1 - Resolve - MIX II
45794 Zephyren(ゼファレン)MA-1 BLACK
50763 Zephyren(ゼファレン) DENIM JACKET HARD WASH / BUNNY
52436 ROTTENGRAFFTY×Zephyren 20周年限定コラボジャケット M-65 Black
52437 ROTTENGRAFFTY×Zephyren 20周年限定コラボジャケット M-65 KHAKI
54951 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - BLACK
54952 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - COLORFUL
54964 Zephyren(ゼファレン)REVERSIBLE JACKET BLACK
54966 Zephyren(ゼファレン)REVERSIBLE JACKET PAINT
54972 Zephyren(ゼファレン)SKA JUMPER - Kaleidoscope - MIX
59457 Zephyren(ゼファレン) MA-1 FLOWER
70908 優里xZEPHYREN -Betelgeuse- SOUVENIR JACKET BEIGE
70909 優里xZEPHYREN -Betelgeuse- SOUVENIR JACKET BLACK
51038 Zephyren(ゼファレン) SKA JUMPER BLACK
51040 Zephyren(ゼファレン) SKA JUMPER PAISLEY
51798 Zephyren(ゼファレン) DAMEGE JACKET CAMO
51799 Zephyren(ゼファレン) RAKUGAKI JACKET BLACK
52534 MY FIRST STORY×Zephyren MA-1 -Captivate- CAMO
52535 MY FIRST STORY×Zephyren MA-1 -Captivate- BLACK
52536 MY FIRST STORY×Zephyren MA-1 -Captivate- WHITE
54953 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - BLACK
54954 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - KHAKI
59448 Zephyren(ゼファレン) TRENCH COAT FLOWER
66492 10-FEET×Zephyren(ゼファレン) TRACK JACET BLACK
27075 Zephyren (ゼファレン) STUDIUM JKT -BEYOND- BLACK
27076 Zephyren (ゼファレン) STUDIUM JKT -BEYOND- BURGUNDY
27078 Zephyren (ゼファレン) STUDIUM JKT -SPADE- BURGUNDY
50518 Zephyren(ゼファレン) NYLON MODS COAT BLACK
51803 Zephyren(ゼファレン) NYLON JACKET NAVY / BURGUNDY
51804 Zephyren(ゼファレン) NYLON JACKET CAMO / KHAKI
51808 Zephyren(ゼファレン) CHESTER COAT PYTHON
59444 Zephyren(ゼファレン) MA-1 Type BLOUSON FLOWER
31519 Zephyren(ゼファレン)xMY FIRST STORY STUDS TAILORD JKT -S.C.W- HEX
41969 Zephyren(ゼファレン) JERSEY HOOD BLACK
50372 Zephyren(ゼファレン) BIG JERSEY BLACK / apocalypse
50373 Zephyren(ゼファレン) BIG JERSEY BLACK
50374 Zephyren(ゼファレン) BIG JERSEY BLACK / MIX
42091 Zephyren(ゼファレン) BIG JAGUARD KNIT BLACK
70703 MY FIRST STORY×Zephyren - Fight Back 23 - STUDIUM JACKET BLACKxWHITE
35835 Zephyren (ゼファレン) BIG JAGUARD KNIT -Cut the world- BLACK
46184 Zephyren(ゼファレン)MODS COAT KHAKI
50212 Zephyren(ゼファレン) MODS COAT - oldschool - BLACK
50213 Zephyren(ゼファレン) MODS COAT - oldschool - KAHKI
50660 Zephyren(ゼファレン) BIG JAGUARD KNIT RED
50661 Zephyren(ゼファレン) BIG JAGUARD KNIT BLACK
50662 Zephyren(ゼファレン) BIG JAGUARD KNIT WHITE
55039 Zephyren(ゼファレン)FUR PARKA WHITE
55040 Zephyren(ゼファレン)FUR PARKA BLACK
70697 優里xZephyren -Betelgeuse- JACQUARD KNIT BLACK
17195 ZEPHYREN (ゼファレン) CARGO SHORTS - KHAKI
19584 ZEPHYREN (ゼファレン) DENIM MK-Ⅰ - ONE WASH
45527 Zephyren(ゼファレン)MOUNTAIN PARKA BLACK
19371 ZEPHYREN (ゼファレン) TIE DYE TRIBAL ZIP PARKA GRAY
23609 Zephyren (ゼファレン) SLACKS SHORTS CAMO
27110 Zephyren (ゼファレン) CAMOUFLAGE QUILT PARKA BLACK
27111 Zephyren (ゼファレン) CAMOUFLAGE QUILT PARKA GREEN
36037 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- BLACK
36038 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- KHAKI
40384 Zephyren MID CUT SNEAKER SUEDExPAINT
52045 Zephyren(ゼファレン) CLASHED SKINNY BLACK
52046 Zephyren(ゼファレン) CLASHED SKINNY BLACK.DENIM
52047 Zephyren(ゼファレン) CLASHED SKINNY INDIGO.DENIM
52049 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK.DENIM
57580 【予約商品】Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK.DENIM
22644 Zephyren (ゼファレン) CROSS PAISLEY PARKA BLACK x WHITE
24783 ZEPHYREN (ゼファレン) TIE DYE TRIBAL PARKA -Resolve - NAVY
27068 Zephyren (ゼファレン) MELTON JKT BLACK
42718 Zephyren(ゼファレン) MID CUT SNEAKER SUEDE
50663 Zephyren(ゼファレン) BIG BORDER KNIT RED
70905 優里xZEPHYREN -Betelgeuse- PARKA BEIGE
70906 優里xZEPHYREN -Betelgeuse- PARKA BLACK
70907 優里xZEPHYREN -Betelgeuse- PARKA GRAY
35739 Zephyren (ゼファレン) LEATHER HOODY WHITE
35741 Zephyren (ゼファレン) BIG MA-1 BLACK
35742 Zephyren (ゼファレン) BIG MA-1 KHAKI
17180 ZEPHYREN (ゼファレン) SKINNY -BLACK-
19596 ZEPHYREN (ゼファレン) SKINNY - I.DENIM
26585 Zephyren (ゼファレン) WORK PANTS -EMBLEM- BEIGE
27034 Zephyren (ゼファレン) LONG MA-1 BLACK
38443 Zephyren (ゼファレン) BANDANA SHORTS CAMO
40027 Zephyren BANDANA HOOD SHIRT S/S -DOOR- WHITE
40180 Zephyren BANDANA SHORTS BLACK
40376 Zephyren SLIPPON PAISLEY
42095 Zephyren(ゼファレン) LONG CARDIGAN BLACK/INTAGRAL
45156 Zephyren(ゼファレン)SLIPPON SUEDE
45810 Zephyren(ゼファレン)RAINBOW BIG PARKA WHITE
48709 Zephyren(ゼファレン) SWITCHING SHIRT L/S BLACK
50377 Zephyren(ゼファレン) SWITCHING SHIRT L/S MIX
50529 Zephyren(ゼファレン) SLACKS BLACK / CHECK
51042 Zephyren(ゼファレン) SWITCHING SHIRT L/S MIX