61
edits
User talk:Andyed: Difference between revisions
Jump to navigation
Jump to search
m
→Query to Click Patterns (all queries)
mNo edit summary |
|||
| Line 18: | Line 18: | ||
OR rev_host like '%moc.hcraes.nsm%' | OR rev_host like '%moc.hcraes.nsm%' | ||
OR rev_host like '%moc.evil.hcraes%' | OR rev_host like '%moc.evil.hcraes%' | ||
OR rev_host = 'moc.oohay.hcraes.' | OR rev_host = 'moc.oohay.hcraes.%' | ||
OR rev_host = 'moc.gnib.') | OR rev_host = 'moc.gnib.%') | ||
AND (p.url like '%q=%' or p.url like '%p=%') | AND (p.url like '%q=%' or p.url like '%p=%') | ||
GROUP BY rev_host | GROUP BY rev_host | ||