Warning: mysqli_query(): (HY000/1): Can't create/write to file '/tmp/#sql_63c_51.MAI' (Errcode: 28 "No space left on device") in /pub/mazanewa/ceskevylety.cz/web/www/_libs/_db_functions.php on line 91
Chyba dotazu:
SELECT
f.id_gfoto, f.id_mesto as m, f.nazev, f.autor_text, f.autor_link,
f.zdroj_text, f.zdroj_link, f.zdroje, f.popis, f.orientace, f.status,
m.nazev as mesto, o.nazev as oblast, r.nazev as region,
coalesce(o.id_oblast,f.id_oblast) as o,
coalesce(r.id_region,f.id_region) as r,
if(m.id_mesto='586056','0',if(m.id_oblast='20','1',if(m.id_region='CZ0625','2','3'))) as poradi
FROM
galerie_foto f
left join galerie_f2t on (f.id_gfoto=galerie_f2t.id_gfoto)
left join c_mesta m on (f.id_mesto=m.id_mesto)
left join c_oblast o on (f.id_oblast=o.id_oblast)
left join c_region r on (f.id_region=r.id_region)
GROUP BY id_gfoto HAVING ( (m='586056') OR (r='CZ0625') AND (o='20')) ORDER BY poradi, oblast, region, mesto, f.nazev
