Kilns for Ceramic Artists, Schools, Universities, Industry and More

user warning: Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hotkilns_live.node_data_field_cust_category.field_cust_category_value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node_data_field_mainimage.field_mainimage_fid AS node_data_field_mainimage_field_mainimage_fid, node_data_field_mainimage.field_mainimage_list AS node_data_field_mainimage_field_mainimage_list, node_data_field_mainimage.field_mainimage_data AS node_data_field_mainimage_field_mainimage_data, node.type AS node_type, node.vid AS node_vid, node_data_field_teasertext.field_teasertext_value AS node_data_field_teasertext_field_teasertext_value, node_data_field_cust_category.field_cust_category_value AS node_data_field_cust_category_field_cust_category_value, node_data_field_order.field_order_value AS node_data_field_order_field_order_value FROM node node LEFT JOIN content_field_mainimage node_data_field_mainimage ON node.vid = node_data_field_mainimage.vid LEFT JOIN content_field_teasertext node_data_field_teasertext ON node.vid = node_data_field_teasertext.vid LEFT JOIN content_field_cust_category node_data_field_cust_category ON node.vid = node_data_field_cust_category.vid LEFT JOIN content_type_types node_data_field_order ON node.vid = node_data_field_order.vid 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 = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.type in ('types')) AND (node.status = 1) )GROUP BY nid ORDER BY node_data_field_cust_category_field_cust_category_value ASC, node_data_field_order_field_order_value ASC in /home/hotkilns/public_html/sites/all/modules/views/includes/view.inc on line 814.

Every customer is different but there are some common themes, issues and recommendations that these groupings can help with. See what helps other people like yourself.