Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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