added ticket queries to content provider