Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. Comment.
  2. joins("INNER JOIN (SELECT m1.id,m1.topic_id, COUNT(m2.id) as c FROM multimedias as m1 LEFT JOin multimedias as m2 ON
  3. m1.topic_id = m2.topic_id AND m1.id < m2.id
  4. WHERE m1.topic_id IS NOT NULL GROUP BY m1.id, m1.topic_id HAVING c < 4
  5. ORDER by m1.topic_id, c desc) as m3 ON m3.id = multimedias.id").
  6. where([ "multimedias.topic_id IN (?)", topics_id ])
  7.  
  8. Comment.
  9. joins("INNER JOIN (SELECT m1.id,m1.topic_id, COUNT(m2.id) as c FROM multimedias as m1 LEFT JOin multimedias as m2 ON
  10. m1.topic_id = m2.topic_id AND m1.id < m2.id
  11. WHERE m1.topic_id IS NOT NULL GROUP BY m1.id, m1.topic_id HAVING c < 4
  12. ORDER by m1.topic_id, c desc) as m3 ON m3.id = multimedias.id").
  13. where([ "multimedias.topic_id IN (?)", topics_id ]).
  14. last(4)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement