Resolving Errors in Select Queries with Group By Statements in CakePHP on SQL Server

Optimizing MySQL Performance on Subquery Count of Another Table