Junioři - články 2015/2016

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 >= '2015-07-01' AND datum <= '2016-06-30 23:59:59' AND ((datumexpirace is null) or (datumexpirace >= '2025-07-12 17:49:10')) AND verejny = 1 AND (tema = '2' or tema like '%;2;%' or tema like '2;%') order by datum desc, id desc