Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Paginator has a deprecated constructor in /var/www/html/mybestapartments/_inc/paginator.class.php on line 3
SELECT p.*, u.*, ( 6371 * acos( cos( radians(43.8970929) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-78.8657912) ) + sin( radians(43.8970929) ) * sin( radians( lat ) ) ) ) AS distance FROM (properties p) INNER JOIN prop_units u ON (p.id_pg = u.id_prop ) WHERE p.pub=1 AND p.deleted=0 GROUP BY p.id_pg HAVING distance < 30
Notice: Invalid query: Expression #27 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cj3wilso_rent254.u.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/mybestapartments/_inc/memcache.php on line 47

Notice: Trying to get property 'num_rows' of non-object in /var/www/html/mybestapartments/_inc/memcache.php on line 49

Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/mybestapartments/list.php on line 67
SELECT p.*, c.photo, STR_TO_DATE(date, '%M %d %Y') as latest, IF(COUNT( DISTINCT u.rent ) > 1,CONCAT('$', MIN(u.rent), ' - $', MAX(u.rent)),CONCAT('$', u.rent)) AS rent, IF(COUNT( DISTINCT u.beds ) > 1,CONCAT(MIN(u.beds), ' - ', MAX(u.beds)),u.beds) AS beds, ( 6371 * acos( cos( radians(43.8970929) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-78.8657912) ) + sin( radians(43.8970929) ) * sin( radians( lat ) ) ) ) AS distance FROM properties p INNER JOIN ( SELECT MAX(rent) AS maxrent FROM prop_units ) AS umax INNER JOIN prop_units u ON (p.id_pg = u.id_prop ) LEFT JOIN prop_photos c ON p.id_pg = c.id_prop AND c.p_order = 1 WHERE p.pub=1 AND p.deleted=0 GROUP BY p.id_pg HAVING distance < 30 ORDER BY (CASE WHEN p.city = 'Oshawa' THEN 1 ELSE 0 END ) DESC, created DESC LIMIT -15,15
Notice: Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-15,15' at line 14 in /var/www/html/mybestapartments/_inc/memcache.php on line 47

Notice: Trying to get property 'num_rows' of non-object in /var/www/html/mybestapartments/_inc/memcache.php on line 49

Warning: Invalid argument supplied for foreach() in /var/www/html/mybestapartments/list.php on line 105

Notice: Undefined variable: id_props in /var/www/html/mybestapartments/list.php on line 116
SELECT uf.id_prop AS star FROM properties p INNER JOIN user_fav uf ON p.id_pg = uf.id_prop AND uf.id_session = '5fbbee69c2b8d3.53705028' WHERE p.id_pg IN ()
Notice: Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4 in /var/www/html/mybestapartments/list.php on line 120

Notice: Trying to get property 'num_rows' of non-object in /var/www/html/mybestapartments/list.php on line 122

Fatal error: Uncaught Error: Call to a member function fetch_array() on bool in /var/www/html/mybestapartments/list.php:124 Stack trace: #0 /var/www/html/mybestapartments/rent.php(16): include() #1 {main} thrown in /var/www/html/mybestapartments/list.php on line 124