Netzkarte: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| Zeile 47: | Zeile 47: | ||
** http://www.jens-wiesser.de/google/index5.php | ** http://www.jens-wiesser.de/google/index5.php | ||
* Offline Nodes | * Offline Nodes | ||
| − | ** "SELECT * , count_connects / count_visible AS a1 | + | ** "SELECT * , count_connects / count_visible AS a1 FROM gps, ranking WHERE gps.node = ranking.knotennummer AND TO_DAYS( NOW( ) ) - TO_DAYS( seen_last ) >=2" |
| − | FROM gps, ranking | ||
| − | WHERE gps.node = ranking.knotennummer | ||
| − | AND TO_DAYS( NOW( ) ) - TO_DAYS( seen_last ) >=2" | ||
== Bilder == | == Bilder == | ||