<head>
<style>
@page {
mso-page-orientation:landscape;
margin:.5in .5in .5in .5in;
mso-footer-margin:.25in;
mso-footer-data:"&R&P of &N";
}
.NB {border:none}
.th {background:#def;border:0.5pt solid black}
.th2 {background:#def;border-top:0.5pt solid black;border-bottom:0.5pt solid black}
td,th {border:none}
.BD td {border:0.5pt solid silver;border-left:none;border-top:none;padding:0.2em}
.BB th {width:3.5em;border:0.5pt solid silver;border-top:0.5pt solid black;border-bottom:0.5pt solid black;background:yellow}
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>XNAMEX</x:Name>
<x:WorksheetOptions>
<x:DoNotDisplayGridlines/>
<x:Print>
<x:ValidPrinterInfo/>
</x:Print>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
<x:ExcelName>
<x:Name>Print_Titles</x:Name>
<x:SheetIndex>1</x:SheetIndex>
<x:Formula>=XNAMEX!$1:$10</x:Formula>
</x:ExcelName>
</xml><![endif]-->
</head>
<body>
<table cellspacing=0 cellpadding=0 style="border-collapse:collapse;font-family:arial;font-size:9pt">
<tr valign="top">
<td colspan="7" style="font-weight:bold">xGroup
<tr><td colspan="7" style="font-weight:bold">xSite
<tr><td colspan="7" style="font-weight:bold">xLoc
<tr><td colspan="7" style="font-weight:bold">xWatershed
<tr><td>
XXXX
</table>
</body>
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
)
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.
Adopt-A-
