Finding content-type / template combinations


I’m using the following SQL

select * from psx_objectrelationship
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?

I think you want psx_objectrelationship.DEPENDENT_ID.

Yep … that’ll be it. Couldn’t see the mistake for looking!