Code | DrupalBin

Code

August 19, 2008 - 9:51am — Anonymous

-- Error: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause query
 
SELECT n.newspaper_id, n.DATE, n.sent, COUNT(o.nid) AS node_count 
FROM newspaper AS n 
LEFT JOIN newspaper_nodes AS o 
USING (newspaper_id)
ORDER BY DATE DESC LIMIT 0, 25;'