select id
from machine_store
group by machine_num, machine_source
having count(*) > 1
select *
from machine_store
where id in (
select id
from machine_store
group by machine_num, machine_source
having count(*) > 1
)
select id
from machine_store
group by machine_num, machine_source
having count(*) > 1
select *
from machine_store
where id in (
select id
from machine_store
group by machine_num, machine_source
having count(*) > 1
)