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 =1
)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-05-23 18:36:15')
AND pc.point_rate >1
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 60
61416 VIRGO KITE ZIPPER CUTSHIRTS WHITE
61417 VIRGO KITE ZIPPER CUTSHIRTS KHAKI
61418 VIRGO KITE ZIPPER CUTSHIRTS BLACK
61867 glamb (グラム) Military Remake CS - White×Khaki
63377 Anti Social Social Club Passing Fad Mint Tee
63379 Anti Social Social Club Self Conclusion Sand Tee
63381 Anti Social Social Club The Notebook Orange Tee
63383 Anti Social Social Club Out Of Time Blue Tee
56213 Anti Social Social Club Headrush All Over White Tee
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
63347 ROLLING CRADLE (ローリングクレイドル) HI-NECK SWEAT TEE / NAVY
63348 ROLLING CRADLE (ローリングクレイドル) HI-NECK SWEAT TEE / OLIVE
63816 ROLLING CRADLE (ローリングクレイドル) VVV TEE / BLUE
63817 ROLLING CRADLE (ローリングクレイドル) VVV TEE / RED
60165 Anti Social Social Club THE REAL ME WHITE TEE
56210 Anti Social Social Club Enrique White Vneck Tee
59280 ROLLING CRADLE BORDER TURTLE NECK / GREEN
64937 A FEW GOOD KIDS (アフューグッドキッズ) STARRY SKY LOGO TEE WHITE
64938 A FEW GOOD KIDS (アフューグッドキッズ) STARRY SKY LOGO TEE BLACK
64939 A FEW GOOD KIDS (アフューグッドキッズ) POPULAR CARTOON TEE WHITE
64940 A FEW GOOD KIDS (アフューグッドキッズ) POPULAR CARTOON TEE BLACK
64943 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE WHITE
64944 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE BLACK
64945 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE BEIGE
64946 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE ORANGE
59955 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE WHITE
64061 Subciety (サブサエティ) HALF SLEEVE SWEAT KHAKI
59844 HYPER CORE T-367 承認欲求がぁる2 -I need your Reply, Retweet & いいね- Tシャツ ブルー×パープル
61853 A FEW GOOD KIDS ICECREAM TEE WHITE
61854 A FEW GOOD KIDS ICECREAM TEE BLACK
61855 A FEW GOOD KIDS ICECREAM TEE BLUE
64863 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE WHITE
64864 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE LIGHT BLUE
64865 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE GRAY
64875 HYPER CORE(ハイパーコア) DISTORTION -The multiverse of HYPERCORE- ジップTシャツ BLACK
64876 HYPER CORE(ハイパーコア) DISTORTION -The multiverse of HYPERCORE- ジップTシャツ PURPLE
64877 HYPER CORE(ハイパーコア) MELON PAIN ジップTシャツ
65009 SUPPLIER (サプライヤー) IRON LOGO RAGLAN TEE/GREEN
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
54674 FILA FFM9802 ユニセックス クルーネックシャツ RED
54675 FILA FFM9802 ユニセックス クルーネックシャツ NAVY
47105 NOT COMMON SENSE GENESIS SEAM TEE WHITE
64962 ROLLING CRADLE RC x KUDAN LOGO TEE / BLACK
64963 ROLLING CRADLE RC x KUDAN LOGO TEE / WHITE
56038 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE WHITE
64895 acOlaSia (アコレイジア) GAMING ERROR tee WHITE
64898 acOlaSia (アコレイジア) GAMING ERROR tee BLACK
58163 NOT COMMON SENSE HARD CORE TEE BLACK
58164 NOT COMMON SENSE DEAD TUDE TEE BLACK
58165 NOT COMMON SENSE DEAD TUDE TEE WHITE
59233 LONELY論理 LONELY UNIV TEE white
59235 LONELY論理 LONELY UNIV TEE black
59405 SUPPLIER (サプライヤー) SPIDER WEB TEE
60030 SUPPLIER (サプライヤー) ANGEL TEE PINK
60047 SAMURAI CORE リンガーTEE RED
60048 SAMURAI CORE リンガーTEE BLUE
60049 SAMURAI CORE リンガーTEE BLACK
61436 glamb (グラム)×攻殻機動隊 SAC_2045 T White
61437 glamb (グラム)×攻殻機動隊 SAC_2045 T Black
53149 SAMURAI CORE 釈迦 TEE WHITE