Ako nájsť brigádu jak-najit-brigadu
Pre tieto lokality nie sú žiadne ponuky,

zobraziť >>

Nábor ľudí do databázy (1)
Pre tieto lokality nie sú žiadne ponuky,

zobraziť >>

Administratívny pracovník Asistent - administratíva Sekretárka Finančný poradca, špecialista v banke Pokladník, pokladníčka Účtovníčka Bezpečnostná služba Vrátnik Realitný maklér Programátor, webmaster, kodér Grafik Komparz Kuriér, vodič dodávky Letuška, stevard Vodič/vodička Skladník Copywriter Online marketing (reklama, PPC, sociálne siete) Personalista, recruiter Doplňovač tovaru, merchandiser Hosteska, promotér Obchodný zástupca, asistent, manažér Pracovník call centra Predavač/ka Doučovanie Opatrovanie detí Obsluha čerpacej stanice Záhradník Vysokoškolský učiteľ Opatrovateľ, ošetrovateľ, osobný asistent Animátor Čašník, servírka Delegát cestovnej kancelárie, sprievodca Kuchár, šéfkuchár Plavčík Chyžná Predajca zájazdov Recepčná Tlmočník, prekladateľ Anketár, marketingový výskum Gazdiná Distribúcia letákov Upratovačka Predajca áut Ostatné - automobilový priemysel Odborný pracovník, asistent Krupiér Domovník, správca objektu Módny návrhár Au-pair Elektrikár, elektrotechnik Projektant, architekt, inžinier Ostatné - doprava a zásobovanie Lektor, inštruktor Výrobný pracovník, montér Ostatné - služby Ostatné Pracovník v potravinárstve Manažér, pracovník prevádzky Kontrolór kvality Robotník, pomocný pracovník Zákaznícka podpora (pasívna), helpdesk Dokončenie výrobkov Brigáda na stavenisku Hosteska na výstavisku, v reštaurácii, privítanie Kozmetička, vizážistka, kaderníčka, manikérka Brigáda v zdravotníctve Mystery shopping (tajné nakupovanie) Stánkový predaj (zmrzlina, občerstvenie, ovocie) Venčenie psov, starostlivosť o domáce zvieratá Aktívna ponuka služieb/produktov Marketing (priame oslovenie klientov) Distribúcia letákov s ponukou produktov/služieb Priamy predaj - MLM Lektor/ka skupín, kurzov Modelka vlasov Ostatné (iné dočasné práce) Dohadovanie schôdzok Humanitárna pomoc Barman/ka Operátor/ka výroby Práca v rýchlom občerstvení Vodič, kuriér - nábor Zber ovocia a iných plodín Pomocná sila v kuchyni Sťahovanie, vypratávanie Vkladanie dát do PC, systému Balenie oblečenia, tovaru Usporiadateľ/ka, organizátor/ka

V súčasnosti nie sú pre lokalitu žiadne aktívne ponuky. Nižšie nájdete inzeráty pre okres Rožňava.

Brigády Rožňava vhodné pre OZP

Brigády Rožňava sú vždy overené a aktuálne. Ponuky vhodné pre OZP u nás nájdete v mestách po celej Slovenskej republike. Hľadáš si ju aj ty? Na portáli Fajn-brigady.sk nájdeš najväčšiu ponuku voľných pozícií.

Prevádzkovateľ portálu
Fajn skupina pracovných
portálov s. r. o.
Žilinská 1
81105 Bratislava
© Copyright 2022
Fajn-brigady.sk - denne aktuálna
ponuka brigád z celej SR i zahraničia

s.id=>76

s.kontroler=>inzeraty/vypis/hlavni/i.vypis.hlavni.php

s.kontroler1=>inzeraty/vypis/hlavni/k.i.vypis.hlavni.php

