public function testUniqueEncodedTitles() { // SELECT encodedtitle, COUNT(newsid) AS articles FROM typef_news GROUP BY encodedtitle HAVING articles > 1 $articles = new Model_News_Article(); $articles->selectFields('encodedtitle', 'COUNT(newsid) AS articles'); $articles->group('encodedtitle'); $articles->having('articles > 1'); $titles = array(); foreach ($articles->select() as $article) { $titles[] = "'{$article['encodedtitle']}' ({$article['articles']})"; } $this->assertTrue(count($titles) == 0, "The following encoded titles are not unique: " . implode(',', $titles)); }