Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO QandA(id, title, content, tags, date_time, user_id)
- SELECT NULL, :title, :content, :tags, unix_timestamp(), :id
- FROM QandA
- WHERE user_id = :id
- AND NOT EXISTS (
- SELECT COUNT(CASE WHEN date_time > now() - INTERVAL 90 MINUTE THEN 1 ELSE NULL END) AS rowsInLast90Min
- , COUNT(CASE WHEN date_time > now() - INTERVAL 1 DAY THEN 1 ELSE NULL END) AS rowsInLastDay
- , COUNT(CASE WHEN date_time > now() - INTERVAL 1 MONTH THEN 1 ELSE NULL END) AS rowsInLastMonth
- , COUNT(CASE WHEN date_time > now() - INTERVAL 1 YEAR THEN 1 ELSE NULL END) AS rowsInLastYear
- FROM cookie
- WHERE email = $email
- HAVING rowsInLast90Min > 0
- OR rowsInLastDay > 6
- OR rowsInLastMonth > 50
- OR rowsInLastYear > 200
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement