Rozporządzenie Ministra Spraw Wewnętrznych z dnia 23 kwietnia 2014 r. w sprawie wzoru zaproszenia, wzoru formularza wniosku o wpisanie zaproszenia do ewidencji zaproszeń oraz wysokości środków, które powinien posiadać zapraszający
DU 2014/546 · stan odczytu teraz
Brak źródłowego powiązania aktu ze sprawą.
Status zapisany ze źródła: uznany za uchylony. Nie jest to samodzielna ocena skutku prawnego.
Rozpoznane automatycznie w tekstach druków
Sprawy sejmowe przywołujące ten akt
0
Sprawy, w których drukach automatycznie rozpoznano adres publikacyjny tego aktu albo jego tekstu jednolitego. Przywołanie nie oznacza, że projekt zmienia ten akt.
Skąd to wiemy
Program odczytuje adresy z tekstów pobranych druków. Polecenia nowelizujące z projektów nie są jeszcze rozpoznawane. Etap sprawy jest wnioskowaniem aplikacji z etapów procesu Sejmu.
W odczytanych drukach nie rozpoznano adresu tego aktu. Nie dowodzi to, że żaden projekt go nie dotyczy.
Pliki pobrane z urzędowego źródła
Zachowane pliki
0
Brak zachowanych plików znanych w wybranym czasie.
DU/2010/768 · Rozporządzenie Ministra Spraw Wewnętrznych i Administracji z dnia 2 czerwca 2010 r. w sprawie wzoru zaproszenia potwierdzającego posiadanie wystarczających środków utrzymania na czas trwania planowanego pobytu oraz na powrót do państwa pochodzenia lub zamieszkania lub na tranzyt do państwa trzeciego, które udzieli pozwolenia na wjazd, oraz wzoru formularza wniosku o wpisanie zaproszenia do ewidencji zaproszeń · data wskazana w źródle: 2014-05-01Opis aktu w urzędowym źródle · Potwierdzenie w opisie drugiego aktu
Podane w opisie tego aktu
Akty zmieniające 2
DU/2015/741 · Rozporządzenie Ministra Spraw Wewnętrznych z dnia 20 maja 2015 r. zmieniające rozporządzenie w sprawie wzoru zaproszenia, wzoru formularza wniosku o wpisanie zaproszenia do ewidencji zaproszeń oraz wysokości środków, które powinien posiadać zapraszający · data wskazana w źródle: 2015-06-01Opis aktu w urzędowym źródle · Potwierdzenie w opisie drugiego aktu
DU/2016/289 · Rozporządzenie Ministra Spraw Wewnętrznych i Administracji z dnia 19 lutego 2016 r. zmieniające rozporządzenie w sprawie wzoru zaproszenia, wzoru formularza wniosku o wpisanie zaproszenia do ewidencji zaproszeń oraz wysokości środków, które powinien posiadać zapraszający · data wskazana w źródle: 2016-03-23Opis aktu w urzędowym źródle · Potwierdzenie w opisie drugiego aktu
DU/2018/1526 · Rozporządzenie Ministra Spraw Wewnętrznych i Administracji z dnia 27 lipca 2018 r. w sprawie wzoru zaproszenia, wzoru formularza wniosku o wpisanie zaproszenia do ewidencji zaproszeń oraz wysokości środków, które powinien posiadać zapraszający · data wskazana w źródle: 2018-08-12Opis aktu w urzędowym źródle · Potwierdzenie w opisie drugiego aktu
1. (3.24ms; exec 3.17 + fetch 0.07; rows 1) SELECT a.eli_id, a.title, a.act_kind, a.publisher_code, a.publication_year, a.position, a.source_status, a.adoption_date, a.first_observed_at, a.last_observed_at, o.observed_at, r.snapshot FROM legal_acts a LEFT JOIN eli_act_observations o ON o.id = ( SELECT o2.id FROM eli_act_observations o2 WHERE o2.act_id = a.object_id AND (NULL IS NULL OR o2.observed_at <= NULL) ORDER BY o2.observed_at DESC, o2.id DESC LIMIT 1 ) LEFT JOIN object_revisions r ON r.id = o.revision_id WHERE a.object_id = 208237 AND (NULL IS NULL OR o.id IS NOT NULL)
2. (1.39ms; exec 1.36 + fetch 0.02; rows 0) SELECT c.id, c.provision_selector, c.candidate_date, c.candidate_event, c.source_expression, c.inference_status, c.review_status, c.evidence_id FROM temporal_rule_candidates c WHERE c.act_id = 208237 ORDER BY c.candidate_date, c.id
3. (3.77ms; exec 3.75 + fetch 0.02; rows 0) SELECT DISTINCT b.object_id, b.term, b.bill_number, b.print_number, b.title, b.source_status, NULL AS snapshot FROM sejm_current_bill_process_links l JOIN sejm_bills b ON b.object_id = l.bill_id JOIN sejm_processes p ON p.object_id = l.process_id WHERE p.legal_act_id = 208237 OR p.eli_id = 'DU/2014/546' ORDER BY b.term, b.bill_number
4. (126.13ms; exec 126.1 + fetch 0.04; rows 0) SELECT d.object_id, d.owner_object_id, d.title, d.document_kind, sejm_print.print_number AS owner_print_number, r.snapshot FROM documents d LEFT JOIN publications p ON p.object_id = d.owner_object_id LEFT JOIN sejm_prints sejm_print ON sejm_print.object_id = d.owner_object_id LEFT JOIN object_revisions r ON r.id = ( SELECT r2.id FROM object_revisions r2 WHERE r2.object_id = d.object_id AND (NULL IS NULL OR r2.recorded_at <= NULL) ORDER BY r2.revision_no DESC LIMIT 1 ) WHERE (d.legal_act_id = 208237 OR p.act_id = 208237) AND (NULL IS NULL OR r.id IS NOT NULL) ORDER BY d.object_id
5. (1.32ms; exec 1.29 + fetch 0.02; rows 1) SELECT a.eli_id, JSON_VALUE(r.snapshot, '$.textPDF') AS pdf, JSON_VALUE(r.snapshot, '$.textHTML') AS html FROM legal_acts a LEFT JOIN eli_act_observations o ON o.id = ( SELECT o2.id FROM eli_act_observations o2 WHERE o2.act_id = a.object_id AND (NULL IS NULL OR o2.observed_at <= NULL) ORDER BY o2.observed_at DESC, o2.id DESC LIMIT 1 ) LEFT JOIN object_revisions r ON r.id = o.revision_id WHERE a.object_id = 208237
6. (7.06ms; exec 6.89 + fetch 0.17; rows 11) SELECT IF(r.source_act_id = 208237, 'outgoing', 'incoming') AS direction, r.source_category, other.eli_id, other.object_id AS act_id, other.title, IF(r.source_act_id = 208237, r.target_eli_id, source.eli_id) AS other_eli_id, r.source_date, r.source_article_raw, (SELECT MIN(e.evidence_id) FROM eli_act_relation_evidence e WHERE e.relation_id = r.id) AS evidence_id FROM eli_act_relations r JOIN legal_acts source ON source.object_id = r.source_act_id LEFT JOIN legal_acts other ON other.object_id = IF(r.source_act_id = 208237, r.target_act_id, r.source_act_id) AND (NULL IS NULL OR other.first_observed_at <= NULL) WHERE (r.source_act_id = 208237 OR r.target_act_id = 208237) AND (NULL IS NULL OR r.created_at <= NULL) ORDER BY direction DESC, r.source_category, r.source_date, r.target_eli_id, r.id
7. (3.26ms; exec 3.23 + fetch 0.03; rows 0) SELECT DISTINCT m.id, m.target_eli_id, m.target_address, m.operation, m.detail, s.unit_path AS instruction, s.ordinal AS position, m.ordinal, other.object_id AS act_id, other.eli_id, other.title FROM act_amendments m JOIN text_segments s ON s.id = m.segment_id JOIN extractions x ON x.id = m.extraction_id AND x.id = (SELECT MAX(latest.id) FROM extractions latest WHERE latest.source_artifact_id = x.source_artifact_id AND latest.method = x.method AND latest.quality_state = 'success') JOIN document_version_artifacts b ON b.artifact_id = x.source_artifact_id AND b.current_selector_sha = b.selector_sha JOIN document_versions v ON v.object_id = b.version_id JOIN documents d ON d.object_id = v.document_id AND d.document_kind = 'eli_act_text' LEFT JOIN legal_acts other ON other.eli_id = m.target_eli_id WHERE d.owner_object_id = 208237 ORDER BY position, m.ordinal
8. (1.04ms; exec 1.02 + fetch 0.03; rows 0) SELECT target_eli_id FROM eli_act_relations WHERE source_act_id = 208237 AND source_category = 'Inf. o tekście jednolitym'
9. (3.53ms; exec 3.49 + fetch 0.03; rows 0) SELECT DISTINCT m.id, m.target_eli_id, m.target_address, m.operation, m.detail, s.unit_path AS instruction, s.ordinal AS position, m.ordinal, other.object_id AS act_id, other.eli_id, other.title FROM act_amendments m JOIN text_segments s ON s.id = m.segment_id JOIN extractions x ON x.id = m.extraction_id AND x.id = (SELECT MAX(latest.id) FROM extractions latest WHERE latest.source_artifact_id = x.source_artifact_id AND latest.method = x.method AND latest.quality_state = 'success') JOIN document_version_artifacts b ON b.artifact_id = x.source_artifact_id AND b.current_selector_sha = b.selector_sha JOIN document_versions v ON v.object_id = b.version_id JOIN documents d ON d.object_id = v.document_id AND d.document_kind = 'eli_act_text' JOIN legal_acts other ON other.object_id = d.owner_object_id WHERE m.target_eli_id IN ('DU/2014/546') AND m.operation <> 'unrecognized' AND d.owner_object_id <> 208237 ORDER BY other.publication_year, other.position + 0, position, m.ordinal
10. (4.11ms; exec 4.09 + fetch 0.02; rows 0) SELECT x.id, x.method, x.source_artifact_id, LOWER(HEX(a.sha256)) AS sha256, p.name, p.version, p.image_digest, f.requested_url, f.finished_at, s.metrics AS block_metrics, s.id AS block_scan_id FROM documents d JOIN document_versions v ON v.object_id = ( SELECT latest.object_id FROM document_versions latest JOIN document_version_artifacts lb ON lb.version_id = latest.object_id WHERE latest.document_id = d.object_id AND lb.role = 'pdf' AND JSON_UNQUOTE(JSON_EXTRACT(lb.selector, '$.type')) = 'U' ORDER BY latest.sequence_no DESC LIMIT 1) JOIN document_version_artifacts b ON b.version_id = v.object_id AND b.role = 'pdf' AND b.current_selector_sha IS NOT NULL AND JSON_UNQUOTE(JSON_EXTRACT(b.selector, '$.type')) = 'U' JOIN artifacts a ON a.id = b.artifact_id JOIN evidence e ON e.id = b.evidence_id JOIN fetches f ON f.id = e.fetch_id JOIN extractions x ON x.id = (SELECT newest.id FROM extractions newest JOIN processing_runs nr ON nr.id = newest.run_id AND nr.state = 'completed' WHERE newest.source_artifact_id = a.id AND newest.method IN ('poppler-text', 'poppler+ocr-pol', 'poppler+vision-ocr') ORDER BY newest.id DESC LIMIT 1) AND x.quality_state = 'success' JOIN processing_runs run ON run.id = x.run_id JOIN processors p ON p.id = run.processor_id JOIN document_block_scans s ON s.extraction_id = x.id AND s.reader = 'page-text-blocks' AND s.reader_version = 'page-layout-v15' WHERE d.owner_object_id = 208237 AND d.document_kind = 'eli_act_text' ORDER BY f.finished_at DESC, x.id DESC LIMIT 1
11. (3.05ms; exec 3.04 + fetch 0.02; rows 0) SELECT x.id, x.method, x.source_artifact_id, LOWER(HEX(a.sha256)) AS sha256, p.name, p.version, p.image_digest, f.requested_url, f.finished_at FROM documents d JOIN document_versions v ON v.object_id = ( SELECT latest.object_id FROM document_versions latest WHERE latest.document_id = d.object_id AND EXISTS (SELECT 1 FROM document_version_artifacts html WHERE html.version_id = latest.object_id AND html.role = 'html') ORDER BY latest.sequence_no DESC LIMIT 1 ) JOIN document_version_artifacts b ON b.version_id = v.object_id AND b.role = 'html' AND b.current_selector_sha IS NOT NULL JOIN evidence e ON e.id = b.evidence_id JOIN fetches f ON f.id = e.fetch_id JOIN artifacts a ON a.id = b.artifact_id JOIN extractions x ON x.source_artifact_id = b.artifact_id AND x.quality_state = 'success' AND x.method = 'eli-act-units' JOIN processing_runs run ON run.id = x.run_id AND run.state = 'completed' JOIN processors p ON p.id = run.processor_id WHERE d.owner_object_id = 208237 AND d.document_kind = 'eli_act_text' ORDER BY f.finished_at DESC, x.id DESC LIMIT 1
12. (0.93ms; exec 0.91 + fetch 0.02; rows 0) SELECT target_eli_id FROM eli_act_relations WHERE source_act_id = 208237 AND source_category = 'Inf. o tekście jednolitym'
13. (4.16ms; exec 4.13 + fetch 0.04; rows 0) SELECT b.object_id, b.term, b.bill_number, b.print_number, b.title, b.received_on, COUNT(DISTINCT c.id) AS citations, COUNT(DISTINCT c.artifact_id) AS files FROM act_citations c LEFT JOIN legal_acts held ON held.eli_id = c.target_eli_id JOIN document_version_artifacts binding ON binding.artifact_id = c.artifact_id AND binding.current_selector_sha = binding.selector_sha JOIN document_versions v ON v.object_id = binding.version_id AND v.sequence_no = (SELECT MAX(latest.sequence_no) FROM document_versions latest WHERE latest.document_id = v.document_id) JOIN documents d ON d.object_id = v.document_id JOIN sejm_prints p ON p.object_id = d.owner_object_id LEFT JOIN sejm_additional_prints additional ON additional.child_print_id = p.object_id LEFT JOIN sejm_prints parent ON parent.object_id = additional.parent_print_id AND parent.current_revision_id = additional.parent_revision_id LEFT JOIN sejm_additional_prints outer_link ON outer_link.child_print_id = parent.object_id LEFT JOIN sejm_prints outer_parent ON outer_parent.object_id = outer_link.parent_print_id AND outer_parent.current_revision_id = outer_link.parent_revision_id JOIN sejm_bills b ON b.term = p.term AND b.print_number = COALESCE(outer_parent.print_number, parent.print_number, p.print_number) WHERE c.target_eli_id IN ('DU/2014/546') AND c.origin = 'parsed-address' AND c.parse_problem IS NULL AND (c.cited_act_date IS NULL OR c.cited_act_date = held.adoption_date) GROUP BY b.object_id ORDER BY b.received_on DESC, b.object_id DESC
Top slow:
126.13ms SELECT d.object_id, d.owner_object_id, d.title, d.document_kind, sejm_print.print_number AS owner_print_number, r.snapshot FROM documents d LEFT JOIN publications p ON p.object_id = d.owner_object_id LEFT JOIN sejm_prints sejm_print ON sejm_print.object_id = d.owner_object_id LEFT JOIN object_revisions r ON r.id = ( SELECT r2.id FROM object_revisions r2 WHERE r2.object_id = d.object_id AND (NULL IS NULL OR r2.recorded_at <= NULL) ORDER BY r2.revision_no DESC LIMIT 1 ) WHERE (d.legal_act_id = 208237 OR p.act_id = 208237) AND (NULL IS NULL OR r.id IS NOT NULL) ORDER BY d.object_id
7.06ms SELECT IF(r.source_act_id = 208237, 'outgoing', 'incoming') AS direction, r.source_category, other.eli_id, other.object_id AS act_id, other.title, IF(r.source_act_id = 208237, r.target_eli_id, source.eli_id) AS other_eli_id, r.source_date, r.source_article_raw, (SELECT MIN(e.evidence_id) FROM eli_act_relation_evidence e WHERE e.relation_id = r.id) AS evidence_id FROM eli_act_relations r JOIN legal_acts source ON source.object_id = r.source_act_id LEFT JOIN legal_acts other ON other.object_id = IF(r.source_act_id = 208237, r.target_act_id, r.source_act_id) AND (NULL IS NULL OR other.first_observed_at <= NULL) WHERE (r.source_act_id = 208237 OR r.target_act_id = 208237) AND (NULL IS NULL OR r.created_at <= NULL) ORDER BY direction DESC, r.source_category, r.source_date, r.target_eli_id, r.id
4.16ms SELECT b.object_id, b.term, b.bill_number, b.print_number, b.title, b.received_on, COUNT(DISTINCT c.id) AS citations, COUNT(DISTINCT c.artifact_id) AS files FROM act_citations c LEFT JOIN legal_acts held ON held.eli_id = c.target_eli_id JOIN document_version_artifacts binding ON binding.artifact_id = c.artifact_id AND binding.current_selector_sha = binding.selector_sha JOIN document_versions v ON v.object_id = binding.version_id AND v.sequence_no = (SELECT MAX(latest.sequence_no) FROM document_versions latest WHERE latest.document_id = v.document_id) JOIN documents d ON d.object_id = v.document_id JOIN sejm_prints p ON p.object_id = d.owner_object_id LEFT JOIN sejm_additional_prints additional ON additional.child_print_id = p.object_id LEFT JOIN sejm_prints parent ON parent.object_id = additional.parent_print_id AND parent.current_revision_id = additional.parent_revision_id LEFT JOIN sejm_additional_prints outer_link ON outer_link.child_print_id = parent.object_id LEFT JOIN sejm_prints outer_parent ON outer_parent.object_id = outer_link.parent_print_id AND outer_parent.current_revision_id = outer_link.parent_revision_id JOIN sejm_bills b ON b.term = p.term AND b.print_number = COALESCE(outer_parent.print_number, parent.print_number, p.print_number) WHERE c.target_eli_id IN ('DU/2014/546') AND c.origin = 'parsed-address' AND c.parse_problem IS NULL AND (c.cited_act_date IS NULL OR c.cited_act_date = held.adoption_date) GROUP BY b.object_id ORDER BY b.received_on DESC, b.object_id DESC
N+1 candidates:
2× (1.97ms) SELECT target_eli_id FROM eli_act_relations WHERE source_act_id = ? AND source_category = ?