select top 100 location , id as idUser , displayname , re...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Space Exploration

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

select top 100
  location
  , id as idUser
  , displayname
  , reputation
from
  users
where
  location not like '%,%'
and 
  location not like '%-%'
and 
  location <> ''
order by
  location asc
  , reputation desc;

Enter Parameters

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