instruction: List of pending query with indication of user's score for it. This lists the tag synonyms suggestion that are still opened, but only shows the one where the given user can vote (needs a score of 5 on it).
response: SELECT * FROM (SELECT st.TagName AS stTagName, tt.TagName AS ttTagName, ts.CreationDate, ts.OwnerUserId AS "user_link", SUM(CASE v.VoteTypeId WHEN 2 THEN 1 WHEN 3 THEN -1 END) AS Score FROM TagSynonyms AS ts INNER JOIN Tags AS st ON ts.SourceTagName = st.TagName INNER JOIN Tags AS tt ON ts.TargetTagName = tt.TagName INNER JOIN PostTags AS pt ON pt.TagId = tt.Id INNER JOIN Posts AS q ON q.Id = pt.PostId INNER JOIN Posts AS a ON a.ParentId = q.Id INNER JOIN Votes AS v ON v.PostId = a.Id WHERE ts.ApprovalDate IS NULL AND q.PostTypeId = 1 AND a.PostTypeId = 2 AND a.OwnerUserId = @user GROUP BY tt.TagName, st.TagName, ts.CreationDate, ts.OwnerUserId) AS list WHERE Score > 4 ORDER BY Score DESC