process collector

SQL Statement = select * from com_panel where 1=1 AND pnl_id NOT IN (SELECT ptc_participant FROM com_participant WHERE ptc_survey in (''))
Email Id Code Lastname Firstname Phone Source Gender Year of Birth Indigenous Identity Community Type Official Language Indigenous Languages Spoken at Home Education Employment Household Income Province City PostalCode Band Last Updated Traditional Community Status
carmenjkeesko@gmail.com 12859 QMB00011 Organic Female 1988 First Nation Prefer Not To Say Prefer Not To Say Prefer Not To Say Prefer Not to Say Alberta No Prefer not to say Active
ckaren389@gmail.com 12860 YQF00013 Organic Male 1992 First Nation Prefer Not To Say Prefer Not To Say Prefer Not To Say Prefer Not to Say Saskatchewan No Prefer not to say Active
floydsabit@Hotmail.com 12861 YOO00012 Jack Organic Male 1974 Métis Urban English Prefer Not To Say Self Employed Prefer Not to Say Ontario No No Active
ljerome@ucalgary.ca 12863 GGZ00015 Organic Female 1956 Métis Urban English Prefer Not To Say Prefer Not To Say Prefer Not to Say Saskatchewan No No Active
alexdedam23@gmail.com 12864 BAX00029 Alex 506-760-8716 Organic Female 1990 First Nation Prefer Not To Say University Bachelor Full Time Between $25,000 and $34,999 Quebec Listuguj G0c 2r0 Yes Prefer not to say Active
amandapoulette@hotmail.com 12865 FIJ00016 Amanda 902-578-6282 Organic Female 1983 First Nation Remote University Bachelor Prefer Not To Say Between $50,000 and $$74,999 Nova Scotia Eskasoni NS Yes Prefer not to say Active
amber.herney@gmail.com 12866 ZOO00020 Amber 902-814-2240 Organic Female 1994 First Nation Prefer Not To Say Prefer Not To Say Unemployed Between $75,000 and $99,999 Nova Scotia Truro Heights NS Yes Prefer not to say Active
asanregret@hotmail.com 12867 UCK00034 Organic Female 1974 Métis Rural Prefer Not To Say Full Time Between $75,000 and $99,999 Prefer Not To Say T0A 1A0 Prefer not to say Prefer not to say Active
baby_tigger_17@hotmail.com 12868 SXD00021 Phia 902-379-2628 Organic Female 1985 First Nation Prefer Not To Say Prefer Not To Say Unemployed Between $15,000 and $19,999 Nova Scotia Eskasoni NS Yes Prefer not to say Active
balexis.199518@gmail.com 12869 GBT00018 780-902-5690 Organic Male 1995 First Nation Prefer Not To Say University Bachelor Full Time Between $50,000 and $$74,999 Prefer Not To Say T0E 0X0 Yes Prefer not to say Active