select * from geoptsets where gpsname in ('legend') and gpsop='a' and gpssite='us.nor' 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>29.7904452830 and t1.lat<30.1281971698 and t1.lon>-90.4237042025 and t1.lon<-89.7293708025 and ( t1.DirectoryType in ( 'rst', 'ldg', 'glf', 'rtl', 'ski') )