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); }