Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql -D "kettu-core" -e "SELECT contact_email FROM users INNER JOIN memberships ON memberships.connectable_id=users.id INNER JOIN rents ON rents.connectable_id=users.id INNER JOIN rooms ON rents.room_id=rooms.id WHERE (memberships.end>NOW() OR memberships.end=0000-00-00) AND (rents.end>NOW() OR rents.end IS NULL) AND ,left(rooms.name, 3)=\"2-C\";" --skip-column-names --skip-line-numbers --user=mail --password=********** --silent
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement