424 bytes added,
16:44, 10 February 2014 <pre>SELECT
`field`. fieldtype,
`field`.display_mechanism,
customdefinedfield.cdf_datatype,
Count(`field`.field_guid)
FROM
customdefinedfield
Inner Join `field` ON `field`.cdf_guid = customdefinedfield.cdf_id
GROUP BY
`field`.fieldtype,
`field`.display_mechanism,
customdefinedfield.cdf_datatype
ORDER BY
`field`.fieldtype ASC,
`field`.display_mechanism ASC,
customdefinedfield.cdf_datatype ASC
</pre>
[[Category:NoPublic]]