FILE: /var/www/zelenausporam.cz/web/vyhledavani/admin/cfg/libs_parser/module/overview.inc.php
LINE: 1
ERROR: Table 'zelenausporamcz_data.sod_dodavatel_vyrobce' 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`.`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`.`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`.`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`.`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`.`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`.`poznamka_pro_zadatele` as `vyrobek_poznamka_pro_zadatele`, `vyrobek`.`datum_email_vraceni` as `vyrobek_datum_email_vraceni`, `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`.`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`.`nazev` as `vyrobce_nazev`, `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`) 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` = '21475') GROUP BY `d`.`ico`, `vyrobek`.`id`, `oblast`.`id` ORDER BY `vyrobek`.`nazev` ASC
DATE: 23.10.2017 00:45:31