Skip to content

Instantly share code, notes, and snippets.

@helderjs

helderjs/dql.sql

Created December 29, 2013 17:56
Show Gist options
  • Save helderjs/8172917 to your computer and use it in GitHub Desktop.
Save helderjs/8172917 to your computer and use it in GitHub Desktop.
Download ZIP
DQL Query
Raw
dql.sql
SELECT DISTINCT item.positioning
FROM Ciwwic\PositionBundle\Entity\PositionItem item
JOIN item.periods period
WHERE item.keyword = :keyword
AND item.region = :region
AND item.page = :page
AND period.date = :period
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment