Difference between revisions of "Template:Mini Conversations List"

From A3! Wiki
m
Line 2: Line 2:
 
! colspan="2" style="text-align: center; " |{{{character|}}}
 
! colspan="2" style="text-align: center; " |{{{character|}}}
 
{{#cargo_query:tables=Mini_Conversations
 
{{#cargo_query:tables=Mini_Conversations
|fields=character,lesson,partner,type
+
|fields=chara,lesson,partner,type
|where=Mini_Conversations.chara HOLDS 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:21, 7 February 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)