[a / b / c / d / e / f / g / gif / h / hr / k / m / o / p / r / s / t / u / v / vg / vm / vmg / vr / vrpg / vst / w / wg] [i / ic] [r9k / s4s / vip / qa] [cm / hm / lgbt / y] [3 / aco / adv / an / bant / biz / cgl / ck / co / diy / fa / fit / gd / hc / his / int / jp / lit / mlp / mu / n / news / out / po / pol / pw / qst / sci / soc / sp / tg / toy / trv / tv / vp / vt / wsg / wsr / x / xs] [Settings] [Search] [Mobile] [Home]
Board
Settings Mobile Home
/wsr/ - Worksafe Requests


Thread archived.
You cannot reply anymore.


[Advertise on 4chan]


File: 1520697952203.jpg (143 KB, 1200x756)
143 KB
143 KB JPG
does anyone know of a website that has a database of video games that lets you filter out platforms? i'm trying to get the most accurate possible list of games that are available for ps4 but not pc. ps4 exclusive lists don't cut it since i'm looking for games that are also for switch, xbone, vita, etc. to be included. https://videogamegeek.com/ has this feature but the database seems very incomplete/outdated.
>>
https://en.wikipedia.org/wiki/Category:Video_game_lists_by_platform
>>
>>1456808
if there's a way to return results that exist in a specific one of those categories while excluding results that exist in one specific other category, that'd be what i'm looking for. is there a tool like that for wikipedia?
>>
>>1456809
It's an SQL query job. You can put entries into text and then put it into several Access tables for game platforms (Excel can do that too but never tried it personally). The query will be something like this (you'll need to use real table and field names):
SELECT PC.Gaym_Naym, Atari_Jag.Gaym_Naym
FROM Atari_Jag RIGHT JOIN PC ON Atari_Jag.Gaym_Naym = PC.Gaym_Naym
WHERE (Atari_Jag.Gaym_Naym Is Null);

Problem is some game names won't match letter to letter in different lists so they will count as separate entities unless you filter them out. If you somehow get your hands on an existing database where game entries are unique it'll be even better.
>>
>>1456874
while looking into how to get a clean csv/etc. dump of the page titles in a wikipedia category, i ended up coming across this tool that just lets you directly query which pages are in one category and not another like i wanted
https://petscan.wmflabs.org/?psid=28061835
but thanks for the lead, anon



[Advertise on 4chan]

Delete Post: [File Only] Style:
[Disable Mobile View / Use Desktop Site]

[Enable Mobile View / Use Mobile Site]

All trademarks and copyrights on this page are owned by their respective parties. Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.