All pastes #950275 Raw Edit

Anonymous

public text v1 · immutable
·published 2008-03-20 13:42 UTC
rendered paste body
SELECT id, nome, etc
  FROM table AS t,
    table AS t,
    etc
  LEFT JOIN table as t
    ON t.field = t.field
    AND t.field = t1.field
  WHERE field = value
    AND field = value
  ORDER BY field ASC 
    field DESC
  GROUP BY field, field
  LIMIT 1/1