Moderators: Polly, Muiz, NadjaNadja, Telpeva, Essie73, ynskek, Ladybird
+---------+---------+---------------------+
| nr | post_id | tijd |
+---------+---------+---------------------+
| 2999996 | 3026449 | 2004-01-19 01:12:45 |
| 2999997 | 3026450 | 2004-01-19 01:12:57 |
| 2999998 | 3026451 | 2004-01-19 01:12:57 |
| 2999999 | 3026452 | 2004-01-19 01:13:19 |
| 3000000 | 3026453 | 2004-01-19 01:13:35 |
| 3000001 | 3026454 | 2004-01-19 01:13:37 |
| 3000002 | 3026455 | 2004-01-19 01:13:39 |
| 3000003 | 3026456 | 2004-01-19 01:13:48 |
| 3000004 | 3026457 | 2004-01-19 01:14:42 |
| 3000005 | 3026458 | 2004-01-19 01:14:52 |
+---------+---------+---------------------+
> SELECT SUM(forum_topics) AS topic_total, SUM(forum_posts) AS post_total FROM forums; SELECT count(*) FROM posts;
+-------------+------------+
| topic_total | post_total |
+-------------+------------+
| 184619 | 3001006 |
+-------------+------------+
1 row in set (0.00 sec)
+----------+
| count(*) |
+----------+
| 3001005 |
+----------+
1 row in set (0.00 sec)
BartVB schreef:Hmm, ik zie het alHet totaal op de hoofdpagina wordt berekend door het aantal posts dat in de forums tabel is opgeslagen op te tellen (dus alle tellers die je op de hoofdpagina ziet) en daar mist zo te zien ergens 1 post.
- Code
> SELECT SUM(forum_topics) AS topic_total, SUM(forum_posts) AS post_total FROM forums; SELECT count(*) FROM posts;
+-------------+------------+
| topic_total | post_total |
+-------------+------------+
| 184619 | 3001006 |
+-------------+------------+
1 row in set (0.00 sec)
+----------+
| count(*) |
+----------+
| 3001005 |
+----------+
1 row in set (0.00 sec)