Changes

SQL Templates

46 bytes added, 12:33, 12 February 2014

no edit summary

</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]]

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits