Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 26 in /var/www/it-design.es/inc/real_estates.class.php on line 1297
Mysql Error(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 'GROUP BY a.id
ORDER BY a.area_es' at line 4)
Query:
SELECT a.id, a.area_es as col FROM area a INNER JOIN properties p ON p.area_id = a.id WHERE a.region_id = GROUP BY a.id ORDER BY a.area_es
Query:
SELECT a.id, a.area_es as col FROM area a INNER JOIN properties p ON p.area_id = a.id WHERE a.region_id = GROUP BY a.id ORDER BY a.area_es