Error!

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 'TOP_20_FASTEST_GROWING_COMPANIEFOR_SECOND_CONSECUTIVE_YEAR' and locations.countr' at line 1
SQL Statement: SELECT count(*) as total_records FROM contents WHERE contents.id IN(SELECT bgcompanies.id FROM bgcompanies,locations WHERE bgcompanies.display_address=locations.id AND locations.state='MARABU_NORTH_AMERICA_NAMED_ONE_OF_SOUTH_CAROLINA'TOP_20_FASTEST_GROWING_COMPANIEFOR_SECOND_CONSECUTIVE_YEAR' and locations.country='' ) and contents.id IN (select content_taxonomy.content_id from content_taxonomy where taxonomy_id=54840) and contents.publish_date <= '2016-05-28 15:44:02' and contents.published=1 and contents.magazine_id=10