Advertisement
Guest User

Untitled

a guest
Jun 21st, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.42 KB | None | 0 0
  1. 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