Ja sam ranije imao slicne probleme i od tada pisem querije ovako:
PHP kôd:
$query = "SELECT a.nesto, b.nestoDrugo ";
$query .="FROM tabela1 AS a ";
$query .="LEFT JOIN tabela2 AS b USING (key1) ";
$query .="WHERE nesto ";
$query .="GROUP BY something ";
$query .="ORDER BY ... ";
$query .="LIMIT ... ";