Can you post your Drupal query? Hard to troubleshoot w/o the original code.

nan wich wrote:
I have the following query, which works fine in PhpMyAdmin, but Drupal upchucks on it. Why?
 
SELECT nc.nid, n.title, n.created, nc.daycount AS views_today, nc.totalcount AS total_views,
  (SELECT COUNT(*) FROM comments c WHERE c.timestamp >= 1270699200 AND c.nid=nc.nid) AS comments_today,
  cs.comment_count
  FROM node_counter nc
  INNER JOIN node n ON n.nid=nc.nid
  LEFT JOIN node_comment_statistics cs ON cs.nid=nc.nid
  WHERE nc.daycount > 0
  ORDER BY nc.daycount DESC
 
Yes, in Drupal, I do put the brackets around the table names.
 
The error message says there's a problem at " AS comments_today, cs.comment_count FROM...".
 

Nancy E. Wichmann, PMP

Sometimes the questions are complicated and the answers are simple. - Dr. Suess



-- 
Aaron Winborn

Advomatic, LLC
http://advomatic.com/

Drupal Multimedia available in September!
http://www.packtpub.com/create-multimedia-website-with-drupal/book

My blog:
http://aaronwinborn.com/

Reply via email to