You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Reilly'
AND spomocnik=1
GROUP BY wp_posts.ID
ORDER BY publish DESC
LIMIT 0,10' at line 9You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Reilly'
AND spomocnik=1
GROUP BY wp_posts.ID
ORDER BY publish DESC
LIMIT 0,10' at line 9
SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.ID,post_title,post_excerpt,post_date as publish,jmeno_autora as autor,hlavni,vedlejsi,cas_zarazeni,kategorie,pocet_zobrazeni as displays,hodnoceni_rvp as rvp_rating,hodnoceni_uzivatelu_prumer as user_rating,komentare as pocet_komentaru,nazev,posledni_komentar,o_jazyce,obor,spomocnik,post_author,medaile_inspiromat
FROM wp_posts
JOIN wp_prispevky ON wp_posts.ID=wp_prispevky.id
JOIN wp_typ_prispevku ON wp_prispevky.id = wp_typ_prispevku.prispevek
JOIN wp_kategorie_prispevek ON wp_typ_prispevku.prispevek=wp_kategorie_prispevek.prispevek
JOIN wp_kategorie ON wp_kategorie_prispevek.kategorie=wp_kategorie.id
JOIN wp_prispevek_stat ON wp_prispevek_stat.prispevek=wp_kategorie_prispevek.prispevek
JOIN wp_keyword_prispevek ON wp_keyword_prispevek.prispevek=wp_posts.ID
JOIN wp_keyword ON wp_keyword.id=wp_keyword_prispevek.keyword
WHERE wp_posts.post_status='1000'
AND wp_keyword.slovo='Tim O'Reilly'
AND spomocnik=1
GROUP BY wp_posts.ID
ORDER BY publish DESC
LIMIT 0,10
Celkem: 0