SQL ERROR: Incorrect key file for table '/tmp/#sql_5e53_0.MYI'; try to repair it
SQL: SELECT DISTINCT listings.*, c.name AS catname, c.slug AS catslug, IF(listings.status=1,1,IF(listings.status=3,1,2)) AS ordering, IFNULL(img.url,'') AS img, IFNULL(img.zid,'') AS imgzid FROM listings INNER JOIN categories c ON c.id=listings.categoryid AND c.slug='world' LEFT JOIN images img ON img.listing_id=listings.id WHERE (status='1' OR status='6' OR (status='3' AND activate_date>unix_timestamp()-31*86400) OR userid='') GROUP BY listings.id ORDER BY ordering ASC, create_date DESC LIMIT 10 OFFSET 0