- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid) AS num_records
FROM node node
WHERE node.status <> 0
GROU' at line 3
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -18000 SECOND), '%Y%m') AS created_year_month,
DISTINCT(node.nid) AS num_records
FROM node node
WHERE node.status <> 0
GROUP BY created_year_month, nid
ORDER BY created_year_month DESC
) count_alias in /home/httpd/drupal/modules/views/plugins/views_plugin_pager.inc on line 134.
- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid) AS num_records
FROM node node
WHERE node.status <> 0
GROU' at line 3
query: SELECT DISTINCT(node.nid) AS nid,
DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -18000 SECOND), '%Y%m') AS created_year_month,
DISTINCT(node.nid) AS num_records
FROM node node
WHERE node.status <> 0
GROUP BY created_year_month, nid
ORDER BY created_year_month DESC
LIMIT 0, 10 in /home/httpd/drupal/modules/views/plugins/views_plugin_query_default.inc on line 1093.
(ITMS)
Subscribe in a reader
