Advertisement
Guest User

Untitled

a guest
Jul 7th, 2015
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. SELECT COUNT(DISTINCT(mobile_number))
  2. FROM `subscription_all`
  3. WHERE updated_at > (created_at + INTERVAL 5 minute)
  4. AND YEAR(created_at) = '2014'
  5. ORDER BY `subscription_all`.`id` DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement