select totals.venue,vn_name,player,player_num,first_name,last_name,sum(points)as total from nfth_gpf_points totals join gpf_venues on gpf_venue_id = totals.venue join nfth_players on id = player where ((pointtype like '%participation') OR(pointtype like '%place') OR(pointtype = 'bounty') or(pointtype = 'Bonus')) and (scheduled >='10/1/2009' and scheduled <='10/31/2009')and(totals.league = 1 or totals.altleague = 1) and not(totals.venue = '136') group by totals.venue,vn_name,player,player_num,first_name,last_name order by totals.venue,vn_name,total desc1703**1Envy Bar & Grill--5747--2798--Michael--McGuire--5
1557**2Envy Bar & Grill--7402--5843--Mike--Loeffler--4
1281**3Envy Bar & Grill--5446--2480--Dennis--Sexton--3
852**4Envy Bar & Grill--9369--9155--Gordon--Mcleod--2
774**5Envy Bar & Grill--9985--9978--Terry--Smith--2
619**6Envy Bar & Grill--10645--9000579--Frontier--Ford--2
556**7Envy Bar & Grill--69--69--Mike--Smith--2
533**8Envy Bar & Grill--5061--2173--Austin--Miller--2
2227**1Halftime Sports Saloon--5061--2173--Austin--Miller--5
2193**2Halftime Sports Saloon--9852--7801--Melissa--Kitterman--4
2076**3Halftime Sports Saloon--5867--4325--James--Appelgate--3
1935**4Halftime Sports Saloon--9636--9180--Ron--Eccles--2
1888**5Halftime Sports Saloon--10029--7210--Brett--Rutherford--2
1856**6Halftime Sports Saloon--5324--2446--Mike--May--2
1804**7Halftime Sports Saloon--5866--4326--Tami--Appelgate--2
1702**8Halftime Sports Saloon--8948--8094--Chaz--Jasperson--2
2349**1Q`z Restaurant & Lounge--10023--7416--Mike--Menigoz--5
2252**2Q`z Restaurant & Lounge--9912--866--Jody --Simonson--4
1766**3Q`z Restaurant & Lounge--9746--8222--Marty--Plumb--3
1603**4Q`z Restaurant & Lounge--10391--9423--Jim--Hagar--2
1516**5Q`z Restaurant & Lounge--10078--7433--Skullman--Williams--2
1254**6Q`z Restaurant & Lounge--9398--9277--Tabitha--Curtis--2
1242**7Q`z Restaurant & Lounge--9393--9276--Duan--Curtis--2
1222**8Q`z Restaurant & Lounge--10112--7454--Tiffany--Landis--2