Error getting TOPOFFERselect CONCAT(firstletter,refcode) as r,typename as t,typenameeng as te,city, locationname, statename, lastupdate, idProperty as id, size as size, courtsize as courtsize
from property
inner join state on State_idState=idState
inner join objecttype on ObjectType_idObjectType=idObjectType
inner join location on Location_idlocation=idLocation
WHERE keyproject=1 AND hide=0 AND rented=0 AND idObjectType=1 ORDER BY lastupdate desc
LIMIT 0,1
