Jump to content

File:Confirmations and participants of project Personal acquaintances, 2021-05-20.png

Page contents not supported in other languages.
This is a file from the Wikimedia Commons
From Wikipedia, the free encyclopedia

Original file (1,964 × 1,156 pixels, file size: 171 KB, MIME type: image/png)

Summary

Description
Deutsch: Das Diagramm zeigt die Anzahl der Bestätigungen und Teilnehmer bei WP:PB für den Zeitraum vom 8. Februar 2008 bis 30. Mai 2021
English: Statistics: Number of confirmations and participants from February 8 to May 30th, 2021
Date
Source

Own work

// Diese Abfrage betrachtet nicht die als gelöscht oder gesperrt markierte Bestätigungen und Benutzer. Somit gibt es Abweichungen.
mysql --defaults-file=~/replica.pb-db.cnf -h tools-db s51344__pb -e "
SELECT Date, IFNULL(newUsers, 0), IFNULL(newConfs, 0) FROM (
SELECT DATE(LEAST(IFNULL(cf.cf_timestamp_Date, NOW()), IFNULL(u.user_participates_since_Date, NOW()))) AS Date, newUsers, newConfs FROM (
	SELECT COUNT(*) AS newConfs, DATE(cf_timestamp) AS cf_timestamp_Date  from confirmation GROUP BY DATE(cf_timestamp)
) cf LEFT JOIN (
	SELECT COUNT(*) AS newUsers, DATE(user_participates_since) AS user_participates_since_Date from user GROUP BY DATE(user_participates_since)
) u ON cf.cf_timestamp_Date = u.user_participates_since_Date
UNION
SELECT DATE(LEAST(IFNULL(cf.cf_timestamp_Date, NOW()), IFNULL(u.user_participates_since_Date, NOW()))) AS Date, newUsers, newConfs FROM (
	SELECT COUNT(*) AS newConfs, DATE(cf_timestamp) AS cf_timestamp_Date  from confirmation GROUP BY DATE(cf_timestamp)
) cf RIGHT JOIN (
	SELECT COUNT(*) AS newUsers, DATE(user_participates_since) AS user_participates_since_Date from user GROUP BY DATE(user_participates_since)
) u ON cf.cf_timestamp_Date = u.user_participates_since_Date
) unionTable ORDER BY Date;" > pb-statistik.txt
Created with Excel.
Author Euku
Other versions

Older versions:

Licensing

I, the copyright holder of this work, hereby publish it under the following licenses:
GNU head Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the section entitled GNU Free Documentation License.
w:en:Creative Commons
attribution share alike
This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported, 2.5 Generic, 2.0 Generic and 1.0 Generic license.
You are free:
  • to share – to copy, distribute and transmit the work
  • to remix – to adapt the work
Under the following conditions:
  • attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
  • share alike – If you remix, transform, or build upon the material, you must distribute your contributions under the same or compatible license as the original.
You may select the license of your choice.

Captions

Add a one-line explanation of what this file represents

Items portrayed in this file

depicts

30 May 2021

image/png

76fab049a89d76ddf064e0dc8d53bcf012d935f7

175,363 byte

1,156 pixel

1,964 pixel

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeThumbnailDimensionsUserComment
current21:36, 30 May 2021Thumbnail for version as of 21:36, 30 May 20211,964 × 1,156 (171 KB)Euku== {{int:filedesc}} == {{Information |Description={{de|Das Diagramm zeigt die Anzahl der Bestätigungen und Teilnehmer bei WP:PB für den Zeitraum vom 8. Februar 2008 bis 30. Mai 2021}} {{en|Statistics: Number of confirmations and participants from February 8 to May 30th, 2021}} |Source={{own}} <source lang="bash"> // Diese Abfrage betrachtet nicht die als gelöscht oder gesperrt markierte Bestätigungen und Benutzer. Somit gibt es Abweichungen. mysql --defaults-file=~/replica.pb-d...

The following page uses this file:

Global file usage

The following other wikis use this file:

Metadata