Kazety, fanziny, samolepky

Obrázek

Objednávky pod větev 2015

Obrázek


COUNT select count(*) as pocet from sys_prispevek where (
kategorie in
( select id_rubrika from sys_prispevek_rubrika_skupina where id_project = 1059
and id_skupina in (
select id_skupina from sys_user_skupina_priradit where id_project = 1059
and uname = 'anonymous'
)
and opravneni_verejnost = 'a'
)
   or kategorie in (
select id_rubrika from sys_prispevek_rubrika_opravneni where id_project = 1059
and uname = 'anonymous'
and opravneni_verejnost = 'a'
)
   or (

kategorie NOT in (
select id_rubrika from sys_prispevek_rubrika_skupina where id_project = 1059
and opravneni_verejnost = 'a'
)
and kategorie NOT in (

select id_rubrika from sys_prispevek_rubrika_opravneni where id_project = 1059
and opravneni_verejnost = 'a'
)
)
)
  and typ = ? and id_project = ? and ( lang = ? or lang = ? or lang = ? )
POCET: 255


P_PRISPEVEK: select id, nazev, typ, url, kategorie, publikovat, prvni_pozice, zobrazit_datum, zobrazit_cas, upoutavka, inserted_who, novinka_odkaz, odkaz, obsah,
id_klub, table_akce_select as typ_akce, misto_konani, zacatek_datum, zacatek_cas, konec_datum, konec_cas, obrazek_list,
file_name, file_velikost, file_velikost_small, file_content_type, file_content_disposition, file_x, file_y, file_ext,
flash_file_name, flash_file_ext, video,
inserted_who as inserted_who_foto,
nazev as nazev_url from sys_prispevek where (
kategorie in
( select id_rubrika from sys_prispevek_rubrika_skupina where id_project = 1059
and id_skupina in (
select id_skupina from sys_user_skupina_priradit where id_project = 1059
and uname = 'anonymous'
)
and opravneni_verejnost = 'a'
)
   or kategorie in (
select id_rubrika from sys_prispevek_rubrika_opravneni where id_project = 1059
and uname = 'anonymous'
and opravneni_verejnost = 'a'
)
   or (

kategorie NOT in (
select id_rubrika from sys_prispevek_rubrika_skupina where id_project = 1059
and opravneni_verejnost = 'a'
)
and kategorie NOT in (

select id_rubrika from sys_prispevek_rubrika_opravneni where id_project = 1059
and opravneni_verejnost = 'a'
)
)
)
  and typ = ? and id_project = ? and ( lang = ? or lang = ? or lang = ? ) order by prvni_pozice, zobrazit_datum desc, zobrazit_cas desc limit 20 offset 0

EXECUTE: 'novinka' '1059' '' 'all' 'cz'

SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027338 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027338 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027338 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7027338 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027213 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027213 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027213 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7027213 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027306 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027306 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027306 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7027306 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027181 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027181 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027181 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7027181 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027116 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027116 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027116 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7027116 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027103 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027103 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7027103 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7027103 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026998 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026998 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026998 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026998 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026862 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026862 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026862 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026862 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026715 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026715 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026715 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026715 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026688 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026688 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026688 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026688 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026658 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026658 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026658 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026658 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026636 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026636 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026636 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026636 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026566 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026566 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026566 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026566 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026538 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026538 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026538 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026538 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026497 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026497 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026497 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026497 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026463 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026463 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026463 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026463 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026425 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026425 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026425 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026425 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026404 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026404 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026404 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026404 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026383 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026383 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026383 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026383 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'
SUBSQL: P_PRISPEVEK - pocet_obrazky - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026354 and typ = 'img' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_video - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026354 and typ = 'video' having count(*) > 0
SUBSQL: P_PRISPEVEK - pocet_mp3 - id - : select count(*) from sys_prispevek_files where
id_prispevek = 7026354 and typ = 'music' having count(*) > 0
SUBSQL: P_PRISPEVEK - editace_opravneni - id - : select id from sys_prispevek where id_project = 1059 and publikovat = 'a' and deleted <> 'a' and id_backup = 0
and id = 7026354 AND typ <> 'clanek' AND typ <> 'akce' AND typ <> 'galerie' AND typ <> 'novinka' AND typ <> 'text' AND typ <> 'odkaz' AND typ <> 'soubor' AND typ <> 'aplikace'