Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

Difference between revisions of "User:Aemony/Sandbox"

From PCGamingWiki, the wiki about fixing PC games
m (Blank)
Tag: Blanking
m
Line 1: Line 1:
 +
{{#cargo_query:
 +
tables=Infobox_game
 +
|fields=Infobox_game._pageName,Infobox_game.Released_Windows=DateUnformatted,DATE_FORMAT(Infobox_game.Released_Windows,"%M %e, %Y")=DateFormatted
 +
|limit=10
 +
}}
  
 +
{{#cargo_query:
 +
tables=Infobox_game
 +
|fields=Infobox_game._pageName,Infobox_game.Released__full=DateUnformatted,DATE_FORMAT(Infobox_game.Released__full,"%M %e, %Y")=DateFormatted,COUNT(Infobox_game.Released__full)=DateFull
 +
|limit=10
 +
}}
 +
 +
---
 +
 +
{{#cargo_query:
 +
tables=Infobox_game,Infobox_game__Released
 +
|join on=Infobox_game._ID=Infobox_game__Released._rowID
 +
|fields=COUNT(Infobox_game__Released._value)
 +
|where=Infobox_game._pageName="Quake"
 +
}}
 +
 +
{{#cargo_query:
 +
tables=Infobox_game,Infobox_game__Released
 +
|join on=Infobox_game._ID=Infobox_game__Released._rowID
 +
|fields=Infobox_game._pageName,DATE_FORMAT(Infobox_game__Released._value,"%M %e, %Y")=DateFormatted
 +
|where=Infobox_game._pageName="Quake"
 +
}}

Revision as of 02:50, 29 November 2021

_pageName DateUnformatted DateFormatted
! That Bastard Is Trying To Steal Our Gold ! 2014-05-09 May 9, 2014
!4RC4N01D! 2018-01-12 January 12, 2018
!4RC4N01D! 2: Retro Edition 2018-02-03 February 3, 2018
!4RC4N01D! 3: Cold Space 2018-03-08 March 8, 2018
!4RC4N01D! 4: Kohbeep Edition 2018-03-30 March 30, 2018
!Anyway! 2018-06-06 June 6, 2018
!BurnToDie! 2018-09-27 September 27, 2018
!Dead Pixels Adventure! 2018-06-12 June 12, 2018
!LABrpgUP! 2018-06-13 June 13, 2018
!Peace Phantom 2! 2018-03-13 March 13, 2018

More...

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Infobox_game._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__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,`cargo__Infobox_game`.`_pageName` AS `_pageName`,`cargo__Infobox_game`.`Released__full` AS `DateUnformatted`,DATE_FORMAT(`cargo__Infobox_game`.`Released__full`,"%M %e, %Y") AS `DateFormatted`,COUNT(`cargo__Infobox_game`.`Released__full`) AS `DateFull`,`cargo__Infobox_game`.`Released__precision` AS `DateUnformatted__precision` FROM `cargo__Infobox_game` ORDER BY `cargo__Infobox_game`.`_pageID`,`cargo__Infobox_game`.`_pageName`,`cargo__Infobox_game`.`Released__full`,DATE_FORMAT(`cargo__Infobox_game`.`Released__full`,"%M %e, %Y"),COUNT(`cargo__Infobox_game`.`Released__full`) LIMIT 100

---

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Infobox_game._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__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(`cargo__Infobox_game__Released`.`_value`) AS `_value)` FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Infobox_game__Released` ON ((`cargo__Infobox_game`.`_ID`=`cargo__Infobox_game__Released`.`_rowID`)) WHERE `cargo__Infobox_game`.`_pageName`="Quake" ORDER BY `cargo__Infobox_game`.`_pageID`,COUNT(`cargo__Infobox_game__Released`.`_value`) LIMIT 100

_pageName DateFormatted
Quake August 26, 2015
Quake August 28, 1997
Quake January 22, 1997
Quake July 5, 1996
Quake June 22, 1996