Muži - články 2009/2010
Disk full (/tmp/#sql_45ae_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 >= '2009-07-01' AND datum <= '2010-06-30 23:59:59' AND ((datumexpirace is null) or (datumexpirace >= '2026-04-15 00:22:19')) AND verejny = 1 AND (tema = '1' or tema like '%;1;%' or tema like '1;%') order by datum desc, id desc
