Chyba get_parametricky_filtr2:
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 ')
AND zp.id_parametru IN (
SELECT id_parametry FROM parametry_ka' at line 5
Dotaz:
SELECT p.*,p.id AS pid, zp.id_parametru,zp.hodnota,zp.id_zbozi,zp.id AS zpid
FROM parametry p
INNER JOIN zbozi_parametry zp ON zp.id_parametru = p.id
INNER JOIN zbozi z ON z.id = zp.id_zbozi
WHERE p.id_obchodu = 109 AND ( )
AND zp.id_parametru IN (
SELECT id_parametry FROM parametry_kategorie WHERE id_kategorie =
)
GROUP BY zp.hodnota
ORDER BY priorita, zp.hodnota