Kontakty

        SELECT  SQL_CALC_FOUND_ROWS `pod`.`url` as `pod_url`, `pod`.`id` as `pod_id`, `pod`.`cilove_skupiny` as `pod_cilove_skupiny`, `pod`.`eu_navstevnost` as `pod_eu_navstevnost`, `pod`.`navstevnost_relative` as `pod_navstevnost_relative`, `pod`.`akvizicni_minimum_id` as `pod_akvizicni_minimum_id`, `pod`.`nastroj` as `pod_nastroj`, `pod`.`sledovany_cil` as `pod_sledovany_cil`, `pod`.`omezeni` as `pod_omezeni`, `pod`.`short_url` as `pod_short_url`, `pod`.`zadost` as `pod_zadost`, `pod`.`zadost_url` as `pod_zadost_url`, `pod`.`konsorcialni_dohoda` as `pod_konsorcialni_dohoda`, `pod`.`navstevnost` as `pod_navstevnost`, `pod`.`use_okec` as `pod_use_okec`, `pod`.`use_nace` as `pod_use_nace`, `pod`.`minimalni_pocet_ucastniku` as `pod_minimalni_pocet_ucastniku`, `pod`.`historie` as `pod_historie`, `pod`.`historie_do` as `pod_historie_do`, `pod`.`da_navstevnost` as `pod_da_navstevnost`, `pod`.`forma` as `pod_forma`, `pod`.`rozsah_podpory` as `pod_rozsah_podpory`, `pod`.`max_vyse_podpory` as `pod_max_vyse_podpory`, `pod`.`celkovy_rozpocet_vyzvy` as `pod_celkovy_rozpocet_vyzvy`, `pod`.`rozsah_uznatelnych_nakladu` as `pod_rozsah_uznatelnych_nakladu`, `pod`.`usefor` as `pod_usefor`, `pod`.`umisteni_id` as `pod_umisteni_id`, `pod`.`UN` as `pod_UN`, `pod`.`typ_dotace` as `pod_typ_dotace`, `pod`.`typ_dotace_real` as `pod_typ_dotace_real`, `pod`.`NUN` as `pod_NUN`, `pod`.`pocatek_prijmu` as `pod_pocatek_prijmu`, `pod`.`ukonceni_prijmu` as `pod_ukonceni_prijmu`, `pod`.`ukonceni_prijmu_viditelnost` as `pod_ukonceni_prijmu_viditelnost`, `pod`.`poznamka` as `pod_poznamka`, `pod`.`zahranicni_pomoc` as `pod_zahranicni_pomoc`, `pod`.`misto_podani_zadosti` as `pod_misto_podani_zadosti`, `pod`.`zahranicni_pomoc_real` as `pod_zahranicni_pomoc_real`, `pod`.`dotacni_kalendar` as `pod_dotacni_kalendar`, `pod`.`use_for` as `pod_use_for`, `pod`.`kontakty` as `pod_kontakty`, `pod`.`use_for_umisteni` as `pod_use_for_umisteni`, `pod`.`use_for_real` as `pod_use_for_real`, `pod`.`souvisejici_dokumenty` as `pod_souvisejici_dokumenty`, `pod`.`euroskop` as `pod_euroskop`, `pod`.`faq` as `pod_faq`, `pod`.`priorita` as `pod_priorita`, `pod`.`datum_vlozeni` as `pod_datum_vlozeni`, `pod`.`nazev` as `pod_nazev`, `pod`.`pripravovana` as `pod_pripravovana`, `pod`.`specifikace_prijemce` as `pod_specifikace_prijemce`, `pod`.`reklama_detail` as `pod_reklama_detail`, `pod`.`perex` as `pod_perex`, `pod`.`razitko` as `pod_razitko`, `pod`.`datum_publikace` as `pod_datum_publikace`, `pod`.`visible` as `pod_visible`, `pod`.`archiv` as `pod_archiv`, `pod`.`zmena` as `pod_zmena`, `pod`.`zmena_newsletter` as `pod_zmena_newsletter`, `pod`.`poradove_cislo` as `pod_poradove_cislo`, `pod`.`rok_vyzvy` as `pod_rok_vyzvy`, `pod`.`predmet` as `pod_predmet`
 
 
 
 FROM ed_titul AS `pod`
   WHERE 1 AND (`pod`.`pocatek_prijmu` <= NOW() AND `pod`.`pocatek_prijmu` <> '0000-00-00' AND `pod`.`visible` = '1')
 
 
 ORDER BY `pod`.`pocatek_prijmu` DESC  LIMIT 4