Art to Buy Online at The Green Art Gallery in Manchester UK

  • user warning: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'greenartgallery.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, profile_values_profile_name.value AS profile_values_profile_name_value, profile_values_profile_name.uid AS profile_values_profile_name_uid, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, uc_products.sell_price AS uc_products_sell_price FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_values_profile_name ON users.uid = profile_values_profile_name.uid AND profile_values_profile_name.fid = '1' 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 uc_products uc_products ON node.vid = uc_products.vid WHERE (node.status = 1) AND (node.type IN ('product')) AND (users.name = 'artistpune') GROUP BY nid ORDER BY profile_values_profile_name_value ASC, node_title ASC ) count_alias in /var/www/vhosts/thegreenartgallery.co.uk/httpdocs/sites/all/modules/views/includes/view.inc on line 805.
  • user warning: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'greenartgallery.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 DISTINCT(node.nid) AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, profile_values_profile_name.value AS profile_values_profile_name_value, profile_values_profile_name.uid AS profile_values_profile_name_uid, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, uc_products.sell_price AS uc_products_sell_price FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_values_profile_name ON users.uid = profile_values_profile_name.uid AND profile_values_profile_name.fid = '1' 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 uc_products uc_products ON node.vid = uc_products.vid WHERE (node.status = 1) AND (node.type IN ('product')) AND (users.name = 'artistpune') GROUP BY nid ORDER BY profile_values_profile_name_value ASC, node_title ASC LIMIT 0, 20 in /var/www/vhosts/thegreenartgallery.co.uk/httpdocs/sites/all/modules/views/includes/view.inc on line 810.

Art for Sale by