BIRD SPECIES LIST BY FAMILY

Bird Species by Family

Fatal error: Query Failed! SQL: SELECT bf.bird_family_id, bf.bird_family, bp.country_id, c.country, c.flag_svg, bp.bird_species_id, bs.bird_species_common, bs.bird_species_scient, MAX(bp.img_date) AS date_last_seen, (SELECT MIN(bp2.img_date) AS first_seen FROM tbl_bird_photos bp2 LEFT JOIN tbl_countries c2 ON bp2.country_id = c2.countryID WHERE bp.bird_species_id = bp2.bird_species_id ORDER BY bp2.img_date ASC LIMIT 1) AS date_first_seen, (SELECT c2.flag_svg AS FirstSeenFlag FROM tbl_bird_photos bp2 LEFT JOIN tbl_countries c2 ON bp2.country_id = c2.countryID WHERE bp.bird_species_id = bp2.bird_species_id ORDER BY bp2.img_date ASC LIMIT 1) AS flag_first_seen, (SELECT c2.country AS countryFirstSeen FROM tbl_bird_photos bp2 LEFT JOIN tbl_countries c2 ON bp2.country_id = c2.countryID WHERE bp.bird_species_id = bp2.bird_species_id ORDER BY bp2.img_date ASC LIMIT 1) AS country_first_seen FROM tbl_bird_photos bp LEFT JOIN tbl_bird_species bs ON bp.bird_species_id = bs.bird_species_id LEFT JOIN tbl_bird_families bf ON bs.bird_family_id = bf.bird_family_id LEFT JOIN tbl_countries c ON bp.country_id = c.countryID LEFT JOIN tbl_bird_photos_rating bpr ON bp.bird_photo_id = bpr.bird_photo_id WHERE bs.bird_family_id Is Not Null GROUP BY bf.bird_family_id, bf.bird_family, bp.country_id, c.country, c.flag_svg, bp.bird_species_id, bs.bird_species_common, bs.bird_species_scient ORDER BY bf.bird_family ASC, bird_species_common ASC, MAX(bp.img_date) DESC, country ASC - Error: Table 'cronkflies_luchtvaart.tbl_bird_photos_rating' doesn't exist in /home/cronkflies/domains/cronkflies.com/public_html/2024/bird-photo-gallery/bird-list-family.php on line 126