Error message

Notice: Undefined index: disabled_javascripts in eu_cookie_compliance_page_build() (line 306 of /var/www/drupal7/sites/all/modules/eu_cookie_compliance/eu_cookie_compliance.module).

How many senders are there on mailing lists in Alioth projects? (07-2011)

Description

This graph shows the number of mailing lists with each count of email senders in Alioth.

Visualization:

The first number shown when hovering over a dot is the number of senders. The second number is the number of mailing lists with that sender count.



SQL Script

Use the results from the following query to create a temp table.

SELECT mailing_list AS List, COUNT(DISTINCT sender) AS Senders
FROM al_messages
GROUP BY List
ORDER BY Senders DESC;

Use the temp table for the following query.

SELECT sender_count AS Sender Count, COUNT(mailing_list) AS Frequency
FROM al_temp_table
GROUP BY Sender Count
ORDER BY Frequency DESC;

AttachmentSize
Image icon 07-11-alioth-list-senders.png42.82 KB
Data Resources: