SELECT v.id, v.slogan, v.ilce_id, v.semt_id, v.baslik_en, v.kapasite, v.banyo, v.oda, v.icerik2, v.thumb, v.on_odeme , IFNULL(total_fiyat, 0) as total_fiyat FROM villa v LEFT JOIN ( SELECT villa_sezon_grup_list.villa_id, ROUND( SUM( toplam_fiyat_try ) ) as total_fiyat FROM villa_sezon_grup_list WHERE villa_sezon_grup_list.tarih BETWEEN '2025-07-01' AND '2025-07-01' GROUP BY villa_sezon_grup_list.villa_id ) as tf ON v.id = tf.villa_id WHERE v.konut_tipi = 'villa' AND v.valid = '1' AND (v.view_valid = '1' OR v.belge_no != '') AND total_fiyat > 0 AND NOT EXISTS ( SELECT * FROM villa_takvim vt WHERE vt.villa_id = v.id AND vt.tarih BETWEEN '2025-07-02' AND '2025-07-01' ) ORDER BY IFNULL(total_fiyat, 0) ASC, v.puan DESC