Difference between revisions of "User:Aemony/Sandbox"
m (AemonyTestingTwoFalse) |
m (Text replacement - "AemonyTestingTwoFalse" to "AemonyTestingTwoTrue") |
||
Line 3: | Line 3: | ||
AemonyTestingTrue | AemonyTestingTrue | ||
− | + | AemonyTestingTwoTrue | |
'''Basic example -- does not work with multiple defined dates: ''' | '''Basic example -- does not work with multiple defined dates: ''' |
Revision as of 06:38, 10 September 2022
Test
AemonyTestingTrue
AemonyTestingTwoTrue
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 |
.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 |
'Member the Alamo? | 2020-10-30 | October 30, 2020 |
---
NumOfRows:
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 !
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