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 id_static_page_group' at line 1
Dotaz: SELECT static_page_group_category.*, static_page_group_name.name FROM static_page_group_category JOIN static_page_group_name ON static_page_group_name.id_static_page_group=static_page_group_category.id_static_page_group AND static_page_group_name.id_language=1 WHERE id_category IN () GROUP BY id_static_page_group