Most efficient way to write this query in Sequel?

[djrobby]

What is the most efficient way of writing this query in Sequel without using DB.fetch(raw_sql)?

SELECT c.*,
       COUNT(ls.id) like_count
FROM comments c
LEFT JOIN likes ls ON ls.likeable_id = c.id
AND ls.likeable_type = 'Comment'
WHERE c.commentable_id = 3
  AND c.commentable_type = 'Post'
  AND c.parent_id IS NULL
GROUP BY c.id
ORDER BY like_count DESC

[jeremyevans]

DB.from{comments.as(:c)}.
  select_all(:c).
  select_append{count(ls[:id]).as(:like_count)}.
  left_join(Sequel[:likes].as(:ls), likeable_id: :id, likeable_type: 'Comment').
  where{{c[:commentable_id]=>3, c[:commentable_type]=>'Post', c[:parent_id]=>nil}}.
  group{c[:id]}.
  reverse(:like_count)