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
, k.picture, k.picture_attributes
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 (97)
GROUP BY n.id
ORDER BY
newsPrior
LIMIT 0, 20
Got error 28 from storage engine
Táto sekcia je prázdna...