(reporting@localhost) [sac_reporting]> SELECT source, campaign_medium, SUM(1) qty FROM prospects WHERE created_at> NOW() - INTERVAL 1 MONTH AND club_id=1 GROUP BY source, campaign_medium;
+----------+-----------------+-------+
| source   | campaign_medium | qty   |
+----------+-----------------+-------+
|          |                 |   469 |
|          | display         |  4571 |
|          | e-mail          |   769 |
|          | email           |  4298 |
|          | organic         |    32 |
|          | the_medium      |     1 |
| CS       | display         |    13 |
| facebook |                 |   149 |
| facebook | display         | 30927 |
+----------+-----------------+-------+