Template:Item query: Difference between revisions
From Chinese Religious Text Authority
No edit summary |
No edit summary |
||
Line 13: | Line 13: | ||
|where=(title LIKE '%{{{title|}}}%' OR title_list HOLDS LIKE '%{{{title|}}}%') AND | |where=(title LIKE '%{{{title|}}}%' OR title_list HOLDS LIKE '%{{{title|}}}%') AND | ||
IF("{{{publication_place|}}}" = "", TRUE, publication_places HOLDS LIKE '%{{{publication_place|}}}%') AND | IF("{{{publication_place|}}}" = "", TRUE, publication_places HOLDS LIKE '%{{{publication_place|}}}%') AND | ||
YEAR(date) = {{{year_exact|}}} | IF("{{{year_exact|}}}" = "", TRUE, YEAR(date) = {{{year_exact|}}}) | ||
|group by=Item_infobox._ID | |group by=Item_infobox._ID |
Revision as of 18:13, 26 May 2021
This is the 'Item query' template. It should be called via the Form:Item query form.