1
2
3

Clip.find_by_sql(["select * from clips where not exists
        (select 'clip_id' from histories where histories.clip_id = clips.id
        and histories.user_id = ?) ORDER BY clips.created_at DESC LIMIT 20", user.id])

1
2
3
4

class Item < ActiveRecord::Base
  ALL_VOTES = "all_votes"
  SCORE = "score"
...

1
2
3
4

select rrr.account_number,
       summa,
       to_char(to_date('19570101', 'YYYYMMDD') + max(rrr.lst_pay_dn),
...

1
2
3
4

    #players = select distinct(player) from actions;
    players = repository(:default).adapter.query('select distinct(player) from actions')

...

1
2
3

Declare @Index varchar(128)
...

1
2
3

Use Master

...

1
2
3
4

<?php

$flacpath = '/bin/flac';
...

1
2
3
4

Tables:

items
...