Difference between revisions of "List of games delisted from Amazon.co.uk"
m (Protected "List of games delisted from Amazon.co.uk": (via JWB) ([Edit=Allow only autoconfirmed users] (indefinite) [Move=Allow only autoconfirmed users] (indefinite))) |
m (→top: General maintenance with AutoWikiBrowser in Bot mode) |
||
Line 7: | Line 7: | ||
|format=text | |format=text | ||
}} | }} | ||
− | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Infobox_game,Availability | tables=Infobox_game,Availability | ||
Line 18: | Line 17: | ||
|intro={{Game list/intro}} | |intro={{Game list/intro}} | ||
|template=Game list/row | |template=Game list/row | ||
− | |outro=</table> | + | |outro=</table></div> |
}} | }} | ||
[[Category:Lists]] | [[Category:Lists]] |
Revision as of 05:53, 6 September 2022
This is an automated list of all games believed to have been delisted from Amazon.
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`LIKE 'Amazon UK') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Amazon UK') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100