Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 9th, 2012  |  syntax: None  |  size: 0.27 KB  |  hits: 25  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SELECT d.id,
  2. (SELECT SUM(v.vote) FROM votes v WHERE v.vote > 0 AND v.voteable_id = d.id AND v.voteable_type = 'Discussion') AS likes
  3. (SELECT SUM(v.vote) FROM votes v WHERE v.vote < 0 AND v.voteable_id = d.id AND v.voteable_type = 'Discussion') AS dislikes
  4. FROM discussions d;
create a new version of this paste RAW Paste Data