select * from geoptsets where gpsname in ('legend') and gpsop='a' and gpssite='int.peru' members: select t1.*, t2.* from membersites as t1 left join nodes as t2 on (t1.ID=t2.nmemsiteid and ( t2.ntype > 1 or t2.nmemsitenode1='1') ) where t1.lat>-18.8200358550 and t1.lat<0.1041151050 and t1.lon>-83.4186553506 and t1.lon<-66.6094307437 and ( t1.DirectoryType in ( 'rst', 'ldg', 'glf', 'rtl', 'ski') )