Miscellany

create table test.tmp_is_primary_phone ( id integer unsigned );insert into test.tmp_is_primary_phone select min(id) from civicrm_phone where is_primary = 1 group by contact_id ;update civicrm_phone set is_primary = 0 where id not in ( select id from test.tmp_is_primary_phone ) ;drop table test.tmp_is_primary_phone ;