- user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crtda.node_data_field_country.field_country_value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query:
SELECT count(node.nid) AS nids,
node_data_field_country.field_country_value AS country,
FROM_UNIXTIME(node.created,'%e-%m-%Y') AS node_created,
FROM_UNIXTIME(node.created,'%e-%m') AS node_created2
FROM node node
LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND flag_content_node.fid = 2
LEFT JOIN content_type_petition_signature node_data_field_petition ON node.vid = node_data_field_petition.vid
LEFT JOIN content_type_petition_signature node_data_field_country ON node.vid = node_data_field_country.vid
WHERE (node.status = 1)
AND (node.type in ('petition_signature'))
AND (flag_content_node.uid IS NOT NULL)
AND (node_data_field_petition.field_petition_nid = 14682)
group by node_created
ORDER BY node.nid ASC in /var/www/www.crtda.org.lb/sites/all/modules/views_php/plugins/views/views_php_handler_field.inc(223) : runtime-created function on line 25.
- user warning: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crtda.node.created' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query:
SELECT count(node.nid) AS nids,
node_data_field_country.field_country_value AS country,
FROM_UNIXTIME(node.created,'%e-%m-%Y') AS node_created
FROM node node
LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND flag_content_node.fid = 2
LEFT JOIN content_type_petition_signature node_data_field_petition ON node.vid = node_data_field_petition.vid
LEFT JOIN content_type_petition_signature node_data_field_country ON node.vid = node_data_field_country.vid
WHERE (node.status = 1)
AND (node.type in ('petition_signature'))
AND (flag_content_node.uid IS NOT NULL)
AND (node_data_field_petition.field_petition_nid = 14682)
group by country
ORDER BY country ASC in /var/www/www.crtda.org.lb/sites/all/modules/views_php/plugins/views/views_php_handler_field.inc(223) : runtime-created function on line 74.
الإحصائيات
