CDF missing in field

This query check if all records in customdefinedfield are in field

SELECT
customdefinedfield.name,
customdefinedfield.cdf_datatype,
customdefinedfield.entitytype
FROM
customdefinedfield
Left Join `field` ON customdefinedfield.cdf_id = `field`.cdf_guid
WHERE
`field`.cdf_guid IS NULL

This query check if all CDF records in field are in customdefinedfield

SELECT
`field`.property_name,
`field`.fieldtype,
`field`.display_mechanism,
`field`.cdf_guid
FROM
customdefinedfield
Right Outer Join `field` ON customdefinedfield.cdf_id = `field`.cdf_guid
WHERE
customdefinedfield.cdf_id IS NULL  AND
`field`.cdf_guid IS NOT NULL  AND
(`field`.fieldtype =  'cdf' OR
`field`.fieldtype =  'select_cdf')
ORDER BY
`field`.fieldtype ASC

Note: This query is in 5.x format