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 for the Current Year

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

{arttablesorter 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 WHERE s_start_year = YEAR( CURDATE( ) ) GROUP BY s_breeder, s_start_year ORDER BY s_start_year DESC , cnt DESC" headerNames="First Name, Last Name, Number of Spawns, Year" headers=" first_name,last_name, cnt, s_start_year " }{/artsqltable}{/arttablesorter}