The following leads were collected starting Wed - July 22, 2015. Totals reflect unique emails.

Total Leads: {exp:query sql="SELECT DISTINCT field_id_741 FROM exp_channel_data WHERE channel_id='110' OR channel_id='111'"} {if count==1}{total_results}{/if} {/exp:query}

YEARS FROM 2015-2020


Remainder of 2015 {exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2015'"}({the_count}){/exp:query}

{exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2015' GROUP BY field_id_742 ORDER BY FIELD(field_id_742,'January','February','March','April','May','June','July','August','September','October','November','December','Undecided','')"}

{if field_id_742}{field_id_742} {field_id_743}{if:else}Misc{/if} ({the_count})

{/exp:query}

FY 2016 {exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2016'"}({the_count}){/exp:query}

{exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2016' GROUP BY field_id_742 ORDER BY FIELD(field_id_742,'January','February','March','April','May','June','July','August','September','October','November','December','Undecided','')"}

{if field_id_742}{field_id_742} {field_id_743}{if:else}Misc{/if} ({the_count})

{/exp:query}

FY 2017 {exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2017'"}({the_count}){/exp:query}

{exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2017' GROUP BY field_id_742 ORDER BY FIELD(field_id_742,'January','February','March','April','May','June','July','August','September','October','November','December','Undecided','')"}

{if field_id_742}{field_id_742} {field_id_743}{if:else}Misc{/if} ({the_count})

{/exp:query}

FY 2018 {exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2018'"}({the_count}){/exp:query}

{exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2018' GROUP BY field_id_742 ORDER BY FIELD(field_id_742,'January','February','March','April','May','June','July','August','September','October','November','December','Undecided','')"}

{if field_id_742}{field_id_742} {field_id_743}{if:else}Misc{/if} ({the_count})

{/exp:query}

FY 2019 {exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2019'"}({the_count}){/exp:query}

{exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2019' GROUP BY field_id_742 ORDER BY FIELD(field_id_742,'January','February','March','April','May','June','July','August','September','October','November','December','Undecided','')"}

{field_id_742} {field_id_743} ({the_count})

{/exp:query}

FY 2020 {exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2020'"}({the_count}){/exp:query}

{exp:query sql="SELECT DISTINCT field_id_741,field_id_742,field_id_743,count(*) as the_count FROM exp_channel_data WHERE field_id_743='2020' GROUP BY field_id_742 ORDER BY FIELD(field_id_742,'January','February','March','April','May','June','July','August','September','October','November','December','Undecided','')"}

{if field_id_742}{field_id_742} {field_id_743}{if:else}Misc{/if} ({the_count})

{/exp:query}