Skip to content

Instantly share code, notes, and snippets.

@mikebaldry

mikebaldry/gist:3760646

Created September 21, 2012 09:42
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mikebaldry/3760646 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mikebaldry/3760646 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT `campaigns`.* FROM `campaigns`
WHERE
(
(
(media_plan_lines.start_at <= '2012-09-21'
AND
media_plan_lines.end_at >= '2012-09-21')
OR
(DATEDIFF(CURDATE(), media_plan_lines.end_at) <= 10)
)
AND
NOT media_plan_lines.status = 'pipeline'
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment