Skip to content

Instantly share code, notes, and snippets.

@coderberry

coderberry/blogPost2.sql

Created March 29, 2011 17:03
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save coderberry/892761 to your computer and use it in GitHub Desktop.
Download ZIP
blogPost2.sql
Raw
blogPost2.sql
SELECT count(l.id)
FROM lead AS l, submission AS s, buyerLog as bl
WHERE l.id = s.leadId
AND s.id = bl.submissionId
AND bl.leadBuyer = $buyerName
AND l.id != $lead.id
AND l.dateCreated::date > $daysAgo
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment