project in ("OpenMRS Trunk", "OpenMRS Standalone", "Release Testing Helper", "Module Maven Archetype", "HTML Form Entry Module", "Reporting Module", "HTML Widgets", "Reporting Compatability Module", "Serialization XStream", "XForms Module", "Patient Flags Module", "Form Entry Module", "Metadata Sharing Module")  and issuetype = Bug AND resolution = Unresolved and status not in ("In Progress", "Design", "Code Review (Initial)", "Code Review (Post-Commit)", "Code Review (Pre-Commit)") and key != TRUNK-1 ORDER BY votes DESC, priority DESC