ahmedrahil786

Push Notification for Seri - Atleast one Reservation - age

Aug 6th, 2019
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. set @startdate1 = '2019-01-01';
  2. select
  3. distinct r.member_id as mid,
  4. m.display_name as name,
  5. m.email as email,
  6. YEAR(r.start_at) - YEAR(m.birthday) as age
  7. from reservations r left join members m on m.id = r.member_id
  8. where r.return_at + interval 8 hour >= @startdate1
  9. and r.state in ('completed','inUse')
  10. and m.imaginary in ('normal')
  11. and r.member_id not in ('125', '127')
  12. and YEAR(r.start_at) - YEAR(m.birthday) < 100
  13. and YEAR(r.start_at) - YEAR(m.birthday) between '19' and '35'
Advertisement
Add Comment
Please, Sign In to add comment