SQL Error SELECT "sights" as type, a.slug_name as id,a.name as name,"" as text,a.homepage_photo,
(select file_name from photos as p where p.id=a.main_photo) as image,
(select group_concat( distinct concat_ws("",px.file_name,"::") SEPARATOR "~~~") from photos as px where px.offering_id=a.id) as image1,
group_concat(distinct concat_ws("::",t.id,t.tag_name) SEPARATOR "~~~" ) as dropDown
from sightsattractions as a
join businessprofiles_productsactivities as b on b.sa_id=a.id
join businessprofiles_products as g on b.product_id=g.id and g.content_permissioning="All"
join businessprofiles as h on g.profile_id=h.id and h.content_permissioning="All"
join tags as t on b.activity_id=t.id
where a.country_id=\"36\" and a.content_permissioning="All"
group by a.id
order by count(g.bookable) desc
limit 15
: 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 '\"36\" and a.content_permissioning="All"
group by' at line 10 --> Czech Republic | Tours & Activities - Project Expedition
The Czech Republic is a landlocked country with a rich landscape filled with rolling hills, rivers and lush countryside. The capital c...see moresee less