- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY n.nid ASC ORDER BY score DESC' at line 1
query: CREATE TEMPORARY TABLE temp_faceted_search_results_6 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT n.nid AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1335649655) * 6.43e-8) AS score FROM node AS n INNER JOIN term_node AS term_node_5 ON n.nid = term_node_5.nid LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid WHERE ((n.status = 1) AND (n.type IN ('corsage')) AND (term_node_5.tid = 5)) AND n.nid IN () GROUP BY n.nid ASC ORDER BY score DESC in /home/crabappl/public_html/sites/all/modules/faceted_search/faceted_search.inc on line 1185.
- user warning: Table 'crabappl_drupal.temp_faceted_search_results_6' doesn't exist
query: SELECT COUNT(*) FROM temp_faceted_search_results_6 in /home/crabappl/public_html/sites/all/modules/faceted_search/faceted_search.inc on line 1186.
Corsage Search: Pink
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.