SELECT z.id as zbozi_id, z.aktivni, z.nazev, z.autor, z.cena, z.sleva, z.sleva_kategorie, z.abstrakt, o.id as obrazek_id, z.pocet_skladem, z.pocet_skladem_prodejna
FROM `kategorie` k
LEFT JOIN `zbozi` z ON z.kategorie_id = k.id
LEFT JOIN `obrazky` o ON z.id = o.zbozi_id AND o.hlavni = 1 WHERE z.aktivni = 1 AND k.id_rodice = AND z.kategorie_typ_id = 1 ORDER BY z.nazev LIMIT 140, 20You 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 z.kategorie_typ_id = 1 ORDER BY z.nazev LIMIT 140, 20' at line 4