https://bugzilla.wikimedia.org/show_bug.cgi?id=57038
--- Comment #13 from Alvaro <[email protected]> --- (In reply to comment #12) > (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 With the correct query this number is: * 49 people with +2 actions not from WMF in 2013 Q3. I am sorry about the noise! > > * 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
