Template:Yearsofteams: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) No edit summary |
Kamalanath (talk | contribs) No edit summary |
||
| Line 3: | Line 3: | ||
{{#vardefine:FindTeamTypeName|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos}}}}}} | {{#vardefine:FindTeamTypeName|{{#sub:{{PAGENAME}}|{{#var:LastColnNextPos}}}}}} | ||
{{#vardefine:LeftStringFromColn|{{#sub:{{PAGENAME}}|0|{{#var:LastColnPos}}}}}} | {{#vardefine:LeftStringFromColn|{{#sub:{{PAGENAME}}|0|{{#var:LastColnPos}}}}}} | ||
{{# | {{#vardefine:FindTeamName|LeftStringFromColn}} | ||
{{#var: | {{#var:FindTeamTypeName}} | ||
{{#var:FindTeamName}} | |||
{{#get_db_data: | {{#get_db_data: | ||
|server=drck-db | |server=drck-db | ||
|from=wikiyearsofteams | |from=wikiyearsofteams | ||
|where=(TeamTypeName='{{#var: | |where=(TeamTypeName='{{#var:FindTeamTypeName}}') and (TeamName='{{#var:FindTeamName}}') | ||
|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 | ||
Revision as of 06:13, 9 December 2023
Yearsofteams LeftStringFromColn The query SELECT Year,TeamTypeName,TeamName,TeamTypePageName,TeamPhoto,Photo FROM `wikiyearsofteams` WHERE (TeamTypeName='Yearsofteams') and (TeamName='LeftStringFromColn') 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') and (TeamName='LeftStringFromColn') ORDER BY Year DESC ).
| Team Name |
|---|