select id,houseId,mainImageSrc,titleMain,titleMinor,comment,housePrice,features,updateDate,ownerType,longitude,latitude,round ((st_distance (point (longitude, latitude),point(-8.6319,41.1363) ) / 0.0111)*1000) AS distance from house where houseType='2' and id<>'41301' and longitude<>'' AND latitude<>'' order by distance limit 10