_ 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 tshopzbozi.Aktivni=1
ORDER BY tshopzbozi.Titulek' at l
---
SELECT tshopzbozi.*,
tshopzbozi.Titulek_en AS Titulek,
tshopzbozi.KratkyPopis,
tshopzbozi.DlouhyPopis,
tshopzbozi.KratkyPopis_en,
tshopzbozi.DlouhyPopis_en,
tshopvyrobci.Popis as vyrobcepopis
FROM tshopzbozi LEFT JOIN tshopvyrobci ON tshopvyrobci.ID=tshopzbozi.IDZnacky
WHERE tshopzbozi.IDZBOZI= AND tshopzbozi.Aktivni=1
ORDER BY tshopzbozi.Titulek
---
produkt nebyl nalezen. hlavni strana