---

SELECT
    r.id AS request_number,
    u.full_name AS client,
    e.full_name AS employee,
    s.name AS status,
    r.device_type,
    r.device_model,
    r.problem_description,
    r.price,
    r.created_at
FROM repair_requests r
JOIN users u ON r.user_id = u.id
LEFT JOIN employees e ON r.employee_id = e.id
JOIN request_statuses s ON r.status_id = s.id
ORDER BY r.id;