Koji smor... ja sam ponekad pisao ovako
PHP kôd:
$query = "SELECT a.nesto, b.nestoDrugo ".
"FROM tabela1 AS a ".
"LEFT JOIN tabela2 AS b USING (key1) ".
"WHERE nesto ".
"GROUP BY something ".
"ORDER BY ... ".
"LIMIT ... ";
ali mi je to bzzze

kada promenis, moras da menjas navodnike, tackice,...