help complex query

Hi! I don’t know if it’s complex but I don’t know how to attack it. Well, I ve woocommerce in my site. Every product has it’s own acf fields. I ve a repeater field. I want to do filter products if repeater field has something..

Example:

Product1. Has the repeater field filled… so I ve to add an extra where.
Product2. Repeater field empty. Ignore extra where.
…

In raw sql I would have a: WHERE… (case when repeater_field_filled then acf_field_X = ‘value’ else 1=1 end) .. something like that

Some help? ??