business trip to





užitečné informace


Zobrazit na mapě

Autokempy v okolí 



Query fout: 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 'ORDER BY distance' at line 25
query: SELECT bezienswaardigheidnaam, beznaam,introtext,text,districtnaam,latitude,longitude,districtafkorting , acos(sin(0)*sin(radians(latitude)) + cos(0)*cos(radians(latitude))*cos(radians(longitude)-0)) * 6371 AS distance FROM ( SELECT DISTINCT bwd.bezienswaardigheidnaam , blg.naam AS beznaam , blg.introtext , blg.text , dtt.districtnaam , bwd.latitude , bwd.longitude , pls.districtafkorting FROM district dtt INNER JOIN plaats pls ON (dtt.districtafkorting = pls.districtafkorting) INNER JOIN bezienswaardigheid_plaats bps ON (bps.plaatsnaam = pls.plaatsnaam) INNER JOIN bezienswaardigheid bwd ON (bwd.bezienswaardigheidnaam = bps.bezienswaardigheidnaam) INNER JOIN bezienswaardigheidlang blg ON (blg.bezienswaardigheidnaam = bwd.bezienswaardigheidnaam) WHERE blg.languageid = 'cz' AND blg.showonpage = 1 AND bwd.latitude > 0 AND bwd.latitude < 0 AND bwd.longitude > 0 AND bwd.longitude < 0 ) AS allresults WHERE acos(sin(0)*sin(radians(latitude)) + cos(0)*cos(radians(latitude))*cos(radians(longitude)-0))*6371 < ORDER BY distance