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 '-12,12' at line 7
SELECT z.*, z.nazev as kod, l1.hodnota as nazev, l2.hodnota as popis, l3.hodnota as kategorie FROM ps1_zbozi z
LEFT JOIN ps1_lokalizace l1 ON l1.item_id = z.zbozi_id
LEFT JOIN ps1_lokalizace l2 ON l2.item_id = z.zbozi_id
LEFT JOIN ps1_lokalizace l3 ON l3.item_id = z.kategorie_id WHERE (z.status_id=3001 OR z.status_id = 3004) AND l1.kod = 'loc_nazev_cs'
AND l1.menu_id = 204 AND l2.kod = 'loc_popis_cs'
AND l2.menu_id = 204 AND l3.kod = 'loc_nazev_cs'
AND l3.menu_id = 203 AND ( z.kategorie_id = 86 OR z.kategorie_id = 95 OR z.kategorie_id = 96 OR z.kategorie_id = 98 OR z.kategorie_id = 110 OR z.kategorie_id = 116 ) ORDER BY z.vyrobce, z.nazev asc LIMIT -12,12
svět očima hudby
Tel./Fax: +420 272 272 500 E-mail: eshop@soh.cz
SOH.cz LED obrazovky