SELECT o.file_id, o.client_name, o.client_no, o.plant, o.object_name, o.system_name, o.bundle_name, o.serial_no, o.construction_year, o.plot_no, o.language, o.contact_person, o.media_inside, o.media_outside, m.description AS material, m.magnetic AS material_magnetic, d.od AS dim_od, d.wt AS dim_wt, d.length AS dim_length, d.od_raw AS dim_od_raw, d.wt_raw AS dim_wt_raw, d.length_raw AS dim_length_raw, ts.tube_count, ts.matrix_angle, ts.grid_quadrant, ts.x_spread, ts.y_spread, ts.authentic_angle, ts.u_bends, f.rel_path AS file_path, f.last_change AS file_last_change, f.last_user AS file_last_user, f.software_version FROM objects o JOIN files f ON f.file_id = o.file_id LEFT JOIN materials m ON m.file_id = o.file_id AND m.idx = 0 LEFT JOIN dimensions d ON d.file_id = o.file_id AND d.idx = 0 LEFT JOIN tube_systems ts ON ts.file_id = o.file_id WHERE f.parse_error IS NULL