Guest User

Untitled

a guest
Feb 14th, 2015
259
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.36 KB | None | 0 0
  1.             INSERT INTO analytics (TYPE,path)
  2.                 SELECT %d,'%s' FROM analytics WHERE NOT EXISTS (
  3.                     SELECT %d AS tmp FROM analytics WHERE
  4.                         (MONTH(ts) = MONTH(NOW()) AND YEAR(ts) = YEAR(NOW()) AND TYPE=%d AND path='%s')
  5.                     ) LIMIT 1;
  6.             UPDATE analytics SET counter = counter + 1 WHERE (MONTH(ts) = MONTH(NOW()) AND YEAR(ts) = YEAR(NOW()) AND path='%s' AND TYPE=%d);
Advertisement
Add Comment
Please, Sign In to add comment