An Error Was Encountered

Error Number: 1317

Query execution was interrupted

SELECT c.housing_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'housing' AS mtable FROM housing c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.jobs_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'jobs' AS mtable FROM jobs c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.disscussiongroups_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'disscussiongroups' AS mtable FROM disscussiongroups c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.dating_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'dating' AS mtable FROM dating c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.entertainment_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'entertainment' AS mtable FROM entertainment c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.cars_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'cars' AS mtable FROM cars c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.services_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'services' AS mtable FROM services c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.pets_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'pets' AS mtable FROM pets c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.travel_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'travel' AS mtable FROM travel c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.buysell_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'buysell' AS mtable FROM buysell c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.travel_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'travel' AS mtable FROM travel c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.school_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'school' AS mtable FROM school c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.community_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'community' AS mtable FROM community c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.announcement_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'announcement' AS mtable FROM announcement c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.business_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'business' AS mtable FROM business c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' UNION SELECT c.freeitems_id AS listing_id,c.ad_title,c.date_created ,c.ad_description ,c.maincategory_id maincatid,c.subcategory_id catid,c.active,c.city,cc.city_name,'freeitems' AS mtable FROM freeitems c,thumbnail th,city cc WHERE cc.city_id=c.city AND c.wanted='1' ORDER By date_created DESC