Template:Item query: Difference between revisions
From Chinese Religious Text Authority
No edit summary |
No edit summary |
||
Line 11: | Line 11: | ||
|format=ol | |format=ol | ||
|group by=Item_infobox._pageName | |group by=Item_infobox._pageName | ||
|where=title LIKE '%{{{title|}}}%' AND UPPER(pinyin_title) LIKE UPPER('%{{{pinyin_title|}}}%') AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' and date >= DATE_ADD('00-01-01', INTERVAL '{{{year_min|}}}' YEAR) | |where=title LIKE '%{{{title|}}}%' AND UPPER(pinyin_title) LIKE UPPER('%{{{pinyin_title|}}}%') AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' and date >= DATE_ADD(DATE('00-01-01'), INTERVAL '{{{year_min|}}}' YEAR) | ||
}} | }} | ||
</includeonly> | </includeonly> |
Revision as of 15:25, 18 May 2020
This is the 'Item query' template. It should be called via the Form:Item query form.