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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =571
)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-04-28 07:20:26')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 60
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
66989 glamb (グラム)GB0223/SH06 : Stand Collar Check SH / スタンドカラーチェックシャツ - Blue
66990 glamb (グラム)GB0223/SH06 : Stand Collar Check SH / スタンドカラーチェックシャツ - Yellow
66991 glamb (グラム)GB0223/SH06 : Stand Collar Check SH / スタンドカラーチェックシャツ - Red
70858 【予約商品】glamb (グラム)Patchwork Scarf Shirt / パッチワークスカーフシャツ - White
33772 ANIMALIA AN17U-SH05 SWAGGER-Slashed 17SU WASH INDIGO
51603 MUSIC SAVED MY LIFE CROSSES OPEN COLLAR SHORT SLEEVE SHIRT BLACK
51604 【予約商品】MUSIC SAVED MY LIFE CROSSES OPEN COLLAR SHORT SLEEVE SHIRT WHITE
70921 glamb (グラム) LA Photo Shirt Black
45379 Subciety 2019 福袋 -NEW YEAR BAG-
50321 Subciety 2020 福袋 -NEW YEAR BAG-
56066 Subciety 2021 福袋 -NEW YEAR BAG-
70023 glamb (グラム) Leopard Bowling Shirts / レオパードボウリングシャツ Black
70024 glamb (グラム) Leopard Bowling Shirts / レオパードボウリングシャツ Yellow
70025 glamb (グラム) Leopard Bowling Shirts / レオパードボウリングシャツ Pink
70925 glamb (グラム) Eaten Apple Shirt Black
70926 glamb (グラム) Eaten Apple Shirt Blue
40914 ROLLING CRADLE RC-S1497 MAJESTIC BASEBALL SHIRT Black
39135 Subciety 2018 福袋 -NEW YEAR BAG-
67959 ANIMALIA (アニマリア) SWAGGER S/S SHIRTS - SKUNK BLACK
49474 CRIMIE CR01-01K3-SH71 PLAYBOY SHIRT WHITE
51605 MUSIC SAVED MY LIFE M101-02L1-SS02 CRAZY PATTERN SHIRT BLACK
51657 MUSIC SAVED MY LIFE M201-02L1-SS01 OPEN COLLAR SHORT SLEEVE SHIRT GREIGE
51658 MUSIC SAVED MY LIFE M201-02L1-SS01 OPEN COLLAR SHORT SLEEVE SHIRT BLACK
51660 MUSIC SAVED MY LIFE M201-02L1-SS02 MILITARY GRUNGE SHIRT KHAKI
63821 Subciety(サブサエティ) MILITARY OVER SHIRT WHITE
69063 Dogmatic Gourmet x over print x RIP DESIGN WORXX キューバシャツセットアップ
71388 NineMicrophones (ナインマイクロフォンズ) CUBA SHIRT BLACK
71389 NineMicrophones (ナインマイクロフォンズ) CUBA SHIRT ORANGE
35029 ROLLING CRADLE KUNG FU CAT SHIRT / White
35030 ROLLING CRADLE KUNG FU CAT SHIRT / Red
47718 ROLLING CRADLE RCx東京幻想 CHAMPLOO SHIRT -KAMINARIMON GENSO- / Gray
47719 ROLLING CRADLE RCx東京幻想 CHAMPLOO SHIRT -KAMINARIMON GENSO- / Red
33888 ANIMALIA AN17U-SH01 LIBERTINE Shirts 17SU BLACK
61380 SLEEPING TABLET X [ WIDE SHORT SLEEVE SHIRTS ] BLACK
61381 SLEEPING TABLET X [ WIDE SHORT SLEEVE SHIRTS ] GRAY
61382 SLEEPING TABLET X [ WIDE SHORT SLEEVE SHIRTS ] PINK
63884 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / YELLOW
46876 Subciety DROP SHOULDER SHIRT IVORY
46877 Subciety DROP SHOULDER SHIRT BLUE
63812 Subciety(サブサエティ) PAISLEY COACH SHIRT BLACK
63813 Subciety(サブサエティ) PAISLEY COACH SHIRT BLUE
49275 CRIMIE CR01-01K3-SH76 PLAYBOY CHECK SHIRT BLUE
49276 CRIMIE CR01-01K3-SH76 PLAYBOY CHECK SHIRT RED
53959 KONUS Color Blocked Cotton Twill Oversized Shirt BLACK
54611 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG BLACK
54612 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG WHITE
68460 VIRGOwearworks (ヴァルゴウェアワークス) Vintage mily hawaii shirt BLACK
54434 ANIMALIA AN20U-SH04 BIG DOLMAN SHIRTS BLACK
54435 ANIMALIA AN20U-SH04 BIG DOLMAN SHIRTS OLIVE
59246 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLACK
59226 ROLLING CRADLE TV STATIC SHIRT BLACK
20684 Subciety WORK SHIRT S/S-ROCK SMITH- BLACK
20980 NineMicrophones (ナイン・マイクロフォンズ) BOWLING SHIRT S/S-MORTOR HEAD- MUSTARD
34531 MUSIC SAVED MY LIFE (MSML) GRUNGE SHIRT BLACK
34532 MUSIC SAVED MY LIFE (MSML) GRUNGE SHIRT BLUE
34533 MUSIC SAVED MY LIFE (MSML) GRUNGE SHIRT RED