SELECT ad.*,paida_ad_id,paidt_all_adfv,adf_db_name,paidt_paids_id,
paida_frequence,paida_view,paida_group_view,paids_nb_ad,
(paida_frequence-(paida_round_view/paida_group_view)*100) priority,
if(ad.ad_expiration_date < NOW(),1,0) as expired,
paida_paidt_id, paida_id, adf_primary, paida_round_view
FROM paid_ad
INNER JOIN paid_type ON paida_paidt_id = paidt_id
INNER JOIN paid_spot ON paidt_paids_id = paids_id
INNER JOIN ad ON ad_id = paida_ad_id
INNER JOIN usr ON usr_id=ad_usr_id
INNER JOIN ad_field ON paidt_adf_id = adf_id
INNER JOIN paid_page_type ON paidpt_paidt_id = paidt_id AND paidpt_page_id=3
WHERE paida_end_date = '0000-00-00 00:00:00'
ORDER BY adf_primary ASC,paidt_all_adfv ASC,priority DESC
Country House, Gore, Lakefield, Near Lachute - Real estate Sale-Country cottages on sale - Dome Pac Ontario
Countryhouse, winterized type condo (1 of 3), border Lake Solar, near Lachute. (Gore, Lakefield).Magnificent view, full equipped and nicely furnished, three bedrooms, garden, gazebo. garage. Private sale: $130.000. - (450) 566-0317 or (450) 227-7613
