====== select *, MATCH (EnItem) AGAINST ('apartment for in zamalek' IN BOOLEAN MODE) AS Relevance from Mls where ID>0 and PropertyFor like '%Rent%' and MATCH (EnItem) AGAINST ('apartment for in zamalek' IN BOOLEAN MODE) ORDER BY Relevance DESC,UpdateStamp DESC LIMIT 40,20 =============
BY 19057
Beds
2
Bathrooms
3
Area
200 M2
Floor No.
22
BY 13511
Beds
3
Bathrooms
3
Area
170 M2
BY 13513
Beds
3
Bathrooms
2
Area
150 M2
BY 13515
Beds
1
Bathrooms
2
Area
105 M2
EBP 24020
Beds
3
Bathrooms
2
Area
180 M2
Floor No.
2
GB 3159
Beds
4
Bathrooms
2
Area
190 M2
EBP 25397
Beds
2
Bathrooms
1
Area
130 M2
Floor No.
4
GB 3174
BY 15865
Beds
2
Bathrooms
2
Area
150 M2
Floor No.
8
EBP 25396
Beds
2
Bathrooms
2
Area
130 M2
Floor No.
4
EBP 23670
Beds
2
Bathrooms
2
Area
160 M2
Floor No.
6
BY 17733
Beds
4
Bathrooms
3
Area
250 M2
Floor No.
7
BY 12226
Beds
2
Bathrooms
2
Area
130 M2
EBP 23633
Beds
3
Bathrooms
2
Area
150 M2
Floor No.
3
BY 10996
Beds
2
Bathrooms
2
Area
250 M2
BY 18682
Beds
2
Bathrooms
2
Area
140 M2
Floor No.
5
BY 18681
Beds
2
Bathrooms
2
Area
140 M2
Floor No.
5
BY 18639
Beds
2
Bathrooms
2
Area
200 M2
Floor No.
13
BY 18637
Beds
2
Bathrooms
2
Area
200 M2
Floor No.
13
GB 3803
Beds
3
Bathrooms
2
Area
175 M2
Floor No.
3