Magyar
English
Deutsch
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=111 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_noSQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'kozjegyz_idigi'@'172.23.4.0/255.255.255.0' (using password: YES)
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=111 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<>111) 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=111 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<>111) 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)
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=111 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<>111) 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=111 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<>111) 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)
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=111 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<>111) 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=111 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<>111) 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)
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=111 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<>111) 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=111 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<>111) 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)Dr. Szlezák Rezső ♦1882
Dr. Szlezák Rezső 1882-ben született Újvidéken. A középiskolát Újvidéken végezte. Jogi tanulmányokat 1903 és 1907 között a Budapesti Tudományegyetemen föl ytatott. Jogi doktori oklevelet 1912. július 27-én szerzett. Az ügyvédi vizsgát 1913-ban Budapesten tette le. Egyéves önkéntesi katonai szolgálatát a szabadkai 6. számú honvéd gyalogezred kötelékében teljesítette. 1913-ban a Szabadkai Ügyvédi Kamara újvidéki székhellyel jegyezte be tagjai sorába. 19I4-ben az Újvidéki Hitelszövetkezet, mint az Országos Központi Hitelszövetkezet tagja, igazgatósági tagjának választották. A világháború kitörése után 1914-ben népfelkelő főhadnagyként vonult be a 6. számú honvéd gyalogezredhez. Az orosz fronton harcolt, ahol 1916. július 31-én hadifogságba esett. A fogságából 1918 júniusában tért vissza Újvidékre.1920-ban alapító tagja és egyben első felelős szerkesztője volt a Délbácska napilapnak. A szerkesztői tisztséget 1923-ig töltötte be. A lap a délvidéki magyarság fóruma volt, amely célját a magyar kisebbség védelmében jelölte meg. Ezért politikai irányvonalát nemcsak a helyi szerb lapok, hanem a magyar napilapok is folyamatosan bírálták. A sajtóban közölt támadó cikkek mellett a lap szerkesztősége ellen több alkalommal követtek el merényletet. 1922. december 1-jén szerb szélsőséges elemek robbantottak bombát a szerkesztőségben. 1923-ban a szerb Orjuna szervezet tagjai verték szét a szerkesztőség berendezését, és fizikailag is bántalmazták a szerkesztőség tagjait. Dr. Szlezák Rezsőt életveszélyesen megsebesítették. A Délbácska a történtek ellenére is folyamatosan megjelent. A lap cikkeit, a közölt anyagokat a cenzúra is igyekezett megritkítani. 1922-től a Magyar Országos Párt megalakulását és fő követeléseit ismertette. Miután 1923-ban dr. Szlezák Rezső lemondott, az új főszerkesztő Tornán Sándor lett. 1930-ban ügyvédi irodája székhelyét Topolyára helyezte át. 1941-ben az illetékes magyar katonai hatóság ideiglenes megbízással topolyai közjegyzőnek nevezte ki. Működésének első öt hónapjában 102 hagyatéki ügyet tárgyalt le, és 64 közjegyzői okiratot készített.66 Kinevezését az igazságügyi miniszter azonban nem erősítette meg, 1941. december 4-én az Újvidéki Ügyvédi Kamara újvidéki székhellyel jegyezte be tagjai sorába. 1944 utáni sorsa nem ismert.
