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}