������������ ����������������
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 (p.name LIKE '%������������ ����������������%' OR p.tags LIKE '%������������ ����������������%' OR p.full_text LIKE '%������������ ����������������%')
group by p.id
ORDER BY p.featured DESC, p.priority ASC, p.modified DESC, p.id DESC
LIMIT 0, 20
