- user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lianyico_wsite.node_data_field_image.field_image_fid' 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_data_field_image.field_image_fid AS node_data_field_image_field_image_fid, node_data_field_image.field_image_list AS node_data_field_image_field_image_list, node_data_field_image.field_image_data AS node_data_field_image_field_image_data, node_data_field_image.delta AS node_data_field_image_delta, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_data_field_dimension.field_dimension_value AS node_data_field_dimension_field_dimension_value, node_data_field_dimension.field_year_built_value AS node_data_field_dimension_field_year_built_value, node.sticky AS node_sticky FROM node node INNER JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_node term_data_term_node ON node.vid = term_data_term_node.vid LEFT JOIN term_data term_data_term_node__term_data ON term_data_term_node.tid = term_data_term_node__term_data.tid LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN content_type_vessel node_data_field_dimension ON node.vid = node_data_field_dimension.vid WHERE (node.status <> 0) AND (node.type in ('vessel')) AND (term_node.tid = 4) AND (term_data_term_node__term_data.name = 'Tugboat') GROUP BY nid ORDER BY node_sticky ASC, node_title ASC ) count_alias in /home/lianyico/public_html/modules/views/includes/view.inc on line 745.
- user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lianyico_wsite.node_data_field_image.field_image_fid' 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_data_field_image.field_image_fid AS node_data_field_image_field_image_fid, node_data_field_image.field_image_list AS node_data_field_image_field_image_list, node_data_field_image.field_image_data AS node_data_field_image_field_image_data, node_data_field_image.delta AS node_data_field_image_delta, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_data_field_dimension.field_dimension_value AS node_data_field_dimension_field_dimension_value, node_data_field_dimension.field_year_built_value AS node_data_field_dimension_field_year_built_value, node.sticky AS node_sticky FROM node node INNER JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_node term_data_term_node ON node.vid = term_data_term_node.vid LEFT JOIN term_data term_data_term_node__term_data ON term_data_term_node.tid = term_data_term_node__term_data.tid LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN content_type_vessel node_data_field_dimension ON node.vid = node_data_field_dimension.vid WHERE (node.status <> 0) AND (node.type in ('vessel')) AND (term_node.tid = 4) AND (term_data_term_node__term_data.name = 'Tugboat') GROUP BY nid ORDER BY node_sticky ASC, node_title ASC LIMIT 0, 20 in /home/lianyico/public_html/modules/views/includes/view.inc on line 771.
|
No vessels found |
