Medallas faltantes en puntuacion de candidato

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow en español

Preguntas y respuestas para programadores y profesionales de la informática

SELECT DISTINCT 
(
CASE Name
WHEN 'Civic Duty' THEN 'Obligación civil'
WHEN 'Cleanup' THEN 'Limpieza'
WHEN 'Constituent' THEN 'Votante'
WHEN 'Convention' THEN 'Convencion'
WHEN 'Copy Editor' THEN 'Editor de textos'
WHEN 'Deputy' THEN 'Ayudante'
WHEN 'Electorate' THEN 'Electorado'
WHEN 'Enthusiast' THEN 'Entusiasta'
WHEN 'Explainer' THEN 'Explicador'
WHEN 'Investor' THEN 'Inversor'
WHEN 'Marshal' THEN 'Mariscal'
WHEN 'Organizer' THEN 'Organizador'
WHEN 'Quorum' THEN 'Quorum'
WHEN 'Refiner' THEN 'Refinador'
WHEN 'Sportsmanship' THEN 'Espiritu deportivo'
WHEN 'Strunk & White' THEN 'Strunk & White'
WHEN 'Tag Editor' THEN 'Editor de etiquetas'
WHEN 'Reviewer' THEN 'Revisor'
WHEN 'Steward' THEN 'Encargado'
WHEN 'Yearling' THEN 'Añejo'
END
) AS Medalla
FROM Badges
WHERE Name IN (
  'Civic Duty', 
  'Cleanup',
  'Constituent',
  'Convention',
  'Copy Editor',
  'Deputy',
  'Electorate',
  'Enthusiast',
  'Explainer',
  'Investor',
  'Marshal',
  'Organizer',
  'Quorum',
  'Refiner',
  'Sportsmanship',
  'Strunk & White',
  'Tag Editor',
  'Reviewer',
  'Steward', 
  'Yearling'
)
AND Name NOT IN (
  SELECT Name FROM Badges
  WHERE UserId = ##UserId##
)

Enter Parameters

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