Hi, it does not seem possible in the current YQL implementation to retrieve UK results from local.search. Setting location='london,england' returns mainly US results. Limiting resultset with a radius and/or geo co-ordinates both return non-UK results.

Is there way to return valid UK listings from Yahoo Local ?

YQL query on local.search

CODE

select * from local.search where location='london, england' and query='hotel'

The nearest alternative is a YQL data query on the HTML from a Yahoo Local search page, but Xpath is not efficient when querying multiple attributes within a parent result DIV (for anyone interested the parent is "addr") e.g. name, address, phone, post code, lat and long all exist within the DIV class, but as a variety of formats - h2, h3, div, p and span, making the xpath impossible.

Can the below query be improved to bring back just the obvious attributes listed above ?

YQL query on HTML using Xpath:

CODE

select * from html where url="http://uk.local.yahoo.com/search.html;_ylt=Ar.jd4e8wLfgc5LuQc5MhH2jaY85;_ylv=3?fr=yfp-t-702&cs=&vid=&p=hotel&poi=London%2C+Greater+London&yls-submit=Search" and
      xpath='//div[@class="addr"]'

Thanks