You're already pulling your weeks from a table "time t". Why not just add a fiscalYear column to that table and group on it and/or just add where t.fiscalYear = whatever?
└> bt
Forum Etiquette: How to post data/code on a forum to get the best help[/url]