Template:Query masteries: Difference between revisions
Jump to navigation
Jump to search
Neokowloon (talk | contribs) (Created page with "{{#cargo_query: |tables=mastery_groups, mastery_effects=m_e |join on= mastery_groups.mastery_effects HOLDS m_e.id |fields= mastery_groups._pageName=Mastery, GROUP_CONCAT( CONCAT('* ', m_e.stat_text) SEPARATOR "\n")=Effects |where= m_e.stat_text LIKE "%{{#if: {{{where|}}}| AND ({{{where|}}})|}}%" |order by=mastery_groups._pageName |group by=mastery_groups._pageName }}") |
Neokowloon (talk | contribs) No edit summary |
||
Line 6: | Line 6: | ||
GROUP_CONCAT( CONCAT('* ', m_e.stat_text) | GROUP_CONCAT( CONCAT('* ', m_e.stat_text) | ||
SEPARATOR "\n")=Effects | SEPARATOR "\n")=Effects | ||
|where= m_e.stat_text LIKE | |where= m_e.stat_text LIKE {{#if: {{{where|}}}| AND ({{{where|}}})|}} | ||
|order by=mastery_groups._pageName | |order by=mastery_groups._pageName | ||
|group by=mastery_groups._pageName | |group by=mastery_groups._pageName | ||
}} | }} |
Revision as of 00:56, 29 October 2022
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY `cargo__mastery_groups`.`_pageName` ORDER BY `cargo__mastery_groups`...' at line 2
Function: CargoSQLQuery::run Query: SELECT `cargo__mastery_groups`.`_pageName` AS `Mastery`,GROUP_CONCAT( CONCAT('* ', `m_e`.`stat_text`)
SEPARATOR "\n") AS `Effects` FROM `cargo__mastery_groups` LEFT OUTER JOIN `cargo__mastery_groups__mastery_effects` ON ((`cargo__mastery_groups`.`_ID`=`cargo__mastery_groups__mastery_effects`.`_rowID`)) RIGHT OUTER JOIN `cargo__mastery_effects` `m_e` ON ((`cargo__mastery_groups__mastery_effects`.`_value`=`m_e`.`id`)) WHERE `m_e`.`stat_text` LIKE GROUP BY `cargo__mastery_groups`.`_pageName` ORDER BY `cargo__mastery_groups`.`_pageName` LIMIT 100