Instalar Steam
iniciar sesión
|
idioma
简体中文 (chino simplificado)
繁體中文 (chino tradicional)
日本語 (japonés)
한국어 (coreano)
ไทย (tailandés)
Български (búlgaro)
Čeština (checo)
Dansk (danés)
Deutsch (alemán)
English (inglés)
Español de Hispanoamérica
Ελληνικά (griego)
Français (francés)
Italiano
Bahasa Indonesia (indonesio)
Magyar (húngaro)
Nederlands (holandés)
Norsk (noruego)
Polski (polaco)
Português (Portugués de Portugal)
Português-Brasil (portugués de Brasil)
Română (rumano)
Русский (ruso)
Suomi (finés)
Svenska (sueco)
Türkçe (turco)
Tiếng Việt (vietnamita)
Українська (ucraniano)
Comunicar un error de traducción
SELECT PRD.playerId, P.firstName, P.lastName, PRD.stars, (PA.strength + PA.runBlocking + PA.passBlocking)/3 AS rating, PA.potential, PA.durability, P.position, P.archetype, PA.speed, PA.strength, PA.runBlocking, PA.passBlocking,
CASE
WHEN PRD.metaJson = '{"gem":true}' THEN 'GEM'
ELSE ''
END AS Gems
FROM PlayerRecruitDetails PRD
JOIN Player P ON PRD.playerId = P.id
JOIN PlayerAttributes PA ON PRD.playerId = PA.playerId
WHERE PRD.year = 2027 AND PRD.position = 'OL' AND PRD.isJuco != 1 AND PA.potential >= 75 AND PA.durability >= 75
ORDER BY rating DESC
Not anything I would use, but someone VERY interested in a exact starting point for college football could recreate the universe..all 7,000 plus players.