https://bugzilla.wikimedia.org/show_bug.cgi?id=57038
--- Comment #12 from Alvaro <a...@bitergia.com> --- (In reply to comment #8) > Ok Quim, finally I have found time for gathering the results. > > From Jul to Sep 2013: > > * 34 people with +2 actions not from WMF > * The complete list below > > mysql> select count(distinct(changes.id)) as total, changed_by, > people_upeople.upeople_id, people.name, company_id, companies.name from > changes, people_upeople, people, > acs_cvsanaly_mediawiki_2428.upeople_companies, > acs_cvsanaly_mediawiki_2428.companies where people.id = > people_upeople.people_id and changes.changed_by=people_upeople.people_id and > upeople_companies.upeople_id = people_upeople.upeople_id and > upeople_companies.company_id = companies.id and new_value='2' and changed_on > > > '2013-06' and changed_on < '2013-10' and companies.name <>'Wikimedia > Deutschland' and companies.name<>'Wikimedia Foundation'group by changed_by > order by total desc; Guys, this query was not correct because "changed_on > '2013-06' and changed_on < '2013-10'". This should be "changed_on > '2013-06-31' and changed_on < '2013-10-01'". It is better for quarter analysis to use: "QUARTER(changed_on) = 3 and YEAR(changed_on) = '2013'" -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
