SELECT pq.workerFk userFk, r.name report, p.name printer, r.method FROM printQueue pq JOIN report r ON r.id = pq.reportFk LEFT JOIN printer p ON p.id = pq.printerFk WHERE pq.id = ?