SQL Templates

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