Talk:Account Creation Improvement Project/Results

From Outreach Wiki
Jump to navigation Jump to search

Stats for five edits[edit]

Original version[edit]

SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110329000000" AND user_registration<"20110330000000" AND day>="2011-03-29" AND day<"2011-03-30" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 339 | +----------+ 1 row in set (2.96 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110330000000" AND user_registration<"20110331000000" AND day>="2011-03-30" AND day<"2011-03-31" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 316 | +----------+ 1 row in set (6.60 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110331000000" AND user_registration<"20110401000000" AND day>="2011-03-31" AND day<"2011-04-01" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 339 | +----------+ 1 row in set (6.00 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110401000000" AND user_registration<"20110402000000" AND day>="2011-04-01" AND day<"2011-04-02" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 344 | +----------+ 1 row in set (6.56 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110402000000" AND user_registration<"20110403000000" AND day>="2011-04-02" AND day<"2011-04-03" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 251 | +----------+ 1 row in set (5.36 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110403000000" AND user_registration<"20110404000000" AND day>="2011-04-03" AND day<"2011-04-04" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 234 | +----------+ 1 row in set (5.66 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110404000000" AND user_registration<"20110405000000" AND day>="2011-04-04" AND day<"2011-04-05" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 337 | +----------+ 1 row in set (5.71 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110405000000" AND user_registration<"20110406000000" AND day>="2011-04-05" AND day<"2011-04-06" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 345 | +----------+ 1 row in set (6.01 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110406000000" AND user_registration<"20110407000000" AND day>="2011-04-06" AND day<"2011-04-07" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 342 | +----------+ 1 row in set (5.50 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110407000000" AND user_registration<"20110408000000" AND day>="2011-04-07" AND day<"2011-04-08" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 336 | +----------+ 1 row in set (5.30 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110408000000" AND user_registration<"20110409000000" AND day>="2011-04-08" AND day<"2011-04-09" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 294 | +----------+ 1 row in set (5.49 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110409000000" AND user_registration<"20110410000000" AND day>="2011-04-09" AND day<"2011-04-10" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 211 | +----------+ 1 row in set (5.08 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110410000000" AND user_registration<"20110411000000" AND day>="2011-04-10" AND day<"2011-04-11" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 231 | +----------+ 1 row in set (5.50 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110411000000" AND user_registration<"20110412000000" AND day>="2011-04-11" AND day<"2011-04-12" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 309 | +----------+ 1 row in set (5.53 sec)



mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110412000000" AND user_registration<"20110413000000" AND day>="2011-04-12" AND day<"2011-04-13" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 310 | +----------+ 1 row in set (3.14 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110413000000" AND user_registration<"20110414000000" AND day>="2011-04-13" AND day<"2011-04-14" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 288 | +----------+ 1 row in set (3.14 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110414000000" AND user_registration<"20110415000000" AND day>="2011-04-14" AND day<"2011-04-15" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 327 | +----------+ 1 row in set (3.11 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110415000000" AND user_registration<"20110416000000" AND day>="2011-04-15" AND day<"2011-04-16" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 290 | +----------+ 1 row in set (3.00 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110416000000" AND user_registration<"20110417000000" AND day>="2011-04-16" AND day<"2011-04-17" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 243 | +----------+ 1 row in set (3.01 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110417000000" AND user_registration<"20110418000000" AND day>="2011-04-17" AND day<"2011-04-18" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 252 | +----------+ 1 row in set (3.10 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110418000000" AND user_registration<"20110419000000" AND day>="2011-04-18" AND day<"2011-04-19" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 317 | +----------+ 1 row in set (2.96 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110419000000" AND user_registration<"20110420000000" AND day>="2011-04-19" AND day<"2011-04-20" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 331 | +----------+ 1 row in set (3.12 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110420000000" AND user_registration<"20110421000000" AND day>="2011-04-20" AND day<"2011-04-21" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 251 | +----------+ 1 row in set (3.07 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110421000000" AND user_registration<"20110422000000" AND day>="2011-04-21" AND day<"2011-04-22" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 315 | +----------+ 1 row in set (7.55 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110422000000" AND user_registration<"20110423000000" AND day>="2011-04-22" AND day<"2011-04-23" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 285 | +----------+ 1 row in set (8.26 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110423000000" AND user_registration<"20110424000000" AND day>="2011-04-23" AND day<"2011-04-24" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 252 | +----------+ 1 row in set (7.94 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110424000000" AND user_registration<"20110425000000" AND day>="2011-04-24" AND day<"2011-04-25" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 249 | +----------+ 1 row in set (8.09 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110425000000" AND user_registration<"20110426000000" AND day>="2011-04-25" AND day<"2011-04-26" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 348 | +----------+ 1 row in set (8.56 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110426000000" AND user_registration<"20110427000000" AND day>="2011-04-26" AND day<"2011-04-27" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 368 | +----------+ 1 row in set (9.08 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110427000000" AND user_registration<"20110428000000" AND day>="2011-04-27" AND day<"2011-04-28" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 370 | +----------+ 1 row in set (9.17 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110428000000" AND user_registration<"20110429000000" AND day>="2011-04-28" AND day<"2011-04-29" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 335 | +----------+ 1 row in set (9.91 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110429000000" AND user_registration<"20110430000000" AND day>="2011-04-29" AND day<"2011-04-30" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 322 | +----------+ 1 row in set (7.97 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110430000000" AND user_registration<"20110501000000" AND day>="2011-04-30" AND day<"2011-05-01" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 239 | +----------+ 1 row in set (4.83 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110501000000" AND user_registration<"20110502000000" AND day>="2011-05-01" AND day<"2011-05-02" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 273 | +----------+ 1 row in set (7.98 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110502000000" AND user_registration<"20110503000000" AND day>="2011-05-02" AND day<"2011-05-03" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 283 | +----------+ 1 row in set (8.34 sec)

mysql> SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110503000000" AND user_registration<"20110504000000" AND day>="2011-05-03" AND day<"2011-05-04" AND contribs>="5") as dummy; +----------+ | COUNT(*) | +----------+ | 299 | +----------+ 1 row in set (8.01 sec)

Version without mysql query[edit]

2011-03-29 |339 |

2011-03-30 |316 |

2011-03-31 |339 |

2011-04-01 |344 |

2011-04-02 |251 |

2011-04-03 |234 |

2011-04-04 |337 |

2011-04-05 |345 |

2011-04-06 |342 |

2011-04-07 |336 |

2011-04-08 |294 |

2011-04-09 |211 |

2011-04-10 |231 |

2011-04-11 |309 |

2011-04-12 |310 |

2011-04-13 |288 |

2011-04-14 |327 |

2011-04-15 |290 |

2011-04-16 |243 |

2011-04-17 |252 |

2011-04-18 |317 |

2011-04-19 |331 |

2011-04-20 |251 |

2011-04-21 |315 |

2011-04-22 |285 |

2011-04-23 |252 |

2011-04-24 |249 |

2011-04-25 |348 |

2011-04-26 |368 |

2011-04-27 |370 |

2011-04-28 |335 |

2011-04-29 |322 |

2011-04-30 |239 |

2011-05-01 |273 |

2011-05-02 |283 |

2011-05-03 |299 |