SQL QUERY:select n.id as idecko, n.pouzivatel_id, n.diskusia_id, n.datum_pridania, n.nadpis, n.hlavicka, n.ukazat_formular, n.je_otvorena, n.text_spravy, nk.priorita as newsPrior, n.last_update, date_format(datum_pridania,'%d%m%Y') as pridane, date_format(last_update,'%d%m%Y') as zmenene, n.show_diskusia, n.for_logged as locked_article, n.show_hlavicka_after_open, n.related_articles, n.related_as_header, n.pull_down, n.show_title_icons, n.picture_path, n.hits, n.enable_rating, n.friendly_url, k.priorita as kategPrior, p.id, p.level as userLevel, p.prihl_meno as nick, k.id as katid, k.nazov as katnazov, k.popis, k.pridal_pouzivatel_id as katUserId, k.for_logged as locked, k.show_this, k.idx from europumps__pouzivatel as p, europumps__news as n LEFT JOIN europumps__newsCats as nk ON nk.news_id = n.id LEFT JOIN europumps__kategorie as k ON nk.category = k.id where n.zobrazit = 1 and n.position = 'center' and n.authorized = 'y' and n.datum_pridania <= CURDATE() and p.id = n.pouzivatel_id and k.id NOT IN (1, 2, 3) and k.id in (145) GROUP BY n.id ORDER BY newsPrior LIMIT 0, 20
Got error 28 from storage engineSQL QUERY:SELECT k.id, k.nazov, k.popis, k.idx, k.picture, k.picture_attributes, k.onlyCategoryLink FROM europumps__kategorie as k LEFT JOIN europumps__newsCats as nc ON nc.category = k.id WHERE k.show_this = 1 AND k.id_parent = 145 AND k.id NOT IN (1,2,3,4) GROUP BY k.id ORDER BY k.priorita ASC, k.id
Got error 28 from storage engine