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 (test http://neonfloppy.sytes.net/)
m (restore)
Line 1: Line 1:
−
http://neonfloppy.sytes.net/
 
−
 
−
 
 
'''Basic example -- does not work with multiple defined dates: '''
 
'''Basic example -- does not work with multiple defined dates: '''
  

Revision as of 22:34, 20 June 2022

Basic example -- does not work with multiple defined dates:

_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
¡Zombies! : Faulty Towers 2019-08-14 August 14, 2019
.Age
.EXE 2016-06-16 June 16, 2016
.fall 2019-10-28 October 28, 2019
.hack//G.U. Last Recode 2017-11-03 November 3, 2017
.kkrieger 2004-04-10 April 10, 2004
.Projekt 2018-03-17 March 17, 2018
.T.E.S.T: Expected Behaviour 2018-05-04 May 4, 2018
'83
'90s Football Stars 2018-08-30 August 30, 2018

More...

---

NumOfRows:

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`="Half-Life" ORDER BY `cargo__Infobox_game`.`_pageID`,COUNT(`cargo__Infobox_game__Released`.`_value`) LIMIT 100

_pageName DateFormatted
Half-Life January 25, 2013
Half-Life January 25, 2013
Half-Life November 19, 1998

Delimited: January 25, 2013 and January 25, 2013 and November 19, 1998

---

Full:

_pageName Released Released full CONCAT__full SUBSTRING
Doom (1993) 1993-12-10 • 1994-10-10 • 1994-11-04 • 1996-08-20 • 2001-01-01 • 2006-02-03 • 2007-08-03 1993-12-10 • 1994-10-10 • 1994-11-04 • 1996-08-20 • 2001-01-01 • 2006-02-03 • 2007-08-03 1993-12-10;1994-10-10;1994-11-04;1996-08-20;2001-01-01;2006-02-03;2007-08-03

---

Group By:

_pageName DateFormatted
Half-Life January 25, 2013
Half-Life November 19, 1998

Delimited: January 25, 2013 and November 19, 1998

---

Duplicate data in table ? Returns 2 rows -- should only be 1 !

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`,`Released__full` AS `DateUnformatted`,DATE_FORMAT(`cargo__Infobox_game`.`Released__full`,"%M %e, %Y") AS `DateFormatted`,COUNT(*) AS `NumOfRows`,`cargo__Infobox_game`.`Released__precision` AS `DateUnformatted__precision` FROM `cargo__Infobox_game` WHERE `cargo__Infobox_game`.`_pageName`="Quake" 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(*) LIMIT 100