An Error Was Encountered

Error Number: 1054

Unknown column 'bold_data.genus' in 'field list'

SELECT bold_data.genus,bold_data.species,COUNT(DISTINCT bold_data.id) AS result_count, bold_data.id, bold_data.citation, bold_data.common_name FROM bold_data WHERE bold_data.id IS NOT NULL AND bold_data.genus IS NOT NULL AND bold_data.genus <> '' AND bold_data.order_name = 'piciformes' GROUP BY bold_data.genus,bold_data.species