Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ╔════════════════════════════════╦══════════╗
- ║ Post Link ║ Name ║
- ╠════════════════════════════════╬══════════╣
- ║ Some awesome question's title ║ UpVote ║
- ║ Not an answer ║ DownVote ║
- ║ etc... ║ ... ║
- ╚════════════════════════════════╩══════════╝
- ╔════════════════════════════════╦══════════╗
- ║ Post Link ║ Name ║
- ╠════════════════════════════════╬══════════╣
- ║ A favorite question ║ Favorite ║
- ║ Another favorite question ║ Favorite ║
- ║ etc... ║ ... ║
- ╚════════════════════════════════╩══════════╝
- SELECT COUNT(*)
- FROM Votes
- WHERE UserId = ##UserId:Int##
- SELECT UpVotes + DownVotes
- FROM Users
- WHERE Id = ##UserId:Int##
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement