FILE: /var/www/registracenova-zelenausporamcz/web/registrace.nova-zelenausporam.cz/vyhledavani/admin/cfg/libs_parser/module/overview.inc.php
LINE: 1
ERROR: Table 'nzu_registrace_search.sod_dodavatel_technologie' doesn't exist
SOURCE: SELECT SQL_CALC_FOUND_ROWS `dt`.`id` as `dt_id`, `dt`.`id_1` as `dt_id_1`, `dt`.`id_2` as `dt_id_2` , `dodavatel`.`file_potvrzeni_financniho_uradu` as `dodavatel_file_potvrzeni_financniho_uradu`, `dodavatel`.`datum_zmeny` as `dodavatel_datum_zmeny`, `dodavatel`.`fulltext` as `dodavatel_fulltext`, `dodavatel`.`poznamka_pro_zadatele_odeslat` as `dodavatel_poznamka_pro_zadatele_odeslat`, `dodavatel`.`poznamka_pro_zadatele_odeslano` as `dodavatel_poznamka_pro_zadatele_odeslano`, `dodavatel`.`timestamp` as `dodavatel_timestamp`, `dodavatel`.`rejstrik_obchod_vydani` as `dodavatel_rejstrik_obchod_vydani`, `dodavatel`.`rejstrik_obchod_platnost` as `dodavatel_rejstrik_obchod_platnost`, `dodavatel`.`plna_moc_vydani` as `dodavatel_plna_moc_vydani`, `dodavatel`.`plna_moc_platnost` as `dodavatel_plna_moc_platnost`, `dodavatel`.`rejstrik_trest_vydani` as `dodavatel_rejstrik_trest_vydani`, `dodavatel`.`rejstrik_trest_platnost` as `dodavatel_rejstrik_trest_platnost`, `dodavatel`.`osvedceni_zaskoleni` as `dodavatel_osvedceni_zaskoleni`, `dodavatel`.`certifikat9000_vydani` as `dodavatel_certifikat9000_vydani`, `dodavatel`.`certifikat9000_platnost` as `dodavatel_certifikat9000_platnost`, `dodavatel`.`certifikat14001_vydani` as `dodavatel_certifikat14001_vydani`, `dodavatel`.`certifikat14001_platnost` as `dodavatel_certifikat14001_platnost`, `dodavatel`.`certifikat_emas_vydani` as `dodavatel_certifikat_emas_vydani`, `dodavatel`.`certifikat_emas_platnost` as `dodavatel_certifikat_emas_platnost`, `dodavatel`.`certifikat_dalsi` as `dodavatel_certifikat_dalsi`, `dodavatel`.`rejstrik_obchod` as `dodavatel_rejstrik_obchod`, `dodavatel`.`plna_moc` as `dodavatel_plna_moc`, `dodavatel`.`rejstrik_trest` as `dodavatel_rejstrik_trest`, `dodavatel`.`certifikat9000` as `dodavatel_certifikat9000`, `dodavatel`.`certifikat14001` as `dodavatel_certifikat14001`, `dodavatel`.`certifikat_emas` as `dodavatel_certifikat_emas`, `dodavatel`.`id` as `dodavatel_id`, `dodavatel`.`web` as `dodavatel_web`, `dodavatel`.`tel` as `dodavatel_tel`, `dodavatel`.`fax` as `dodavatel_fax`, `dodavatel`.`zaslani_nazev` as `dodavatel_zaslani_nazev`, `dodavatel`.`zaslani_osoba` as `dodavatel_zaslani_osoba`, `dodavatel`.`zaslani_osoba_email` as `dodavatel_zaslani_osoba_email`, `dodavatel`.`zaslani_osoba_tel` as `dodavatel_zaslani_osoba_tel`, `dodavatel`.`heslo` as `dodavatel_heslo`, `dodavatel`.`zaslani_ulice` as `dodavatel_zaslani_ulice`, `dodavatel`.`zaslani_cp` as `dodavatel_zaslani_cp`, `dodavatel`.`zaslani_obec` as `dodavatel_zaslani_obec`, `dodavatel`.`zaslani_psc` as `dodavatel_zaslani_psc`, `dodavatel`.`zaslani_stat` as `dodavatel_zaslani_stat`, `dodavatel`.`nazev` as `dodavatel_nazev`, `dodavatel`.`zamestnanci` as `dodavatel_zamestnanci`, `dodavatel`.`zamestnanci_odborni` as `dodavatel_zamestnanci_odborni`, `dodavatel`.`zakazky_solar` as `dodavatel_zakazky_solar`, `dodavatel`.`zakazky_cerpadla` as `dodavatel_zakazky_cerpadla`, `dodavatel`.`zakazky_kotle` as `dodavatel_zakazky_kotle`, `dodavatel`.`zakazky_zateplovani` as `dodavatel_zakazky_zateplovani`, `dodavatel`.`zakazky_vyplne` as `dodavatel_zakazky_vyplne`, `dodavatel`.`zakazky_pasdomy` as `dodavatel_zakazky_pasdomy`, `dodavatel`.`zelena_usporam` as `dodavatel_zelena_usporam`, `dodavatel`.`poznamka` as `dodavatel_poznamka`, `dodavatel`.`sidlo_ulice` as `dodavatel_sidlo_ulice`, `dodavatel`.`zahajeni_podnikani` as `dodavatel_zahajeni_podnikani`, `dodavatel`.`zapis_do_seznamu` as `dodavatel_zapis_do_seznamu`, `dodavatel`.`pravni_forma_id` as `dodavatel_pravni_forma_id`, `dodavatel`.`file_vypis_rejstriku_trestu` as `dodavatel_file_vypis_rejstriku_trestu`, `dodavatel`.`file_cestne_prohlaseni_likvidace` as `dodavatel_file_cestne_prohlaseni_likvidace`, `dodavatel`.`file_vypis_obchodni_rejstrik` as `dodavatel_file_vypis_obchodni_rejstrik`, `dodavatel`.`vyrobci` as `dodavatel_vyrobci`, `dodavatel`.`odeslan` as `dodavatel_odeslan`, `dodavatel`.`poznamka_sfzp` as `dodavatel_poznamka_sfzp`, `dodavatel`.`datum_odeslani` as `dodavatel_datum_odeslani`, `dodavatel`.`datum_registarce` as `dodavatel_datum_registarce`, `dodavatel`.`datum_email` as `dodavatel_datum_email`, `dodavatel`.`kontrola_vyrobce` as `dodavatel_kontrola_vyrobce`, `dodavatel`.`sidlo_cp` as `dodavatel_sidlo_cp`, `dodavatel`.`kontrola_dokladu` as `dodavatel_kontrola_dokladu`, `dodavatel`.`datum_emailu_zruseni` as `dodavatel_datum_emailu_zruseni`, `dodavatel`.`datum_elektronick_vyzvy` as `dodavatel_datum_elektronick_vyzvy`, `dodavatel`.`poznamka_pro_zadatele` as `dodavatel_poznamka_pro_zadatele`, `dodavatel`.`datum_email_vraceni` as `dodavatel_datum_email_vraceni`, `dodavatel`.`sidlo_obec` as `dodavatel_sidlo_obec`, `dodavatel`.`datova_schranka` as `dodavatel_datova_schranka`, `dodavatel`.`sidlo_psc` as `dodavatel_sidlo_psc`, `dodavatel`.`sidlo_stat` as `dodavatel_sidlo_stat`, `dodavatel`.`trvaly_pobyt_ulice` as `dodavatel_trvaly_pobyt_ulice`, `dodavatel`.`trvaly_pobyt_cp` as `dodavatel_trvaly_pobyt_cp`, `dodavatel`.`trvaly_pobyt_obec` as `dodavatel_trvaly_pobyt_obec`, `dodavatel`.`trvaly_pobyt_psc` as `dodavatel_trvaly_pobyt_psc`, `dodavatel`.`trvaly_pobyt_stat` as `dodavatel_trvaly_pobyt_stat`, `dodavatel`.`ico` as `dodavatel_ico`, `dodavatel`.`dic` as `dodavatel_dic`, `dodavatel`.`email` as `dodavatel_email`, `tt`.`id` as `tt_id`, `tt`.`rodic_id` as `tt_rodic_id`, `tt`.`kod` as `tt_kod`, `tt`.`nazev` as `tt_nazev`, `tt`.`poradi` as `tt_poradi`, `tt`.`oblast_id` as `tt_oblast_id`, `tt`.`opatreni` as `tt_opatreni`, `tt`.`opatreni_id` as `tt_opatreni_id`, `tt`.`popisek` as `tt_popisek`, `v`.`fulltext` as `v_fulltext`, `v`.`timestamp` as `v_timestamp`, `v`.`dovozce_dic` as `v_dovozce_dic`, `v`.`dovozce_email` as `v_dovozce_email`, `v`.`dovozce_datova_schranka` as `v_dovozce_datova_schranka`, `v`.`vyrobce_dic` as `v_vyrobce_dic`, `v`.`vyrobce_email` as `v_vyrobce_email`, `v`.`vyrobce_datova_schranka` as `v_vyrobce_datova_schranka`, `v`.`dokumenty` as `v_dokumenty`, `v`.`zadatel_role` as `v_zadatel_role`, `v`.`envi` as `v_envi`, `v`.`envi_datum_vystaveni` as `v_envi_datum_vystaveni`, `v`.`envi_datum_platnosti` as `v_envi_datum_platnosti`, `v`.`technologie_id` as `v_technologie_id`, `v`.`subtechnologie_id` as `v_subtechnologie_id`, `v`.`id` as `v_id`, `v`.`vyrobce_obec` as `v_vyrobce_obec`, `v`.`vyrobce_psc` as `v_vyrobce_psc`, `v`.`vyrobce_stat_id` as `v_vyrobce_stat_id`, `v`.`vyrobce_ico` as `v_vyrobce_ico`, `v`.`dovozce_nazev` as `v_dovozce_nazev`, `v`.`program` as `v_program`, `v`.`dovozce_ulice` as `v_dovozce_ulice`, `v`.`dovozce_cp` as `v_dovozce_cp`, `v`.`dovozce_obec` as `v_dovozce_obec`, `v`.`dovozce_psc` as `v_dovozce_psc`, `v`.`dovozce_stat_id` as `v_dovozce_stat_id`, `v`.`kod` as `v_kod`, `v`.`dovozce_ico` as `v_dovozce_ico`, `v`.`web` as `v_web`, `v`.`certifikat_cislo` as `v_certifikat_cislo`, `v`.`certifikat_datum` as `v_certifikat_datum`, `v`.`certifikat_datum_do` as `v_certifikat_datum_do`, `v`.`prohlaseni_cislo` as `v_prohlaseni_cislo`, `v`.`prohlaseni_datum` as `v_prohlaseni_datum`, `v`.`prohlaseni_vydavatel` as `v_prohlaseni_vydavatel`, `v`.`popis` as `v_popis`, `v`.`certif_organ_nazev` as `v_certif_organ_nazev`, `v`.`certif_organ_ulice` as `v_certif_organ_ulice`, `v`.`nazev` as `v_nazev`, `v`.`certif_organ_cp` as `v_certif_organ_cp`, `v`.`certif_organ_obec` as `v_certif_organ_obec`, `v`.`certif_organ_psc` as `v_certif_organ_psc`, `v`.`certif_organ_stat_id` as `v_certif_organ_stat_id`, `v`.`certif_organ_osvedceni` as `v_certif_organ_osvedceni`, `v`.`list_vyrobku` as `v_list_vyrobku`, `v`.`certifikat_shody` as `v_certifikat_shody`, `v`.`certifikat_shody_2` as `v_certifikat_shody_2`, `v`.`certifikat_shody_3` as `v_certifikat_shody_3`, `v`.`katalog` as `v_katalog`, `v`.`dalsi_info` as `v_dalsi_info`, `v`.`dalsi_info_2` as `v_dalsi_info_2`, `v`.`dalsi_info_3` as `v_dalsi_info_3`, `v`.`poznamka` as `v_poznamka`, `v`.`odeslan` as `v_odeslan`, `v`.`poznamka_sfzp` as `v_poznamka_sfzp`, `v`.`zadatel_id` as `v_zadatel_id`, `v`.`datum_odeslani` as `v_datum_odeslani`, `v`.`typ` as `v_typ`, `v`.`modifikace` as `v_modifikace`, `v`.`datum_email` as `v_datum_email`, `v`.`datum_emailu_zruseni` as `v_datum_emailu_zruseni`, `v`.`kontrola_dokladu` as `v_kontrola_dokladu`, `v`.`editor_parametru` as `v_editor_parametru`, `v`.`parametry_ok` as `v_parametry_ok`, `v`.`datum_elektronick_vyzvy` as `v_datum_elektronick_vyzvy`, `v`.`poznamka_pro_zadatele` as `v_poznamka_pro_zadatele`, `v`.`datum_email_vraceni` as `v_datum_email_vraceni`, `v`.`typ_kotle_np` as `v_typ_kotle_np`, `v`.`misto_vyroby` as `v_misto_vyroby`, `v`.`puvod_stat_id` as `v_puvod_stat_id`, `v`.`obrazek` as `v_obrazek`, `v`.`vyrobce_id` as `v_vyrobce_id`, `v`.`vyrobce_nazev` as `v_vyrobce_nazev`, `v`.`vyrobce_ulice` as `v_vyrobce_ulice`, `v`.`vyrobce_cp` as `v_vyrobce_cp`, `o`.`id` as `o_id`, `o`.`oznaceni` as `o_oznaceni`, `o`.`nazev` as `o_nazev` , `t`.`id` as `t_id`, `t`.`rodic_id` as `t_rodic_id`, `t`.`kod` as `t_kod`, `t`.`nazev` as `t_nazev`, `t`.`poradi` as `t_poradi`, `t`.`oblast_id` as `t_oblast_id`, `t`.`opatreni` as `t_opatreni`, `t`.`opatreni_id` as `t_opatreni_id`, `t`.`popisek` as `t_popisek`, `vt`.`id` as `vt_id`, `vt`.`id_1` as `vt_id_1`, `vt`.`id_2` as `vt_id_2`, `dv`.`id` as `dv_id`, `dv`.`id_1` as `dv_id_1`, `dv`.`id_2` as `dv_id_2` FROM sod_dodavatel_technologie AS `dt` INNER JOIN `sod_dodavatel` AS `dodavatel` ON 1 AND (`dodavatel`.`id` = `dt`.`id_1` AND `dodavatel`.`odeslan` = '2') INNER JOIN `sod_technologie` AS `tt` ON 1 AND (`tt`.`id` = `dt`.`id_2`) LEFT JOIN `sod_technologie` AS `t` ON 1 AND (`t`.`kod` = `tt`.`kod`) LEFT JOIN `svt_vyrobek_technologie` AS `vt` ON 1 AND (`vt`.`id_2` = `t`.`id`) LEFT JOIN `sod_dodavatel_vyrobce` AS `dv` ON 1 AND (`dv`.`id_1` = `dodavatel`.`id`) INNER JOIN `svt_vyrobek` AS `v` ON 1 AND (`v`.`id` = `vt`.`id_1` AND `v`.`program` <> '2') INNER JOIN `sod_oblast` AS `o` ON 1 AND (`o`.`id` = `t`.`oblast_id`) WHERE 1 AND (`v`.`odeslan` = '2' AND `v`.`vyrobce_id` = `dv`.`id_2` AND `t`.`id` IS NOT NULL AND `vt`.`id` IS NOT NULL AND `dv`.`id` IS NOT NULL AND `v`.`id` = '9788') GROUP BY `dodavatel`.`ico`, `v`.`id`, `o`.`id` ORDER BY `dodavatel`.`nazev` ASC
DATE: 27.01.2022 22:00:24