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 >='4/1/2009' and scheduled <='4/30/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 desc2546**1Halftime Sports Saloon--5869--2150--Harley--Pendleton--5
2172**2Halftime Sports Saloon--5176--2304--Paula--McCord--4
2019**3Halftime Sports Saloon--8948--8094--Chaz--Jasperson--3
1976**4Halftime Sports Saloon--9390--9157--Karen--Mcleod--2
1965**5Halftime Sports Saloon--5324--2446--Mike--May--2
1851**6Halftime Sports Saloon--5794--2933--Mary Anne--Richey--2
1415**7Halftime Sports Saloon--9751--8500--Cheryl--Werner--2
1323**8Halftime Sports Saloon--7364--5864--Troy--Yost--2
2470**1Q`z Restaurant & Lounge--10079--7434--Cathy--Williams--5
2429**2Q`z Restaurant & Lounge--10078--7433--Skullman--Williams--4
2029**3Q`z Restaurant & Lounge--9976--7263--Gary--Koden--3
1836**4Q`z Restaurant & Lounge--10112--7454--Tiffany--Landis--2
1629**5Q`z Restaurant & Lounge--10154--7474--Stephenie--Jerome--2
1590**6Q`z Restaurant & Lounge--9912--866--Jody --Simonson--2
1583**7Q`z Restaurant & Lounge--9393--9276--Duan--Curtis--2
1563**8Q`z Restaurant & Lounge--9398--9277--Tabitha--Curtis--2
2147**1Sunset Bar & Grill--5869--2150--Harley--Pendleton--5
1669**2Sunset Bar & Grill--5867--4325--James--Appelgate--4
1384**3Sunset Bar & Grill--8191--6948--Kenny--Nguyen--3
1381**4Sunset Bar & Grill--9751--8500--Cheryl--Werner--2
1380**5Sunset Bar & Grill--9390--9157--Karen--Mcleod--2
1320**6Sunset Bar & Grill--9369--9155--Gordon--Mcleod--2
1249**7Sunset Bar & Grill--5028--2104--Sheldon--Fancher--2
1124**8Sunset Bar & Grill--9625--9183--Nita--Mcpherson--2
2512**1Cassidy`s Pub & Mini-Golf--10112--7454--Tiffany--Landis--5
2090**2Cassidy`s Pub & Mini-Golf--9943--8877--Jon--Little--4
1834**3Cassidy`s Pub & Mini-Golf--10023--7416--Mike--Menigoz--3
1747**4Cassidy`s Pub & Mini-Golf--9976--7263--Gary--Koden--2
1744**5Cassidy`s Pub & Mini-Golf--8063--6651--William--Treinen--2
1737**6Cassidy`s Pub & Mini-Golf--9942--8876--Jeanette--Lively--2
1433**7Cassidy`s Pub & Mini-Golf--5794--2933--Mary Anne--Richey--2
1412**8Cassidy`s Pub & Mini-Golf--9829--8792--Rocco--Falsetta--2
1500**1GPF Online Monthly Leaderboard--10204--9000086--Brandon--Baccus--5
1300**2GPF Online Monthly Leaderboard--4--2--Donald--Bly--4
1150**3GPF Online Monthly Leaderboard--9907--861--Daryl--Richotte--3
1025**4GPF Online Monthly Leaderboard--8266--100006--Troy--Cable--2
925**5GPF Online Monthly Leaderboard--5747--2798--Michael--McGuire--2
850**6GPF Online Monthly Leaderboard--7241--5624--Mike--Carroll--2
800**7GPF Online Monthly Leaderboard--6058--5068--Tim--Fierro--2
775**8GPF Online Monthly Leaderboard--10170--9000067--John--Hayward--2
708**1Galloping Gerties--10217--8605--Jason--Ferrell--5
699**2Galloping Gerties--4--2--Donald--Bly--4
602**3Galloping Gerties--10311--8631--Donald--Eaton--3
508**4Galloping Gerties--9678--9925--Jim--Bass--2
440**5Galloping Gerties--9907--861--Daryl--Richotte--2
306**6Galloping Gerties--10314--8633--Christine--Adams--2
300**7Galloping Gerties--10381--8635--Timothy--Stewart--2
274**8Galloping Gerties--9917--8873--Alison--Cross--2