example.sql

-- I used to do it like this:

SELECT * FROM table WHERE
  hurr
  AND (foo = 'bar')
  AND (bar = 'foo')

-- Then later I spaced it out even more:

SELECT
  *
FROM
  table
WHERE
  hurr
AND
  (foo = 'bar')
LIMIT
  1



SELECT *
FROM table
WHERE hurr
  AND (foo = 'bar')
  AND (bar = 'baz')
LIMIT 1

I've always preferred the final one - much easier to mentally parse the statement and thereby figure out what it's attempting to achieve.