SELECT p.pid, p.filename, AVG(v.vote) as avgv, COUNT(v.vote) as avgc
			FROM wp_ngg_pictures p
			LEFT JOIN wp_nggv_votes v ON (p.pid = v.pid)
...

select distinct(user_id) from facebook_post_comments where page_id =some_page_id and user_id in (select distinct(user_id) from facebook_post_comments where page_id = some_other_page_id)

procedure TfrmOperationDetail.SaveOperationInfo;
var
  s: string;
...

def self.find_for(options = {})
    scope = scoped
    scope = scope.where(:hook => options[:hook].to_s)  if options[:hook]
...

# link_categories has_many links
create_table "link_categories", :force => true do |t|
  t.string   "name"
...

// Stored procedure: IsItUnique

CREATE PROCEDURE [dbo].[IsItUnique]
...

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])

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

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

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

...

Declare @Index varchar(128)
...

Use Master

...

<?php

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

Tables:

items
...