- 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