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.

Cares Bap by Year

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

{arttablesorter search="2018" 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, year, COUNT( jos_bap_cares_spawns.id) AS cnt FROM jos_bap_cares_spawns join jos_bap_participant on jos_bap_participant.id = breeder GROUP BY breeder, year ORDER BY year DESC, cnt DESC" headerNames="First N Name, Last Name, Number of Cares Spawns, Year" headers=" first_name,last_name, cnt,year "}{/artsqltable}{/arttablesorter}