[Koha-bugs] [Bug 6178] tag cloud diff depends on where you click

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6178

--- Comment #6 from Owen Leonard <oleonard at 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.