No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{#cargo_query:tables = UMVC3_FrameData=f, UMVC3_Glossary=g | {{#cargo_query:tables = UMVC3_FrameData=f, UMVC3_Glossary=g | ||
| join on = f.properties | | join on = g.terms HOLDS f.properties | ||
| fields = f.moveId, input, f.name, f.startup, f.active, f.recovery, f.cancel, f.damage, f.guard, f.onHit, f.onBlock, f.cancel, g.shortDefinition | | fields = f.moveId, input, f.name, f.startup, f.active, f.recovery, f.cancel, f.damage, f.guard, f.onHit, f.onBlock, f.cancel, g.shortDefinition | ||
| where = moveId='{{{moveId|{{{1}}}}}}' | | where = moveId='{{{moveId|{{{1}}}}}}' | ||
Revision as of 10:20, 2 May 2025
Function: CargoSQLQuery::run Query: SELECT `g`.`_pageID` AS `cargo_backlink_page_id_g`,`f`.`_pageID` AS `cargo_backlink_page_id_f`,`f`.`moveId` AS `moveId`,`input` AS `input`,`f`.`name` AS `name`,`f`.`startup` AS `startup`,`f`.`active` AS `active`,`f`.`recovery` AS `recovery`,`f`.`cancel` AS `cancel`,`f`.`damage` AS `damage`,`f`.`guard` AS `guard`,`f`.`onHit` AS `onHit`,`f`.`onBlock` AS `onBlock`,`g`.`shortDefinition` AS `shortDefinition` FROM `mw_cargo__UMVC3_FrameData` `f` LEFT OUTER JOIN `mw_cargo__UMVC3_FrameData__properties` `f__properties` ON ((`f`.`_ID`=`f__properties`.`_rowID`)) RIGHT OUTER JOIN `mw_cargo__UMVC3_Glossary` `g` ON ((`f__properties`.`_value`=`g`.`terms`)) WHERE moveId='{{{1}}}' ORDER BY `g`.`_pageID`,`f`.`_pageID`,`f`.`moveId`,`input`,`f`.`name` LIMIT 100