http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6178 --- Comment #6 from Owen Leonard <oleonard@myacpl.org> 2011-05-20 15:38:42 UTC --- Proposed new SQL: SELECT tags_approval.term AS term, tags_approval.approved AS approved, tags_approval.date_approved AS date_approved, tags_approval.approved_by AS approved_by, tags_approval.weight_total AS weight_total, tags_all.borrowernumber AS tag_submitter CONCAT(borrowers.surname, ', ', borrowers.firstname) AS approved_by_name FROM tags_approval LEFT JOIN borrowers ON tags_approval.approved_by = borrowers.borrowernumber LEFT JOIN tags_all ON tags_all.term = tags_approval.term WHERE approved = 1 and tags_all.borrowernumber = [logged in borrower] -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.