Find hills: Beginner, Beginner

  • user warning: Not unique table/alias: 'term_node_12' query: CREATE TEMPORARY TABLE temp_faceted_search_results_1 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT DISTINCT(n.nid) AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1322378026) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 0.2)) AS score FROM node AS n INNER JOIN term_node AS term_node_12 ON n.nid = term_node_12.nid INNER JOIN term_node AS term_node_12 ON n.nid = term_node_12.nid LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( ((n.status = 1) AND (n.type IN ('hill')) AND (term_node_12.tid = 12) AND (term_node_12.tid = 12)) AND n.nid IN (SELECT DISTINCT(node.nid) FROM node node LEFT JOIN file_revisions file_revisions ON node.vid = file_revisions.vid LEFT JOIN files files ON file_revisions.fid = files.fid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.status = '1') ) ) ) GROUP BY n.nid ASC ORDER BY score DESC in /opt/www/hillbomb/html/includes/database.mysqli.inc on line 156.
  • user warning: Table 'hillbomb.temp_faceted_search_results_1' doesn't exist query: SELECT COUNT(*) FROM temp_faceted_search_results_1 in /opt/www/hillbomb/html/includes/database.mysqli.inc on line 156.

Your search yielded no results

  • Check if your spelling is correct.
  • Remove quotes around phrases to match each word individually: "blue smurf" will match less than blue smurf.
  • Consider loosening your query with OR: blue smurf will match less than blue OR smurf.