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 = '60387da68eb868.68837438'
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