a

select COUNT(product_id),product_id
from table_check A
WHERE EXISTS (
select 1
from m_product B
where product_code IN (
'code_dalam_lampiran'
)
AND A.product_id = B.product_id
)
group by product_id