query = '''
            SELECT "ew"."ogc_fid", "ew"."iddzialki", "ew"."powierzchniaewidencyjna", "ew"."numerkw",
            "ew"."numerelektronicznejkw", "udz"."licznik" || '/' || "udz"."mianownik", "udz"."rodzaj", "wlad"."rodzaj_podm"
            FROM {0}"egb_dzialkaewidencyjna" AS "ew"
            JOIN {0}"egb_jednostkarejestrowa" AS "jrg" ON ("jrg"."jrg_href" = "ew"."jrg2_href")
            JOIN
            (
            SELECT
            'własność' AS "rodzaj",
            "podmiotudzialuwlasnosci_egb_podmiot_pkid" AS "podm_ogr_pkid",
            "przedmiotudzialuwlasnosci_egb_jednostkarejestrowa_pkid" AS "jrg_ogr_pkid",
            "licznikulamkaokreslajacegowartoscudzialu" AS "licznik",
            "mianownikulamkaokreslajacegowartoscudzialu" AS "mianownik"
            FROM {0}"egb_udzialwlasnosci"
            UNION
            SELECT
            'władanie' AS "rodzaj",
            "podmiotudzialuwewladaniu_egb_podmiot_pkid" AS "podm_ogr_pkid",
            "przedmiotudzialuwladania_egb_jednostkarejestrowa_pkid" AS "jrg_ogr_pkid",
            "licznikulamkaokreslajacegowartoscudzialu" AS "licznik",
            "mianownikulamkaokreslajacegowartoscudzialu" AS "mianownik"
            FROM {0}"egb_udzialwewladaniunieruchomosciasplubjst"
            UNION
            SELECT
            'gospodarowanie' AS "rodzaj",
            "podmiotudzialugz_egb_podmiot_pkid" AS "podm_ogr_pkid",
            "przedmiotudzialugz1_egb_jednostkarejestrowa_pkid" AS "jrg_ogr_pkid",
            "licznikulamkaokreslajacegowartoscudzialu" AS "licznik",
            "mianownikulamkaokreslajacegowartoscudzialu" AS "mianownik"
            FROM {0}"egb_udzialgospodarowanianieruchomosciasplubjst"
            ) AS "udz" ON ("jrg"."ogr_pkid" = "udz"."jrg_ogr_pkid")
            JOIN
            (
            SELECT "podm"."ogr_pkid" AS "ogr_pkid", 'osoba fizyczna' as "rodzaj_podm", "os"."identifier" AS "identifier"
            FROM {0}"egb_osobafizyczna" as "os"
            JOIN {0}"egb_podmiot" AS "podm" ON ("podm"."osobafizyczna5_href" = substr("os"."identifier", 1, length("os"."identifier")-20))
            UNION ALL
            SELECT "podm"."ogr_pkid" AS "ogr_pkid", 'małżeństwo' as "rodzaj_podm", "malz"."osobafizyczna2_href"||"malz"."osobafizyczna3_href" AS "identifier"
            FROM {0}"egb_malzenstwo" as "malz"
            JOIN {0}"egb_podmiot" AS "podm" ON ("podm"."malzenstwo4_href" = substr("malz"."identifier", 1, length("malz"."identifier")-20))
            UNION ALL
            SELECT "podm"."ogr_pkid" AS "ogr_pkid", 'instytucja' as "rodzaj_podm", "inst"."identifier" AS "identifier"
            FROM {0}"egb_instytucja" as "inst"
            JOIN {0}"egb_podmiot" AS "podm" ON ("podm"."instytucja3_href" = substr("inst"."identifier", 1, length("inst"."identifier")-20))
            UNION ALL
            SELECT "podm"."ogr_pkid" AS "ogr_pkid", 'podmiot grupowy - osoba fizyczna' as "rodzaj_podm", "os"."identifier" AS "identifier"
            FROM {0}"egb_osobafizyczna" as "os"
            JOIN {0}"egb_podmiotgrupowy_osobafizyczna4" AS "podm_gr_link" ON ("podm_gr_link"."href" = substr("os"."identifier", 1, length("os"."identifier")-20))
            JOIN {0}"egb_podmiotgrupowy" AS "podm_gr" ON ("podm_gr"."ogr_pkid" = "podm_gr_link"."parent_ogr_pkid")
            JOIN {0}"egb_podmiot" AS "podm" ON ("podm"."podmiotgrupowy1_href" = substr("podm_gr"."identifier", 1, length("podm_gr"."identifier")-20))
            UNION ALL
            SELECT "podm"."ogr_pkid" AS "ogr_pkid", 'podmiot grupowy - małżeństwo' as "rodzaj_podm", "malz"."osobafizyczna2_href"||"malz"."osobafizyczna3_href" AS "identifier"
            FROM {0}"egb_malzenstwo" as "malz"
            JOIN {0}"egb_podmiotgrupowy_malzenstwo3" AS "podm_gr_link" ON ("podm_gr_link"."href" = substr("malz"."identifier", 1, length("malz"."identifier")-20))
            JOIN {0}"egb_podmiotgrupowy" AS "podm_gr" ON ("podm_gr"."ogr_pkid" = "podm_gr_link"."parent_ogr_pkid")
            JOIN {0}"egb_podmiot" AS "podm" ON ("podm"."podmiotgrupowy1_href" = substr("podm_gr"."identifier", 1, length("podm_gr"."identifier")-20))
            UNION ALL
            SELECT "podm"."ogr_pkid" AS "ogr_pkid", 'podmiot grupowy - instytucja' as "rodzaj_podm", "inst"."identifier" AS "identifier"
            FROM {0}"egb_instytucja" as "inst"
            JOIN {0}"egb_podmiotgrupowy_instytucja" AS "podm_gr_link" ON ("podm_gr_link"."href" = substr("inst"."identifier", 1, length("inst"."identifier")-20))
            JOIN {0}"egb_podmiotgrupowy" AS "podm_gr" ON ("podm_gr"."ogr_pkid" = "podm_gr_link"."parent_ogr_pkid")
            JOIN {0}"egb_podmiot" AS "podm" ON ("podm"."podmiotgrupowy1_href" = substr("podm_gr"."identifier", 1, length("podm_gr"."identifier")-20))
            ) AS "wlad" ON ("udz"."podm_ogr_pkid" = "wlad"."ogr_pkid")
            WHERE "wlad"."identifier" LIKE '%' || '{1}' || '%'