Re-factored the SQL to get rid of meaningless "TRUE" condition (one of those things that was easy in the light of day but seemed hard at 2 am).
Re-factored the SQL to get rid of meaningless "TRUE" condition (one of those things that was easy in the light of day but seemed hard at 2 am).

STS179: LHDs granted access to see another jurisdiction's CMR are currently not seeing them in their CMR list
STS208: Duplicate events appear in CMR list when they are assigned to multiple jurisdictions 
STS219: Sorting CMR list results in an page not found error 


git-svn-id: 105a8f2fe5eb3dca76b21e204c69f6587dfa9961@2584 b21a84b9-e453-0410-92a3-c4f515f7ae45

csinitiative/trisano,csinitiative/trisano,csinitiative/trisano,csinitiative/trisano,csinitiative/trisano