0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for software developers, mathematicians and others interested in cryptography

Select distinct u1.id,u1.location,u2.location from users u1 left join users u2 
ON u1.location=u2.location
where u1.location like '%new%' and u1.id=u2.id
order by u1.id,u1.location

fork query

edited oct 22 17

created oct 22 17 anonymous