Mine

mysql> describe innlegg;
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| innleggid   | int(10) unsigned |      | PRI | NULL    | auto_increment |
| innlegg     | text             | YES  |     | NULL    |                |
| tittel      | varchar(255)     | YES  |     | NULL    |                |
| innleggdato | datetime         | YES  |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

mysql> describe kommentarer;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| kommentarid   | int(10) unsigned |      | PRI | NULL    | auto_increment |
| innleggnr     | int(10) unsigned | YES  |     | NULL    |                |
| kommentar     | text             | YES  |     | NULL    |                |
| navn          | varchar(255)     | YES  |     | NULL    |                |
| email         | varchar(255)     | YES  |     | NULL    |                |
| kommentardato | datetime         | YES  |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
6 rows in set (0.04 sec)


mysql> SELECT tittel,innlegg,innleggdato,innleggid,COUNT(innleggnr) FROM innlegg,kommentarer WHERE innleggnr=innleggid GROUP BY innleggid ORDER BY innleggdato DESC;
Empty set (0.00 sec)