select * from tour_full where site_id = 115 and (flag&1)>0 and class = 3 and type=32 order by length(COALESCE(alt_details,''))* length(COALESCE(photo,'') ) desc,type=7 asc, length(COALESCE(alt_details,'')) desc Hotels in British Columbia

Places to stay in British Columbia - Hotels

Web-Max 2016