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 'ADORE' and'' ) and IN (select' at line 1
SQL Statement: SELECT count(*) as total_records FROM contents WHERE IN(SELECT FROM bgcompanies,locations WHERE AND locations.state='LVMH_ADOREJ'ADORE' and'' ) and IN (select content_taxonomy.content_id from content_taxonomy where taxonomy_id=61692) and contents.publish_date <= '2016-05-24 22:17:38' and contents.published=1 and contents.magazine_id=8