string(502) "SELECT DISTINCT species.*, media.Species_ID AS 'has_media' FROM Maryland_Species species LEFT JOIN ( SELECT DISTINCT Species_ID FROM Media WHERE NeedsReview = 0 AND Photographer_ID = :user ) media ON species.Species_ID = media.Species_ID JOIN ( SELECT DISTINCT Species_ID FROM MDB_Records WHERE IsDisplayed = 1 AND Person_ID = :user ) records ON species.Species_ID = records.Species_ID WHERE species.IsDisplayed = 1 ORDER BY Kingdom, Class, OrderName, Family, Genus, Species"

Checklist

Filters
All Timedmft via iNaturalist
Total 9
Common Name Genus Species Media Records Category Family Order Class Kingdom
Redbreast SunfishLepomisauritus1FishCentrarchidae aPerciformesActinopterygiiAnimalia
Largemouth BassMicropterusnigricans1FishCentrarchidae aPerciformesActinopterygiiAnimalia
Striped BassMoronesaxatilis1FishMoronidae aPerciformesActinopterygiiAnimalia
BluefishPomatomussaltatrix1FishPomatomidae aPerciformesActinopterygiiAnimalia
SpotLeiostomusxanthurus1FishSciaenidae aPerciformesActinopterygiiAnimalia
Summer FlounderParalichthysdentatus1FishParalichthyidae aPleuronectiformesActinopterygiiAnimalia
White CatfishAmeiuruscatus1FishIctaluridae aSiluriformesActinopterygiiAnimalia
Channel CatfishIctaluruspunctatus1FishIctaluridae aSiluriformesActinopterygiiAnimalia
Broad-headed SkinkPlestiodonlaticeps1ReptilesScincidae aSquamataReptiliaAnimalia