Cafés

user warning: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 's061626d_drupal.term_data.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, uc_products.sell_price AS uc_products_sell_price, uc_products.model AS uc_products_model FROM node node LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (node.type in ('product')) AND (node.vid IN ( SELECT tn.vid FROM term_node tn LEFT JOIN term_hierarchy th ON th.tid = tn.tid LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid WHERE tn.tid = 9 OR th1.tid = 9 )) GROUP BY nid ORDER BY node_title ASC ) count_alias in /home/s061626d/public_html/sites/all/modules/views/includes/view.inc on line 805.