SELECT DISTINCT r.ID, b.idB, bi.location, type, englishName, chineseName, bedroom, specialOffer, squareMeter, pic1, d.district_name, type, marketPrice, r.decoration
FROM building b, residential r, Binfo bi, districts d
WHERE b.compGroup = '553'
AND bi.language_id = '1'
AND r.buildingID <> 553
AND b.idB=r.buildingID
AND bi.idB = b.idB
AND d.district_id=b.dist_id
AND ptype = 'lease'
AND visibility = 1
AND activation = 1
GROUP BY ID
ORDER BY updated, bedroom, specialOffer
limit 0,15
Do not have others properties in this compound.