SHARE
TWEET

Untitled

a guest Oct 26th, 2012 45 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. delete from Most_Popular;INSERT INTO Most_Popular SELECT a.title, p.url FROM passiveLog as p, assetData as a, asset as a1  WHERE p.assetId=a.assetId AND p.assetId = a1.assetId AND a1.className LIKE '%Article' AND timestamp >  (UNIX_TIMESTAMP()-15778463) AND p.url LIKE '%.html' AND p.url NOT LIKE '%?%' AND p.url NOT LIKE '/root/%' AND p.url NOT LIKE '%/index.html' AND p.url NOT LIKE '%default%' AND p.url NOT LIKE '%wiki%' AND p.url NOT LIKE '%404%' GROUP by p.assetId, p.url ORDER by count(p.assetId) DESC limit 15
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top