SELECT
                    data_blocks.*,
                    _languages.`country_sign` AS flag,
                    _languages.`name` AS language_name,
                    _statuses.`name` AS status_name,
                    _statuses.`description` AS status_description,
                    _data_types.`name` AS data_type_name,
                    _data_types.`system_ID` AS system_ID,
                    count(tmp_live_connections_with_data_pages.ID) as connections,
                    tmp_live_connections_with_data_pages.order_no as order_no
                FROM
                    (SELECT
                        IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
                        FROM
                        (SELECT
                            *
                        FROM
                            view_data_blocks_last_version_per_languages
                        WHERE
                            language_id=1 AND status_id=6) AS last_version_per_hu
                        LEFT JOIN
                            (SELECT
                                *
                            FROM
                                view_data_blocks_last_version_per_languages
                            WHERE
                                language_id=1 AND status_id=6) AS last_version_per_actual_language
                            ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id) AS last_version_good_id
                    LEFT JOIN data_blocks
                        ON last_version_good_id.good_id=data_blocks.ID
                    LEFT JOIN _languages
                        ON data_blocks.language_id=_languages.ID
                    LEFT JOIN _statuses
                        ON data_blocks.status_id=_statuses.ID
                    LEFT JOIN _data_types
                        ON data_blocks.data_type_id=_data_types.ID
                    LEFT JOIN tmp_live_connections_with_data_pages
                        ON (
                            data_blocks.data_head_id=tmp_live_connections_with_data_pages.data_head_id AND
                            tmp_live_connections_with_data_pages.data_table='data_blocks') AND
                            (tmp_live_connections_with_data_pages.parent_data_head_id=248 AND
                            tmp_live_connections_with_data_pages.parent_data_table='data_persons')
                GROUP BY data_blocks.data_head_id
                HAVING
                    connections>0
                ORDER BY
                    order_no

                SELECT
                    *
                FROM
                    (
                    SELECT
                        d_p.*,
                        d_c.ID as connect_id,
                        d_c.order_no as order_no,
                        "order_no" as order_type
                    FROM
                        (
                        SELECT
                            *
                        FROM
                            data_connections
                        WHERE
                            data_table="data_persons" AND
                            parent_data_table="data_persons" AND
                            parent_data_head_id=248 AND
                            status_id<>7
                        ) as d_c
                        INNER JOIN
                            (
                                SELECT
                                    data_persons.*
                                FROM
                                    (

                                        SELECT
                                            IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
                                        FROM
                                            (
                                                SELECT
                                                    *
                                                FROM
                                                    view_data_persons_last_version_per_languages
                                                WHERE
                                                    language_id=1 AND status_id=6
                                            ) AS last_version_per_hu
                                            LEFT JOIN
                                                (
                                                    SELECT
                                                        *
                                                    FROM
                                                        view_data_persons_last_version_per_languages
                                                    WHERE
                                                        language_id=1 AND status_id=6
                                                ) AS last_version_per_actual_language
                                                ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id
                                    ) AS last_version_good_id        
                                    
                                    LEFT JOIN data_persons
                                        ON last_version_good_id.good_id=data_persons.ID
                                WHERE
                                    data_persons.status_id=6
                            ) as d_p
                            ON d_c.data_head_id=d_p.data_head_id
                        WHERE
                            (d_c.data_table="data_persons" AND d_p.data_head_id<>248) OR d_c.data_table<>"data_persons"

                    UNION

                    SELECT
                        d_p.*,
                        d_c.ID as connect_id,
                        d_c.parent_order_no as order_no,
                        "parent_order_no" as order_type
                    FROM
                        (
                        SELECT
                            *
                        FROM
                            data_connections
                        WHERE
                            data_table="data_persons" AND
                            data_head_id=248 AND
                            parent_data_table="data_persons" AND
                            status_id<>7) as d_c
                        INNER JOIN
                            (
                            SELECT
                                data_persons.*
                            FROM
                                (
                                    SELECT
                                        IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
                                    FROM
                                        (
                                            SELECT
                                                *
                                            FROM
                                                view_data_persons_last_version_per_languages
                                            WHERE
                                                language_id=1 AND status_id=6
                                        ) AS last_version_per_hu
                                        LEFT JOIN
                                            (
                                                SELECT
                                                    *
                                                FROM
                                                    view_data_persons_last_version_per_languages
                                                WHERE
                                                    language_id=1 AND status_id=6
                                            ) AS last_version_per_actual_language
                                            ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id
                                ) AS last_version_good_id

                                LEFT JOIN data_persons
                                        ON last_version_good_id.good_id=data_persons.ID
                                WHERE
                                    data_persons.status_id=6) as d_p
                            ON d_c.parent_data_head_id=d_p.data_head_id
                        WHERE
                            (d_c.parent_data_table="data_persons" AND d_p.data_head_id<>248) OR d_c.parent_data_table<>"data_persons") as connections
                ORDER BY
                     name 
                                

                SELECT
                    *
                FROM
                    (
                    SELECT
                        d_p.*,
                        d_c.ID as connect_id,
                        d_c.order_no as order_no,
                        "order_no" as order_type
                    FROM
                        (
                        SELECT
                            *
                        FROM
                            data_connections
                        WHERE
                            data_table="data_events" AND
                            parent_data_table="data_persons" AND
                            parent_data_head_id=248 AND
                            status_id<>7
                        ) as d_c
                        INNER JOIN
                            (
                                SELECT
                                    data_events.*
                                FROM
                                    (

                                        SELECT
                                            IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
                                        FROM
                                            (
                                                SELECT
                                                    *
                                                FROM
                                                    view_data_events_last_version_per_languages
                                                WHERE
                                                    language_id=1 AND status_id=6
                                            ) AS last_version_per_hu
                                            LEFT JOIN
                                                (
                                                    SELECT
                                                        *
                                                    FROM
                                                        view_data_events_last_version_per_languages
                                                    WHERE
                                                        language_id=1 AND status_id=6
                                                ) AS last_version_per_actual_language
                                                ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id
                                    ) AS last_version_good_id        
                                    
                                    LEFT JOIN data_events
                                        ON last_version_good_id.good_id=data_events.ID
                                WHERE
                                    data_events.status_id=6
                            ) as d_p
                            ON d_c.data_head_id=d_p.data_head_id
                        WHERE
                            (d_c.data_table="data_persons" AND d_p.data_head_id<>248) OR d_c.data_table<>"data_persons"

                    UNION

                    SELECT
                        d_p.*,
                        d_c.ID as connect_id,
                        d_c.parent_order_no as order_no,
                        "parent_order_no" as order_type
                    FROM
                        (
                        SELECT
                            *
                        FROM
                            data_connections
                        WHERE
                            data_table="data_persons" AND
                            data_head_id=248 AND
                            parent_data_table="data_events" AND
                            status_id<>7) as d_c
                        INNER JOIN
                            (
                            SELECT
                                data_events.*
                            FROM
                                (
                                    SELECT
                                        IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
                                    FROM
                                        (
                                            SELECT
                                                *
                                            FROM
                                                view_data_events_last_version_per_languages
                                            WHERE
                                                language_id=1 AND status_id=6
                                        ) AS last_version_per_hu
                                        LEFT JOIN
                                            (
                                                SELECT
                                                    *
                                                FROM
                                                    view_data_events_last_version_per_languages
                                                WHERE
                                                    language_id=1 AND status_id=6
                                            ) AS last_version_per_actual_language
                                            ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id
                                ) AS last_version_good_id

                                LEFT JOIN data_events
                                        ON last_version_good_id.good_id=data_events.ID
                                WHERE
                                    data_events.status_id=6) as d_p
                            ON d_c.parent_data_head_id=d_p.data_head_id
                        WHERE
                            (d_c.parent_data_table="data_persons" AND d_p.data_head_id<>248) OR d_c.parent_data_table<>"data_persons") as connections
                ORDER BY
                     name 
                                

                SELECT
                    *
                FROM
                    (
                    SELECT
                        d_p.*,
                        d_c.ID as connect_id,
                        d_c.order_no as order_no,
                        "order_no" as order_type
                    FROM
                        (
                        SELECT
                            *
                        FROM
                            data_connections
                        WHERE
                            data_table="data_items" AND
                            parent_data_table="data_persons" AND
                            parent_data_head_id=248 AND
                            status_id<>7
                        ) as d_c
                        INNER JOIN
                            (
                                SELECT
                                    data_items.*
                                FROM
                                    (

                                        SELECT
                                            IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
                                        FROM
                                            (
                                                SELECT
                                                    *
                                                FROM
                                                    view_data_items_last_version_per_languages
                                                WHERE
                                                    language_id=1 AND status_id=6
                                            ) AS last_version_per_hu
                                            LEFT JOIN
                                                (
                                                    SELECT
                                                        *
                                                    FROM
                                                        view_data_items_last_version_per_languages
                                                    WHERE
                                                        language_id=1 AND status_id=6
                                                ) AS last_version_per_actual_language
                                                ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id
                                    ) AS last_version_good_id        
                                    
                                    LEFT JOIN data_items
                                        ON last_version_good_id.good_id=data_items.ID
                                WHERE
                                    data_items.status_id=6
                            ) as d_p
                            ON d_c.data_head_id=d_p.data_head_id
                        WHERE
                            (d_c.data_table="data_persons" AND d_p.data_head_id<>248) OR d_c.data_table<>"data_persons"

                    UNION

                    SELECT
                        d_p.*,
                        d_c.ID as connect_id,
                        d_c.parent_order_no as order_no,
                        "parent_order_no" as order_type
                    FROM
                        (
                        SELECT
                            *
                        FROM
                            data_connections
                        WHERE
                            data_table="data_persons" AND
                            data_head_id=248 AND
                            parent_data_table="data_items" AND
                            status_id<>7) as d_c
                        INNER JOIN
                            (
                            SELECT
                                data_items.*
                            FROM
                                (
                                    SELECT
                                        IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
                                    FROM
                                        (
                                            SELECT
                                                *
                                            FROM
                                                view_data_items_last_version_per_languages
                                            WHERE
                                                language_id=1 AND status_id=6
                                        ) AS last_version_per_hu
                                        LEFT JOIN
                                            (
                                                SELECT
                                                    *
                                                FROM
                                                    view_data_items_last_version_per_languages
                                                WHERE
                                                    language_id=1 AND status_id=6
                                            ) AS last_version_per_actual_language
                                            ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id
                                ) AS last_version_good_id

                                LEFT JOIN data_items
                                        ON last_version_good_id.good_id=data_items.ID
                                WHERE
                                    data_items.status_id=6) as d_p
                            ON d_c.parent_data_head_id=d_p.data_head_id
                        WHERE
                            (d_c.parent_data_table="data_persons" AND d_p.data_head_id<>248) OR d_c.parent_data_table<>"data_persons") as connections
                ORDER BY
                     name 
                                

                SELECT
                    *
                FROM
                    (
                    SELECT
                        d_p.*,
                        d_c.ID as connect_id,
                        d_c.order_no as order_no,
                        "order_no" as order_type
                    FROM
                        (
                        SELECT
                            *
                        FROM
                            data_connections
                        WHERE
                            data_table="data_places" AND
                            parent_data_table="data_persons" AND
                            parent_data_head_id=248 AND
                            status_id<>7
                        ) as d_c
                        INNER JOIN
                            (
                                SELECT
                                    data_places.*
                                FROM
                                    (

                                        SELECT
                                            IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
                                        FROM
                                            (
                                                SELECT
                                                    *
                                                FROM
                                                    view_data_places_last_version_per_languages
                                                WHERE
                                                    language_id=1 AND status_id=6
                                            ) AS last_version_per_hu
                                            LEFT JOIN
                                                (
                                                    SELECT
                                                        *
                                                    FROM
                                                        view_data_places_last_version_per_languages
                                                    WHERE
                                                        language_id=1 AND status_id=6
                                                ) AS last_version_per_actual_language
                                                ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id
                                    ) AS last_version_good_id        
                                    
                                    LEFT JOIN data_places
                                        ON last_version_good_id.good_id=data_places.ID
                                WHERE
                                    data_places.status_id=6
                            ) as d_p
                            ON d_c.data_head_id=d_p.data_head_id
                        WHERE
                            (d_c.data_table="data_persons" AND d_p.data_head_id<>248) OR d_c.data_table<>"data_persons"

                    UNION

                    SELECT
                        d_p.*,
                        d_c.ID as connect_id,
                        d_c.parent_order_no as order_no,
                        "parent_order_no" as order_type
                    FROM
                        (
                        SELECT
                            *
                        FROM
                            data_connections
                        WHERE
                            data_table="data_persons" AND
                            data_head_id=248 AND
                            parent_data_table="data_places" AND
                            status_id<>7) as d_c
                        INNER JOIN
                            (
                            SELECT
                                data_places.*
                            FROM
                                (
                                    SELECT
                                        IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
                                    FROM
                                        (
                                            SELECT
                                                *
                                            FROM
                                                view_data_places_last_version_per_languages
                                            WHERE
                                                language_id=1 AND status_id=6
                                        ) AS last_version_per_hu
                                        LEFT JOIN
                                            (
                                                SELECT
                                                    *
                                                FROM
                                                    view_data_places_last_version_per_languages
                                                WHERE
                                                    language_id=1 AND status_id=6
                                            ) AS last_version_per_actual_language
                                            ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id
                                ) AS last_version_good_id

                                LEFT JOIN data_places
                                        ON last_version_good_id.good_id=data_places.ID
                                WHERE
                                    data_places.status_id=6) as d_p
                            ON d_c.parent_data_head_id=d_p.data_head_id
                        WHERE
                            (d_c.parent_data_table="data_persons" AND d_p.data_head_id<>248) OR d_c.parent_data_table<>"data_persons") as connections
                ORDER BY
                     name 
                                

