<BR><p><b>Erro:</b> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,0) as tem_tipo,
						if( app_imovel.dormitorios = ,1,0) as tem_dormitorios,
	' at line 10<p><b>SQL:</b> SELECT
		                app_imovel.* ,
		                app_bairro.nome as bairro,
		                app_cidade.nome as cidade,
		                app_contrato_tipo.nome as contrato_nome,
		                app_usuario.nome as usuario_nome,
		                app_usuario.id as usuario_id,
		                app_imovel_tipo.nome as tipo_imovel_nome,
		                app_imovel_tipo.caracteristica as tipo_imovel_caracteristica,
						if( app_imovel.tipo_id = ,1,0) as tem_tipo,
						if( app_imovel.dormitorios = ,1,0) as tem_dormitorios,
						if( app_imovel.cidade_id = ,1,0) as tem_cidade,	
						if( app_imovel.bairro_id = ,1,0) as tem_bairro,
						if( app_imovel.tipo_id =  and app_imovel.bairro_id = ,1,0) as tem_ambos,	 
						if( app_imovel.tipo_id =  and app_imovel.bairro_id =  and app_imovel.dormitorios =  ,1,0) as tem_principais							

  
		                FROM app_imovel
		                        LEFT JOIN app_contrato 		ON (app_imovel.contrato_id = app_contrato.id)
		                        LEFT JOIN app_usuario 		ON (app_usuario.id = app_contrato.usuario_id)
		                        LEFT JOIN app_contrato_tipo ON (app_contrato.contrato_tipo_id = app_contrato_tipo.id)
		                        LEFT JOIN app_cidade 		ON (app_cidade.id = app_imovel.cidade_id)
		                        LEFT JOIN app_bairro 		ON (app_imovel.bairro_id = app_bairro.id)
		                        LEFT JOIN app_imovel_tipo	ON (app_imovel.tipo_id = app_imovel_tipo.id)
		                WHERE
		                        (app_contrato.data_inicio <= CURRENT_DATE() AND app_contrato.data_fim >= CURRENT_DATE())

		                         AND app_imovel_tipo.caracteristica = '' AND app_imovel.modalidade_id = '' AND app_imovel.id <> ''

							ORDER BY tem_principais DESC, tem_ambos DESC, tem_tipo DESC, tem_bairro DESC, tem_bairro DESC, tem_cidade DESC, tem_dormitorios DESC,  rand()
					  LIMIT 3 <p><b>Filename:</b> www.guarida.com.br/index.php<b><p>Timestamp:</b> May 18, 2012, 7:56 am<p><b>Server/User:</b>187.45.207.150/guarida<p><b>IP:</b>38.107.179.236