query neprovedeno:
SELECT *,d.ID as mainid,
(ROUND( SQRT( POW(69.1 * (49.14765040371976 - SUBSTRING_INDEX(Gmaps_Souradnice, ',', 1)) * 1.609, 2) + POW(45.28 * (14.175672054552706 - SUBSTRING_INDEX(Gmaps_Souradnice, ',', -1)) * 1.609, 2)), 1)) AS distance
FROM instituce AS d
LEFT JOIN instituce_cs AS d_cs ON d.ID=d_cs.ID
LEFT JOIN instituce_adresy AS d_adr ON d.Inst_Adresa=d_adr.id
LEFT JOIN obce_cr AS d_obce ON d_adr.Obec_Adr=d_obce.ID
LEFT JOIN ulice_vodnany AS d_ulvod ON d_ulvod.ID=d_adr.Ulice
WHERE AND ((d_cs.Nazev_cs IS NOT NULL) AND (d_cs.Stav_cs = '1')) ORDER BY Nazev_cs
--