Failed to connect to MySQL: (2002) Connection refusedSELECT DISTINCT p.prov
FROM properties p
WHERE p.removed = '0000-00-00 00:00:00' AND p.pub=1
ORDER BY p.prov(select COUNT(`city`) posts, prov, city from properties where prov = 'AB' GROUP BY city order by posts DESC limit 6)
union all
(select COUNT(`city`) posts, prov, city from properties where prov = 'BC' GROUP BY city order by posts DESC limit 6)
union all
(select COUNT(`city`) posts, prov, city from properties where prov = 'MB' GROUP BY city order by posts DESC limit 6)
union all
(select COUNT(`city`) posts, prov, city from properties where prov = 'NB' GROUP BY city order by posts DESC limit 6)
union all
(select COUNT(`city`) posts, prov, city from properties where prov = 'NL' GROUP BY city order by posts DESC limit 6)
union all
(select COUNT(`city`) posts, prov, city from properties where prov = 'NS' GROUP BY city order by posts DESC limit 6)
union all
(select COUNT(`city`) posts, prov, city from properties where prov = 'ON' GROUP BY city order by posts DESC limit 22)
union all
(select COUNT(`city`) posts, prov, city from properties where prov = 'PE' GROUP BY city order by posts DESC limit 6)
union all
(select COUNT(`city`) posts, prov, city from properties where prov = 'QC' GROUP BY city order by posts DESC limit 6)
union all
(select COUNT(`city`) posts, prov, city from properties where prov = 'SK' GROUP BY city order by posts DESC limit 6)
Rentals in Canada
