public function testRelationManyToMany()
{
$criteria = new Criteria('User', $this->config);
$criteria->greaterThan('id', 5);
$criteria->limit(20);
$criteria->order('id');
$criteria->relation('Tag')->equalTo('type', 2);
$select = $criteria->getQuery($criteria);
$sql = $select->getSqlString($this->dbAdapter->getPlatform());
$this->assertInstanceOf('Zend\\Db\\Sql\\Select', $select);
$this->assertEquals("SELECT `users`.* " . "FROM `users` " . "INNER JOIN `users_tags_link` ON `users_tags_link`.`user_id` = `users`.`id` " . "INNER JOIN `tags` ON `users_tags_link`.`tag_id` = `tags`.`id` " . "WHERE `users`.`id` > '5' " . "AND `tags`.`type` = '2' " . "ORDER BY `users`.`id` ASC " . "LIMIT '20'", $sql);
}
