Problem with query 			
       SELECT DISTINCT
            x.personid,
            x.personname,
            x.positionname,
            x.departmentid,
            x.departmentname,
            left(x.fromtime::text,4) AS fromtime,
            left(x.totime::text,4) AS totime,
            regexp_replace(substring(w.value,'^(.+?)(?:\s+alt=.*)?\s+rank='),'^../../','') AS filename,
			positiontype
        FROM (
SELECT DISTINCT
            np.individualid AS personid,
            lang.fullconstruction(np.nameid) as personname,
			lang.fullconstruction(cc.constructionid) as positionname,
            nc.individualid AS departmentid,
            lang.fullconstruction(nc.nameid) as departmentname,
            left(e1.date::text, 4) AS fromtime,
            left(e2.date::text, 4) AS totime,
			1 AS positiontype
        FROM
            radar.individual_value v
            LEFT JOIN radar.individual_name np ON np.namingid = v.dual_individualid
            LEFT JOIN radar.event e1 ON e1.id = v.eventfromid
            LEFT JOIN radar.event e2 ON e2.id = v.eventtoid 
		    LEFT JOIN lang.concept_construction cc ON cc.conceptid = v.relationid AND cc.default_construction_or_not = true
		     JOIN lang.construction c ON c.id = cc.constructionid and c.languageid = 1
            LEFT JOIN radar.individual_name nc ON nc.namingid = v.individualid
			JOIN (
                SELECT DISTINCT p.individualid,p.dual_individualid  
                FROM radar.individual_individual p 
                WHERE p.dual_individualid in(318014,375790,2822102,373311) AND p.relationid in(104026)
                UNION
                SELECT q.individualid,q.dual_individualid 
                FROM radar.individual_individual q
                WHERE q.dual_individualid in(
                    SELECT DISTINCT p.individualid 
                    FROM radar.individual_individual p 
                    WHERE p.dual_individualid in(318014,375790,2822102,373311,375035,375795,374662,375796,375098,375791,374786,374913) 
                    AND p.relationid in(104026)) AND q.relationid in(104026)
                ) r ON r.individualid = nc.individualid
        UNION
		SELECT a.individualid as personid,b.name as personname, case when role=2 then 'oktató' when role=1 then 'akadémikus' end,null,null,null,null,2
		FROM radar.individual_person_bme a,radar.individual_name_mata b 
		WHERE a.individualid = b.individualid and b.relationid in(101218)
		) x 
        LEFT JOIN radar.individual_value w ON w.individualid = x.personid AND w.relationid in(136571) and w.value ~ ' rank=1'
    ORDER BY 
        9,6 desc
            <br/>ERROR:  relation "radar.individual_person_bme" does not exist
LINE 45:   FROM radar.individual_person_bme a,radar.individual_name_m...
                ^