Query Error: Out of resources when opening file '/var/temp/#sql_49a8_3.MAD' (Errcode: 24)
SQL: SELECT so.image AS '@image', so.search_image AS '@search_image', so.is_active AS '@is_active', so.is_featured, so.show_booking AS '@show_booking', so.show_title_mobile AS '@show_title_mobile', soc.title AS '#title', soc.code AS '#perma_link', so.minimum_stay, so.start_date, so.end_date, so.book_by_date, so.promo_code AS '@promo', so.rate_code AS '@rate_code', soc.short_description AS '#short_description', so.device AS '#device', br.code AS 'brand_code', pr.code AS 'property_code' FROM special_offer_published so INNER JOIN special_offer_to_property so2p ON so.id = so2p.special_offer_id INNER JOIN property pr ON pr.id = so2p.property_id AND pr.is_deleted = 0 AND pr.is_active = 1 INNER JOIN country co ON co.id = pr.country_id AND co.is_deleted = 0 AND co.is_active = 1 INNER JOIN region rg ON rg.id = co.region_id AND rg.is_deleted = 0 AND rg.is_active = 1 INNER JOIN property_to_brand pr2br ON pr2br.property_id = pr.id INNER JOIN brand_published br ON br.id = pr2br.brand_id AND br.is_deleted = 0 AND br.is_active = 1 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' WHERE so.is_deleted = 0 AND so.is_active = 1 AND so.is_hidden = 0 AND so.is_published = 1 AND so.is_featured = 1 AND so.book_by_date > NOW() AND (so.device = 'Desktop/Tablet' OR so.device = 'All' OR so.device = '' OR so.device IS NULL) AND br.code = 'vibe-hotels' GROUP BY so.id ORDER BY br.priority, so.book_by_date ASCAn error has been encountered while accessing the database. Please try again later.