A Flourish of Strumpets

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

SELECT    U.Id                AS [User Link]
        , U.Displayname       AS 'Display'
        , U.Location          AS 'Location'
        , U.Creationdate      AS 'Created'
        , U.Lastaccessdate    AS 'Accessed'
        , U.Views             AS 'Views'
        , U.Aboutme           AS 'About Me'

FROM users U

WHERE  U.Reputation = 1
   AND (
        U.Displayname LIKE '% escort%'
     OR U.Displayname LIKE '%888%'
     OR U.Displayname LIKE '%sextoy%' 
     
     OR U.Aboutme     LIKE '% slot%'
     OR U.Aboutme     LIKE '% casino%'
     OR U.Aboutme     LIKE '% blackjack '
     OR U.Aboutme     LIKE '% poker%'
     OR U.Aboutme     LIKE '% bingo%'
     OR U.Aboutme     LIKE '% roulette%'
     OR U.Aboutme     LIKE '% sport%'
     OR U.Aboutme     LIKE '% lottery%'
     OR U.Aboutme     LIKE '% gambl%'

 )   

ORDER BY DisplayName
       , Location

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results