select startTime, channelID, channels.description, sum(pixClicks), sum(seClicks) from whMonthlyGroupPerf join tsacommon.distribution on distributionID=distribution.id join tsacommon.channels on distribution.channelID=channels.id where whMonthlyGroupPerf.accountID=606 group by whMonthlyGroupPerf.accountID, startTime, distribution.channelID;
+------------+-----------+----------------------------+----------------+---------------+
| startTime  | channelID | description                | sum(pixClicks) | sum(seClicks) |
+------------+-----------+----------------------------+----------------+---------------+
| 2009-08-01 |         1 | Paid Search                |            720 |             0 | 
| 2009-08-01 |         3 | Organic Search             |            204 |             0 | 
| 2009-08-01 |         6 | Organic Bookmarks/Type-Ins |            935 |             0 | 
| 2009-08-01 |         7 | Other Referring Domains    |           6124 |             0 | 
| 2009-08-01 |         9 | Organic Email              |             50 |             0 | 
| 2009-09-01 |         1 | Paid Search                |           2362 |             0 | 
| 2009-09-01 |         3 | Organic Search             |            482 |             0 | 
| 2009-09-01 |         6 | Organic Bookmarks/Type-Ins |           1242 |             0 | 
| 2009-09-01 |         7 | Other Referring Domains    |          12906 |             0 | 
| 2009-09-01 |         9 | Organic Email              |              5 |             0 | 
| 2009-10-01 |         1 | Paid Search                |           2245 |             0 | 
| 2009-10-01 |         3 | Organic Search             |            642 |             0 | 
| 2009-10-01 |         6 | Organic Bookmarks/Type-Ins |           2076 |             0 | 
| 2009-10-01 |         7 | Other Referring Domains    |          15630 |             0 | 
| 2009-10-01 |         9 | Organic Email              |              7 |             0 | 
| 2009-11-01 |         1 | Paid Search                |           3848 |             0 | 
| 2009-11-01 |         3 | Organic Search             |            381 |             0 | 
| 2009-11-01 |         6 | Organic Bookmarks/Type-Ins |           9379 |             0 | 
| 2009-11-01 |         7 | Other Referring Domains    |          11013 |             0 | 
| 2009-11-01 |         9 | Organic Email              |              2 |             0 | 
| 2009-12-01 |         1 | Paid Search                |           4689 |             0 | 
| 2009-12-01 |         3 | Organic Search             |            611 |             0 | 
| 2009-12-01 |         6 | Organic Bookmarks/Type-Ins |           1721 |             0 | 
| 2009-12-01 |         7 | Other Referring Domains    |          10921 |             0 | 
| 2009-12-01 |         9 | Organic Email              |              1 |             0 | 
| 2010-01-01 |         1 | Paid Search                |           3760 |             0 | 
| 2010-01-01 |         3 | Organic Search             |            336 |             0 | 
| 2010-01-01 |         6 | Organic Bookmarks/Type-Ins |           1748 |             0 | 
| 2010-01-01 |         7 | Other Referring Domains    |           9458 |             0 | 
| 2010-02-01 |         1 | Paid Search                |           1054 |             0 | 
| 2010-02-01 |         3 | Organic Search             |            342 |             0 | 
| 2010-02-01 |         6 | Organic Bookmarks/Type-Ins |           1549 |             0 | 
| 2010-02-01 |         7 | Other Referring Domains    |           9051 |             0 | 
| 2010-02-01 |         9 | Organic Email              |              7 |             0 | 
| 2010-03-01 |         1 | Paid Search                |           2106 |             0 | 
| 2010-03-01 |         3 | Organic Search             |            242 |             0 | 
| 2010-03-01 |         6 | Organic Bookmarks/Type-Ins |           4960 |             0 | 
| 2010-03-01 |         7 | Other Referring Domains    |          10512 |             0 | 
| 2010-03-01 |         9 | Organic Email              |              2 |             0 | 
| 2010-04-01 |         1 | Paid Search                |            824 |             0 | 
| 2010-04-01 |         3 | Organic Search             |            170 |             0 | 
| 2010-04-01 |         6 | Organic Bookmarks/Type-Ins |           6022 |             0 | 
| 2010-04-01 |         7 | Other Referring Domains    |          11251 |             0 | 
| 2010-04-01 |         9 | Organic Email              |              1 |             0 | 
| 2010-05-01 |         1 | Paid Search                |           1756 |             0 | 
| 2010-05-01 |         3 | Organic Search             |            104 |             0 | 
| 2010-05-01 |         6 | Organic Bookmarks/Type-Ins |           4245 |             0 | 
| 2010-05-01 |         7 | Other Referring Domains    |           8860 |             0 | 
| 2010-05-01 |         9 | Organic Email              |              5 |             0 | 
| 2010-06-01 |         1 | Paid Search                |            245 |             0 | 
| 2010-06-01 |         3 | Organic Search             |             10 |             0 | 
| 2010-06-01 |         6 | Organic Bookmarks/Type-Ins |            291 |             0 | 
| 2010-06-01 |         7 | Other Referring Domains    |            943 |             0 | 
| 2010-06-01 |         9 | Organic Email              |              1 |             0 | 
+------------+-----------+----------------------------+----------------+---------------+
54 rows in set (0.03 sec)