SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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-30 19:33:08')
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
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
53483 Zephyren(ゼファレン)LEATHER WATCH - MOON - BLACK
26608 Zephyren (ゼファレン) PAISLEY WATCH BLACK
28475 Zephyren (ゼファレン) PAISLEY WATCH WHITE
17335 ZEPHYREN (ゼファレン) PAISLEY LETHER WALLET -LONG- BROWN
19754 ZEPHYREN (ゼファレン) PAISLEY LETHER WALLET -LONG - BLACK
19756 ZEPHYREN (ゼファレン) PAISLEY LETHER WALLET -LONG - NAVY
35922 Zephyren (ゼファレン) FELT HAT CAMEL
55215 Zephyren(ゼファレン)WIDEBRIM FELT HAT BLACK
55217 Zephyren(ゼファレン)WIDEBRIM FELT HAT BEIGE
27402 Zephyren (ゼファレン) PAISLEY LETHER WALLET BLACK
35912 Zephyren (ゼファレン) STAR STUDS BERET BROWN
35913 Zephyren (ゼファレン) WOOL B.B CAP -LATITUDE LONGTITUDE- WHITE
40239 Zephyren WASHABLE BLADE HAT IVOLY
45815 Zephyren(ゼファレン)BACK PACK - VISIONARY - BLACK
17231 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- - BLACK/WHITE
17236 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BLACK/GRAY
17257 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY- BLACK/WHITE
19657 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY - BLACK/GRAY
19740 Zephyren LETHER BELT-CRAFT LOGO - WHITE
19741 Zephyren LETHER BELT-CRAFT LOGO - BLACK
22745 Zephyren (ゼファレン) BUCKET HAT -SKULL HEAD- WHITE
27295 Zephyren (ゼファレン) HOUNDSTOOTH BEANIE BLACK
27323 Zephyren (ゼファレン) WAIST BAG -VISIONARY- BLACK
27325 Zephyren (ゼファレン) WAIST BAG -VISIONARY- GREEN
27326 Zephyren (ゼファレン) WAIST BAG -VISIONARY- NAVY
31690 Zephyren LETHER BELT-CRAFT LOGO - BLACK×WHITE
33385 Zephyren (ゼファレン) METAL NECKLACE -HAWK- ANTIQUE GOLD
35962 Zephyren (ゼファレン) PAISLEY LETHER BELT WHITE
35963 Zephyren (ゼファレン) PAISLEY LETHER BELT BLACK
35994 Zephyren (ゼファレン) FLAP BACKPACK BLACK
35995 Zephyren (ゼファレン) FLAP BACKPACK NAVY
38450 Zephyren (ゼファレン) LONG STRAP LO CAP -ENGRAVE- WHITE
38451 Zephyren (ゼファレン) LONG STRAP LO CAP -ENGRAVE- BLACK
38489 Zephyren METAL NECKLACE -HAWK- BLACKxBLACK
38492 Zephyren METAL NECKLACE -HAWK- ANTIQUE GOLDxBLACK
40217 Zephyren LONG STRAP LO CAP -ENGRAVE - SKY
40249 Zephyren METAL NECKLACE -HAWK- ANTIQUE SILVERxBLACK
57610 【予約商品】Zephyren(ゼファレン) B.B CAP -BEYOND- BLACK / WHITE
57616 【予約商品】Zephyren(ゼファレン) B.B CAP -BEYOND- BLACK / GRAY
35923 Zephyren (ゼファレン) BIRD MOUNTAIN HAT BLACK
30783 Zephyren(ゼファレン) PAISLEY G.I BELT WHITE
35920 Zephyren (ゼファレン) FELT HAT BLACK
45600 Zephyren(ゼファレン)LO CAP - PROVE - WHITE
45602 Zephyren(ゼファレン)LO CAP - PROVE - BLACK
50215 Zephyren(ゼファレン) BUCKET HAT - PROVE - BLACK
50216 Zephyren(ゼファレン) BUCKET HAT - PROVE - WHITE
52479 【バンドリ!×ゲキクロ 第4弾復刻】ZEPHYREN×氷川 日菜コラボ 限定 ビーニー
57623 【予約商品】Zephyren(ゼファレン) LO CAP -PROVE- BLACK
57628 【予約商品】Zephyren(ゼファレン) BUCKET HAT -PROVE- WHITE
57629 Zephyren(ゼファレン) BUCKET HAT -PROVE- BLACK
62386 Zephyren(ゼファレン) MESH CAP -Victoria- BLACK / RED
54490 【バンドリ!×ゲキクロ第1弾復刻】ZEPHYREN×湊友希那コラボ 限定 キャップ
19730 ZEPHYREN (ゼファレン) WALLET CHAIN -SKULL HEAD - BLACK
19732 ZEPHYREN (ゼファレン) WALLET CHAIN -SKULL HEAD - SILVER
19733 ZEPHYREN (ゼファレン) WALLET CHAIN -SKULL HEAD - ANTIQUE GOLD
19734 ZEPHYREN (ゼファレン) WALLET CHAIN -SKULL HEAD - ANTIQUE SILVER
35910 Zephyren (ゼファレン) STAR STUDS BERET BLACK
35911 Zephyren (ゼファレン) STAR STUDS BERET GRAY
55778 【バンドリ!×ゲキクロ 第2弾復刻】ZEPHYREN×湊友希那コラボ 限定 キャップ
59717 Zephyren(ゼファレン) LONG BEANIE -You Are Here WHITE
59723 Zephyren(ゼファレン) LONG BEANIE -You Are Here PURPLE
59724 Zephyren(ゼファレン) LONG BEANIE -You Are Here ORANGE
19692 ZEPHYREN (ゼファレン) FELT HAT - BLACK
22754 Zephyren (ゼファレン) METAL NECKLACE -STUDS CROSS- ANTIQUE SILVER
24932 Zephyren (ゼファレン) WIDE BRIM PANAMA HAT BLACK
24933 Zephyren (ゼファレン) WIDE BRIM PANAMA HAT BEIGE
24934 Zephyren (ゼファレン) WIDE BRIM PANAMA HAT MIX
27290 Zephyren (ゼファレン) WIDE BRIM FELT HAT BLACK
30774 Zephyren(ゼファレン) WALLET CHAIN -ENGRAVE- BLACK
31463 Zephyren(ゼファレン) WALLET CHAIN -ENGRAVE- ANTIQUEGOLD
31464 Zephyren(ゼファレン) WALLET CHAIN -ENGRAVE- ANTIQUESILVER
35914 Zephyren (ゼファレン) WOOL B.B CAP -LATITUDE LONGTITUDE- BLACK
35918 Zephyren (ゼファレン) BOA BUCKET HAT BLACK
35919 Zephyren (ゼファレン) BOA BUCKET HAT LEOPARD
35970 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- BLACK
35971 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- NAVY
36033 Zephyren (ゼファレン) ASH TRAY -ENGRAVE- WHITE
27262 Zephyren (ゼファレン) SIDE ZIP SKIRT -You Are Here- PAISLEY
27263 Zephyren (ゼファレン) SIDE ZIP SKIRT -You Are Here- BLACK CHECK
26259 Zephyren (ゼファレン) OVERWRAP B.B. CAP -BEYOND- BLACK
26261 Zephyren (ゼファレン) OVERWRAP B.B. CAP -BEYOND- BLACKxORANGE
27279 Zephyren (ゼファレン) B.B CAP -LATITUDE LONGITUDE- WHITE
27280 Zephyren (ゼファレン) B.B CAP -LATITUDE LONGITUDE- BLACK
27284 Zephyren (ゼファレン) B.B CAP -LATITUDE LONGITUDE- BLACK-GRAY
27285 Zephyren (ゼファレン) B.B CAP -LATITUDE LONGITUDE- BLACK SNAKE
27286 Zephyren (ゼファレン) B.B CAP -LATITUDE LONGITUDE- WHITE SNAKE
30723 Zephyren(ゼファレン) CHOSEN MATERIAL TWILL CAP -GRAVE- BLACKPAISLEY
30724 Zephyren(ゼファレン) CHOSEN MATERIAL TWILL CAP -GRAVE- WHITECAMO
33265 Zephyren (ゼファレン) ALL MESH B.B CAP -Flow- BLACK
33380 Zephyren (ゼファレン) PANAMA HAT BLACK
33382 Zephyren (ゼファレン) WIDEBRIM PANAMA HAT WHITE
33383 Zephyren (ゼファレン) WIDEBRIM PANAMA HAT BLACK
35973 Zephyren (ゼファレン) SUNGLASS-GENIOT- CLEAR
35977 Zephyren (ゼファレン) SUNGLASS-BRIGHTARK- BLACKxCLEAR
35980 Zephyren (ゼファレン) SUNGLASS-BRIGHTARK- BROWNxCLEAR
40307 Zephyren SUNGLASS -GENIOT BLUE
15247 ZEPHYREN (ゼファレン) SNAPBACK CAP -BEYOND- BLK/BLK
15250 ZEPHYREN (ゼファレン) SNAPBACK CAP -Thorns fame- BLK
17232 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BLACK/BURGUNDY
17233 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BURGUNDY
17235 Zephyren B.B.CAP -BEYOND- - CHARCOAL
17237 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- CHARCOAL/BLACK
17247 ZEPHYREN (ゼファレン) B.B.CAP -Thorns fame- NAVY
17248 ZEPHYREN (ゼファレン) B.B.CAP -Thorns fame- - CHARCOAL
17251 ZEPHYREN (ゼファレン) B.B.CAP -Thorns fame- NAVY/RED
17258 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY- BLACK/BURGUND
17263 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY- CHARCOAL/BLACK
17264 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY- - NAVY/RED
17275 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- - WHITE
17276 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- BLACK
17277 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- NAVY
17278 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- BURGUNDY
17279 ZEPHYREN (ゼファレン) BUCKET HAT -VISIONARY- CAMO I
19654 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY - BURGUNDY
19655 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY - NAVY
19686 ZEPHYREN (ゼファレン) BEANIE -VISIONARY - BLACK
19687 ZEPHYREN (ゼファレン) BEANIE -VISIONARY - GRAY
19689 ZEPHYREN (ゼファレン) BEANIE -VISIONARY - DARK.GREEN
19690 ZEPHYREN (ゼファレン) BEANIE -VISIONARY - NAVY
19695 ZEPHYREN (ゼファレン) BON BON KNIT - BLACK