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-04-27 11:58:31')
AND pc.price02 > 13636
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
70909 優里xZEPHYREN -Betelgeuse- SOUVENIR JACKET BLACK
70908 優里xZEPHYREN -Betelgeuse- SOUVENIR JACKET BEIGE
70906 優里xZEPHYREN -Betelgeuse- PARKA BLACK
70905 優里xZEPHYREN -Betelgeuse- PARKA BEIGE
70907 優里xZEPHYREN -Betelgeuse- PARKA GRAY
70703 MY FIRST STORY×Zephyren - Fight Back 23 - STUDIUM JACKET BLACKxWHITE
70704 MY FIRST STORY×Zephyren - Fight Back 23 - NYLON JACKET BLACK
70701 MY FIRST STORY×Zephyren - Fight Back 23 - BIG PARKA BLACK
70697 優里xZephyren -Betelgeuse- JACQUARD KNIT BLACK
66722 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise MOCK NECK LOOSE SWEAT BK
66725 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA BLACK
66723 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA OATMEAL
66492 10-FEET×Zephyren(ゼファレン) TRACK JACET BLACK
66473 10-FEET×Zephyren(ゼファレン) BIG PARKA BLACK
66494 10-FEET×Zephyren(ゼファレン) BIG PARKA BlackxBlack
66496 10-FEET×Zephyren(ゼファレン) BIG PARKA OFF WHITE
66501 10-FEET×Zephyren(ゼファレン) SWEAT PANTS BLACK
66502 10-FEET×Zephyren(ゼファレン) SWEAT PANTS BlackxBlack
66495 10-FEET×Zephyren(ゼファレン) BIG PARKA GRAY
66504 10-FEET×Zephyren(ゼファレン) SWEAT PANTS OFF WHITE
66505 10-FEET×Zephyren(ゼファレン) SWEAT PANTS GRAY
61271 Zephyren 2022 NEW YEAR BAG
64475 【予約商品】Zephyren(ゼファレン) PRINT SHIRT L/S FLOW - Proof - WHITE
64524 Zephyren(ゼファレン)COACH JACKET - In vino veritas - BLACK
64522 Zephyren(ゼファレン)COACH JACKET - FEAR NO ONE - BLACK
62198 Zephyren(ゼファレン) CHECK SHIRT S/S - Resolve - GRAYⅠ
62214 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - PAISLEY
62228 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - BLACK / DRAGONFLY
62229 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - RED / DRAGONFLY
62195 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK
62347 Zephyren(ゼファレン) SHORTS BLACK / DRAGONFLY
62209 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK CHECK
57456 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - RED CHECK
57455 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - NAVY CHECK
59492 Zephyren(ゼファレン) EMBLEM SHIRT L/S WHITE
59493 Zephyren(ゼファレン) EMBLEM SHIRT L/S BLACK
59498 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - WHITE
59499 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - BLACK
55155 Zephyren(ゼファレン)WIDE SLACKS BLACK
62342 Zephyren(ゼファレン) EASY PANTS 8/S BLACK / DRAGONFLY
59534 Zephyren(ゼファレン) BIG SHIRT L/S BROWN / PAISLEY
59459 Zephyren(ゼファレン) WIDE TAILORD JACKET BLACK / CHECK
59491 【予約商品】Zephyren(ゼファレン) LONG COAT RED / CHECK
59432 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - L.PINK
59438 Zephyren(ゼファレン) DENIM JKT - Victoria - BLACK / BLACK
59440 Zephyren(ゼファレン) DENIM JKT - Victoria - INDIGO / BLACK
59441 Zephyren(ゼファレン) DENIM JKT - Victoria - INDIGO/RED
59448 Zephyren(ゼファレン) TRENCH COAT FLOWER
59434 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - GRAY
59435 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - KHAKI
59543 Zephyren(ゼファレン) PAISLEY PARKA BLACK
59518 Zephyren(ゼファレン) DOLMAN BIG PARKA RED / Creux
59517 Zephyren(ゼファレン) DOLMAN BIG PARKA BLUE / Creux
59428 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - BLACK
59429 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - NAVY / WHITE
59479 Zephyren(ゼファレン) STUDIUM JACKET MIX
59480 Zephyren(ゼファレン) FUR COAT BLACK
59481 Zephyren(ゼファレン) FUR COAT BROWN
59676 Zephyren(ゼファレン) JERSEY PANTS BLACK / RED
59444 Zephyren(ゼファレン) MA-1 Type BLOUSON FLOWER
59457 Zephyren(ゼファレン) MA-1 FLOWER
59552 Zephyren(ゼファレン) JACQUARD CUT L/S BLACK / MIX
57583 Zephyren(ゼファレン) EASY PANTS BROWN CHECK
57587 Zephyren(ゼファレン) EASY PANTS 8/S BROWN CHECK
49887 Zephyren(ゼファレン)LONG CHECK SHIRT S/S BLACK
57437 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - WHITE
57438 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BLACK
57451 Zephyren(ゼファレン) SHIRT S/S - Resolve - FLOWER
57594 Zephyren(ゼファレン) SHORTS BROWN CHECK
57597 Zephyren(ゼファレン) DOUBLE POCKET SHORTS BLACK
57458 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - FLOWER
57598 Zephyren(ゼファレン) DOUBLE POCKET SHORTS PAISLEY
57439 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BURGUNDY
57444 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK / You are hare
57596 Zephyren(ゼファレン) SHORTS PAISLEY
54999 Zephyren(ゼファレン)LONG SHIRT L/S FLOWER
52049 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK.DENIM
36037 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- BLACK
36038 Zephyren (ゼファレン) MOUNTAIN BOOTS -RIDGE- KHAKI
57580 【予約商品】Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK.DENIM
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
55039 Zephyren(ゼファレン)FUR PARKA WHITE
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
55011 Zephyren(ゼファレン)SWITCHING LONG SHIRT L/S - Resolve - BLACK
54955 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - BLACK
54956 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - ZEBRA
54953 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - BLACK
54954 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - KHAKI
54972 Zephyren(ゼファレン)SKA JUMPER - Kaleidoscope - MIX
54973 Zephyren(ゼファレン)SWITCHING MA-1 - Resolve - MIX I
54974 Zephyren(ゼファレン)SWITCHING MA-1 - Resolve - MIX II
54987 Zephyren(ゼファレン)STUDIUM JACKET - As above,So below - WHITE
54988 Zephyren(ゼファレン)STUDIUM JACKET - As above,So below - BLACK / WHITE
54989 Zephyren(ゼファレン)STUDIUM JACKET - As above,So below - BLACK / BLACK
55004 Zephyren(ゼファレン)SHIRT L/S PAISLEY
55107 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - BLACK
54952 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - COLORFUL
54951 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - BLACK
54964 Zephyren(ゼファレン)REVERSIBLE JACKET BLACK
54978 Zephyren(ゼファレン)COACH JACKET - fiat lux - BURGUNDY
54976 Zephyren(ゼファレン)COACH JACKET - fiat lux - BLACK
54966 Zephyren(ゼファレン)REVERSIBLE JACKET PAINT
55015 Zephyren(ゼファレン)LINE PARKA - Resolve - BLACK
55017 Zephyren(ゼファレン)LINE PARKA - Resolve - MUSTARD
55028 Zephyren(ゼファレン)PEINTED SWEAT MUSTARD
55010 Zephyren(ゼファレン)SWITCHING LONG SHIRT L/S - Resolve - WHITE
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
30211 Zephyren(ゼファレン) LONG SHIRT L/S -Resolve- BLACK