http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6178
--- Comment #6 from Owen Leonard <oleon...@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.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
