/**
	* Preparation of the list query.
	*
	* @access	protected
	* @param	object	&$query	returns a filled query object.
	*
	* @return	void
	*/
	protected function prepareQuery(&$query)
	{

		$acl = TestHelper::getActions();

		//FROM : Main table
		$query->from('#__users AS a');



		//IMPORTANT REQUIRED FIELDS
		$this->addSelect(	'a.id');


		switch($this->getState('context', 'all'))
		{

			case 'all':
				//SELECT : raw complete query without joins
				$this->addSelect('a.*');

				// Disable the pagination
				$this->setState('list.limit', null);
				$this->setState('list.start', null);
				break;
		}

		//FILTER - Access for : Root table


		//WHERE - FILTER : created_by
		if($filter_created_by = $this->getState('filter.created_by'))
		{
			if ($filter_created_by == 'auto'){
				$this->addWhere('a.created_by = ' . (int)JFactory::getUser()->get('id'));
			}
			else 
			if ($filter_created_by > 0){
				$this->addWhere("a.created_by = " . (int)$filter_created_by);
			}
		}


		//WHERE - FILTER : modified_by
		if($filter_modified_by = $this->getState('filter.modified_by'))
		{
			if ($filter_modified_by == 'auto'){
				$this->addWhere('a.modified_by = ' . (int)JFactory::getUser()->get('id'));
			}
			else 
			if ($filter_modified_by > 0){
				$this->addWhere("a.modified_by = " . (int)$filter_modified_by);
			}
		}


		//WHERE - FILTER : user_id
		if($filter_user_id_user_id = $this->getState('filter.user_id_user_id'))
		{
			$this->addJoin("`#__test_users` AS _user_id_ ON _user_id_.id = a.user_id", 'LEFT');
			if ($filter_user_id_user_id == 'auto'){
				$this->addWhere('_user_id_.user_id = ' . (int)JFactory::getUser()->get('id'));
			}
			else 
			if ($filter_user_id_user_id > 0){
				$this->addWhere("_user_id_.user_id = " . (int)$filter_user_id_user_id);
			}
		}


		//WHERE - FILTER : user_id
		if($filter_user_id = $this->getState('filter.user_id'))
		{
			if ($filter_user_id == 'auto'){
				$this->addWhere('a.user_id = ' . (int)JFactory::getUser()->get('id'));
			}
			else 
			if ($filter_user_id > 0){
				$this->addWhere("a.user_id = " . (int)$filter_user_id);
			}
		}


		// Apply all SQL directives to the query
		$this->applySqlStates($query);
	}

                $this->orm->queryDump($query);

                // Apply all SQL directives to the query
                $this->applySqlStates($query);

stdClass Object
(
    [FROM] => #__jbreeding_pedigrees AS a
)

$this->applySqlStates($query);