Error!

MySQL Error: Sort aborted: Query execution was interrupted
SQL Statement: SELECT contents.id,contents.title,contents.content_type_id,contents.primary_image,contents.author_name,contents.slug,contents.summary,contents.primary_issue_slug,contents.publish_date FROM contents WHERE contents.published=1 and DATE(publish_date) <= '2015-09-03' and ( contents.magazine_id = '9') and ( contents.id != '109508') and ( contents.content_type_id = '2486') and id in (select content_id from content_taxonomy join taxonomy on taxonomy.id=content_taxonomy.taxonomy_id where ( content_taxonomy.taxonomy_id=23254 or content_taxonomy.taxonomy_id=23253 or content_taxonomy.taxonomy_id=23326 or content_taxonomy.taxonomy_id=23311 or content_taxonomy.taxonomy_id=23233 or content_taxonomy.taxonomy_id=23301 or content_taxonomy.taxonomy_id=23312 or content_taxonomy.taxonomy_id=23256 or content_taxonomy.taxonomy_id=23270 or content_taxonomy.taxonomy_id=23271 or content_taxonomy.taxonomy_id=23274 or content_taxonomy.taxonomy_id=23260 or content_taxonomy.taxonomy_id=23500 or content_taxonomy.taxonomy_id=23501 or content_taxonomy.taxonomy_id=23503 or content_taxonomy.taxonomy_id=23490 or content_taxonomy.taxonomy_id=23515 or content_taxonomy.taxonomy_id=23458 or content_taxonomy.taxonomy_id=23465 or content_taxonomy.taxonomy_id=23468 or content_taxonomy.taxonomy_id=23471 or content_taxonomy.taxonomy_id=23588 or content_taxonomy.taxonomy_id=23590 or content_taxonomy.taxonomy_id=23591 or content_taxonomy.taxonomy_id=23593 or content_taxonomy.taxonomy_id=23578 or content_taxonomy.taxonomy_id=23579 or content_taxonomy.taxonomy_id=23580 or content_taxonomy.taxonomy_id=23557 or content_taxonomy.taxonomy_id=23598 or content_taxonomy.taxonomy_id=23600 or content_taxonomy.taxonomy_id=23548 or content_taxonomy.taxonomy_id=23549 or content_taxonomy.taxonomy_id=23531 or content_taxonomy.taxonomy_id=23563 or content_taxonomy.taxonomy_id=23567 or content_taxonomy.taxonomy_id=23571 or content_taxonomy.taxonomy_id=23564 ) and taxonomy.ignore_flag=0) group by contents.id ORDER BY contents.publish_date desc LIMIT 13