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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =588
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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 18:54:51')
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, 75
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
57102 Zephyren 2021 NEW YEAR BAG
55039 Zephyren(ゼファレン)FUR PARKA WHITE
55040 Zephyren(ゼファレン)FUR PARKA BLACK
27110 Zephyren (ゼファレン) CAMOUFLAGE QUILT PARKA BLACK
27111 Zephyren (ゼファレン) CAMOUFLAGE QUILT PARKA GREEN
22644 Zephyren (ゼファレン) CROSS PAISLEY PARKA BLACK x WHITE
70905 優里xZEPHYREN -Betelgeuse- PARKA BEIGE
70906 優里xZEPHYREN -Betelgeuse- PARKA BLACK
70907 優里xZEPHYREN -Betelgeuse- PARKA GRAY
45810 Zephyren(ゼファレン)RAINBOW BIG PARKA WHITE
66473 10-FEET×Zephyren(ゼファレン) BIG PARKA BLACK
66494 10-FEET×Zephyren(ゼファレン) BIG PARKA BlackxBlack
66495 10-FEET×Zephyren(ゼファレン) BIG PARKA GRAY
66496 10-FEET×Zephyren(ゼファレン) BIG PARKA OFF WHITE
19408 ZEPHYREN (ゼファレン) TIE DYE PARKA -VISIONARY - NAVY
50376 Zephyren(ゼファレン) DOLMAN BIG PARKA BLACK
50384 Zephyren(ゼファレン) DOLMAN BIG PARKA WHITE
50386 Zephyren(ゼファレン) TAPE BIG PARKA NAVY
50387 Zephyren(ゼファレン) TAPE BIG PARKA WHITE
51868 Zephyren(ゼファレン) SWITCHING PARKA BLACK / WHITE
51869 Zephyren(ゼファレン) SWITCHING PARKA NAVY / RED
55015 Zephyren(ゼファレン)LINE PARKA - Resolve - BLACK
55017 Zephyren(ゼファレン)LINE PARKA - Resolve - MUSTARD
55019 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - BLACK
55020 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - GREEN
55021 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - MUSTARD
59517 Zephyren(ゼファレン) DOLMAN BIG PARKA BLUE / Creux
59518 Zephyren(ゼファレン) DOLMAN BIG PARKA RED / Creux
66723 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA OATMEAL
66725 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA BLACK
45987 Zephyren(ゼファレン)PARKA -alea iacta est / milestone- YELLOW
51967 Zephyren(ゼファレン) BIG PARKA - VISIONARY / zebra eye - WHITE
51968 Zephyren(ゼファレン) BIG PARKA - VISIONARY / zebra eye - BLACK
55143 Zephyren(ゼファレン)PARKA - VISIONARY / Kaleidoscope - BLACK
70701 MY FIRST STORY×Zephyren - Fight Back 23 - BIG PARKA BLACK
27206 Zephyren (ゼファレン) HEAVY WEIGHT PARKA -BEYOND- GRAY
27213 Zephyren (ゼファレン) HEAVY WEIGHT PARKA -SPADE- DENIM
35426 Zephyren (ゼファレン) WAFFLE PARKA -Inhale the black- BLACKxNAVY
42167 Zephyren(ゼファレン) PARKA -DOOR- WHITE
45534 Zephyren(ゼファレン)PARKA - BEYOND PAINTED - BLACK / TIE DIE
45536 Zephyren(ゼファレン)PARKA -MONOLITH- GRAY
45983 Zephyren(ゼファレン)PARKA -alea iacta est / milestone- BLACK
45986 Zephyren(ゼファレン)PARKA -alea iacta est / milestone- GRAY
51962 Zephyren(ゼファレン) PARKA - Raw color - WHITE
51963 Zephyren(ゼファレン) PARKA - Raw color - BLACK
55130 Zephyren(ゼファレン)PARKA - variat omnia tempus - WHITE
55131 Zephyren(ゼファレン)PARKA - variat omnia tempus - BLACK
55133 Zephyren(ゼファレン)PARKA - variat omnia tempus - YELLOW
55134 Zephyren(ゼファレン)PARKA - variat omnia tempus - PURPLE
55135 Zephyren(ゼファレン)PARKA - variat omnia tempus - PINK
22355 Zephyren (ゼファレン) PARKA -Zephees- BLK
27138 Zephyren (ゼファレン) PARKA -BEYOND- WHITE
27139 Zephyren (ゼファレン) PARKA -BEYOND- BLACK
27154 Zephyren (ゼファレン) LIGHT WEIGHT PARKA -SKULL HEAD- BLACKxCAMO
32225 Zephyren(ゼファレン) PARKA -CHOCO BEYOND- GRAY
32226 Zephyren(ゼファレン) PARKA -CHOCO BEYOND- BLACK
45980 Zephyren(ゼファレン)PARKA -PROVE- CAMO 2
45981 Zephyren(ゼファレン)PARKA -PROVE- YELLOW
51955 Zephyren(ゼファレン) PARKA -PROVE- BURGUNDY
52417 Zephyren 2020 NEW YEAR BAG
59651 Zephyren(ゼファレン) PARKA - Elysium - YELLOW
42165 Zephyren(ゼファレン) PARKA -PROVE- BURGUNDY
50513 Zephyren(ゼファレン) PARKA -PROVE- BLACK
68007 【BanG Dream! ×ゲキクロ 2023 ver.】湊友希那×ZEPHYREN コラボ プルオーバーパーカー
19367 ZEPHYREN (ゼファレン) FLEECE STRIPE PARKA -Resolve - BLACK
23897 Zephyren (ゼファレン) SWITCHING S/S LONG HOODY -Resolve- CHA/CHK
50378 Zephyren(ゼファレン) PONCHO HOODY L/S BLACK
54488 【バンドリ!×ゲキクロ第1弾復刻】ZEPHYREN×湊友希那コラボ 限定 パーカー
25082 Zephyren (ゼファレン) S/S HOODY -BEYOND- GRAY
26301 Zephyren (ゼファレン) S/S HOODY -BEYOND- WHITE
48220 Zephyren(ゼファレン)PONCHO HOODY S/S BLACK / 如意宝珠
48229 Zephyren(ゼファレン)PONCHO HOODY S/S BLACK
48233 Zephyren(ゼファレン)PONCHO HOODY S/S WHITE / 如意宝珠