File:Confirmations and participants of project Personal acquaintances, 2014-10-30.png
Size of this preview: 800 × 477 pixels. Other resolutions: 320 × 191 pixels | 640 × 382 pixels | 1,030 × 614 pixels.
Original file (1,030 × 614 pixels, file size: 33 KB, MIME type: image/png)
File information
Structured data
Captions
Summary
editDescriptionConfirmations and participants of project Personal acquaintances, 2014-10-30.png |
Deutsch: Das Diagramm zeigt die Anzahl der Bestätigungen und Teilnehmer bei WP:PB für den Zeitraum vom 8. Februar 2008 bis 30. Oktober 2014
English: Statistics: Number of confirmations and participants from February 8 to October 30, 2014 |
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 dewiki.labsdb p50380g50752__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
|
Author | Euku |
Other versions |
other versions: |
Licensing
editI, the copyright holder of this work, hereby publish it under the following licenses:
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.http://www.gnu.org/copyleft/fdl.htmlGFDLGNU Free Documentation Licensetruetrue |
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.
File history
Click on a date/time to view the file as it appeared at that time.
Date/Time | Thumbnail | Dimensions | User | Comment | |
---|---|---|---|---|---|
current | 16:28, 30 October 2014 | 1,030 × 614 (33 KB) | Euku (talk | contribs) | == {{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. Oktober 2014}} {{en|Statistics: Number of confirmations and par... |
You cannot overwrite this file.
File usage on Commons
There are no pages that use this file.
File usage on other wikis
The following other wikis use this file:
- Usage on wikimania2016.wikimedia.org
- Usage on wikimania2017.wikimedia.org
Metadata
This file contains additional information such as Exif metadata which may have been added by the digital camera, scanner, or software program used to create or digitize it. If the file has been modified from its original state, some details such as the timestamp may not fully reflect those of the original file. The timestamp is only as accurate as the clock in the camera, and it may be completely wrong.
Horizontal resolution | 37.79 dpc |
---|---|
Vertical resolution | 37.79 dpc |