WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT MIN(time) FROM wp_statz LIMIT 0,1
Blog-Statz seit
10Beiträge seit 23.3.20070Kommentare seit 5Tage online2,00Beiträge pro Tag0,00Kommentare pro Tag0Kommentierer WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT DISTINCT username, page, ip, time FROM wp_statz WHERE time > Now() - INTERVAL 300 SECOND GROUP BY ip DESC
WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT COUNT(DISTINCT ip) FROM wp_statz WHERE time > Now() - INTERVAL 300 SECOND
User online
Keine Einträge WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT COUNT(ip) AS hits, COUNT(DISTINCT ip) AS visitors, COUNT(DISTINCT referer) AS referers, substring(time,1,10) AS date FROM wp_statz GROUP BY date ORDER BY time DESC LIMIT 0, 7
7-Tage-Statz
Keine Einträge WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT DISTINCT referer, time FROM wp_statz WHERE referer NOT LIKE '%wa8211.om18.de%' ORDER BY time DESC LIMIT 0, 10
Die 10 neuesten Referer
Keine Einträge WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT DISTINCT host, COUNT(host) AS num FROM wp_statz WHERE host !='NULL' AND time >= '2007-03-28' GROUP BY host ORDER BY num DESC LIMIT 0, 10
Die 10 häufigsten Hosts heute
Keine Einträge WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT keyword, time, ip FROM `wp_statz` WHERE keyword != 'NULL' ORDER BY time DESC LIMIT 0, 10
Die 10 neuesten Suchbegriffe
Keine EinträgeDie 10 Top-Kommentierer
Keine Einträge WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT post_title AS posttitle, post_name as postname, guid AS postid, COUNT(wp_statz.page) AS count FROM wp_posts, wp_statz WHERE wp_statz.page = wp_posts.ID AND time >= '2007-03-28' GROUP BY postid ORDER BY count DESC LIMIT 10
Die Top-10-Beiträge heute
Keine Einträge WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT post_title AS posttitle, post_name as postname, guid AS postid, COUNT(wp_statz.page) AS count FROM wp_posts, wp_statz WHERE wp_statz.page = wp_posts.ID GROUP BY postid ORDER BY count DESC LIMIT 10
Die Top-10-Beiträge seit Statz-Aufzeichnung
Keine Einträge WordPress Datenbank-Fehler: [Table 'wa8211_db1.wp_statz' doesn't exist]
SELECT DISTINCT username, COUNT(username) as num FROM wp_statz WHERE time >= '2007-03-28' AND username != 'Gast' GROUP BY username ORDER BY num DESC
Die heutigen User
Keine EinträgeDie Top-10 der kommentierten Beiträge
Keine Einträge