Novinky

SELECT cl.id_clanku AS IDC, cl.datum_zobrazeni, cl.nazev AS nazev_clanku, cl.perex, cl.obrazek_align, cl.obrazek_border, cl.obrazek, r.id_rubriky AS IDR, r.nazev AS nazev_rubriky, r.id_webu AS IDW FROM c_rubrika r, c_clanek2rubrika c2r, c_clanek cl WHERE cl.datum_zobrazeni>0 AND cl.datum_zobrazeni<=1371696712 AND r.id_rubriky IN (1) AND r.id_rubriky=c2r.id_rubriky AND c2r.id_clanku=cl.id_clanku AND cl.schvaleno=1 AND (cl.datum_schovani > 1371696712 OR cl.datum_schovani = 0 ) GROUP BY IDC ORDER BY cl.datum_zobrazeni DESC, c2r.priorita DESC LIMIT 0, 10 Table './cnso/c_clanek' is marked as crashed and should be repairedSELECT count(cl.id_clanku) AS pocet FROM c_clanek cl LEFT JOIN c_clanek2rubrika c2r ON cl.id_clanku = c2r.id_clanku LEFT JOIN c_rubrika r ON r.id_rubriky=c2r.id_rubriky WHERE cl.datum_zobrazeni>0 AND cl.datum_zobrazeni<=1371696712 AND r.id_rubriky IN (1) AND cl.schvaleno=1 AND (cl.datum_schovani > 1371696712 OR cl.datum_schovani = 0 ) Table './cnso/c_clanek' is marked as crashed and should be repaired