There may certainly be something going on with db_rewrite_sql(), so you'll probably have to find out what the actual query is when it gets sent to mysql. Stepping into db_query() is a great way to do this.
-Randy--
On Thu, Apr 8, 2010 at 11:20 AM, Aaron Winborn <winborn@advomatic.com> wrote: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 DESCYes, 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/
Randy Fay
Drupal Development, troubleshooting, and debugging
randy@randyfay.com
+1 970.462.7450