CDF display format
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