Ideas - By Date

  • 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 'range, count( DISTINCT(node.nid)) AS num_nodes FROM node node LEFT JOIN content' at line 1 query: SELECT DATE_FORMAT(STR_TO_DATE(node_data_field_release_date.field_release_date_value, '%Y-%m-%dT%T'), '%Y-%m') AS range, count( DISTINCT(node.nid)) AS num_nodes FROM node node LEFT JOIN content_field_release_date node_data_field_release_date ON node.vid = node_data_field_release_date.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 = 1 AND na.realm = 'content_access_rid'))) AND ( (node.type IN ('ideas')) AND (node.status = '1') ) GROUP BY DATE_FORMAT(STR_TO_DATE(node_data_field_release_date.field_release_date_value, '%Y-%m-%dT%T'), '%Y-%m') LIMIT 40, 20 in /home/psr/public_html/includes/database.mysql.inc on line 174.
  • 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 'range, count( DISTINCT(node.nid)) AS num_nodes FROM node node LEFT JOIN content' at line 1 query: SELECT DATE_FORMAT(STR_TO_DATE(node_data_field_release_date.field_release_date_value, '%Y-%m-%dT%T'), '%Y-%m') AS range, count( DISTINCT(node.nid)) AS num_nodes FROM node node LEFT JOIN content_field_release_date node_data_field_release_date ON node.vid = node_data_field_release_date.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 = 1 AND na.realm = 'content_access_rid'))) AND ( (node.type IN ('ideas')) AND (node.status = '1') ) GROUP BY DATE_FORMAT(STR_TO_DATE(node_data_field_release_date.field_release_date_value, '%Y-%m-%dT%T'), '%Y-%m') ORDER BY node_data_field_release_date.field_release_date_value DESC LIMIT 40, 20 in /home/psr/public_html/includes/database.mysql.inc on line 174.
  • 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 'IN ('')) AND (. '')' at line 1 query: SELECT count(DISTINCT(DATE_FORMAT(STR_TO_DATE(node_data_field_release_date.field_release_date_value, '%Y-%m-%dT%T'), '%Y-%m'))) FROM node node LEFT JOIN content_field_release_date node_data_field_release_date ON node.vid = node_data_field_release_date.vid WHERE (. IN ('')) AND (. '') in /home/psr/public_html/includes/database.mysql.inc on line 174.