Changes

SQL Templates

477 bytes added, 14:26, 11 February 2014

Created page with "<pre>SELECT fieldreportname, orgname, publisheddate, `version`, Count(fieldreport_guid) FROM fieldreport INNER JOIN fieldreportdesc ON fieldreport.fieldreportdesc_guid = field..."

<pre>SELECT
fieldreportname,
orgname,
publisheddate,
`version`,
Count(fieldreport_guid)
FROM
fieldreport
INNER JOIN fieldreportdesc ON fieldreport.fieldreportdesc_guid = fieldreportdesc.fieldreportdesc_guid
INNER JOIN organisation ON fieldreportdesc.org_guid = organisation.org_guid
GROUP BY
fieldreportdesc.fieldreportname,
organisation.orgname,
publisheddate,
`version`
ORDER BY
fieldreportname ASC,
orgname ASC,
publisheddate ASC,
`version` ASC

</pre>
[[Category:NoPublic]]

• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits