Ошибка DB:
Can't create/write to file '/var/tmp/#sql_2f51_22.MAI' (Errcode: 28)
SELECT `osr_real_prodaja`.*,`osr_cities`.`city_name_ru`,
`osr_real_cat`.`name` as `tip_name`,`osr_real_cat`.`fields`,
(SELECT osr_real_image.path FROM osr_real_image WHERE osr_real_image.idrealty=`osr_real_prodaja`.id and
osr_real_image.first<2 ORDER BY osr_real_image.first DESC LIMIT 1) as imagefirst
FROM `osr_real_prodaja`
LEFT JOIN `osr_real_cat` ON `osr_real_prodaja`.`tip`=`osr_real_cat`.`id`
LEFT JOIN `osr_cities` ON `osr_real_prodaja`.`city`=`osr_cities`.`id_city`
WHERE `osr_real_prodaja`.`moderate`='1' and `osr_real_prodaja`.`public`='1'
and (`osr_real_prodaja`.`hotenable`=1 or `osr_real_prodaja`.`hotenable`>UNIX_TIMESTAMP())
ORDER BY RAND()
LIMIT 5