s.uri_cs=>/brigady/*

s.nazev_cz=>Inzeráty výpis

s.titulek_cz=>Inzeráty výpis

s.popis_cz=>Inzeráty výpis

s.nazev_sk=>Inzeráty výpis

s.titulek_sk=>Inzeráty výpis

s.popis_sk=>Inzeráty výpis

s.autorizovany_uchazec=>vse

titulek=>Inzeráty výpis

popis=>Hľadáš si brigádu na jednorazový alebo dlhodobý privyrobenie pre OZP? Nájdi si ju u nás na portáli, kde sú iba aktuálne a overené ponuky. Brigády máme po celej SR aj v lokalite Rožňava.

1) 0.032975
select nazev_sk as nazev, nazev_cz `nazev_cz`, nazev_sk `nazev_sk`, ident `ident`, id_sekce `id_sekce` from preklady where zobraz_sk = "1"

2) 0.003712
select presm.id `presm.id`, presm.cil `presm.cil`, presm.status `presm.status` from presmerovani presm where (presm.zdroj = "https://www.fajn-brigady.sk/brigady/roznava/ozp/" and presm.shoda = "presna" ) or (locate(presm.zdroj, "https://www.fajn-brigady.sk/brigady/roznava/ozp/%") > 0 and presm.shoda = "volna" )

3) 0.000749
select ip `ip` from ip_blokace where ip = "216.73.216.212" and archiv = "0"

4) 0.002127
select hled_vyr.id `hled_vyr.id`, hled_vyr.`poz.id` `hled_vyr.poz.id`, hled_vyr.`vhod.id` `hled_vyr.vhod.id`, hled_vyr.`benef.id` `hled_vyr.benef.id`, hled_vyr.titulek_cz `hled_vyr.titulek_cz` from hledane_vyrazy hled_vyr where (hled_vyr.ident_cz = "/brigady/roznava/ozp/" or hled_vyr.ident_sk = "/brigady/roznava/ozp/" )

5) 0.001103
select s.id `s.id`, s.uri_sk `s.uri_sk` from stranky s where 1 and s.archiv = "0" and s.`pr.id` = "1" and s.stara_url_fb = "0" and s.id not in (10)

6) 0.000635
select s.id `s.id`, s.kontroler `s.kontroler`, s.kontroler1 `s.kontroler1`, s.uri_cs `s.uri_cs`, s.nazev_cz `s.nazev_cz`, s.titulek_cz `s.titulek_cz`, s.popis_cz `s.popis_cz`, s.nazev_sk `s.nazev_sk`, s.titulek_sk `s.titulek_sk`, s.popis_sk `s.popis_sk`, s.autorizovany_uchazec `s.autorizovany_uchazec` from stranky s where 1 and s.archiv = "0" and s.stara_url_fb = "0" and s.id = "76" and s.`pr.id`="1"

7) 0.047309
select `i.st.id2` from inzeraty_select i where `i.st.id2` > 0 and `i.titulek_cz`="" and `i.st.id2` != "2" and `i.web` = "1" group by `i.st.id2`

8) 0.001558
select menu_pol.nazev_sk `menu_pol.nazev`, s.id `s.id`, s.uri_sk `s.url` from menu_polozky menu_pol join stranky s on s.id = menu_pol.stranky_id where menu_pol.zobraz = "1" and s.autorizovany_uchazec in("vse", "neprihlaseny") and s.`pr_jaz.id` = "1"

9) 0.018258
select SQL_CALC_FOUND_ROWS * from ( (select 1 rank, `i.titulek_cz`, `i.popis_cz`, `i.titulek_sk`, `i.popis_sk`, `i.st.id2`, `i.se_i.id`, `i.kr.id`, `i.okr.id`, `i.ob.id`, `i.kat_brig.id`, `i.obor.id`, `i.poz.id`, `i.uvaz.id`, `i.mzda_od_mesicne_float`, `i.mzda_do_mesicne`, `i.datum_schvaleni`, `i.datum_upravy`, `i.datum_aktualizace`, `i.vek.ids`, `i.min_vzd.id`, `i.inzer.id`, `fi.koncovka1`, `i.poh.ids`, `u.id`, `fi.id`, `fi.nazev`, `fi.overena_firma_1`, `fi.odpovime_ihned`, `i.firma_nazev`, `u.firma_nazev`, `i.id`, `i.cela_cr`, `i.cela_sk`, `poradi`, `poradi_datum`, `i.zdroj`, `zvyh.top`, `zvyh.vip`, `i.datum` from inzeraty_select i where 1=1 and `i.web` = "1" and `i.st.id2`="2" and `i.se_i.id` = "1" and `i.jaz_sk` = "1" and `i.okr.id` = "106" and `i.kr.id` = "17" and `i.ob.id` in("2751") and `i.vhod.id` REGEXP ",4," and `i.jaz_sk`="1" ) union all (select 2 rank, `i.titulek_cz`, `i.popis_cz`, `i.titulek_sk`, `i.popis_sk`, `i.st.id2`, `i.se_i.id`, `i.kr.id`, `i.okr.id`, `i.ob.id`, `i.kat_brig.id`, `i.obor.id`, `i.poz.id`, `i.uvaz.id`, `i.mzda_od_mesicne_float`, `i.mzda_do_mesicne`, `i.datum_schvaleni`, `i.datum_upravy`, `i.datum_aktualizace`, `i.vek.ids`, `i.min_vzd.id`, `i.inzer.id`, `fi.koncovka1`, `i.poh.ids`, `u.id`, `fi.id`, `fi.nazev`, `fi.overena_firma_1`, `fi.odpovime_ihned`, `i.firma_nazev`, `u.firma_nazev`, `i.id`, `i.cela_cr`, `i.cela_sk`, `poradi`, `poradi_datum`, `i.zdroj`, `zvyh.top`, `zvyh.vip`, `i.datum` from inzeraty_select i where 1=1 and `i.web` = "1" and `i.ob.id` != "2751" and `i.st.id2`="2" and `i.se_i.id` = "1" and `i.jaz_sk` = "1" and `i.okr.id` = "106" and `i.kr.id` = "17" and `i.vhod.id` REGEXP ",4," and `i.jaz_sk`="1" ) union all (select 3 rank, `i.titulek_cz`, `i.popis_cz`, `i.titulek_sk`, `i.popis_sk`, `i.st.id2`, `i.se_i.id`, `i.kr.id`, `i.okr.id`, `i.ob.id`, `i.kat_brig.id`, `i.obor.id`, `i.poz.id`, `i.uvaz.id`, `i.mzda_od_mesicne_float`, `i.mzda_do_mesicne`, `i.datum_schvaleni`, `i.datum_upravy`, `i.datum_aktualizace`, `i.vek.ids`, `i.min_vzd.id`, `i.inzer.id`, `fi.koncovka1`, `i.poh.ids`, `u.id`, `fi.id`, `fi.nazev`, `fi.overena_firma_1`, `fi.odpovime_ihned`, `i.firma_nazev`, `u.firma_nazev`, `i.id`, `i.cela_cr`, `i.cela_sk`, `poradi`, `poradi_datum`, `i.zdroj`, `zvyh.top`, `zvyh.vip`, `i.datum` from inzeraty_select i where 1=1 and `i.web` = "1" and `i.ob.id` != "2751" and `i.okr.id` != "106" and `i.st.id2`="2" and `i.se_i.id` = "1" and `i.jaz_sk` = "1" and `i.kr.id` = "17" and `i.vhod.id` REGEXP ",4," and `i.jaz_sk`="1" limit 5 ) union all (select 4 rank, `i.titulek_cz`, `i.popis_cz`, `i.titulek_sk`, `i.popis_sk`, `i.st.id2`, `i.se_i.id`, `i.kr.id`, `i.okr.id`, `i.ob.id`, `i.kat_brig.id`, `i.obor.id`, `i.poz.id`, `i.uvaz.id`, `i.mzda_od_mesicne_float`, `i.mzda_do_mesicne`, `i.datum_schvaleni`, `i.datum_upravy`, `i.datum_aktualizace`, `i.vek.ids`, `i.min_vzd.id`, `i.inzer.id`, `fi.koncovka1`, `i.poh.ids`, `u.id`, `fi.id`, `fi.nazev`, `fi.overena_firma_1`, `fi.odpovime_ihned`, `i.firma_nazev`, `u.firma_nazev`, `i.id`, `i.cela_cr`, `i.cela_sk`, `poradi`, `poradi_datum`, `i.zdroj`, `zvyh.top`, `zvyh.vip`, `i.datum` from inzeraty_select i where 1=1 and `i.se_i.id`="1" and `i.web` = "1" and (`zvyh.top`="1" or `zvyh.vip`="1") and `i.cela_sk` = "1" and `i.jaz_sk`="1" limit 3 ) ) a group by (a.`i.id`) order by rank asc, `zvyh.top` = "1" desc, `i.zdroj` = "0" desc, poradi asc, poradi_datum desc, `i.cela_cr`="0" desc, `i.cela_sk`="0" desc limit 0, 40

10) 0.000397
SELECT FOUND_ROWS()

11) 0.000703
select seo_text.id `seo_text.id`, seo_text.text_horni_sk `seo_text.text_horni`, seo_text.text_spodni_sk `seo_text.text_spodni`, seo_text.popis_meta_sk `seo_text.popis_meta`, seo_text.titulek_meta_sk `seo_text.titulek_meta`, seo_text.nadpis_h1_sk `seo_text.nadpis_h1` from seo_texty seo_text where seo_text.archiv = "0" and seo_text.`pr.id` = "1" and seo_text.`ob.id` = "2751" and seo_text.`kr.id` = "17" and seo_text.`st.id1` = "2" and seo_text. `okr.id` = "106" and seo_text.`se_i.id` = "1" and seo_text.`obor.id` is null and seo_text.`vhod.id` = "4" and seo_text.`uvaz.id` is null and seo_text.`benefity.id` is null and seo_text.`poz.id` is null and seo_text.`kat_brig.id` is null

12) 0.001303
select seo_text_vych.id `seo_text.id`, seo_text_vych.text_horni_sk `seo_text.text_horni`, seo_text_vych.text_spodni_sk `seo_text.text_spodni`, seo_text_vych.popis_meta_sk `seo_text.popis_meta`, seo_text_vych.titulek_meta_sk `seo_text.titulek_meta`, seo_text_vych.nadpis_h1_sk `seo_text.nadpis_h1` from seo_texty_vychozi seo_text_vych where seo_text_vych.archiv = "0" and seo_text_vych.`pr.id` = "1" and seo_text_vych.typ_lokality = "mesto" and seo_text_vych.mesto = "1" and seo_text_vych.staty = "0" and seo_text_vych.sekce_inzeraty_id = "1" and seo_text_vych.obory = "0" and seo_text_vych.pozice = "0" and seo_text_vych.vzdelani = "0" and seo_text_vych.benefity = "0" and seo_text_vych.vhodne_pro = "1" and seo_text_vych.kategorie_brigad is null and seo_text_vych.inzerent = "0" and seo_text_vych.uvazek = "0"

13) 0.001539
select count(*) `pocet_inzeratu` from inzeraty_select i where 1 and `i.ob.id` = "2751" and `i.se_i.id` = "1" and `i.vhod.id` like "%,4,%"

14) 0.003793
select cl.id `cl.id`, cl.ident_cs `cl.ident_cs`, cl.ident_sk `cl.ident_sk`, cl.nazev_cs `cl.nazev_cs`, cl.nazev_sk `cl.nazev_sk`, cl.`se_cl.id-iw` `cl.se_cl.id-iw`, cl.`se_cl.id-fb` `cl.se_cl.id-fb`, cl.obrazek `cl.obrazek` from clanky cl where cl.`jaz.ids` REGEXP ",1," and cl.zobraz_sk = "1" and cl.datum_publikace <= "2025-09-28" and cl.`ident_sk` != "" order by rand() limit 2

15) 0.003093
select vid.id `vid.id`, vid.ident_cz `vid.ident_cz`, vid.nazev_cz `vid.nazev_cz`, vid.`se_vid.id` `vid.se_vid.id`, vid.obrazek1 `vid.obrazek1` from (select * from videa where zobraz_cz = "1" and `pr.id` = "1" order by `zobrazeni` desc limit 20) vid where vid.zobraz_cz = "1" and vid.`pr.id` = "1" and vid.archiv = "0" order by rand() limit 3

16) 0.002323
select rekl_ban.id `rekl_ban.id`, rekl_ban.url `rekl_ban.url`, rekl_ban.titulek_cz `rekl_ban.titulek_cz`, rekl_ban.prokliku `rekl_ban.prokliku`, rekl_ban.zobrazeni `rekl_ban.zobrazeni`, rekl_ban.max_pocet_zobrazeni `rekl_ban.max_pocet_zobrazeni`, rekl_ban.max_pocet_prokliku `rekl_ban.max_pocet_prokliku`, rekl_ban.popis_cz `rekl_ban.popis_cz`, rekl_ban.obrazek1 `rekl_ban.obrazek1`, rekl_ban.od `rekl_ban.od`, rekl_ban.do `rekl_ban.do`, rekl_ban.zahranici `rekl_ban.zahranici`, rekl_ban.obrazek_editor `rekl_ban.obrazek_editor`, rekl_ban.editor `rekl_ban.editor`, rekl_ban.prepinac `rekl_ban.prepinac`, rekl_ban.script_reklama `rekl_ban.script_reklama` from reklamni_bannery rekl_ban where rekl_ban.reklamni_bannery_umisteni_id = 34 and rekl_ban.zobraz = "1" and rekl_ban.archiv = "0" and rekl_ban.smazano = "0" and case when rekl_ban.max_pocet_zobrazeni is null then 1 else rekl_ban.zobrazeni <= rekl_ban.max_pocet_zobrazeni end and case when rekl_ban.max_pocet_prokliku is null then 1 else rekl_ban.prokliku <= rekl_ban.max_pocet_prokliku end and case when rekl_ban.do is null then 1 else rekl_ban.do >= curdate() end and case when rekl_ban.od is null then 1 else rekl_ban.od <= curdate() end and (mesta REGEXP ",2751," or (kraje = "" and okresy = "" and mesta = "") or case when okresy != "" then okresy REGEXP ",106," end or case when kraje != "" then kraje REGEXP ",17," end ) and rekl_ban.zahranici = "0" order by rand() limit 1

17) 0.003175
select rekl_ban.id `rekl_ban.id`, rekl_ban.url `rekl_ban.url`, rekl_ban.nazev `rekl_ban.nazev`, rekl_ban.prokliku `rekl_ban.prokliku`, rekl_ban.zobrazeni `rekl_ban.zobrazeni`, rekl_ban.max_pocet_zobrazeni `rekl_ban.max_pocet_zobrazeni`, rekl_ban.max_pocet_prokliku `rekl_ban.max_pocet_prokliku`, rekl_ban.titulek_cz `rekl_ban.titulek_cz`, rekl_ban.popis_cz `rekl_ban.popis_cz`, rekl_ban.obrazek1 `rekl_ban.obrazek1`, rekl_ban.od `rekl_ban.od`, rekl_ban.do `rekl_ban.do`, rekl_ban.zahranici `rekl_ban.zahranici`, rekl_ban.nofollow `rekl_ban.nofollow` from reklamni_bannery rekl_ban where rekl_ban.reklamni_bannery_umisteni_id = 32 and rekl_ban.zobraz = "1" and rekl_ban.archiv = "0" and rekl_ban.smazano = "0" and case when rekl_ban.max_pocet_zobrazeni is null then 1 else rekl_ban.zobrazeni <= rekl_ban.max_pocet_zobrazeni end and case when rekl_ban.max_pocet_prokliku is null then 1 else rekl_ban.prokliku <= rekl_ban.max_pocet_prokliku end and case when rekl_ban.do is null then 1 else rekl_ban.do >= curdate() end and case when rekl_ban.od is null then 1 else rekl_ban.od <= curdate() end and (mesta REGEXP ",2751," or (kraje = "" and okresy = "" and mesta = "") or case when okresy != "" then okresy REGEXP ",106," end or case when kraje != "" then kraje REGEXP ",17," end ) and case when sekce = "" then 1 else sekce like "%,1,%" end order by rand() limit 1

18) 0.002183
select `i.poz.id`, count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "1" and `i.st.id2` = "2" group by `i.poz.id`

19) 0.004772
select option_id `option_id`, pocty_json_brigady_sk `pocty_json_brigady_sk` from podpodsekce_option where pocty_json_brigady_sk != ""

20) 0.008122
select `i.ob.id`, count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id` in ("2702","2703","2704","2705","2706","2707","2708","2709","2710","2711","2712","2713","2714","2715","2716","2717","2718","2719","2720","2721","2722","2723","2724","2725","2726","2727","2728","2729","2730","2731","2732","2733","2734","2735","2736","2737","2738","2739","2740","2741","2742","2743","2744","2745","2746","2747","2748","2749","2750","2751","2752","2753","2754","2755","2756","2757","2758","2759","2761","2760","2762","2763") and `i.se_i.id` = "1" and `i.vhod.id` like "%,4,%" group by `i.ob.id`

21) 0.001919
select `i.kat_brig.id`, count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "1" and `i.st.id2` = "2" group by `i.kat_brig.id`

22) 0.001782
select `i.benefity` from inzeraty_select i where 1 and `i.ob.id`="2751" and `i.se_i.id` = "1" and `i.st.id2` = "2" and `i.benefity` is not null and `i.benefity` != "" and `i.web` = "1"

23) 0.00192
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "1" and `i.st.id2` = "2" and `i.vhod.id` REGEXP ",1,"

24) 0.001949
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "1" and `i.st.id2` = "2" and `i.vhod.id` REGEXP ",4,"

25) 0.001895
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "1" and `i.st.id2` = "2" and `i.vhod.id` REGEXP ",5,"

26) 0.001929
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "1" and `i.st.id2` = "2" and `i.vhod.id` REGEXP ",6,"

27) 0.001827
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "1" and `i.st.id2` = "2" and `i.vhod.id` REGEXP ",8,"

28) 0.001796
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "1" and `i.st.id2` = "2" and `i.vhod.id` REGEXP ",9,"

29) 0.002009
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "3" and `i.vhod.id` REGEXP ",3,"

30) 0.002407
select fi.id `fi.id`, fi.nazev `fi.nazev`, fi.ident `fi.ident`, fi.pocet_1 `fi.pocet_1`, (select count(`i.id`) from inzeraty_select where `fi.id`=fi.id and `i.web` = "1" and `i.ob.id`="2751" and `i.se_i.id` = "1") `fi.pocet` from firmy fi where fi.id in (2268, 3303, 2069, 115, 2490) order by fi.id DESC limit 5

31) 0.005643
select `i.okr.id`, count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.se_i.id` = "1" and `i.st.id2` = "2" and `i.st.id2` = "2" group by `i.okr.id`

32) 0.003024
select rekl_ban.id `rekl_ban.id`, rekl_ban.url `rekl_ban.url`, rekl_ban.obrazek1 `rekl_ban.obrazek1`, rekl_ban.prokliku `rekl_ban.prokliku`, rekl_ban.zobrazeni `rekl_ban.zobrazeni`, rekl_ban.max_pocet_zobrazeni `rekl_ban.max_pocet_zobrazeni`, rekl_ban.max_pocet_prokliku `rekl_ban.max_pocet_prokliku`, rekl_ban.od `rekl_ban.od`, rekl_ban.do `rekl_ban.do`, rekl_ban.script_reklama `rekl_ban.script_reklama`, rekl_ban.prepinac `rekl_ban.prepinac` from reklamni_bannery rekl_ban where rekl_ban.reklamni_bannery_umisteni_id = 7 and rekl_ban.zobraz = "1" and rekl_ban.archiv = "0" and rekl_ban.smazano = "0" and case when rekl_ban.max_pocet_zobrazeni is null then 1 else rekl_ban.zobrazeni <= rekl_ban.max_pocet_zobrazeni end and case when rekl_ban.max_pocet_prokliku is null then 1 else rekl_ban.prokliku <= rekl_ban.max_pocet_prokliku end and case when rekl_ban.do is null then 1 else rekl_ban.do >= curdate() end and case when rekl_ban.od is null then 1 else rekl_ban.od <= curdate() end and (mesta REGEXP ",2751," or (kraje = "" and okresy = "" and mesta = "") or case when okresy != "" then okresy REGEXP ",106," end or case when kraje != "" then kraje REGEXP ",17," end ) order by rand() limit 1

33) 0.000799
select form.csrf `form.csrf` from formulare form where form.id = "48"

0.001375
insert `pozadavky` (`id`) values (null)

Array
(
    [str] => Array
        (
            [uri] => /brigady/roznava/ozp/
        )

    [auto_prepend_file_old] => 0
    [new] => a1
    [f48] => Array
        (
            [i.se_i.id.1] => 1
            [i.okr.id.1] => 106
            [i.kr.id.1] => 17
            [i.ob.id.2] => Array
                (
                    [0] => 2751
                )

            [i.vhod.id.2] => Array
                (
                    [0] => 4
                )

        )

)
Array
(
)
Array
(
    [csrf] => 68d87a07850b81.40408194
)
Array
(
    [PHPSESSID] => 2156dc33377eecd10530692a3c62021f
)
Array
(
    [magick_temporary_path] => /www/hosting/fajn-brigady.sk/tmp
    [magick_tmp_path] => /www/hosting/fajn-brigady.sk/tmp
    [magick_tmpdir] => /www/hosting/fajn-brigady.sk/tmp
    [sys_temp_dir] => /www/hosting/fajn-brigady.sk/tmp
    [sys_tmp_dir] => /www/hosting/fajn-brigady.sk/tmp
    [HOME] => /www/hosting/fajn-brigady.sk
    [USER] => www-data
    [HTTP_COOKIE] => PHPSESSID=2156dc33377eecd10530692a3c62021f
    [HTTP_REFERER] => https://www.fajn-brigady.sk/brigady/roznava/ozp
    [HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
    [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
    [HTTP_ACCEPT] => */*
    [HTTP_HOST] => www.fajn-brigady.sk
    [KOREN] => /www/hosting/verze/
    [STAT] => sk
    [PROJEKT] => fb
    [PATH_INFO] => /index.php
    [SCRIPT_FILENAME] => /www/hosting/verze/index.php
    [REDIRECT_STATUS] => 200
    [SERVER_NAME] => www.fajn-brigady.sk
    [SERVER_PORT] => 443
    [SERVER_ADDR] => 46.234.101.49
    [REMOTE_USER] => 
    [REMOTE_PORT] => 55721
    [REMOTE_ADDR] => 216.73.216.212
    [SERVER_SOFTWARE] => nginx/1.22.1
    [GATEWAY_INTERFACE] => CGI/1.1
    [HTTPS] => on
    [REQUEST_SCHEME] => https
    [SERVER_PROTOCOL] => HTTP/2.0
    [DOCUMENT_ROOT] => /www/hosting/verze
    [DOCUMENT_URI] => /index.php
    [REQUEST_URI] => /brigady/roznava/ozp/
    [SCRIPT_NAME] => /index.php
    [CONTENT_LENGTH] => 
    [CONTENT_TYPE] => 
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => str[uri]=/brigady/roznava/ozp/&auto_prepend_file_old=0&new=a1
    [FCGI_ROLE] => RESPONDER
    [PHP_SELF] => /index.php/index.php
    [REQUEST_TIME_FLOAT] => 1759017482.6488
    [REQUEST_TIME] => 1759017482
    [cr.id] => 
)