Actually, never mind what i just said. DBIC is right, it's a proper bugfix.
*Generally*, it is not correct to LEFT JOIN one thing then JOIN
onwards from it, which clearly is not your case here.
Sorry for the wrong spot.
--
wallace reis/wreis Catalyst and DBIx::Class consultancy with a clue
Software Developer and a commit bit:
http://shadowcat.co.uk/catalyst/
Shadowcat Systems Limited
http://www.shadowcat.co.uk http://www.linkedin.com/in/wallacereis
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]