[psp] view na interpelace

[kokes]

neco na zpusob

with osoby as (
	select
		id_osoba,
		jmeno || ' ' || prijmeni as jmeno
	from psp.poslanci_osoby
)
SELECT
		pr.*, os.jmeno as tazatel, os2.jmeno as dotazovany, los.*, org.*
	FROM
		psp.interp_poradi pr
		inner join osoby os on os.id_osoba = pr.id_poslanec
		inner join osoby os2 on os2.id_osoba = pr.id_ministr
		INNER JOIN psp.interp_los_interpelaci los on los.id_los = pr.id_losovani
		inner join psp.poslanci_organy org on org.id_organ = los.id_org