
<b style='color:red'>Error</b> in sql command "GetOferte": SELECT 
	_oferte.*,
	PretEUR as Pret, 
	valute.Prescurtare as Valuta,
	users.username as Agent,
	if(isnull(zone.Nume), Zona, zone.Nume) as Zona,
	zone.Regiunea as Regiunea,
	case Obiect 
		when 'apartament' then concat(ap_Camere, ', ', if(ap_Etaj=0,'P', ap_Etaj), '/', ap_NrEtaje, ', ', ap_Compartimentare ) 
		when 'teren' then concat(tr_Sector, ', ', tr_Tip,  ', ', tr_Suprafata, ' mp' )
		when 'casa/vila' then cv_Nivele
		when 'spatiu comercial' then concat( sc_Destinatia )
		else 'n/a'
	end as Detalii,
	oferte2imagini.ImagineID,
	NULL as Foto
FROM 
	_oferte 
LEFT JOIN valute ON _oferte.ValutaID=valute.ValutaID 
LEFT JOIN users ON _oferte.AgentID=users.UserID 
LEFT JOIN zone ON zone.ZonaID=_oferte.ZonaID
LEFT JOIN oferte2imagini ON _oferte.OfertaID=oferte2imagini.OfertaID AND NrCrt=0
LEFT JOIN imagini ON imagini.ImagineID=oferte2imagini.ImagineID
WHERE  obiect='apartament'   AND  ap_Camere='2 camere'  AND  tranzactie='inchiriere'   AND  zone.ZonaID=114  AND Vizibilitate='publica' 
ORDER BY Pret  DESC 
LIMIT 0, 20<br/>Column 'Pret' in order clause is ambiguous