An Error Was Encountered

Error Number: 1064

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 'AND price BETWEEN 29999999.99 AND 90000000.01) GROUP BY b.id, b.value ORDER BY ' at line 1

SELECT b.id,b.value, count(*) cnt FROM borough b, commercial WHERE commercial.published>0 AND b.id=commercial.borough AND commercial.land_position=1 AND (borough= AND price BETWEEN 29999999.99 AND 90000000.01) GROUP BY b.id, b.value ORDER BY b.score DESC, b.id ASC