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 | ||
IF("{{{year_exact|}}}" = "", TRUE, 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:14, 26 May 2021
This is the 'Item query' template. It should be called via the Form:Item query form.
