Difference between revisions of "Template:Mini Conversations List"

From A3! Wiki
m
m
Line 3: Line 3:
 
{{#cargo_query:tables=Mini_Conversations
 
{{#cargo_query:tables=Mini_Conversations
 
|fields=chara,lesson,partner,type
 
|fields=chara,lesson,partner,type
|where=chara LIKE "%{{{character|}}}%"
+
|where=chara HOLDS LIKE "%{{{character|}}}%"
 
|order by=lesson_no ASC, type DESC
 
|order by=lesson_no ASC, type DESC
 
|format=template
 
|format=template

Revision as of 10:35, 2 July 2018


Sakuya Sakuma
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `chara` AS `chara`,`lesson` AS `lesson`,`partner` AS `partner`,`type` AS `type` FROM `mw_cargo__Mini_Conversations` WHERE chara HOLDS LIKE "%Sakuya Sakuma%" ORDER BY lesson_no ASC, type DESC LIMIT 100 Function: CargoSQLQuery::run 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 'HOLDS LIKE "%Sakuya Sakuma%" ORDER BY lesson_no ASC, type DESC LIMIT 100' at line 1 (localhost)

Sakuya Sakuma
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `chara` AS `chara`,`lesson` AS `lesson`,`partner` AS `partner`,`type` AS `type` FROM `mw_cargo__Mini_Conversations` WHERE chara HOLDS LIKE "%Sakuya Sakuma%" ORDER BY lesson_no ASC, type DESC LIMIT 100 Function: CargoSQLQuery::run 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 'HOLDS LIKE "%Sakuya Sakuma%" ORDER BY lesson_no ASC, type DESC LIMIT 100' at line 1 (localhost)

Sakuya Sakuma
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `chara` AS `chara`,`lesson` AS `lesson`,`partner` AS `partner`,`type` AS `type` FROM `mw_cargo__Mini_Conversations` WHERE chara HOLDS LIKE "%Sakuya Sakuma%" ORDER BY lesson_no ASC, type DESC LIMIT 100 Function: CargoSQLQuery::run 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 'HOLDS LIKE "%Sakuya Sakuma%" ORDER BY lesson_no ASC, type DESC LIMIT 100' at line 1 (localhost)

Sakuya Sakuma
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `chara` AS `chara`,`lesson` AS `lesson`,`partner` AS `partner`,`type` AS `type` FROM `mw_cargo__Mini_Conversations` WHERE chara HOLDS LIKE "%Sakuya Sakuma%" ORDER BY lesson_no ASC, type DESC LIMIT 100 Function: CargoSQLQuery::run 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 'HOLDS LIKE "%Sakuya Sakuma%" ORDER BY lesson_no ASC, type DESC LIMIT 100' at line 1 (localhost)