SELECT ts.file_id, o.client_name, o.client_no, o.plant, o.system_name, o.object_name, o.bundle_name, o.serial_no, o.construction_year, m.description AS material, m.magnetic AS material_magnetic, d.od AS dim_od, d.wt AS dim_wt, d.length AS dim_length, ts.tube_count, ts.matrix_angle, ts.grid_quadrant, ts.x_spread, ts.y_spread, ts.authentic_angle, ts.u_bends, (SELECT COUNT(*) FROM tubes t WHERE t.file_id = ts.file_id AND t.plug_a = 1) AS plugged_a, (SELECT COUNT(*) FROM tubes t WHERE t.file_id = ts.file_id AND t.plug_b = 1) AS plugged_b, (SELECT COUNT(*) FROM tubes t WHERE t.file_id = ts.file_id AND (t.plug_a = 1 OR t.plug_b = 1)) AS plugged_total, (SELECT COUNT(*) FROM tubes t WHERE t.file_id = ts.file_id AND t.sel > 0) AS selected_tubes, (SELECT COUNT(DISTINCT t.dim_idx) FROM tubes t WHERE t.file_id = ts.file_id) AS dim_variants, (SELECT COUNT(DISTINCT t.mat_idx) FROM tubes t WHERE t.file_id = ts.file_id) AS mat_variants, f.rel_path AS file_path FROM tube_systems ts JOIN files f ON f.file_id = ts.file_id LEFT JOIN objects o ON o.file_id = ts.file_id LEFT JOIN materials m ON m.file_id = ts.file_id AND m.idx = 0 LEFT JOIN dimensions d ON d.file_id = ts.file_id AND d.idx = 0 WHERE f.parse_error IS NULL