diff options
author | Andrew Dolgov <[email protected]> | 2006-03-02 17:21:18 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-03-02 17:21:18 +0100 |
commit | f26ef034b52faf09001db56d5be616dcea07c4db (patch) | |
tree | afd6d9d328453913e3f9d6b08d401abf0b924c86 | |
parent | 686c3ccfa6060be0b3ed2a634709bb7eff702f50 (diff) |
update stats
-rw-r--r-- | stats.php | 11 |
1 files changed, 8 insertions, 3 deletions
@@ -38,10 +38,15 @@ print "<p>Total articles stored: $total_articles (${articles_size}K)</p>"; - $result = db_query($link, "SELECT COUNT(int_id) as cid,owner_uid,login +/* $result = db_query($link, "SELECT COUNT(int_id) as cid,owner_uid,login FROM ttrss_user_entries - JOIN ttrss_users ON (owner_uid = ttrss_users.id) - GROUP BY owner_uid,login ORDER BY cid DESC"); + LEFT JOIN ttrss_users ON (owner_uid = ttrss_users.id) + GROUP BY owner_uid,login ORDER BY cid DESC"); */ + + $result = db_query($link, "SELECT count(ttrss_entries.id) AS cid, + login FROM ttrss_entries + LEFT JOIN ttrss_user_entries ON (ref_id = ttrss_entries.id) + LEFT JOIN ttrss_users ON (ttrss_users.id = owner_uid) GROUP BY login"); print "<h2>Per-user storage</h2>"; |