select T1.dbid,T1.id,T1.classification,T1.headline_1 as headline,T1.release_build,T1.severity14,T1.production_release,T1.cr_type,T1.discovered,T3.name as State,T1.description,{fn concat({fn concat({fn concat({ fn rtrim( {fn convert(T5.dbid,sql_char)} )}, {fn concat('    ', T5.filename)})}, {fn concat('    ', { fn rtrim( {fn convert(T5.filesize,sql_char)} )})})},     {fn concat('    ', T5.description)})},T1.notes_log,T2.action_timestamp as Submitted,T1.resolution_1,T2.user_name,T1.project,T1.priority,T1.steps_to_reproduce,T1.owners, T6.action_timestamp as Resolved, (select T7.id as DuplicateOf from changerequest T7, parent_child_links L where T1.dbid <> 0 and (T1.dbid = l.child_dbid and l.parent_dbid = T7.dbid and l.link_type_enum=2))  from ( ( ( ( changerequest T1 INNER JOIN statedef T3 ON T1.state = T3.id ) INNER JOIN history T2 ON T1.dbid = T2.entity_dbid  and 16777432 = T2.entitydef_id  and T2.action_name = 'Submit') LEFT OUTER JOIN history T6 ON T1.dbid = T6.entity_dbid  and 16777432 = T6.entitydef_id  and (T6.action_name in ('Close','Accept')) ) LEFT OUTER JOIN attachments T5 ON T1.dbid = T5.entity_dbid  and 16777461 = T5.entity_fielddef_id ) where T1.dbid <> 0 and ((T1.project = 'Selection Boards' and  (T3.name in ('Assigned','Closed','Delivered_to_Test','Duplicated','Fixed','Impacted','Opened','Postponed','Resolved')) ))