MySQL Error: Query execution was interrupted
SQL Statement: SELECT taxonomy.*, count(DISTINCT as count FROM contents JOIN content_taxonomy on content_taxonomy.content_id = JOIN content_locations on JOIN locations on JOIN taxonomy on JOIN asset_packages on asset_packages.resource_id = WHERE contents.content_type_id = 2543 AND taxonomy.child_of = '11668' and contents.publish_date <= '2019-11-21 10:00:00' and contents.published=1 and contents.magazine_id=7 and asset_packages.published = 1 and asset_packages.resource = contents.resource_id and asset_packages.expire_at>= '2019-11-21 10:00:00' and'CH' group by content_taxonomy.taxonomy_id ORDER BY taxonomy.ignore_flag,taxonomy.tag asc