Sign up for email reminders for Meetings, Swaps, Auctions, and Other Events.

Subscribe

Sign up for email reminders for Meetings, Swaps, Auctions, and Other Events.

BAP By Current Year BAP By Year BAP By Member BAP Detailed Data

Bap by Year

Use the search to filter data by first name, last name or year

{arttablesorter search="2015" filter="true" stripeRowsOnStartUp="true" theme="blue" class="table sorter"}{artsqltable attributes="class=tablesorter" query="SELECT jos_bap_participant.first_name, jos_bap_participant.last_name, s_start_year, COUNT( jos_spawns.id) AS cnt FROM jos_spawns join jos_bap_participant on jos_bap_participant.id = s_breeder GROUP BY s_breeder, s_start_year ORDER BY s_start_year DESC, cnt DESC" headerNames="First N Name, Last Name, Number of Spawns, Year" headers=" first_name,last_name, cnt,s_start_year "}{/artsqltable}{/arttablesorter}