Template:Teampage: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) No edit summary |
Kamalanath (talk | contribs) No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 12: | Line 12: | ||
{{#vardefine:FindTeamName|{{#var:LeftStringFromColn}}}} | {{#vardefine:FindTeamName|{{#var:LeftStringFromColn}}}} | ||
{{#get_db_data: | {{#get_db_data: | ||
|server=drck-db | |server=drck-db | ||
|from=wikiyearsofteams | |from=wikiyearsofteams | ||
|where=(TeamTypeName='{{#var:FindTeamTypeName}}') and (TeamName='{{#var:FindTeamName}}') | |where=(TeamTypeName='{{#var:FindTeamTypeName}}') and (TeamName='{{#var:FindTeamName}}') and (Year='{{#var:FindTeamYear}}') | ||
|order by=Year DESC | |order by=Year DESC | ||
|data=Year=Year,TeamTypeName=TeamTypeName,TeamName=TeamName,TeamTypePageName=TeamTypePageName,TeamPhoto=TeamPhoto,Photo=Photo | |data=Year=Year,TeamTypeName=TeamTypeName,TeamName=TeamName,TeamTypePageName=TeamTypePageName,TeamPhoto=TeamPhoto,Photo=Photo | ||
}} | }} | ||
{| class="wikitable" | {| class="wikitable" | ||
{{#for_external_table:<nowiki/> | {{#for_external_table:<nowiki/> | ||
{{!}}- | {{!}}- | ||
{{!}} {{{Photo}}} | {{!}} {{{Photo}}} | ||
}} | }} | ||
|} | |} | ||
Latest revision as of 06:41, 9 December 2023
The query SELECT Year,TeamTypeName,TeamName,TeamTypePageName,TeamPhoto,Photo FROM `wikiyearsofteams` WHERE (TeamTypeName='Teampag') and (TeamName='Teampa') and (Year='Teampage') 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='Teampag') and (TeamName='Teampa') and (Year='Teampage') ORDER BY Year DESC
).