SELECT distinct p.products_id FROM products p LEFT JOIN products_to_products_extra_fields pef on p.products_id = pef.products_id LEFT JOIN products_to_categories ptc on p.products_id = ptc.products_id WHERE p.products_status = '1' AND pef.products_extra_fields_id = '146' AND pef.products_extra_fields_value = '1,04mm' AND ptc.categories_id = '100096' group by p.products_id