Search results

Hello I am trying to use mysql to export a large list along with several fields pertaining to the list for confirmed subscribers. Can a sql ninja help me out with this query? Thanks