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=143 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
SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'kozjegyz_idigi'@'172.23.4.0/255.255.255.0' (using password: YES)

Warning: file_put_contents(./sql_error_log): failed to open stream: Permission denied in /alk/akademia/i-digi.hu/weblap/commons/includes/database/database.querybuilder.php on line 32
                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=143 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<>143) 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=143 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<>143) OR d_c.parent_data_table<>"data_persons") as connections
                ORDER BY
                     name 
                                
SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'kozjegyz_idigi'@'172.23.4.0/255.255.255.0' (using password: YES)

Warning: file_put_contents(./sql_error_log): failed to open stream: Permission denied in /alk/akademia/i-digi.hu/weblap/commons/includes/database/database.querybuilder.php on line 32
                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=143 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<>143) 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=143 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<>143) OR d_c.parent_data_table<>"data_persons") as connections
                ORDER BY
                     name 
                                
SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'kozjegyz_idigi'@'172.23.4.0/255.255.255.0' (using password: YES)

Warning: file_put_contents(./sql_error_log): failed to open stream: Permission denied in /alk/akademia/i-digi.hu/weblap/commons/includes/database/database.querybuilder.php on line 32
                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=143 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<>143) 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=143 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<>143) OR d_c.parent_data_table<>"data_persons") as connections
                ORDER BY
                     name 
                                
SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'kozjegyz_idigi'@'172.23.4.0/255.255.255.0' (using password: YES)

Warning: file_put_contents(./sql_error_log): failed to open stream: Permission denied in /alk/akademia/i-digi.hu/weblap/commons/includes/database/database.querybuilder.php on line 32
                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=143 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<>143) 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=143 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<>143) OR d_c.parent_data_table<>"data_persons") as connections
                ORDER BY
                     name 
                                
SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'kozjegyz_idigi'@'172.23.4.0/255.255.255.0' (using password: YES)

Warning: file_put_contents(./sql_error_log): failed to open stream: Permission denied in /alk/akademia/i-digi.hu/weblap/commons/includes/database/database.querybuilder.php on line 32

DR. MAYER JENŐ ♦ 1890

DR. MAYER JENŐ ♦ 1890


Dr. Mayer Jenő 1890. március 16-án született Zomborban. Édesapja dr. Mayer Nándor zombori ügyvéd, édesanyja Hippich Klára volt. A középiskolát Zomborban végezte. Az érettségi vizsgát 1908. június 25-én a Zombori Állami Főgimnáziumban tette le. Jogi tanulmányokat 1908 és 1910 között a Budapesti Tudományegyetemen folytatott. Jogi doktorrá 1915- március l8-án avatták.54 Egyéves önkéntesi katonai szolgálatát a szabadkai 86. számú gyalogezrednél teljesítette. A világháború kitörése után I9I4-ben bevonult katonának, és a szabadkai 86. számú gyalogezred kötelékében az orosz hadszíntéren teljesített szolgálatot. 1915-től a hadbíróság kötelékébe helyezték át. 1918. október 17-én a bécsi Császári és Királyi Legfelsőbb Katonai Törvényszék előtt hadbírói vizsgát tett. 1919. október I 5-én tartalékos főhadnagy hadbíróként szerelt le. A háború alatt tanúsított érdemeiért a Koronás Arany Érdemkereszt a Vitézségi Érem szalagján, az Ezüst Vitézségi Erem és a Károly Csapatkereszt kitüntetésben részesült. Az 1915. szeptember 7-én Wolfd Erzsébettel kötött házasságából két gyermek született: Sándor és Klárád Az ügyvédi vizsgát 1925. október I9-én tette le Újvidéken. Ezt követően Zomborban lett ügyvéd. 1941. június I7-én a Zombori járási katonai parancsnokság ideiglenesen Apatinban a közjegyzői teendők ellátásával bízta meg. Ezt a megbízatását 1941. december 24-ig látta el. Királyi közjegyzőnek az igazságügyi miniszter 1942-ben Titelre nevezte ki. Közjegyzői irodáját 1942. február 16-án nyitotta meg. Német és szerb nyelven is készített közjegyzői okiratokat. Szakmai munkája mellett a földművelésügyi miniszter az Apatinban székelő Monostorszeg—apatini Ármentesítő és Belvízszabályozó Társulat miniszteri biztosának nevezte ki. Továbbá igazgatósági tagja volt az Apatini Villanytelep Részvénytársaságnak. Budapesten élő családjára, valamint a titeli közjegyzői állás alacsony jövedelmezőségére hivatkozva 1943-ban a ceglédi közjegyzői székhelyre kérte áthelyezését. Az igazságügyi miniszter ezt az áthelyezési kérelmet nem teljesítette. 1944 áprilisában lánya apósával, dr. Kukorelly György érsekújvári közjegyzővel székhelyet cserélt, amit a miniszter jóváhagyott. Érsekújvárt közjegyzői irodáját 1944. május I2-én nyitotta meg. További sorsa ismeretlen.

Galéria