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 Genus, Species and Location

Note this data goes back awhile and may not be perfect, however it is interesting

{arttablesorter filter="true" theme="blue" class="table sorter"} {artsqltable attributes="class=tablesorter" query="SELECT s_genus, s_species, s_location, s_start_year, COUNT( jos_spawns.id) AS cnt FROM jos_spawns GROUP BY s_genus, s_species ORDER BY s_genus ASC, s_species ASC, s_location ASC" headerNames="Genus, Species, Number_of_Spawns" headers="s_genus, s_species, cnt"}{/artsqltable}{/arttablesorter}

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}

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

Bap detailed data by member

Use the search box to filter data by name, year, species, etc

The box on the left is the page number to number of pages and the box on the right is the number of rows to display per page. 

{arttablesorter filter="true" pager="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, s_start_month, s_genus, s_species, s_location FROM jos_spawns join jos_bap_participant on jos_bap_participant.id = s_breeder ORDER BY jos_bap_participant.last_name ASC, s_start_year + 0 DESC, s_start_month + 0 DESC" headerNames="First Name, Last Name, Year, Month, Genus, Species, Location" headers="first_name, last_name, s_start_year, s_start_month, s_genus, s_species, s_location"}{/artsqltable}{/arttablesorter}

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

Bap by Member

Use the search to filter data by either first name or last name

{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, COUNT( jos_spawns.id ) AS cnt, IF( COUNT( jos_spawns.id ) >400, 'Master Breeder IV', IF( COUNT( jos_spawns.id ) >300, 'Master Breeder III', IF( COUNT( jos_spawns.id ) >200, 'Master Breeder II', IF( COUNT( jos_spawns.id ) >100, 'Master Breeder', IF( COUNT( jos_spawns.id ) >50, 'Expert Breeder', IF( COUNT( jos_spawns.id ) >25, 'Advanced Breeder', IF( COUNT(jos_spawns.id ) >10, 'Breeder', 'Novice' ) ) ) ) ) ) ) AS Level FROM jos_spawns JOIN jos_bap_participant ON jos_bap_participant.id = s_breeder GROUP BY s_breeder ORDER BY cnt DESC " headerNames="First N Name, Last Name, Level, Number of Spawns" headers=" first_name,last_name, Level, cnt"}{/artsqltable}{/arttablesorter}

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}