Template:Item query: Difference between revisions

Revision as of 12:19, 12 April 2021

This is the 'Item query' template. It should be called via the Form:Item query form.

@@ Line 7: / Line 7: @@
 {{#cargo_query:
-tables=Item_infobox, Item_infobox__title_list, Item_infobox__publication_places
+tables=Item_infobox, Item_infobox__publication_places
-|join on=Item_infobox._ID=Item_infobox__title_list._rowID, Item_infobox._ID=Item_infobox__publication_places._rowID
+|join on=Item_infobox._ID=Item_infobox__publication_places._rowID
-|fields=_pageName=Entry, title_list__full=Title List, creator_list__full=List of Creators, format=Format, publication_places__full=Publication place(s), publishers__full=Publisher(s), date=Date, date_start=Start Date, date_end=End Date
+|fields=_pageName=Entry, creator_list__full=List of Creators, format=Format, publication_places__full=Publication place(s), publishers__full=Publisher(s), date=Date, date_start=Start Date, date_end=End Date
-|where=title LIKE '%{{{title|}}}%' AND Item_infobox__title_list._value HOLDS LIKE '%{{{title|}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%'
+|where=title LIKE '%{{{title|}}}%' AND publication_places HOLDS LIKE '%{{{publication_place|}}}%' AND format LIKE '%{{{format|}}}%'
 |group by=Item_infobox._ID