There are separate queries attached to this solution - one for Biotics5 (Oracle SQL) and one for Biotics6 (PostgreSQL).

This query checks for inconsistencies in the SRANK of infra taxa and their related “parent” species. 

Example: Infra SRANK = S4 and parent SRANK = SH. 

ACTION: Please review both the SRANKS and GRANKS for these elements, then update the SRANK values in the infra and/or the “parent” species as needed.