tend to changes-requested points from import script

[michielbdejong]

select count(*) from points where user_id=4 and status='changes-requested';
 count 
-------
  1112
(1 row)

[michielbdejong]

Did the ones with service Google. Got it down by 14, to 1098.

[michielbdejong]

Got it down by 17, to 1081.

[michielbdejong]

removed a number of duplicates and took 100 points myself.

[michielbdejong]

select user_id, count(*) from points where status='changes-requested' group by user_id order by count desc limit 5;
 user_id | count 
---------+-------
       4 |   852
       6 |   102
     133 |    96
       7 |    10
      17 |     9
(5 rows)

[michielbdejong]

down from by 23+23=46:

select user_id, count(*) from points where status='changes-requested' group by user_id order by count desc limit 5;
 user_id | count 
---------+-------
       4 |   829
     133 |    96
       6 |    79
       7 |    10
      17 |     9
(5 rows)

[michielbdejong]

Down by 8 points in 35 minutes. I guess I can do about 80 points per day (did 85 today, but only about 30 of those were actual investigations; the other 55 were just removing duplicates or removing points about discontinued services).

[michielbdejong]

Assigned points up to id 1466 to user 568 using #706.

 select user_id, count(*) from points where status='changes-requested' group by user_id order by count desc limit 5;
 user_id | count 
---------+-------
       4 |   712
     568 |   103
     133 |    96
       6 |    72
       7 |    10
(5 rows)