Magyar
• English
• Deutsch

Kapcsolat

 

 

Kapcsolat

Regisztráció

Belépés

• Keresés
• Tárgyi emlékek
  • Közjegyzői sírok
  • Közjegyzői pecsétek
• Nagy egyéniségek
  • Pécsi Kamara
    • Pécsi Kamara II. rész
    • Pécsi Kamara I. rész
    • Közjegyzők írásai
    • A kamara élete és eseményei
  • Közjegyzők a múltból
  • Közjegyzők a Délvidéken
• Történelmi korok
  • Rendszerváltás
  • Császári és királyi közjegyzőség
• Szómagyarázat (Lexikon)
• Hírek

• Keresés
• Tárgyi emlékek
  • Közjegyzői sírok
  • Közjegyzői pecsétek
• Nagy egyéniségek
  • Pécsi Kamara
    • Pécsi Kamara II. rész
    • Pécsi Kamara I. rész
    • Közjegyzők írásai
    • A kamara élete és eseményei
  • Közjegyzők a múltból
  • Közjegyzők a Délvidéken
• Történelmi korok
  • Rendszerváltás
  • Császári és királyi közjegyzőség
• Szómagyarázat (Lexikon)
• Hírek
• Galéria
• Filmtár
• Impresszum
• Jogi dokumentum
• Azonnali üzenetküldő

