select * from tour_full where site_id = 28 and (flag&1)>0 and class = 3 and type=39 order by length(COALESCE(alt_details,''))* length(COALESCE(photo,'') ) desc,type=7 asc, length(COALESCE(alt_details,'')) desc Lodges in Newfoundland

Places to stay in Newfoundland - Lodges

Web-Max 2016