Skip to content

Instantly share code, notes, and snippets.

@Akii

Akii/gist:3381588

Created August 17, 2012 18:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Akii/3381588 to your computer and use it in GitHub Desktop.
Save Akii/3381588 to your computer and use it in GitHub Desktop.
Download ZIP
My custom statement
Raw
gistfile1.sql
SELECT * FROM tx_spreise_domain_model_reise r JOIN tx_spreise_domain_model_tour t ON(r.tour = t.uid)
WHERE t.schiff = '1' AND t.land = '1' AND r.anfang <= '1345154400' AND r.ende >= '1345154400' AND (r.max - r.belegt) >= '1' AND r.hidden = 0 AND r.deleted = 0 AND t.hidden = 0 AND t.deleted = 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment