function CRIA_QUERY()
{
//var sql = "select * from imoveissite LEFT JOIN CADzona on imoveissite.zona = CADzona.IDzona where codigo > 0";
var sql = "select * from imoveissite LEFT JOIN CADUnidade on imoveissite.codigo = CADUnidade.IDUnidade LEFT JOIN CADZona on CADUnidade.IDZona=CADZona.IDZona where imoveissite.codigo > 0";


	if(document.getElementById('codigo').value!='')
	{
		sql += " and codigo = "+document.getElementById('codigo').value;
	}
	else
	{
//--------------------------------------------------------------------------------------------------------------------------
		if(document.getElementById('tp_consulta').value!='')
		{
			sql += " and "+document.getElementById('tp_consulta').value+" <> 0 ";
		}
		if(document.getElementById('tpimovel').value!='')
		{
			sql += " and tpimovel = '"+document.getElementById('tpimovel').value+"'";
		}
//-----------------------------------------------------------------------------------------------------	
		if(document.getElementById('Zona').value!='selecione')
		{
			sql += " and CadZona.idzona = "+document.getElementById('Zona').value;
		}
//--------------------------------------------------------------------------------------------------------------------------
		if(document.getElementById('mindorm').value!='0')
		{
			sql += " and dormitorio = "+document.getElementById('mindorm').value;
		}
//--------------------------------------------------------------------------------------------------------------------------
		
		if(document.getElementById('tp_consulta').value =='venda')		{
			if((document.getElementById('valor').value!='') && (document.getElementById('valor').value!='0'))			{
				sql += " and venda "+document.getElementById('valor').value;
			}
		}
		else if(document.getElementById('tp_consulta').value =='locacao')
		{
			if((document.getElementById('valor').value!='') && (document.getElementById('valor').value!='0'))
			{
				sql += " and locacao "+document.getElementById('valor').value;
			}
		}
		
//-----------------------------------------------------------------------------------------------------	
		if(document.getElementById('bairro').value!='selecione')
		{
			sql += " and bairro = '"+document.getElementById('bairro').value+"'";
		}
	}

//-----------------------------------------------------------------------------------------------------	
	//if(document.getElementById('tp_consulta').value!='todos')
		//{
		///sql += " order by "+document.getElementById('tp_consulta').value+" asc"
	//}
	//else{
		//sql += " order by venda asc"
	//}
//-----------------------------------------------------------------------------------------------------	

	document.getElementById('SQL').innerHTML = sql
	document.formBusca.submit();
}