</pre>
This query shows counts all existing templatesby Active
<pre>
SELECT
fieldreportnamefieldreportdesc.isactive,publisheddate,`version`Count(fieldreportdesc.fieldreportdesc_guid)
FROM
fieldreportdesc GROUP BYfieldreportdesc.isactive
ORDER BY
fieldreportname fieldreportdesc.isactive ASC,publisheddate ASC,`version` ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]