title: MySQL #1140 - Mixing of GROUP columns
body: <p>Hi wondering if perhaps someone could shed some light on the below error. The sql works fine locally but i get the the  below error remotely.</p>
  
  <p>SQL query: </p>
  
  <pre><code>   SELECT COUNT(node.nid), 
            node.nid AS nid, 
            node_data_field_update_date.field_update_date_value AS node_data_field_update_date_field_update_date_value
       FROM node node
  LEFT JOIN content_type_update node_data_field_update_date ON node.vid = node_data_field_update_date.vid
      WHERE node.type IN ('update')
  ORDER BY node_data_field_update_date_field_update_date_value DESC
  </code></pre>
  
  <p>MySQL said: </p>
  
  <blockquote>
    <p>#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no
    GROUP columns is illegal if there is
    no GROUP BY clause`</p>
  </blockquote>