Failed to connect to MySQL: (2002) Connection refusedSELECT *, uf.id_prop AS star, STR_TO_DATE(date, '%M %d %Y') as latest,
IF(COUNT( DISTINCT rent ) > 1,CONCAT('$', MIN(rent), ' - $', MAX(rent)),CONCAT('$', rent)) as rent,
IF(COUNT( DISTINCT beds ) > 1,CONCAT(MIN(beds), ' - ', MAX(beds)),beds) as beds
FROM properties AS p
INNER JOIN prop_units AS u ON u.id_prop = p.id_pg
LEFT JOIN prop_photos c ON p.id_pg = c.id_prop AND c.p_order = 1
INNER JOIN user_fav uf ON p.id_pg = uf.id_prop AND uf.id_session = '693a0646ccc3e6.38529320'
GROUP BY p.id_pgSELECT us.url AS savedsearch
FROM user_search us
WHERE us.id_session = '693a0646ccc3e6.38529320' AND deleted=0(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)
Faves
