Chyba aplikace nebo serveru: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*' : /* *** fulltextove vyhledavani *** */
SELECT * FROM (
SELECT
if( z.nadrazene_zbozi >0, z.nadrazene_zbozi, z.id ) AS id , f.nadpis,
IF (z.zakazat_nakup='n', 1, 2) AS ord_zakazat_nakup,
( IF (z.id = '0' OR z.kod like '%josera>%', 10, 0) ) AS score1,
(
(
IF (MATCH(f.nadpis) AGAINST('*josera>*' IN BOOLEAN MODE)> 0, 1000, 0)
+
IF(MATCH(f.obsah) AGAINST('*josera>*' IN BOOLEAN MODE)>0, 100, 0)
)
) AS score2
FROM
prefix_zbozi AS z,
prefix_fulltext AS f
WHERE
z.id_obchodu='3498'
AND
f.typ='zbozi'
AND
f.prirazeni = z.id
AND ( ( z.aktivni='y' AND z.vypnuto='n' ) )
HAVING
( score1 >0 or score2 > 0)
ORDER BY
ord_zakazat_nakup,
score1 DESC,
score2 DESC,
f.nadpis
) AS tb
GROUP BY id
ORDER BY
score1 DESC,
score2 DESC
LIMIT 10000