Using WHERE clause to find POI within a range of distance from Longitude and Latitude

I’m using following sql code to find out ‘ALL’ poi closest to the set coordinates, but I would want to find out specific poi instead of all of them. When I try to use the where clause I get an error and it doesn’t work and this is where I’m currently stuck, since I only use one table for all the coordinates off all poi’s.