Query with "not equal" join

Hi,
I have two tables:
foto and relationship_foto_location
They share the same idfoto
Now I want to extract records from the first one (foto) where idfoto is not in the second table (relationship_foto_location)
This is my query:


It doesn’t work at all.
Result is so strange.
https://www.campaniaturismo.org/admin/admin-foto-list.php#admintemplate (second tab - no luoghi)
Can anybody help me?
Thank you

Community Page
Last updated: