You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID' at line 3 - Execute Query False! select a.*,b.NAME_EN as BEDROOMSIZE from (select a.*,b.NAME_EN as NEIGHBORHOODNAME from (select p.* from REI_OP_PROPERTY p,REI_OP_STATISTICS s,users u where s.PROPERTYID = p.PROPERTYID and u.username = s.AGENTID and s.RENATALORSALE = 's' and u.id = order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID) a left join REI_DB_PROPERTY b on b.ID = a.BEDROOMS

Error Track

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID' at line 3 - Execute Query False! select a.*,b.NAME_EN as BEDROOMSIZE from (select a.*,b.NAME_EN as NEIGHBORHOODNAME from (select p.* from REI_OP_PROPERTY p,REI_OP_STATISTICS s,users u where s.PROPERTYID = p.PROPERTYID and u.username = s.AGENTID and s.RENATALORSALE = 'r' and u.id = order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID) a left join REI_DB_PROPERTY b on b.ID = a.BEDROOMS

REIG | Our Company
Name  : 
Office  : 
Cell  : 
Fax  : 
Email  : 
Upper East Side / dfa
BACK


large image

Web ID: W10162
Price: $ 2
Bedrooms: Alcove Studio
Bathrooms: 2
SQ Ft:2
Type: CO-OP
Maint/CC: $ 2
Taxes: $ 2
Percent Down: 10%
Era: New Development
Access: Doorman
Pets: Yes
Sublets: Yes
Amenities: