SELECT a.ex_name as title, concat('http://www.dom.kharkov.ua/', b.ex_folder, '/', a.ex_url, '/') as link , case when a.ex_img <> '' then concat('<table><tr><td valign=top><img border=0 width=150 src="', 'http://www.dom.kharkov.ua/', b.ex_folder, '/', a.ex_url, '/', a.ex_img, '"></td><td valign=top>', a.ex_about, '</td></tr></table>')  else a.ex_about end as description  , UNIX_TIMESTAMP(a.cdate) as pubDate FROM exclusive a left join CITYAREA c on c.id = a.city left join CITYAREA d on d.id = a.street, USERS b WHERE a.vis = 1 AND a.adate >= now() AND a.otype = 2 and a.mdate is null and a.owner = b.id and b.active = 1 and b.hot_preview = 1 and b.last_active_date > now() and a.posutochno = 1 and a.operation = 'set' order by a.cdate desc