Equilibrium: Contest - Weapon Meta

Position	Kills	Weapon
#1	14,942,991	Praxic Blade
#2	7,551,378	Mint Retrograde
#3	6,647,463	Wolfsbane
#4	5,798,896	Yeartide Apex
#5	3,906,724	Psi Aeterna IV
#6	3,545,690	Returned Memory
#7	2,308,632	MIDA Mini-Tool
#8	2,081,203	Compact Defender
#9	2,078,991	Multimach CCX
#10	2,031,066	Choir of One
#11	1,485,331	No Hesitation
#12	1,353,735	M-17 "Fast Talker"
#13	1,279,280	Antedate
#14	930,204	Finality's Auger
#15	885,407	Horror's Least
#16	880,736	Phoneutria Fera
#17	877,155	Zealous Ideal
#18	671,119	Aberrant Action
#19	614,623	Peculiar Charm
#20	612,031	Motif-41
#21	600,957	Tinasha's Mastery
#22	541,363	Gunburn
#23	386,931	Evening SI4
#24	351,367	Modified B-7 Pistol
#25	338,896	Unfall
#26	319,408	Everburning Glitz
#27	313,580	Lotus-Eater (Adept)
#28	305,404	Sarpedon-D
#29	291,902	Unwavering Duty
#30	284,385	Ahab Char
#31	273,769	Festival Flight
#32	259,168	Synanceia
#33	254,971	Voltaic Shade
#34	233,466	Parasite
#35	233,373	All or Nothing
#36	223,987	Giver's Blessing
#37	207,576	Commemoration
#38	188,153	Tractor Cannon
#39	183,280	Reckless Oracle
#40	156,451	Aureus Neutralizer
#41	151,823	Cusp Sempiternal
#42	151,700	Agape
#43	146,557	VS Velocity Baton
#44	139,216	Rake Angle (Adept)
#45	132,045	Lost Signal
#46	130,043	Drang
#47	126,766	Greasy Luck (Adept)
#48	125,677	The Recluse
#49	118,668	Corrective Measure
#50	115,026	Outbreak Perfected
#51	113,663	Thunderlord
#52	112,700	Word of Crota
#53	99,070	Adamantite
#54	93,389	Indebted Kindness
#55	90,332	Praedyth's Revenge
#56	90,026	The Call
#57	83,563	Duty Bound
#58	82,815	Corrective Measure (Timelost)
#59	81,974	High Tyrant
#60	81,520	Graviton Lance
#61	81,347	Outrageous Fortune
#62	80,909	Service of Luzaku
#63	80,908	The Supremacy
#64	79,994	Ergo Sum
#65	79,985	New Malpais
#66	79,822	Perfect Paradox
#67	77,896	Bitter End
#68	77,818	Qua Vinctus IV
#69	76,511	Alethonym
#70	75,855	VS Pyroelectric Propellant
#71	74,717	Greasy Luck
#72	73,057	Finite Maybe
#73	71,515	Grand Overture
#74	69,937	Judgment of Kelgorath
#75	68,510	Riskrunner
#76	68,475	Unloved
#77	67,239	Zaouli's Bane
#78	64,761	Riptide
#79	63,566	Eighty-Six
#80	62,266	Mos Athanor IV
#81	60,378	Sunshot
#82	60,371	CALUS Mini-Tool
#83	59,088	Barrow-Dyad
#84	58,046	Midnight Coup
#85	56,194	Witherhoard
#86	55,928	Nullify
#87	55,514	Gjallarhorn
#88	54,977	Lotus-Eater
#89	53,858	Psychopomp
#90	53,302	Hammerhead
#91	52,919	Forthcoming Deviance
#92	50,883	Khvostov 7G-0X
#93	50,622	Dragon's Breath
#94	49,372	No Survivors
#95	49,162	The Slammer (Adept)
#96	49,023	Watchful Eye
#97	43,943	Zaouli's Bane (Harrowed)
#98	41,801	Praedyth's Revenge (Timelost)
#99	41,334	New Land Beyond
#100	40,816	The Riposte
#101	39,704	Forgiveness
#102	38,942	Forthcoming Deviance (Adept)
#103	38,538	Ancient Gospel
#104	38,387	Word of Crota (Adept)
#105	37,435	Falling Guillotine
#106	36,891	Imminence
#107	36,841	Fatebringer (Timelost)
#108	35,979	Pro Memoria
#109	35,621	Microcosm
#110	35,477	Submersion
#111	34,050	IKELOS_SMG_v1.0.3
#112	32,319	Haliaetus
#113	31,847	No Survivors (Adept)
#114	31,399	Scatter Signal
#115	30,889	Luna's Howl
#116	30,852	Legend of Acrius
#117	30,457	Noxious Vetiver
#118	30,270	Lionfish-4fr
#119	29,920	Parabellum
#120	29,233	Ecliptic Distaff
#121	29,087	Hawthorne's Field-Forged Shotgun
#122	28,914	Heliocentric QSc
#123	28,881	The Enigma
#124	28,803	Mercury-A
#125	28,039	Aisha's Embrace
#126	27,938	The Other Half
#127	27,687	Adamantite (Adept)
#128	27,419	Something Something
#129	27,347	Ulterior Observation
#130	27,246	Third Iteration
#131	26,942	Lumina
#132	26,617	Malfeasance
#133	25,829	The Lament
#134	25,458	Ice Breaker
#135	25,272	Unforgiven
#136	24,859	Still Hunt
#137	24,633	Buried Bloodline
#138	24,386	Monody-44
#139	24,044	Seraphine Haze
#140	23,552	Unsworn
#141	23,051	A Good Shout
#142	22,976	Osteo Striga
#143	22,957	Subjunctive
#144	22,746	Nullify (Adept)
#145	22,271	Cartesian Coordinate
#146	22,176	The Summoner (Adept)
#147	21,782	Lord of Wolves
#148	21,505	Delicate Tomb
#149	21,209	BxR-55 Battler
#150	21,115	Refusal of the Call
#151	20,990	Anarchy
#152	20,749	Rufus's Fury
#153	20,620	Exalted Truth (Adept)
#154	20,604	Fortunate Star
#155	20,410	Nezarec's Whisper
#156	20,115	Lubrae's Ruin
#157	19,916	Fatebringer
#158	19,757	Wastelander M5
#159	19,663	Oxygen SR3
#160	19,617	Nox Sidereal IV
#161	19,401	Intercalary
#162	19,157	Bastion
#163	19,142	Leviathan's Breath
#164	19,112	Rake Angle
#165	19,107	Age-Old Bond
#166	18,831	Gridskipper
#167	18,665	Chronophage
#168	18,439	Retrofit Escapade
#169	18,230	Exalted Truth
#170	17,930	Ribbontail
#171	17,809	The Title
#172	17,398	Vexcalibur
#173	17,319	Lubrae's Ruin (Adept)
#174	17,302	The Mountaintop
#175	17,149	Acasia's Dejection
#176	16,952	IKELOS_SG_v1.0.3
#177	16,564	Funnelweb
#178	15,931	Winterbite
#179	15,821	Qua Nilus II
#180	15,122	Blast Furnace
#181	14,824	Edge Transit
#182	14,527	Shayura's Wrath (Adept)
#183	14,523	Psychopomp (Adept)
#184	13,893	Aurora Dawn
#185	13,880	Trachinus
#186	13,861	The Summoner
#187	13,504	Fixed Odds
#188	13,483	Unworthy
#189	13,125	Monte Carlo
#190	13,096	Conspiracy Honed
#191	13,081	VS Chill Inhibitor
#192	12,985	Song of Ir Yût
#193	12,972	The Huckleberry
#194	12,480	Sullen Claw
#195	12,233	Stars in Shadow
#196	12,225	Speleologist
#197	12,062	Collective Obligation
#198	11,941	Ros Arago IV
#199	11,855	Omniscient Eye
#200	11,684	Slayer's Fang

Time: 0.87s Scanned: 141,817 rows Read: 146.5 MB

WITH data as (
  SELECT weaponId, sum(weaponKills) as kills
    FROM pgcr.vweapons
    WHERE referenceId = 1754635208  -- Equilibrium: Contest
    GROUP BY weaponId
)
SELECT row_number() OVER (ORDER BY kills desc) as position,
argMax(weaponId, data.kills) as weapon,
sum(data.kills) as kills from data
JOIN defs.vitems on (weaponId=vitems.hash)
GROUP BY vitems.name
ORDER BY kills desc
LIMIT 200