Omluvte chyby na serveru způsobené migrací na nový hardware! Na odstranění se pracuje.
Chyba DB: Expression #14 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hrady_cz.t.text' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
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, p.id, 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'
LEFT JOIN obj_pic AS p ON p.hid=o.id AND p.poradi = 1 AND p.status > 0
WHERE o.kraj = 13 AND o.online = '1' GROUP BY o.id ORDER BY o.nazev, o.nazev_dop, t.text
LIMIT 0, 30
Mapa