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-05-08 15:43:30')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 1680, 120
52951 Survive Said The Prophet UNBALANCE TEE YELLOW
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
17973 UNEARTH SKATE RAGE
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
42629 KEYTALK シンプルロゴ刺繍Tシャツ バナナ
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
53930 KEYTALK 繋がるKEYTALKロゴTシャツ WHITE
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
54618 Survive Said The Prophet EMBRONDERY COMFORT TEE GREEN
62572 Survive Said The Prophet TRADITIONAL TEE
62573 Survive Said The Prophet "INFINI" TEE NATURAL
41078 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / PINK
64852 Wall Of Graphic(ウォールオブグラフィック)W.O.G 半袖Tシャツ
22508 ドラマチックアラスカ 人間ロックTシャツ ゲキクロ限定カラー
26399 【限定アイテム】モーモールルギャバン ロゴTシャツ(すしおデザイン)
37839 Xmas Eileen DIS IS LOVEタンクトップ(白)