Get comments of users in a state

1

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

SELECT c.Id, c.Score, c.Text, c.CreationDate, c.UserId, u.Location, u.Reputation
FROM Comments c
INNER JOIN Users u ON u.Id = c.UserId
WHERE 
    (Location LIKE ##abbr:string## 
    or UPPER(Location) LIKE ##full:string##) 
    AND convert(date, c.CreationDate) >= convert(date, '20200220')
    AND convert(date, c.CreationDate) <= convert(date, '20200429')
    AND UPPER(Location) NOT LIKE '%DC%'
    AND UPPER(Location) NOT LIKE '%D.C.%'
    AND UPPER(Location) NOT LIKE '%COLUMBIA%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results