class TagrefsPeer extends BaseTagrefsPeer
{
	static function getTagList()
	{
		$con = Propel::getConnection();
		
		$sql = "
			SELECT
				tagrefs.*,
				tags.*
			FROM
					". TagsPeer::TABLE_NAME." tags
				LEFT JOIN
					". TagrefsPeer::TABLE_NAME." tagrefs
				ON
					(tags.". TagsPeer::TAGREF_ID ." = tagrefs.". TagsPeer::ID .")
		";
		
		$stmt = $con->createStatement();
		
		$rs = $stmt->executeQuery($sql, ResultSet::FETCHMODE_NUM);
		
		$last_id = null;
		$tagrefs = array();
		
		while ($rs->next() )
		{
			if ($last_id != $rs->getInt(1) )
			{
				$last_id = $rs->getInt(1);
				$tagrefs[$last_id] = new Tagrefs();
				$tagrefs[$last_id]->hydrate($rs);
			}
			
			$tag = new Tags();
			$tag->hydrate($rs, sizeof(TagrefsPeer::getFieldNames() ) + 1);
			
			$tagrefs[$last_id]->addTags($tag);
		}
		
		return $tagrefs;
	}
}