title: SQL Query Group by and order by
body: <p>My sql query is like</p>
  
  <pre><code>SELECT `speciesname`, sum(`total_species_catch`) as species_catch FROM `species_estimation` GROUP by `speciesid` ORDER by `species_catch` DESC LIMIT 0,10
  </code></pre>
  
  <p>It is working fine in localhost phpmyadmin</p>
  
  <p>In server it shows error like  </p>
  
  <pre><code>SELECT list is not in GROUP BY clause and contains nonaggregated column 'fimsul.species_estimation.speciesname' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  </code></pre>