yahoo.related.xml

<?xml version="1.0" encoding="UTF-8" ?>
<table xmlns="http://query.yahooapis.com/v1/schema/table.xsd">
  <meta>
    <author>Reid Burke, Yahoo! Inc.</author>
    <sampleQuery>select * from {table} where url="http://omg.yahoo.com/news/report-kristin-davis-dating-australian-photographer/25772"</sampleQuery>
  </meta>
  <bindings>
    <select itemPath="" produces="XML">
      <urls>
        <url></url>
      </urls>
      <inputs>
        <key id="url" type="xs:string" paramType="variable" required="true" />
        <key id="results_per_query" type="xs:integer" paramType="variable" />
        <key id="bing" type="xs:boolean" paramType="variable" />
        <key id="site" type="xs:string" paramType="variable" />
      </inputs>
      <execute><![CDATA[
        var termExtract = function (url) {
            return y.query(
                "select content from search.termextract where context = @url",
                {
                    url: url
                }
            ).results;
        };

        var appendAll = function (target, string) {
            var result = [];
            default xml namespace = "urn:yahoo:cate";
            for each (var node in target.Result) result.push(node + string);
            return result;
        };

        var search = function (terms, count, bing) {
            var terms = " and query in ('" + terms.join("', '") + "')";
            if (bing) {
                var clause = "microsoft.bing where source = 'web' and web.count = " + count;
            } else {
                var clause = "search.web(" + count + ") where filter = '-porn -hate'";
            }
            var q = "select * from " + clause + terms;
            return y.query(q).results;
        };

        if (!site) site = url.match(/https?\:\/\/([^\/]*).*/)[1];
        if (!results_per_query) results_per_query = 1;

        response.object = search( appendAll( termExtract(url), " site:" + site ), results_per_query, bing);
      ]]></execute>
    </select>
  </bindings>
</table>