Template:MainBatteryCount: Difference between revisions
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=JOINMainBatteryCount, ITEMNavalGun | tables=JOINMainBatteryCount, ITEMNavalGun | ||
|fields=ITEMNavalGun.TXT_NavalGunName=Weapon Name, ITEMNavalGun.INT_GunCount=Barrel Count, JOINMainBatteryCount.TXT_GunPosition=Weapon Position, JOINMainBatteryCount.INT_MountCount=Mount Count | |fields=ITEMNavalGun.TXT_NavalGunName=Weapon Name, ITEMNavalGun.INT_GunCount=Barrel Count, JOINMainBatteryCount.TXT_GunPosition=Weapon Position, JOINMainBatteryCount.INT_MountCount=Mount Count, TXT_NavalGunID=NavalGunID | ||
|where=TXT_BelleName = '{{#replace:{{PAGENAME}}|'|\'}}' AND TXT_BatteryType = '{{{3}}}' | |where=TXT_BelleName = '{{#replace:{{PAGENAME}}|'|\'}}' AND TXT_BatteryType = '{{{3}}}' | ||
|join on=JOINMainBatteryCount.TXT_NavalGunID=ITEMNavalGun.TXT_NavalGunID | |join on=JOINMainBatteryCount.TXT_NavalGunID=ITEMNavalGun.TXT_NavalGunID | ||
Revision as of 08:42, 13 May 2023
Function: CargoSQLQuery::run Query: SELECT `mwofb3_cargo__JOINMainBatteryCount`.`_pageID` AS `cargo_backlink_page_id_JOINMainBatteryCount`,`mwofb3_cargo__ITEMNavalGun`.`_pageID` AS `cargo_backlink_page_id_ITEMNavalGun`,`mwofb3_cargo__ITEMNavalGun`.`TXT_NavalGunName` AS `Weapon Name`,`mwofb3_cargo__ITEMNavalGun`.`INT_GunCount` AS `Barrel Count`,`mwofb3_cargo__JOINMainBatteryCount`.`TXT_GunPosition` AS `Weapon Position`,`mwofb3_cargo__JOINMainBatteryCount`.`INT_MountCount` AS `Mount Count`,`TXT_NavalGunID` AS `NavalGunID` FROM `mwofb3_cargo__JOINMainBatteryCount` LEFT OUTER JOIN `mwofb3_cargo__ITEMNavalGun` ON ((`mwofb3_cargo__JOINMainBatteryCount`.`TXT_NavalGunID`=`mwofb3_cargo__ITEMNavalGun`.`TXT_NavalGunID`)) WHERE TXT_BelleName = 'MainBatteryCount' AND TXT_BatteryType = '{{{3}}}' ORDER BY `mwofb3_cargo__JOINMainBatteryCount`.`_pageID`,`mwofb3_cargo__ITEMNavalGun`.`_pageID`,`mwofb3_cargo__ITEMNavalGun`.`TXT_NavalGunName`,`mwofb3_cargo__ITEMNavalGun`.`INT_GunCount`,`mwofb3_cargo__JOINMainBatteryCount`.`TXT_GunPosition` LIMIT 100
| Position | {{{1}}} | {{{2}}} |
|---|
| Template documentation follows |
|---|
| Note: the template above may sometimes be partially or fully invisible. |
| Visit Template:MainBatteryCount/doc to edit this documentation. (How does this work?) |