SELECT v.id, v.slogan, v.ilce_id, v.semt_id, v.baslik, 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(MIN(toplam_fiyat_try)) as total_fiyat FROM villa_sezon_grup_list WHERE villa_sezon_grup_list.tarih >= '2025-01-01' GROUP BY villa_sezon_grup_list.villa_id ) as tf ON v.id = tf.villa_id WHERE v.belge_no != '' AND v.konut_tipi = 'villa' AND v.valid = '1' AND (v.view_valid = '1' OR v.belge_no != '') AND total_fiyat > 0 ORDER BY v.puan DESC, v.ordernum ASC