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=181 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=181 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<>181) 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=181 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<>181) 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=181 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<>181) 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=181 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<>181) 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=181 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<>181) 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=181 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<>181) 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=181 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<>181) 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=181 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<>181) 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)Rakics János ♦ 1825
Rakics János 1825 körül született, ismeretlen helyen. Jogi tanulmányokat az l840-es évek derekán, talán 1843 és 1847 között a Pesti Tudományegyetemen folytatott. Az ügyvédi vizsgát szintén Pesten tette le, 1855 körül. 1862 és I866 között Ternes vármegye főjegyzője volt. Ezt követően Temesváron ügyvédként tevékenykedett. Királyi közjegyzőnek az igazságügyi miniszter 1876-ban Fehértemplomba nevezte kié l880-ban székhelyet cserélt Niamessny Mihály karánsebesi közjegyzővel. Karánsebesen rögtön újabb székhelyet cserélt Dregán János szászsebest közjegyzővel.9 Ekkor azonban már súlyos beteg volt, a szászsebesi székhelyet nem foglalhatta el. Rakics János I88I márciusában hunyt el.10 Dregán János így visszacserélte székhelyét Szászsebesre.