Importing more data
Posted by gregster on 27 Sep 2016 in Tasks
Importing the CGWP records that have matching CVWM rows produces about 10,600 results.
Of those, 173 seem to be duplicates.
We need someone to go through them and weed out dupes.
This is the sql to get those records:
select * from transfer ou where (select count(*) from transfer inr where inr.cwgc_id = ou.cwgc_id) > 1