select top 99 feature,ggevent.xid,groupname,longitudex as longitude,latitudex as latitude,ggevent.xid,timemm,timehh,timeampm,title,ggevent.zip,ggevent.city,ggevent.state,venue,location,datemmm,datedd,dateyyyy,groupname,ggevent.groupid,ggevent.areacode,ggevent.prefix,ggevent.suffix,ggevent.extension,description,ggevent.contact,ggevent.email,admission,cost,sqrt(power(69.1*(35.110055-latitudex),2)+power(53*(-89.945392-longitudex),2)) as miles from ggevent,gguser,uzipcodes where ggevent.datemmm > ' ' and ggevent.dateyyyy > ' ' and ggevent.datedd > ' ' and ggevent.title <> 'ggnew' and ggevent.title > ' ' and ggevent.groupid > ' ' and gguser.groupid=ggevent.groupid and gguser.approved='Y' and uzipcodes.zipcode=ggevent.zip and cast(datemmm+' '+datedd+' '+dateyyyy as datetime) >= '1/1/1956' and cast(datemmm+' '+datedd+' '+dateyyyy as datetime) <= '12/31/2099' and approved='Y' and ggevent.title <> 'ggnew' and ggevent.title > ' ' and ggevent.groupid > ' ' and gguser.groupid=ggevent.groupid and uzipcodes.zipcode=ggevent.zip and (feature='Y' or feature is null or feature='N') and getdate()-1 < cast(datemmm+' '+datedd+' '+dateyyyy as datetime) and sqrt(power(69.1*(35.110055-latitudex),2)+power(53*(-89.945392-longitudex),2)) < 100 order by cast(datemmm+' '+datedd+' '+dateyyyy as datetime),timeampm,timehh,timemm

sql=select top 99 feature,ggevent.xid,groupname,longitudex as longitude,latitudex as latitude,ggevent.xid,timemm,timehh,timeampm,title,ggevent.zip,ggevent.city,ggevent.state,venue,location,datemmm,datedd,dateyyyy,groupname,ggevent.groupid,ggevent.areacode,ggevent.prefix,ggevent.suffix,ggevent.extension,description,ggevent.contact,ggevent.email,admission,cost,sqrt(power(69.1*(35.110055-latitudex),2)+power(53*(-89.945392-longitudex),2)) as miles from ggevent,gguser,uzipcodes where ggevent.datemmm > ' ' and ggevent.dateyyyy > ' ' and ggevent.datedd > ' ' and ggevent.title <> 'ggnew' and ggevent.title > ' ' and ggevent.groupid > ' ' and gguser.groupid=ggevent.groupid and gguser.approved='Y' and uzipcodes.zipcode=ggevent.zip and cast(datemmm+' '+datedd+' '+dateyyyy as datetime) >= '1/1/1956' and cast(datemmm+' '+datedd+' '+dateyyyy as datetime) <= '12/31/2099' and approved='Y' and ggevent.title <> 'ggnew' and ggevent.title > ' ' and ggevent.groupid > ' ' and gguser.groupid=ggevent.groupid and uzipcodes.zipcode=ggevent.zip and (feature='Y' or feature is null or feature='N') and getdate()-1 < cast(datemmm+' '+datedd+' '+dateyyyy as datetime) and sqrt(power(69.1*(35.110055-latitudex),2)+power(53*(-89.945392-longitudex),2)) < 100 order by cast(datemmm+' '+datedd+' '+dateyyyy as datetime),timeampm,timehh,timemm