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



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;