Untitled query #82152

SQL

 SELECT rc_title,
       el_to_path
FROM   recentchanges
JOIN   externallinks
ON     el_from=rc_cur_id
AND    rc_namespace=0
WHERE  (
              el_to_path LIKE '%&utm\_source=%'
       OR     el_to_path LIKE '%?utm\_source=%'
       OR     el_to_path LIKE '%&utm\_medium=%'
       OR     el_to_path LIKE '%?utm\_medium=%'
       OR     el_to_path LIKE '%&utm\_term=%'
       OR     el_to_path LIKE '%?utm\_term=%'
       OR     el_to_path LIKE '%&utm\_campaign=%'
       OR     el_to_path LIKE '%?utm\_campaign=%'
       OR     el_to_path LIKE '%&utm\_content=%'
       OR     el_to_path LIKE '%?utm\_content=%'
       OR     el_to_path LIKE '%&utm\_cid=%'
       OR     el_to_path LIKE '%?utm\_cid=%'
       OR     el_to_path LIKE '%&utm\_reader=%'
       OR     el_to_path LIKE '%?utm\_reader=%'
       OR     el_to_path LIKE '%&utm\_referrer=%'
       OR     el_to_path LIKE '%?utm\_referrer=%'
       OR     el_to_path LIKE '%&utm\_name=%'
       OR     el_to_path LIKE '%?utm\_name=%'
       OR     el_to_path LIKE '%&utm\_social%'
       OR     el_to_path LIKE '%?utm\_social%'
       OR     el_to_path LIKE '%&fbclid=%'
       OR     el_to_path LIKE '%?fbclid=%'
       OR     (
                     el_to_domain_index LIKE 'https://com.facebook%'
              AND    (
                            el_to_path LIKE '%refsrc=%'
                     OR     el_to_path LIKE '%hrc=%'))
       OR     el_to_path LIKE '%&gad_source=%'
       OR     el_to_path LIKE '%?gad_source=%'
       OR     el_to_path LIKE '%&gclid=%'
       OR     el_to_path LIKE '%?gclid=%'
       OR     el_to_path LIKE '%&\_hs\_enc=%'
       OR     el_to_path LIKE '%?\_hs\_enc=%'
       OR     el_to_path LIKE '%&\_hs\_mi=%'
       OR     el_to_path LIKE '%?\_hs\_mi=%'
       OR     (
                     el_to_domain_index LIKE 'https://com.imdb%'
              AND    (
                            el_to_path LIKE '%\_ref=%'))
       OR     el_to_path LIKE '%&igshid=%'
       OR     el_to_path LIKE '%?igshid=%'
       OR     el_to_path LIKE '%&igsh=%'
       OR     el_to_path LIKE '%?igsh=%'
       OR     el_to_path LIKE '%&irclickid=%'
       OR     el_to_path LIKE '%?irclickid=%'
       OR     el_to_path LIKE '%&utm_klaviyo_id=%'
       OR     el_to_path LIKE '%?utm_klaviyo_id=%'
       OR     el_to_path LIKE '%cv\_id%'
       OR     el_to_path LIKE '%wickedid%'
       OR     el_to_path LIKE '%soc\_src=%'
       OR     el_to_path LIKE '%soc_trk=%'
       OR     el_to_path LIKE '%\_openstat=%'
       OR     el_to_path LIKE '%yclid=%'
       OR     el_to_path LIKE '%\_hsenc=%'
       OR     el_to_path LIKE '%\_hsmi=%'
       OR     el_to_path LIKE '%mc\_cid=%'
       OR     el_to_path LIKE '%mc\_eid=%'
       OR     el_to_path LIKE '%&otc=%'
       OR     el_to_path LIKE '%?otc=%'
       OR     el_to_path LIKE '%oly\_anon\_id=%'
       OR     el_to_path LIKE '%oly\_enc\_id=%'
       OR     (
                     el_to_domain_index LIKE 'https://com.tiktok%'
              AND    el_to_path LIKE '%=%')
       OR     (
                     el_to_domain_index LIKE 'https://com.youtube%'
              AND    (
                            el_to_path LIKE '%app%'
                     OR     el_to_path LIKE '%feature%'
                OR     el_to_path LIKE '%kw%'))
              OR     el_to_path LIKE '%&wt\_mc=%'
              OR     el_to_path LIKE '%?wt\_mc=%'
              OR     el_to_path LIKE '%&wt\zmc=%'
              OR     el_to_path LIKE '%?wt\_zmc=%'
              OR     el_to_path LIKE '%&cvid=%'
              OR     el_to_path LIKE '%?cvid=%'
              OR     el_to_path LIKE '%&ocid=%'
              OR     el_to_path LIKE '%?ocid=%'
              OR     el_to_path LIKE '%&ICID=%'
              OR     el_to_path LIKE '%?ICID=%'
              OR     el_to_path LIKE '%rb\_click=%' )
       AND    rc_id > 2197480781
SQL

Checking query status...
