select count(*) from ( select distinct d.* from ( SELECT c.* FROM (select distinct contact_id from certs where Certification_Date>=now()-365*1 union select distinct trainer from certs where Certification_Date>=now()-365*1 union select distinct user from queries where date>=now()-365*1 union select distinct contact_id from (select Event_id from events where date>=now()-365*1) as e left join parts as p on e.Event_id=p.Event_id where contact_id ) AS a LEFT JOIN contacts AS c ON a.contact_id=c.contact_id ) as d left join CG as e on d.Contact_ID=e.Contact_ID )
Groups Sites Events Data Volunteers Newsletters
Currently active
... ... ... ... ... Jan-Mar 2014

Archived
Database totals ... ... ... ... ...
AAS Coordinators and Trainers can post on the calendar. Contact the State Office for more information: aas@gaepd.org.
This database is supported in partnership with the University of Georgia, Marine and Cooperative Extension Services.

The preparation of this website was financed in part through a grant from the U.S. Environmental Protection Agency
under provisions of Section 319(h) of the Federal Clean Water Act of 1987, as amended.

Georgia Adopt-A-Stream Environmental Protection Division, GA DNR
2 MLK Jr. Dr. S.W. Suite 1462 E Atlanta, GA 30334 404-651-1464 aas@gaepd.org