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' 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` , `d`.`file_potvrzeni_financniho_uradu` as `d_file_potvrzeni_financniho_uradu`, `d`.`datum_zmeny` as `d_datum_zmeny`, `d`.`fulltext` as `d_fulltext`, `d`.`poznamka_pro_zadatele_odeslat` as `d_poznamka_pro_zadatele_odeslat`, `d`.`poznamka_pro_zadatele_odeslano` as `d_poznamka_pro_zadatele_odeslano`, `d`.`timestamp` as `d_timestamp`, `d`.`rejstrik_obchod_vydani` as `d_rejstrik_obchod_vydani`, `d`.`rejstrik_obchod_platnost` as `d_rejstrik_obchod_platnost`, `d`.`plna_moc_vydani` as `d_plna_moc_vydani`, `d`.`plna_moc_platnost` as `d_plna_moc_platnost`, `d`.`rejstrik_trest_vydani` as `d_rejstrik_trest_vydani`, `d`.`rejstrik_trest_platnost` as `d_rejstrik_trest_platnost`, `d`.`osvedceni_zaskoleni` as `d_osvedceni_zaskoleni`, `d`.`certifikat9000_vydani` as `d_certifikat9000_vydani`, `d`.`certifikat9000_platnost` as `d_certifikat9000_platnost`, `d`.`certifikat14001_vydani` as `d_certifikat14001_vydani`, `d`.`certifikat14001_platnost` as `d_certifikat14001_platnost`, `d`.`certifikat_emas_vydani` as `d_certifikat_emas_vydani`, `d`.`certifikat_emas_platnost` as `d_certifikat_emas_platnost`, `d`.`certifikat_dalsi` as `d_certifikat_dalsi`, `d`.`rejstrik_obchod` as `d_rejstrik_obchod`, `d`.`plna_moc` as `d_plna_moc`, `d`.`rejstrik_trest` as `d_rejstrik_trest`, `d`.`certifikat9000` as `d_certifikat9000`, `d`.`certifikat14001` as `d_certifikat14001`, `d`.`certifikat_emas` as `d_certifikat_emas`, `d`.`id` as `d_id`, `d`.`web` as `d_web`, `d`.`tel` as `d_tel`, `d`.`fax` as `d_fax`, `d`.`zaslani_nazev` as `d_zaslani_nazev`, `d`.`zaslani_osoba` as `d_zaslani_osoba`, `d`.`zaslani_osoba_email` as `d_zaslani_osoba_email`, `d`.`zaslani_osoba_tel` as `d_zaslani_osoba_tel`, `d`.`heslo` as `d_heslo`, `d`.`zaslani_ulice` as `d_zaslani_ulice`, `d`.`zaslani_cp` as `d_zaslani_cp`, `d`.`zaslani_obec` as `d_zaslani_obec`, `d`.`zaslani_psc` as `d_zaslani_psc`, `d`.`zaslani_stat` as `d_zaslani_stat`, `d`.`nazev` as `d_nazev`, `d`.`zamestnanci` as `d_zamestnanci`, `d`.`zamestnanci_odborni` as `d_zamestnanci_odborni`, `d`.`zakazky_solar` as `d_zakazky_solar`, `d`.`zakazky_cerpadla` as `d_zakazky_cerpadla`, `d`.`zakazky_kotle` as `d_zakazky_kotle`, `d`.`zakazky_zateplovani` as `d_zakazky_zateplovani`, `d`.`zakazky_vyplne` as `d_zakazky_vyplne`, `d`.`zakazky_pasdomy` as `d_zakazky_pasdomy`, `d`.`zelena_usporam` as `d_zelena_usporam`, `d`.`poznamka` as `d_poznamka`, `d`.`sidlo_ulice` as `d_sidlo_ulice`, `d`.`zahajeni_podnikani` as `d_zahajeni_podnikani`, `d`.`zapis_do_seznamu` as `d_zapis_do_seznamu`, `d`.`pravni_forma_id` as `d_pravni_forma_id`, `d`.`file_vypis_rejstriku_trestu` as `d_file_vypis_rejstriku_trestu`, `d`.`file_cestne_prohlaseni_likvidace` as `d_file_cestne_prohlaseni_likvidace`, `d`.`file_vypis_obchodni_rejstrik` as `d_file_vypis_obchodni_rejstrik`, `d`.`vyrobci` as `d_vyrobci`, `d`.`odeslan` as `d_odeslan`, `d`.`poznamka_sfzp` as `d_poznamka_sfzp`, `d`.`datum_odeslani` as `d_datum_odeslani`, `d`.`datum_registarce` as `d_datum_registarce`, `d`.`datum_email` as `d_datum_email`, `d`.`kontrola_vyrobce` as `d_kontrola_vyrobce`, `d`.`sidlo_cp` as `d_sidlo_cp`, `d`.`kontrola_dokladu` as `d_kontrola_dokladu`, `d`.`datum_emailu_zruseni` as `d_datum_emailu_zruseni`, `d`.`datum_elektronick_vyzvy` as `d_datum_elektronick_vyzvy`, `d`.`poznamka_pro_zadatele` as `d_poznamka_pro_zadatele`, `d`.`datum_email_vraceni` as `d_datum_email_vraceni`, `d`.`sidlo_obec` as `d_sidlo_obec`, `d`.`datova_schranka` as `d_datova_schranka`, `d`.`sidlo_psc` as `d_sidlo_psc`, `d`.`sidlo_stat` as `d_sidlo_stat`, `d`.`trvaly_pobyt_ulice` as `d_trvaly_pobyt_ulice`, `d`.`trvaly_pobyt_cp` as `d_trvaly_pobyt_cp`, `d`.`trvaly_pobyt_obec` as `d_trvaly_pobyt_obec`, `d`.`trvaly_pobyt_psc` as `d_trvaly_pobyt_psc`, `d`.`trvaly_pobyt_stat` as `d_trvaly_pobyt_stat`, `d`.`ico` as `d_ico`, `d`.`dic` as `d_dic`, `d`.`email` as `d_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`, `vyrobek`.`fulltext` as `vyrobek_fulltext`, `vyrobek`.`timestamp` as `vyrobek_timestamp`, `vyrobek`.`dovozce_dic` as `vyrobek_dovozce_dic`, `vyrobek`.`dovozce_email` as `vyrobek_dovozce_email`, `vyrobek`.`dovozce_datova_schranka` as `vyrobek_dovozce_datova_schranka`, `vyrobek`.`vyrobce_dic` as `vyrobek_vyrobce_dic`, `vyrobek`.`vyrobce_email` as `vyrobek_vyrobce_email`, `vyrobek`.`vyrobce_datova_schranka` as `vyrobek_vyrobce_datova_schranka`, `vyrobek`.`dokumenty` as `vyrobek_dokumenty`, `vyrobek`.`zadatel_role` as `vyrobek_zadatel_role`, `vyrobek`.`envi` as `vyrobek_envi`, `vyrobek`.`envi_datum_vystaveni` as `vyrobek_envi_datum_vystaveni`, `vyrobek`.`envi_datum_platnosti` as `vyrobek_envi_datum_platnosti`, `vyrobek`.`technologie_id` as `vyrobek_technologie_id`, `vyrobek`.`subtechnologie_id` as `vyrobek_subtechnologie_id`, `vyrobek`.`id` as `vyrobek_id`, `vyrobek`.`vyrobce_obec` as `vyrobek_vyrobce_obec`, `vyrobek`.`vyrobce_psc` as `vyrobek_vyrobce_psc`, `vyrobek`.`vyrobce_stat_id` as `vyrobek_vyrobce_stat_id`, `vyrobek`.`vyrobce_ico` as `vyrobek_vyrobce_ico`, `vyrobek`.`dovozce_nazev` as `vyrobek_dovozce_nazev`, `vyrobek`.`program` as `vyrobek_program`, `vyrobek`.`dovozce_ulice` as `vyrobek_dovozce_ulice`, `vyrobek`.`dovozce_cp` as `vyrobek_dovozce_cp`, `vyrobek`.`dovozce_obec` as `vyrobek_dovozce_obec`, `vyrobek`.`dovozce_psc` as `vyrobek_dovozce_psc`, `vyrobek`.`dovozce_stat_id` as `vyrobek_dovozce_stat_id`, `vyrobek`.`kod` as `vyrobek_kod`, `vyrobek`.`dovozce_ico` as `vyrobek_dovozce_ico`, `vyrobek`.`web` as `vyrobek_web`, `vyrobek`.`certifikat_cislo` as `vyrobek_certifikat_cislo`, `vyrobek`.`certifikat_datum` as `vyrobek_certifikat_datum`, `vyrobek`.`certifikat_datum_do` as `vyrobek_certifikat_datum_do`, `vyrobek`.`prohlaseni_cislo` as `vyrobek_prohlaseni_cislo`, `vyrobek`.`prohlaseni_datum` as `vyrobek_prohlaseni_datum`, `vyrobek`.`prohlaseni_vydavatel` as `vyrobek_prohlaseni_vydavatel`, `vyrobek`.`popis` as `vyrobek_popis`, `vyrobek`.`certif_organ_nazev` as `vyrobek_certif_organ_nazev`, `vyrobek`.`certif_organ_ulice` as `vyrobek_certif_organ_ulice`, `vyrobek`.`nazev` as `vyrobek_nazev`, `vyrobek`.`certif_organ_cp` as `vyrobek_certif_organ_cp`, `vyrobek`.`certif_organ_obec` as `vyrobek_certif_organ_obec`, `vyrobek`.`certif_organ_psc` as `vyrobek_certif_organ_psc`, `vyrobek`.`certif_organ_stat_id` as `vyrobek_certif_organ_stat_id`, `vyrobek`.`certif_organ_osvedceni` as `vyrobek_certif_organ_osvedceni`, `vyrobek`.`list_vyrobku` as `vyrobek_list_vyrobku`, `vyrobek`.`certifikat_shody` as `vyrobek_certifikat_shody`, `vyrobek`.`certifikat_shody_2` as `vyrobek_certifikat_shody_2`, `vyrobek`.`certifikat_shody_3` as `vyrobek_certifikat_shody_3`, `vyrobek`.`katalog` as `vyrobek_katalog`, `vyrobek`.`dalsi_info` as `vyrobek_dalsi_info`, `vyrobek`.`dalsi_info_2` as `vyrobek_dalsi_info_2`, `vyrobek`.`dalsi_info_3` as `vyrobek_dalsi_info_3`, `vyrobek`.`poznamka` as `vyrobek_poznamka`, `vyrobek`.`odeslan` as `vyrobek_odeslan`, `vyrobek`.`poznamka_sfzp` as `vyrobek_poznamka_sfzp`, `vyrobek`.`zadatel_id` as `vyrobek_zadatel_id`, `vyrobek`.`datum_odeslani` as `vyrobek_datum_odeslani`, `vyrobek`.`typ` as `vyrobek_typ`, `vyrobek`.`modifikace` as `vyrobek_modifikace`, `vyrobek`.`datum_email` as `vyrobek_datum_email`, `vyrobek`.`datum_emailu_zruseni` as `vyrobek_datum_emailu_zruseni`, `vyrobek`.`kontrola_dokladu` as `vyrobek_kontrola_dokladu`, `vyrobek`.`editor_parametru` as `vyrobek_editor_parametru`, `vyrobek`.`parametry_ok` as `vyrobek_parametry_ok`, `vyrobek`.`datum_elektronick_vyzvy` as `vyrobek_datum_elektronick_vyzvy`, `vyrobek`.`poznamka_pro_zadatele` as `vyrobek_poznamka_pro_zadatele`, `vyrobek`.`datum_email_vraceni` as `vyrobek_datum_email_vraceni`, `vyrobek`.`typ_kotle_np` as `vyrobek_typ_kotle_np`, `vyrobek`.`misto_vyroby` as `vyrobek_misto_vyroby`, `vyrobek`.`puvod_stat_id` as `vyrobek_puvod_stat_id`, `vyrobek`.`obrazek` as `vyrobek_obrazek`, `vyrobek`.`vyrobce_id` as `vyrobek_vyrobce_id`, `vyrobek`.`vyrobce_nazev` as `vyrobek_vyrobce_nazev`, `vyrobek`.`vyrobce_ulice` as `vyrobek_vyrobce_ulice`, `vyrobek`.`vyrobce_cp` as `vyrobek_vyrobce_cp`, `zadatel`.`timestamp` as `zadatel_timestamp`, `zadatel`.`dic` as `zadatel_dic`, `zadatel`.`datova_schranka` as `zadatel_datova_schranka`, `zadatel`.`typ` as `zadatel_typ`, `zadatel`.`kontakt_jmeno` as `zadatel_kontakt_jmeno`, `zadatel`.`kontakt_prijmeni` as `zadatel_kontakt_prijmeni`, `zadatel`.`kontakt_titul` as `zadatel_kontakt_titul`, `zadatel`.`kontakt_email` as `zadatel_kontakt_email`, `zadatel`.`kontakt_telefon` as `zadatel_kontakt_telefon`, `zadatel`.`dokumenty` as `zadatel_dokumenty`, `zadatel`.`id` as `zadatel_id`, `zadatel`.`sidlo_cp` as `zadatel_sidlo_cp`, `zadatel`.`sidlo_obec` as `zadatel_sidlo_obec`, `zadatel`.`sidlo_psc` as `zadatel_sidlo_psc`, `zadatel`.`sidlo_stat_id` as `zadatel_sidlo_stat_id`, `zadatel`.`ico` as `zadatel_ico`, `zadatel`.`email` as `zadatel_email`, `zadatel`.`poznamka_sfzp` as `zadatel_poznamka_sfzp`, `zadatel`.`tel` as `zadatel_tel`, `zadatel`.`web` as `zadatel_web`, `zadatel`.`fax` as `zadatel_fax`, `zadatel`.`heslo` as `zadatel_heslo`, `zadatel`.`nazev` as `zadatel_nazev`, `zadatel`.`datum_registrace` as `zadatel_datum_registrace`, `zadatel`.`pravni_forma_id` as `zadatel_pravni_forma_id`, `zadatel`.`trvaly_pobyt_ulice` as `zadatel_trvaly_pobyt_ulice`, `zadatel`.`trvaly_pobyt_cp` as `zadatel_trvaly_pobyt_cp`, `zadatel`.`trvaly_pobyt_obec` as `zadatel_trvaly_pobyt_obec`, `zadatel`.`trvaly_pobyt_psc` as `zadatel_trvaly_pobyt_psc`, `zadatel`.`trvaly_pobyt_stat_id` as `zadatel_trvaly_pobyt_stat_id`, `zadatel`.`sidlo_ulice` as `zadatel_sidlo_ulice`, `vyrobce`.`id` as `vyrobce_id`, `vyrobce`.`vyrobce_ico` as `vyrobce_vyrobce_ico`, `vyrobce`.`timestamp` as `vyrobce_timestamp`, `vyrobce`.`vyrobce_email` as `vyrobce_vyrobce_email`, `vyrobce`.`vyrobce_datova_schranka` as `vyrobce_vyrobce_datova_schranka`, `vyrobce`.`nazev` as `vyrobce_nazev`, `vyrobce`.`zadatel_id` as `vyrobce_zadatel_id`, `vyrobce`.`vyrobce_ulice` as `vyrobce_vyrobce_ulice`, `vyrobce`.`vyrobce_cp` as `vyrobce_vyrobce_cp`, `vyrobce`.`vyrobce_obec` as `vyrobce_vyrobce_obec`, `vyrobce`.`vyrobce_psc` as `vyrobce_vyrobce_psc`, `vyrobce`.`vyrobce_stat_id` as `vyrobce_vyrobce_stat_id`, `vyrobce`.`vyrobce_dic` as `vyrobce_vyrobce_dic`, `oblast`.`id` as `oblast_id`, `oblast`.`oznaceni` as `oblast_oznaceni`, `oblast`.`nazev` as `oblast_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 `d` ON 1 AND (`d`.`id` = `dt`.`id_1` AND `d`.`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` = `d`.`id`) INNER JOIN `svt_vyrobek` AS `vyrobek` ON 1 AND (`vyrobek`.`id` = `vt`.`id_1` AND `vyrobek`.`program` <> '2') INNER JOIN `svt_zadatel` AS `zadatel` ON 1 AND (`vyrobek`.`zadatel_id` = `zadatel`.`id`) INNER JOIN `sod_vyrobci` AS `vyrobce` ON 1 AND (`vyrobek`.`vyrobce_id` = `vyrobce`.`id`) INNER JOIN `sod_oblast` AS `oblast` ON 1 AND (`oblast`.`id` = `t`.`oblast_id`) WHERE 1 AND (`vyrobek`.`odeslan` = '2' AND `vyrobek`.`vyrobce_id` = `dv`.`id_2` AND `t`.`id` IS NOT NULL AND `vt`.`id` IS NOT NULL AND `dv`.`id` IS NOT NULL AND `dt`.`id_1` = '319') GROUP BY `d`.`ico`, `vyrobek`.`id`, `oblast`.`id` ORDER BY `vyrobek`.`nazev` ASC
DATE: 18.09.2019 02:45:19