Back to YQL Forum
0

YQL query multiple sites problem

Hello,

I'm trying to wrap my head around using YQL with multiple sites and url's in the WHERE clause, as in :-

CODE
SELECT * FROM search.web(100)
WHERE (query="chicken"
      and (sites="allrecipes.com" or sites="epicurious.com") 
      and (url like "%allrecipes.com/Recipes/%" or url like "%epicurious.com/recipes/%"))
      limit 20


The query itself appears to filter correctly, which is great, however, in the results that I get, it lists all of the allrecipes.com links first and then the epicurious.com links.

How can I have the results returned intermixed and in the order of relevance?

Any help or suggestions would be greatly appreciated.

Thanks,
Chris

by
Report Abuse
1 Reply
  • QUOTE (Austin Family @ Jul 1 2009, 10:02 AM) <{POST_SNAPBACK}>
    CODE
    SELECT * FROM search.web(100)
    WHERE (query="chicken"
          and (sites="allrecipes.com" or sites="epicurious.com") 
          and (url like "%allrecipes.com/Recipes/%" or url like "%epicurious.com/recipes/%"))
          limit 20


    The query itself appears to filter correctly, which is great, however, in the results that I get, it lists all of the allrecipes.com links first and then the epicurious.com links.

    How can I have the results returned intermixed and in the order of relevance?


    You can put a comma separated list of sites in the sites key: sites='allrecipes.com,epicurious.com' (we really should make that batchable) but you will still have the problem that Yahoo! search ranks allrecipes above epicurious and you won't see any epicurious results for thousands and thousands of results.

    http://bit.ly/ALQAX

    Sam
    Report Abuse
    0
Ask a Question

Recent Posts

in YQL