Template:Item query: Difference between revisions

Revision as of 18:24, 20 May 2020

This is the 'Item query' template. It should be called via the Form:Item query form.

@@ Line 9: / Line 9: @@
 tables=Item_infobox, Item_infobox__creator_list
 |join on=Item_infobox._ID=Item_infobox__creator_list._rowID
-|fields=_pageName=title
+|fields=_pageName=title,Item_infobox__creator_list__full
-|where=title HOLDS '%{{{title|}}}%' AND UPPER(pinyin_title) HOLDS ('%{{{pinyin_title|}}}%') AND creator_list HOLDS '%{{{creator|}}}%'
+|where=Item_infobox__creator_list.__value= '%{{{creator|}}}%'
 |intro=Results so far
 |default=No Results