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<br />
<b>Notice</b>:  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 <b>/var/www/html/mybestapartments/_inc/memcache.php</b> on line <b>47</b><br />
<br />
<b>Notice</b>:  Trying to get property 'num_rows' of non-object in <b>/var/www/html/mybestapartments/_inc/memcache.php</b> on line <b>49</b><br />
<br />
<b>Warning</b>:  count(): Parameter must be an array or an object that implements Countable in <b>/var/www/html/mybestapartments/list.php</b> on line <b>67</b><br />
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<br />
<b>Notice</b>:  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 <b>/var/www/html/mybestapartments/_inc/memcache.php</b> on line <b>47</b><br />
<br />
<b>Notice</b>:  Trying to get property 'num_rows' of non-object in <b>/var/www/html/mybestapartments/_inc/memcache.php</b> on line <b>49</b><br />
<br />
<b>Warning</b>:  Invalid argument supplied for foreach() in <b>/var/www/html/mybestapartments/list.php</b> on line <b>105</b><br />
<br />
<b>Notice</b>:  Undefined variable: id_props in <b>/var/www/html/mybestapartments/list.php</b> on line <b>116</b><br />
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 = '6010f3b29a8f15.22419349'
			WHERE p.id_pg IN ()<br />
<b>Notice</b>:  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 <b>/var/www/html/mybestapartments/list.php</b> on line <b>120</b><br />
<br />
<b>Notice</b>:  Trying to get property 'num_rows' of non-object in <b>/var/www/html/mybestapartments/list.php</b> on line <b>122</b><br />
<br />
<b>Fatal error</b>:  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 <b>/var/www/html/mybestapartments/list.php</b> on line <b>124</b><br />