select obyava.id, UNIX_TIMESTAMP(pubdate) as pubdate, content, concat((select y.section as childname from catalog x left join catalog y on x.subsection = y.id where x.id=catalog), '/', catalog.section) as section from obyava, catalog where deleted = '0' and catalog = 36 and obyava.catalog = catalog.id order by pubdate desc limit 50