I’m using the following SQL
select * from psx_objectrelationship join CONTENTSTATUS on (psx_objectrelationship.OWNER_ID = CONTENTSTATUS.CONTENTTYPEID) where contenttypeid = XXXX and variant_id = YYYY
to try and find out where this content-type/template combination is being used. It’s returning zero results. However, when I try to remove this template from the Allowed Templates list, the system is telling me that associations exist.
What am I missing?