Fatal error: Chyba v dotazu select l.lang, z.*, COALESCE(zl.keyword, (SELECT keyword FROM eshop_zbozi_lang AS z1 WHERE keyword IS NOT NULL AND z1.id=z.id) ) as keyword, zl.popis_kratky, zl.nazev, zs.cena_doporucena, ROUND(MIN(IF(zs.prodejne='ano',zs.cena,NULL)), 4) as cena_min, ROUND(MIN(IF(zs.prodejne='ano',zs.cena,NULL))*(z.dph/100+1), 4) as cena_min_dph, (select soubor from eshop_zbozi_fotky where eshop_zbozi_fotky.zbozi=z.id order by priorita,id limit 1) as fotka, CONCAT('ep',z.id%10, '/') as fotka_dir, GROUP_CONCAT(zs.kod SEPARATOR ';') as kod, CONCAT( (SELECT kl1.url FROM eshop_kategorie_lang as kl1 JOIN eshop_zbozi_kategorie as zk1 ON kl1.id=zk1.kategorie_id WHERE zk1.zbozi_id=z.id AND kl1.url IS NOT NULL ORDER BY (kl1.lang=l.lang) DESC, zk1.hlavni DESC LIMIT 1), '/', COALESCE(zl.keyword, (SELECT keyword FROM eshop_zbozi_lang AS z1 WHERE keyword IS NOT NULL AND z1.id=z.id) ) , '.html' ) as url, v.nazev as vyrobce from eshop_lang as in /www/doc/www.ptakoviny.net/www/classes/sql.php on line 165