Aktuality

Disk full (/tmp/#sql_620_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") select * from ( SELECT 0 as typ, clanek.id, clanek.datum, clanek.nadpis, clanek.podnadpis, clanek.telo, clanek.miniatura, clanek.datumexpirace, clanek.verejny, clanek.tema, clanek.precteno, uzivatel.jmeno as autor, clanek.autor as autorlogin, komentare.pocet as komentare, NULL as odkaz FROM clanek left join uzivatel on uzivatel.login=clanek.autor left join (select count(1) as pocet, min(idclanek) as idclanek from komentar group by idclanek) komentare on clanek.id = komentare.idclanek UNION ALL SELECT 1 as typ, id, datumvydani as datum, nadpis, obsah as podnadpis, '' as telo, odkazobrazku as miniatura, NULL as datumexpirace, pozvanka as verejny, idkategorie as tema, 0 as precteno, zdroj as autor, autor as autorlogin, 0 as komentare, odkaz FROM zpravavmediich ) clanek2 where 1 AND datum <= '2025-07-12 17:44:27 23:59:59' AND ((datumexpirace is null) or (datumexpirace >= '2025-07-12 17:44:27')) AND verejny = 1 order by datum desc, id desc limit 0,10 Disk full (/tmp/#sql_620_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") select * from ( SELECT 0 as typ, clanek.id, clanek.datum, clanek.nadpis, clanek.podnadpis, clanek.telo, clanek.miniatura, clanek.datumexpirace, clanek.verejny, clanek.tema, clanek.precteno, uzivatel.jmeno as autor, clanek.autor as autorlogin, komentare.pocet as komentare, NULL as odkaz FROM clanek left join uzivatel on uzivatel.login=clanek.autor left join (select count(1) as pocet, min(idclanek) as idclanek from komentar group by idclanek) komentare on clanek.id = komentare.idclanek UNION ALL SELECT 1 as typ, id, datumvydani as datum, nadpis, obsah as podnadpis, '' as telo, odkazobrazku as miniatura, NULL as datumexpirace, pozvanka as verejny, idkategorie as tema, 0 as precteno, zdroj as autor, autor as autorlogin, 0 as komentare, odkaz FROM zpravavmediich ) clanek2 where 1 AND ((datumexpirace is null) or (datumexpirace >= '2025-07-12 17:44:27')) AND verejny = 1 order by datum desc, id desc

Strana: <<  <