Keresés

Szűkítés

• Személyek
• Tárgyak
• Helyek
• Események
• Képek
• Szómagyarázatok
• Minden

szentgericei DR. JAKAB ZOLTÁN (1882–1962)

közjegyző

kir. közjegyző Igalon (1927–1931) kir. közjegyző Szentesen (1931–1934) kir. közjegyző Balassagyarmaton (1934–1949)

---

1882. január 11-én született Homoródszentmártonban, Jakab Gyula Udvarhely vármegye alispánja és Zathureczki Ilona gyermekeként. Középiskolai tanulmányait a székelyudvarhelyi református gimnáziumban végezte, ahol 1901-ben érettségizett. Még ebben az évben beiratkozott a kolozsvári Magyar Királyi Ferenc József Tudományegyetem jogi karára. Diplomáját 1909. február 1-jén vehette át. 1909. április 3-án Marosvásárhelyen ügyvédi oklevelet szerzett. 1911. február 22én Szabadkán házasságot kötött Láng Ilonával, akitől Karola nevű gyermeke született. Ügyvédként dolgozott Fogarason, Zernesten, Oklándon és Székelyudvarhelyen, majd az impériumváltozás után Magyarországra repatriált. 1922-től dr. Rusa Ernő szigetvári, 1924-től Róhrer Géza budapesti, 1926-tól dr. Jakab Lajos igali közjegyző helyettese. Az igazságügyi miniszter 1927. május 13-án kinevezte közjegyzőnek Igalra, ahonnan 1931-ben Szentesre, majd 1934 májusában Balassagyarmatra helyezték át. Az unitárius egyház vezető egyénisége, előbb egyházi felügyelő, majd főtanácsos. 1962. január 6-án hunyt el Balassagyarmaton, a helyi temetőben temették el. Sírja ma már nincs meg.

Galéria