Difference between revisions of "List of games delisted from itch.io"
m (→top: General maintenance with AutoWikiBrowser in Bot mode) |
m (removed LIKE operator) |
||
Line 4: | Line 4: | ||
tables=Availability | tables=Availability | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
− | |where=Availability.Available_from_historically HOLDS | + | |where=Availability.Available_from_historically HOLDS 'itch.io' AND Availability.Available_from HOLDS NOT 'itch.io' |
|format=text | |format=text | ||
}} | }} | ||
Line 10: | Line 10: | ||
tables=Infobox_game,Availability | tables=Infobox_game,Availability | ||
|join on=Infobox_game._pageName=Availability._pageName | |join on=Infobox_game._pageName=Availability._pageName | ||
− | |where=Availability.Available_from_historically HOLDS | + | |where=Availability.Available_from_historically HOLDS 'itch.io' AND Availability.Available_from HOLDS NOT 'itch.io' |
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on | ||
|format=template | |format=template |
Revision as of 08:21, 23 April 2023
This is an automated list of all games believed to have been delisted from itch.io, or which haven't been released yet.
Total number of games:
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_historically` WHERE `_value`= 'itch.io') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`= 'itch.io') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100