Template:AttackDataCargo-UMVC3/Query: Difference between revisions

Template page
No edit summary
No edit summary
Line 1: Line 1:
{{#cargo_query:tables = UMVC3_FrameData
{{#cargo_query:tables = UMVC3_FrameData=f, UMVC3_Glossary=g
| fields = moveId, input, name, startup, active, recovery, cancel, damage, guard, onHit, onBlock, cancel, properties
| join on = f.properties=g.term
| 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}}}}}}'
| format = template
| format = template

Revision as of 10:12, 2 May 2025

Error 1054: Unknown column 'f.properties' in 'on clause'

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_Glossary` `g` ON ((`f`.`properties`=`g`.`term`)) WHERE moveId='{{{1}}}' ORDER BY `g`.`_pageID`,`f`.`_pageID`,`f`.`moveId`,`input`,`f`.`name` LIMIT 100