Source

						public function testOrderOnRelated() {
		$query = new Query(array(
			'model' => $this->_model,
			'with' => array('MockDatabaseComment')
		));

		$result = $this->db->order('MockDatabaseComment.created DESC', $query);
		$expected = 'ORDER BY MockDatabaseComment.created DESC';
		$this->assertEqual($expected, $result);

		$result = $this->db->order(array('MockDatabaseComment.created' => 'DESC'), $query);
		$expected = 'ORDER BY MockDatabaseComment.created DESC';
		$this->assertEqual($expected, $result);

		$result = $this->db->order(
			array(
				'MockDatabasePost.title' => 'ASC',
				'MockDatabaseComment.created' => 'DESC'
			),
			$query
		);
		$expected = 'ORDER BY MockDatabasePost.title ASC, MockDatabaseComment.created DESC';
		$this->assertEqual($expected, $result);

		$result = $this->db->order(
			array(
				'title' => 'ASC',
				'MockDatabaseComment.created' => 'DESC'
			),
			$query
		);
		$expected = 'ORDER BY {MockDatabasePost}.{title} ASC, MockDatabaseComment.created DESC';
		$this->assertEqual($expected, $result);
	}