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=202 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=202 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<>202) 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=202 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<>202) 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=202 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<>202) 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=202 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<>202) 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=202 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<>202) 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=202 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<>202) 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=202 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<>202) 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=202 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<>202) 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)Rezei Fabius ♦ 1854-1916
Rezei Fabius Fabius Rezem 1854-ben született Lúgoson. jogi tanulmányokat I 870 és 1875 között a Nagyváradi jogakadémián folytatott, joggyakorlatot 1875. március 14-től 1875. december 15-ig egy Román nevezetű, l875. december 21-tői 1876. július 1-jéig Major János lugosi ügyvedeknél, 1876. július 10-től 1877. december 31-ig a Rugosi Királyi Törvényszéknél, 1878. február I-jétől 1878. június 24-ig Titu Haçeg, I878. június 24-től 1878. szeptember 6-ig Fischer Benő lugosi ügyvédeknél teljesített. Az ügyvédi vizsgát Budapesten
1878. december 18-án tette le. Rezei Fabms szakmai pályafutását írnokként kezdte, a volt törvényszéki írnokot és ügyvédjelöltet az igazságügyi miniszter 1 876-ban a Lugosi Királyi Törvényszék II. osztályú jegyzőjévé nevezte ki 1879-ben a Temesvári Ügyvédi Kamara lugosi székhellyel vette fel tagjai sorába. 1891-ben az ügyvédi kamara választmányába is beválasztották.
1893-ban Krassó-Szörénv vármegye közigazgatási házközösségi előadójává nevezték ki, ezért ügyvédi állásáról lemondott. 1895-ben azonban ismét bejegyezték ügyvédnek. A vármegye törvényhatósági bizottságának is tagja volt. Bésán Mihály lugosi közjegyzővel ellentétben ellenzéki, nemzetiségi politizálást folytatott. Coriolan Brediccanu román nemzetiségi politikus híve volt. A vármegyei politika mellett részt vett a lugosi görög katolikus egyházmegye életében is. Ügyvédként képviselte az egyházmegyét és annak alapítványait, emellett az egyházmegyei ügyész tisztet is betöltötte. Amikor 1903-ban a lugosi görög katolikus püspökség fennállásának 50. évfordulóját ünnepelte, a jubileumi rendezvény ünnepi beszédét ő tartotta. Időközben a városi képviselőtestület tiszti ügyészévé választották. Királyi közjegyzőnek az igazságügyi miniszter Lúgosra I 906-ban nevezte ki. Szakmai tevékenysége mellett a Lugosi Királyi Törvényszéken állandó román nyelvű bírósági tolmácsként tevékenykedett. Linóké volt a híres lugosi román dalárdának.
Igazgatósági tagja volt a Krassói Tikarékpénztárnak, a Lugosi Népbanknak és a Lugosi Concordia, az osztrák—magyar első általános tisztviselőegylet takarék és előlegezési szövetkezetének. Igazgatósági tagja volt továbbá a Magyar Délkeleti Helyi Érdekű Vasúti Részvénytársaságnak, valamint az Oravica—Németbogsán—Rcsicabányai Helyi Érdekű Vasút Részvénytársaságnak. 1911-ben a közügyek terén szerzett érdemei elismeréséül királyi tanácsosi címmel tüntették ki. Rezei Fabius 1916. szeptember I9-én hunyt el Lúgoson. Gyászjelentése szerint a 62 évet élt közjegyzőt felesége, született Coscariu Emília és fia, Rezei Fabius későbbi lugosi román királyi főügyész siratta. A lugosi román ortodox temetőben temették el.
Sírja ma már nem található meg.