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

7 years 7 months ago #37304 by libasci
BAP By Current Year was created by libasci
BAP By Current Year
...

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}

Please Log in or Create an account to join the conversation.

More
Time to create page: 0.069 seconds