Advertisement
Guest User

Untitled

a guest
Jun 29th, 2016
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. INSERT INTO QandA(id, title, content, tags, date_time, user_id)
  2. SELECT NULL, :title, :content, :tags, unix_timestamp(), :id
  3. FROM QandA
  4. WHERE user_id = :id
  5. AND NOT EXISTS (
  6. SELECT COUNT(CASE WHEN date_time > now() - INTERVAL 90 MINUTE THEN 1 ELSE NULL END) AS rowsInLast90Min
  7. , COUNT(CASE WHEN date_time > now() - INTERVAL 1 DAY THEN 1 ELSE NULL END) AS rowsInLastDay
  8. , COUNT(CASE WHEN date_time > now() - INTERVAL 1 MONTH THEN 1 ELSE NULL END) AS rowsInLastMonth
  9. , COUNT(CASE WHEN date_time > now() - INTERVAL 1 YEAR THEN 1 ELSE NULL END) AS rowsInLastYear
  10. FROM cookie
  11. WHERE email = $email
  12. HAVING rowsInLast90Min > 0
  13. OR rowsInLastDay > 6
  14. OR rowsInLastMonth > 50
  15. OR rowsInLastYear > 200
  16. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement