Query Error: Out of resources when opening file '/var/temp/#sql_49a8_3.MAI' (Errcode: 24)
SQL: SELECT so.image AS '@image', so.search_image AS '@search_image', so.is_active AS '@is_active', so.is_featured, so.device, so.show_booking AS '@show_booking', soc.title AS '#title', soc.code AS 'code', soc.code AS '#perma_link', so.minimum_stay, so.start_date, so.end_date, so.book_by_date, so.monday, so.tuesday, so.wednesday, so.thursday, so.friday, so.saturday, so.sunday, so.promo_code AS '@promo', so.rate_code AS '@rate_code', so.published_on, soc.short_description AS '#short_description', '' AS '#booking_link', '' AS '#mobile_booking_link', soc.terms_and_conditions AS '#terms_conditions', soc.no_booking_message AS '#no_booking_message', p.booking_engine_id, p.booking_engine_identifier AS '#booking_engine_identifier', p.booking_engine_params AS '#booking_engine_params', la.name AS 'language', la.iso_code_2 AS 'language_code', COUNT(p.id) AS participating_hotels, GROUP_CONCAT(DISTINCT(b.name) SEPARATOR ', ') AS brands, ROUND(MIN(so2p.rate)) AS 'rates_from', IF (ROUND(MIN(so2p.rate)) > 0, 1, 0) AS 'has_rates' FROM special_offer_published so INNER JOIN special_offer_to_property so2p ON so.id = so2p.special_offer_id INNER JOIN special_offer_content_published soc ON so.id = soc.special_offer_id AND soc.is_deleted = 0 INNER JOIN language la ON la.id = soc.language_id AND la.iso_code_2 = 'en' INNER JOIN property p ON p.id = so2p.property_id AND p.is_deleted = 0 AND p.is_active = 1 INNER JOIN city ci ON ci.id = p.city_id AND ci.is_deleted = 0 AND ci.is_active = 1 INNER JOIN country co ON co.id = p.country_id AND co.is_deleted = 0 AND co.is_active = 1 INNER JOIN region r ON r.id = co.region_id AND r.is_deleted = 0 AND r.is_active = 1 LEFT OUTER JOIN state s ON s.id = p.state_id AND s.is_deleted = 0 AND s.is_active = 1 LEFT OUTER JOIN neighborhood n ON n.id = p.neighborhood_id AND n.is_deleted = 0 AND n.is_active = 1 LEFT OUTER JOIN property_to_brand pb ON pb.property_id = p.id LEFT OUTER JOIN brand_published b ON b.id = pb.brand_id AND b.is_deleted = 0 AND b.is_active = 1 AND b.is_published = 1 WHERE so.is_deleted = 0 AND so.is_active = 1 AND so.is_hidden = 0 AND so.is_published = 1 AND so.display_start <= CURDATE() AND so.display_end >= CURDATE() AND (so.device = 'Desktop/Tablet' OR so.device = 'All' OR so.device = '' OR so.device IS NULL) AND so.is_hidden = 0 GROUP BY so.id ORDER BY so.is_featured DESC, so.end_date ASCAn error has been encountered while accessing the database. Please try again later.