Advertisement
Guest User

Untitled

a guest
Oct 26th, 2012
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement