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.