How can I retrieve items with an empty field?

Another problem with the query is that in the answer I receive all the items where this field is not used as false positive (about 3500 items)

Just pushing it up because this issue is a real problem for me

Hello

i missed your last answer

here is the query to only include items that have an item types using the field
(field appears in the item forms of the items)

SELECT c.id, c.title
FROM PPP_content AS c
JOIN PPP_flexicontent_items_ext AS e
ON (c.id = e.item_id)
JOIN PPP_flexicontent_fields_type_relations AS f
ON (e.type_id = f.type_id AND v.field_id = 57)
LEFT JOIN PPP_flexicontent_fields_item_relations AS v
ON (c.id = v.item_id AND v.field_id = 57)
WHERE v.item_id IS NULL;

Here is my sql request with the right field_id and type_id
and I got an error:
#1054 - Champ 'v.field_id' inconnu dans on clause

Hello

the table alias is f

so instead of try
Now full query should be

Yes it works perfectly.

Do you think it is possible to implement that on the backend of Joomla as I don't want to give access at the server directly.

Kind regards