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( ) AS cnt FROM jos_spawns JOIN jos_bap_participant ON = 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}