Disk full (/tmp/#sql_f9c_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT p.*, a.id AS agentid, a.name AS agent, a.user AS user, t.name AS type_name, p.type AS typeid, i.standard, i.thumb, i.title, c.name as user_state, d.title as ads_type_title, d.alias as adsfees_alias, u.user_website as website FROM (dos_hp_properties AS p) LEFT JOIN dos_hp_agents AS a ON p.agent = a.id LEFT JOIN dos_sresuad as u on a.user=u.id LEFT JOIN dos_hp_prop_types AS t ON p.type = t.id LEFT JOIN dos_hp_featured as f ON f.property = p.id LEFT JOIN dos_hp_photos as i on i.property=p.id LEFT JOIN dos_hp_prop_city as c on c.id=u.user_state LEFT JOIN dos_adsfees as d on d.alias=p.ads_type WHERE ((i.ordering=1) or (i.ordering is null)) and p.published='1' AND p.approved='1' AND t.published='1' AND type='27' group by p.id ORDER BY p.featured DESC, p.priority ASC, p.modified DESC, p.id DESC LIMIT 0, 25