- 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
a guest Oct 26th, 2012 45 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
RAW Paste Data