Item query: Difference between revisions
Jump to navigation
Jump to search
Yaron Koren (talk | contribs) (Simplified) |
Yaron Koren (talk | contribs) No edit summary |
||
Line 2: | Line 2: | ||
|join on=Items.Author HOLDS Authors._pageName | |join on=Items.Author HOLDS Authors._pageName | ||
|fields=Items._pageName=Item,Items.Author,Political_affiliation,Source,DATE_FORMAT(Date, "%M %e, %Y")=Publication date,CONCAT('[', URL, ' View item]')=Link | |fields=Items._pageName=Item,Items.Author,Political_affiliation,Source,DATE_FORMAT(Date, "%M %e, %Y")=Publication date,CONCAT('[', URL, ' View item]')=Link | ||
|order by=Date}} | |order by=Date | ||
}} |