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|}}}%
       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.