Querystring:
SELECT 'id'||to_char(row_number() over (order by OBD_FF_PUBLIKACE.NAZEV)) AS "id2",
(CASE
WHEN ID_FORMA = '73' THEN 'article-journal'
WHEN ID_FORMA = '67' THEN 'chapter'
WHEN ID_FORMA = '57' THEN 'chapter'
WHEN ID_FORMA = '63' THEN 'book'
WHEN ID_FORMA = '106' THEN 'chapter'
WHEN ID_FORMA = '81' THEN 'paper-conference'
WHEN ID_FORMA = '109' THEN 'paper-conference'
WHEN ID_FORMA = '121' THEN 'article-journal'
WHEN ID_FORMA = '70' THEN 'motion_picture'
WHEN ID_FORMA = '17' THEN 'article'
WHEN ID_FORMA = '110' THEN 'article'
WHEN ID_FORMA = '87' THEN 'patent'
ELSE 'book' END) AS "type",
PRIJMENI || ', ' || JMENO AS "author",
NAZEV AS "title",
DECODE(ZDROJ_NAZEV,null,'',ZDROJ_NAZEV) AS "container-title", VYDAVATEL_NAZEV AS "publisher", VYDAVATEL_MISTO AS "publisher-place", ROK, OBD_FF_PUBLIKACE.ID AS idpub, KODAUTORA as idauth, PRIJMENI as family, JMENO as given, KONANI_MESTO AS "event-place", STRANY AS "page", CISLO AS "issue", DECODE(ROCNIK,'Neuveden',' ',ROCNIK) AS "volume", DAT_KON_ZACATEK
FROM VERSO.OBD_AUTOR_DATA, VERSO.OBD_FF_PUBLIKACE
WHERE
OBD_FF_PUBLIKACE.ID IN (507939) AND OBD_AUTOR_DATA.ID_PUBLIKACE IN (SELECT OBD_AUTOR_DATA.ID_PUBLIKACE FROM VERSO.OBD_AUTOR_DATA WHERE KODAUTORA='38203310') AND
ROK >= '1348' AND ROK <= '9999' AND
OBD_AUTOR_DATA.TYP=1 AND
OBD_AUTOR_DATA.ID_PUBLIKACE=OBD_FF_PUBLIKACE.ID
ORDER BY OBD_AUTOR_DATA.PORADI