An Error Was Encountered

Error Number: 1054

Unknown column 'Scripts' in 'where clause'

SELECT * FROM (`Residential`) WHERE `listing_office_shortid` = 'officeW11' AND (LIST_22 <= Scripts AND LIST_22 >= 100000) ORDER BY `LIST_22` asc