ACCOMMODATION BY TYPE:
TOWNS
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 'and v.active = 1 and a.fname is not null and a.fname != "" group by v.area_code ' at line 1
select v.area_code, count(v.area_code) as cnt, a.code as lcode, a.fname as fname, c.fname as country from va_venue v left join va_area a on (a.code=v.area_code) left join va_country c on (c.code=v.country_code) where v.region_code = and v.active = 1 and a.fname is not null and a.fname != "" group by v.area_code order by a.fname
Error Text:
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 'and v.active = 1 and a.fname is not null and a.fname != "" group by v.area_code ' at line 1 ....
Query Text:
select v.area_code, count(v.area_code) as cnt, a.code as lcode, a.fname as fname, c.fname as country from va_venue v left join va_area a on (a.code=v.area_code) left join va_country c on (c.code=v.country_code) where v.region_code = and v.active = 1 and a.fname is not null and a.fname != "" group by v.area_code order by a.fname
Invalid_Query_MyExecZ