# Woche vor der Zeitumstellung (Mo-Sa)
mysql> select mod(ahour, 24) as dhour, avg(link-`avg`), stddev(link-`avg`) from alf left join alfredi2 using (node_ip) where `time` >= "2008-10-20" and `time` <= "2008-10-25 23:59" group by dhour;

+-------+-------------------+--------------------+
| dhour | avg(link-`avg`)   | stddev(link-`avg`) |
+-------+-------------------+--------------------+
|     0 |  0.01167738084215 |   0.12749128785065 | 
|     1 |  0.01189380303908 |   0.12958698710288 | 
|     2 |  0.02658102009578 |   0.11891254264537 | 
|     3 |  0.02407836458079 |   0.13474474194973 | 
|     4 |  0.02610393057018 |   0.13026708173781 | 
|     5 |  0.02668247776167 |   0.14311294683223 | 
|     6 |  0.01744662530550 |   0.14697443161544 | 
|     7 |  0.02550039254599 |   0.12109598472085 | 
|     8 |  0.01463243032964 |   0.13785038873192 | 
|     9 |  0.01444820799286 |   0.12773050505868 | 
|    10 |  0.01227814051980 |   0.10955050649397 | 
|    11 | -0.00041386778652 |   0.13389128589128 | 
|    12 | -0.00271121694356 |   0.16193938270855 | 
|    13 | -0.00521599614650 |   0.13792169804128 | 
|    14 | -0.01646687428403 |   0.15702374759327 | 
|    15 | -0.01363146529711 |   0.15436360104803 | 
|    16 | -0.01117880964731 |   0.15593353671208 | 
|    17 | -0.01756085631384 |   0.16163747280409 | 
|    18 | -0.02739384830759 |   0.17966626303710 | 
|    19 | -0.02575538745280 |   0.17980512248402 | 
|    20 | -0.02032933174561 |   0.15968582706026 | 
|    21 | -0.03423686818377 |   0.17814536939275 | 
|    22 | -0.02714861607652 |   0.18166289083558 | 
|    23 | -0.00757013145031 |   0.13051126948760 | 
+-------+-------------------+--------------------+

# Woche nach der Zeitumstellung (Mo-Sa)
mysql> select mod(ahour, 24) as dhour, avg(link-`avg`), stddev(link-`avg`) from alf left join alfredi2 using (node_ip) where `time` >= "2008-10-27" and `time` <= "2008-11-01 23:59" group by dhour;
+-------+-------------------+--------------------+
| dhour | avg(link-`avg`)   | stddev(link-`avg`) |
+-------+-------------------+--------------------+
|     0 |  0.00802329843687 |   0.11964471982162 | 
|     1 |  0.01402241156081 |   0.11607545347832 | 
|     2 |  0.00527950376091 |   0.12230850126134 | 
|     3 |  0.01447156084298 |   0.12444787373254 | 
|     4 |  0.01996772083274 |   0.12423512550122 | 
|     5 |  0.02140958340227 |   0.11481959435228 | 
|     6 |  0.01984590236937 |   0.11603732967828 | 
|     7 |  0.01572412155664 |   0.11565972088636 | 
|     8 |  0.00438841092522 |   0.11502612864365 | 
|     9 |  0.00057241992985 |   0.11199190126607 | 
|    10 | -0.00311263506440 |   0.11849755195433 | 
|    11 | -0.00573847267541 |   0.11717332311589 | 
|    12 | -0.01452900347219 |   0.13546335112101 | 
|    13 | -0.01412147149900 |   0.11958972039310 | 
|    14 | -0.01081761943346 |   0.10750637718418 | 
|    15 | -0.01302019157720 |   0.12044800987904 | 
|    16 | -0.01313677400264 |   0.11804933973376 | 
|    17 | -0.01230348503054 |   0.12035781915345 | 
|    18 | -0.01049186487415 |   0.12678923081430 | 
|    19 | -0.00651026468080 |   0.12652727864115 | 
|    20 | -0.01841346231355 |   0.12860823463293 | 
|    21 | -0.00856549354040 |   0.12836267846932 | 
|    22 | -0.00783555927857 |   0.12583948419919 | 
|    23 | -0.00712664892569 |   0.11656227933201 | 
+-------+-------------------+--------------------+