In A -

, -

Agenzia: Tel: Fax:

Dettagli
Tipologia:
Zona:
Metri Quadri:
Riscaldamento:
Classe Energetica: ( kwh/mq/anno)
Vani:
Servizi:Nessun servizio
Posto Auto:No
Garage:No
Giardino:No

Descrizione

Questa Query ha dato errore :
"SELECT e.estate_id,e.Prezzo,e.TrattativaRiservata,e.MQSuperficie,e.NrLocali,e.Contratto,e.administrative_area_level_3, e.administrative_area_level_1,e.ref, (SELECT GROUP_CONCAT(formats ORDER BY sort_order SEPARATOR '*') FROM files f LEFT JOIN estate_photos ep USING(file_id) WHERE ep.estate_id = e.estate_id) as photos, e.administrative_area_level_3 as nome_comune, (SELECT CASE e.area_type WHEN 'location' THEN (SELECT NomeLocalita FROM immobiliareit_localita il WHERE il.location_id = e.area_id) WHEN 'block' THEN (SELECT NomeQuartiere FROM immobiliareit_quartiere iq WHERE iq.block_id = e.area_id) END) AS area_name, (SELECT NomeTipologia FROM immobiliareit_categoria ic WHERE ic.IDTipologia = e.IDTipologia GROUP BY IDTipologia) as NomeTipologia, et.value as excerpt, ( 3959 * acos ( cos ( radians() ) * cos( radians( e.lat ) ) * cos( radians( e.lng ) - radians() ) + sin ( radians() ) * sin( radians( e.lat ) ) ) ) AS distance FROM estate e LEFT OUTER JOIN estate_portal ep ON e.estate_id = ep.estate_id INNER JOIN portal_agency pa ON e.agency_id = pa.agency_id LEFT OUTER JOIN estate_txt et ON et.estate_id = e.estate_id AND et.lang = 'it' AND et.txt_type = 'estate_excerpt' WHERE (e.status = 0) AND (e.parent_estate_id = 0) AND (ep.portal_id = 5 OR ep.portal_id IS NULL) AND (pa.portal_id = 5) AND (ep.estate_portal_status = 1 OR ep.estate_portal_status = 0 OR ep.estate_portal_status IS NULL) AND NrLocali>=-1 AND NrLocali<=1 HAVING distance < 1 LIMIT 16"

Incorrect parameter count in the call to native function 'radians'