User by Location within tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

-- List of Users in a given location
-- This query lists all users in a given location sorted by reputation.

-- Declare @location varchar = ##location##
select top 100 users.id as [User Link], location, reputation 
from users
where location like '%##location##%' COLLATE SQL_Latin1_General_CP1_CI_AS
and users.id in (select owneruserid from posts where 
  tags like '%##tag##%')
order by reputation desc;

Enter Parameters

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