Template:Yearsofteams: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) No edit summary |
Kamalanath (talk | contribs) No edit summary |
||
| Line 7: | Line 7: | ||
|where=(TeamTypeName='{{#var:FindPageName}}') | |where=(TeamTypeName='{{#var:FindPageName}}') | ||
|order by=Year DESC | |order by=Year DESC | ||
|data=Year=Year,TeamTypeName=TeamTypeName,TeamName=TeamName,TeamTypePageName=TeamTypePageName,TeamPhoto=TeamPhoto, | |data=Year=Year,TeamTypeName=TeamTypeName,TeamName=TeamName,TeamTypePageName=TeamTypePageName,TeamPhoto=TeamPhoto,Photo=Photo | ||
}} | }} | ||
{| class="wikitable" | {| class="wikitable" | ||
| Line 15: | Line 15: | ||
{{!}} [[{{PAGENAME}}:{{{Year}}}|{{{Year}}}]] | {{!}} [[{{PAGENAME}}:{{{Year}}}|{{{Year}}}]] | ||
{{!}} {{{TeamPhoto}}} | {{!}} {{{TeamPhoto}}} | ||
{{!}} {{{Photo}}} | |||
}} | }} | ||
|} | |} | ||
Revision as of 05:11, 9 December 2023
The query SELECT Year,TeamTypeName,TeamName,TeamTypePageName,TeamPhoto,Photo FROM `wikiyearsofteams` WHERE (TeamTypeName='Yearsofteams') ORDER BY Year DESC is invalid (Error 1054: Unknown column 'Photo' in 'field list' Function: EDConnectorRdbms::fetch Query: SELECT Year,TeamTypeName,TeamName,TeamTypePageName,TeamPhoto,Photo FROM `wikiyearsofteams` WHERE (TeamTypeName='Yearsofteams') ORDER BY Year DESC ).
| Team Name |
|---|