Difference between revisions of "User:Garrett/Sandbox4"
From PCGamingWiki, the wiki about fixing PC games
| Line 8: | Line 8: | ||
|template=Infobox company/subsidiaries | |template=Infobox company/subsidiaries | ||
}} | }} | ||
| + | |||
| + | |||
| + | waffles:{{#cargo_query: | ||
| + | tables=Availability | ||
| + | |fields=COUNT(*) | ||
| + | |where=Available_from HOLDS LIKE 'Battle.net' | ||
| + | |format=text | ||
| + | }} | ||
| + | |||
| + | {{#ifeq:{{#cargo_query:tables=Availability|fields=COUNT(*)|where=Available_from HOLDS LIKE 'Battle.net2'|format=text}}|0|Fat|skinny}} | ||
Revision as of 07:47, 2 October 2021
Ubisoft Quebec
, Ubisoft Montreal
, Ubisoft Bucharest
, Ubisoft Singapore
, Ubisoft Montpellier
, Ubisoft Kyiv
, Ubisoft Shanghai
waffles:
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Availability._pageID'; this is incompatible with sql_mode=only_full_group_by (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)
Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,COUNT(*) FROM `cargo__Availability` WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Battle.net') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100
skinny