Error Number: 1054

Unknown column 'col_id_40' in 'field list'

select a.row_id, a.row_order, upper(a.col_id_37) as student, replace(a.col_id_39, '{filedir_9}', '') as suffrage_image, replace(col_id_40, '{filedir_9}', '') as suffrage_pdf, a.col_id_42 as family_bio, a.col_id_48 as pull_quote, upper(a.col_id_44) as family_member, upper(a.col_id_45) as suffrage_name, upper(a.col_id_46) as nationality, a.col_id_47 as birth_death, b.title, c.field_id_166 as grade, d.url_title from exp_channel_grid_field_165 a left outer join exp_channel_titles b on a.entry_id = b.entry_id left outer join exp_channel_data c on a.entry_id = c.entry_id left outer join exp_channel_titles d on a.entry_id = d.entry_id where d.url_title = 'cecile-duquenne' order by row_id;

Filename: modules/query/mod.query.php

Line Number: 53