Lead slug: Difference between revisions

Lead slug (view source)

65 bytes added , 20:23, 12 September 2021

m

Update cargo query to use new MissileWeaponData table

8,290

edits

@@ Line 34: / Line 34: @@
 ==List of Firearms that use Lead Slugs==
-{{#cargo_query:tables=ItemsTable=I,GeneralData=GD|join on=I._pageName=GD._pageName|group by=I._pageName|fields=CONCAT('{{((}}favilink{{!}}', GD.PlainName, '{{))}}')=Weapon, MaxAmmo,Shots=Shots per round|where=I.Ammo = 'lead slug'|format=ul}}
+{{#cargo_query:tables=ItemsTable=I,GeneralData=GD,MissileWeaponData=MWD
+|join on=I.JoinKey=GD.JoinKey,I.JoinKey=MWD.JoinKey
+|group by=I._pageName
+|fields=CONCAT('{{((}}favilink{{!}}', GD.PlainName, '{{))}}')=Weapon, MWD.MaxAmmo=Max ammo, MWD.Shots=Shots per round
+|where=MWD.Ammo = 'lead slug'
+|format=ul}}