SHARE
TWEET

Untitled

a guest Oct 26th, 2012 37 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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
  2.  
  3.  
  4.  
  5. Select a1.title, a1.url FROM assetData as a1 JOIN (passiveLog as p, asset as a2) ON (p.assetId=a1.assetId and a2.assetId=a1.assetId) WHERE a2.lineage LIKE '000001%' and p.assetId=a1.assetId AND p.assetId = a2.assetId AND a2.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