<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "which query to get the results of hierarchy?geonameId=...?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "which query to get the results of hierarchy?geonameId=...?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>which query to get the results of hierarchy?geonameId=...?</title>
				<description><![CDATA[ i am trying to produce from a mysql db to extract the very same information
http://ws.geonames.org/hierarchy?geonameId=<ID>
returns.
due to the somewhat inconsistent/confusing data, i have a rather hard time trying to figure out a query doing that.

otoh, the webservice should execute exactly the query i am looking for -- so, is it possible to get that query somewhere (mysql preferably, but any sql will do)?

i searched but no relevant answers turned up, though i am sure, the question has been asked before ...]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2076.page#8416</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2076.page#8416</link>
				<pubDate><![CDATA[Fri, 10 Sep 2010 15:22:38]]> GMT</pubDate>
				<author><![CDATA[ puck_of_pooks_hill]]></author>
			</item>
			<item>
				<title>Re:which query to get the results of hierarchy?geonameId=...?</title>
				<description><![CDATA[ it is a combination of query and cache. Posting a query would not help you at all.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2076.page#8422</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2076.page#8422</link>
				<pubDate><![CDATA[Mon, 13 Sep 2010 15:14:02]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>