Template:Item query: Difference between revisions
From Chinese Religious Text Authority
No edit summary |
mNo edit summary |
||
Line 9: | Line 9: | ||
tables=Item_infobox, Item_infobox__creator_list | tables=Item_infobox, Item_infobox__creator_list | ||
|join on=Item_infobox._ID=Item_infobox__creator_list._rowID | |join on=Item_infobox._ID=Item_infobox__creator_list._rowID | ||
|fields=_pageName=title | |fields=_pageName=title | ||
|where= | |format=ol | ||
| | |where=title HOLDS '%{{{title|}}}%' AND UPPER(pinyin_title) HOLDS ('%{{{pinyin_title|}}}%') AND creator_list HOLDS '%{{{creator|}}}%' | ||
| | |group by=Item_infobox._pageName | ||
| | |||
}} | }} | ||
</includeonly> | </includeonly> |
Revision as of 14:13, 1 June 2020
This is the 'Item query' template. It should be called via the Form:Item query form.