Worked on the librenms/librenms repository to address a critical backend issue affecting database query reliability. Focused on PHP-based backend development, the work involved correcting the use of qualifyColumn within Port.php subqueries, which previously caused SQL generation to target unnecessary columns and risked breaking queries. By removing the misapplied qualifyColumn statement, the patch restored intended query behavior, improved the stability of subquery execution, and reduced the risk of incorrect data appearing in dashboards and reports. This contribution demonstrated skills in database query optimization and backend engineering, ensuring that port-related data queries remained performant and accurate within the application’s infrastructure.