Chyba DB: 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 o.online = '1'' at line 4 SELECT count(o.id) FROM objekty AS o LEFT JOIN cis_mista AS m ON m.id = o.urceni_mista WHERE (o.cis_typ=? ) AND o.online = '1' SELECT o.id, o.nazev, o.nazev_dop, o.cis_stav, o.cis_typ, o.kraj, o.cis_typ_dop, o.loc_x, o.loc_y, o.pristupnost, o.mnm, o.cis_country, m.obec, t.text, o.urceni_mista, o.url FROM objekty AS o LEFT JOIN cis_mista AS m ON m.id = o.urceni_mista LEFT JOIN text_info AS t ON t.hid=o.id AND t.tid='7' AND t.lang ='0' WHERE (o.cis_typ=? ) AND o.online = '1' GROUP BY o.id, hrady_cz.t.text /*ORDER BY o.nazev, o.nazev_dop*/ ORDER BY CASE WHEN LOWER(o.nazev) LIKE LOWER('') THEN 0 WHEN LOWER(o.nazev) LIKE LOWER('%') THEN 2 WHEN LOWER(o.nazev) LIKE LOWER('%') THEN 3 ELSE 4 END LIMIT 0,15

Hledání turisticky zajímavých míst