Error writing file '/var/tmp/MYTAQjpW' (Errcode: 28 - No space left on device)<br>SELECT h.*,
                       hc.stars_count,
                       r.friendly_url as region_friendly_url
                FROM hotels h
                LEFT JOIN regions r ON r.id = h.region_id
                LEFT JOIN states s ON s.id = r.state_id
                LEFT JOIN hotel_category hc ON hc.id = h.hotel_category_id
                WHERE s.status = 1
                AND r.status = 1
                AND h.status = 1
                AND h.state_id = 12
                GROUP BY h.id
                ORDER BY h.name