IFDB question: Can sort by most wish-listed?

The title pretty much says it all: I’m looking for a way to sort games based on how many times they have been placed on wish lists.

I know that it’s possible to limit searches based on whether or not they are on your own wish list, but what I want to see is how many wish lists the games are on across all registered users. Is this possible?

4 Likes

I don’t think the website allows that right now. You can, however, download the latest backup from the ifarchive and use sql to search it. It seems like a nice feature though!

2 Likes

Here’s a list of the top 100 wishlisted games in IFDB.

MariaDB [ifdb]> select gameid, title, count(userid) w from wishlists join games on gameid = id group by gameid, title order by w desc limit 100;
+------------------+----------------------------------------+-----+
| gameid           | title                                  | w   |
+------------------+----------------------------------------+-----+
| op0uw1gn1tjqmjt7 | Anchorhead                             | 423 |
| ez2mcyx4zi98qlkh | Blue Lacuna                            | 362 |
| aearuuxv83plclpl | Counterfeit Monkey                     | 359 |
| 1aliwzro4e48mdlt | Worlds Apart                           | 325 |
| 032krqe6bjn5au78 | Slouching Towards Bedlam               | 319 |
| u6wzkckne4zsafyl | City of Secrets                        | 308 |
| 2xyccw3pe0uovfad | Spider and Web                         | 305 |
| plvzam05bmz3enh8 | Curses                                 | 300 |
| p0cizeb3kiwzlm2p | Savoir-Faire                           | 287 |
| jdrbw1htq4ah8q57 | Make It Good                           | 279 |
| 4h62dvooeg9ajtfa | A Mind Forever Voyaging                | 258 |
| ywwlr3tpxnktjasd | Varicella                              | 246 |
| ju778uv5xaswnlpl | Photopia                               | 245 |
| j61yaux1cqbptxyb | Metamorphoses                          | 241 |
| mohwfk47yjzii14w | Lost Pig                               | 239 |
| 7vtm1rq16hh3xch  | Endless, Nameless                      | 235 |
| 9ntef9expou18abv | The King of Shreds and Patches         | 226 |
| z5xgyw0jbt9r3ah1 | Babel                                  | 222 |
| w5s3sv43s3p98v45 | The Gostak                             | 217 |
| j18kjz80hxjtyayw | Trinity                                | 212 |
| urxrv27t7qtu52lb | Galatea                                | 208 |
| u58d0mlbfwcorfi  | Hadean Lands                           | 206 |
| 9p8kh3im2j9h2881 | Bronze                                 | 203 |
| g0fl99ovcrq2sqzk | Coloratura                             | 194 |
| 28uhmejlntcbccqm | Jigsaw                                 | 192 |
| 6dj2vguyiagrhvc2 | Vespers                                | 188 |
| hsfc7fnl40k4a30q | Shade                                  | 185 |
| 00e0t7swrris5pg6 | 1893: A World's Fair Mystery           | 180 |
| 4glrrfh7wrp9zz7b | Violet                                 | 177 |
| b2g8je1xxtqzei4u | Alabaster                              | 177 |
| weac28l51hiqfzxz | De Baron                               | 176 |
| 3myqnrs64nbtwdaz | The Dreamhold                          | 170 |
| rcrihauxixy48svr | So Far                                 | 170 |
| k6yq5koj2zjzstpt | The Mulldoon Legacy                    | 169 |
| ouv80gvsl32xlion | The Hitchhiker's Guide to the Galaxy   | 168 |
| 4x7nltu8p851tn4x | Cragne Manor                           | 167 |
| 4s7uohdncurgqb0h | All Roads                              | 166 |
| g79qfkq3m3dtffq4 | The Shadow in the Cathedral            | 166 |
| fq26p07f48ckfror | Christminster                          | 164 |
| xkai23ry99qdxce3 | Suveh Nux                              | 160 |
| 5xzoz5wimz4xxha  | Superluminal Vagrant Twin              | 157 |
| 01efmfsk4r79mtks | Floatpoint                             | 156 |
| t61i5akczyblx2zd | For a Change                           | 155 |
| spsnevz1br6f2z3v | Pytho's Mask                           | 155 |
| xe6kb3cuqwie2q38 | Planetfall                             | 155 |
| 5e23lnq25gon9tp3 | All Things Devours                     | 150 |
| hslgyznv9n2hou7k | Open Sorcery                           | 148 |
| 0dbnusxunq7fw5ro | Zork I                                 | 147 |
| 9s66qxkt22kq5wv9 | Blighted Isle                          | 139 |
| xwedbibfksczn7eq | Gun Mute                               | 139 |
| xf5y04yekcrqtnc  | Toby's Nose                            | 139 |
| x43lndv5htzy38w0 | An Act of Murder                       | 137 |
| 8upuvdnsk4sho6ac | Treasures of a Slaver's Kingdom        | 137 |
| jf4rk3cvmlajhl2r | Delightful Wallpaper                   | 136 |
| 7t22wbllftv7nuiw | Lydia's Heart                          | 136 |
| ykccumi5xc5rltev | Hoist Sail for the Heliopause and Home | 134 |
| pwyjp54iubdq70p0 | Sunset Over Savannah                   | 131 |
| 6d9dfn2akcrlq1bu | To Hell in a Hamper                    | 128 |
| 0stz0hr7a98bp9mp | Rameses                                | 128 |
| z02joykzh66wfhcl | Wishbringer                            | 128 |
| 3a4kqs374jqu2li6 | Nightfall                              | 128 |
| lyblvftb8xtlo0a1 | Everybody Dies                         | 125 |
| bv8of8y9xeo7307g | Theatre                                | 124 |
| 445d989vuwlh4cvz | With Those We Love Alive               | 122 |
| 3a9rb059miw9fc9h | Bad Machine                            | 121 |
| p4dlfwy4yg6pzdba | First Things First                     | 121 |
| xi4s5ne9m6w821xd | Ad Verbum                              | 121 |
| 10387w68qlwehbyq | The Moonlit Tower                      | 120 |
| uq18rw9gt8j58da  | The Wizard Sniffer                     | 120 |
| 6xbqnmlxvkju2n04 | Cryptozookeeper                        | 119 |
| b1xy3s75cjlty973 | Glowgrass                              | 118 |
| clrttol4iw7juc0k | Rogue of the Multiverse                | 117 |
| mlcp0rjb34vnitau | Worldsmith                             | 117 |
| 4tb9soabrb4apqzd | The Edifice                            | 114 |
| 82mn545s8bt3csa4 | Shrapnel                               | 114 |
| mh1a6hizgwjdbeg7 | Hunter, in Darkness                    | 114 |
| f7zdhxmiraht53d1 | Kerkerkruip                            | 113 |
| jhbd0kja1t57uop  | The Lurking Horror                     | 112 |
| j49crlvd62mhwuzu | Aisle                                  | 112 |
| etul31tqgl3n22nl | Mentula Macanus: Apocolocyntosis       | 112 |
| mxj7xp4nffia9rbj | howling dogs                           | 112 |
| t0pidhghzbo91i12 | Risorgimento Represso                  | 111 |
| j1qv39w1ucnlhnms | Lock & Key                             | 111 |
| ddagftras22bnz8h | Plundered Hearts                       | 111 |
| xfezh9wz188ihlel | Dual Transform                         | 111 |
| 8pe83e92v4nvabic | Bee                                    | 111 |
| ap1651hvjldbuugj | Birdland                               | 111 |
| qpecxgjpxnvw50xq | The Elysium Enigma                     | 110 |
| u0fzm0lxlt9vb4fi | Walker & Silhouette                    | 110 |
| l7qf2lyc563kk84p | Little Blue Men                        | 109 |
| ov7wpv4l1fth1tro | Dangerous Curves                       | 108 |
| cpwktis6qwh9ydn8 | Augmented Fourth                       | 108 |
| c6x835i6o9zqfc59 | Fail-Safe                              | 108 |
| 2ej7ntbmoit9ytvy | Taco Fiction                           | 108 |
| p976o7x5ies9ltdh | Deadline                               | 107 |
| 8l9cdcd1tbt77hfl | Creatures Such As We                   | 106 |
| 2cuwjlvpybg8oaf0 | Midnight. Swordfight.                  | 105 |
| az8jb9bddngurwr7 | Fate                                   | 104 |
| gdl05tnyqjja5vc6 | Kaged                                  | 104 |
| yutkd9u0oeog4br1 | Eat Me                                 | 104 |
+------------------+----------------------------------------+-----+
11 Likes

From this list we can get the list of the Top Wishlisted Games That Aren’t In The IFDB Top 100 or Highest Rated Top 100, or more succinctly:

Out-of-Fashion Classics
In order of most to least wishlisted
Top 10
Galatea
Jigsaw
Shade
1893: A World’s Fair Mystery
De Baron
The Dreamhold
So Far
All Roads
Christminster
Floatpoint

Top 11-46
For a Change
Pytho’s Mask
Zork I
Blighted Isle
An Act of Murder
Delightful Wallpaper
Lydia’s Heart
Hoist Sail for the Heliopause and Home
Sunset Over Savannah
Rameses
Wishbringer
Nightfall
Everybody Dies
Theatre
Bad Machine
Ad Verbum
The Moonlit Tower
Glowgrass
Rogue of the Multiverse
The Edifice
Shrapnel
Hunter, in Darkness
Kerkerkruip
Aisle
howling dogs
Risorgimento Represso
Lock & Key
Dual Transform
The Elysium Enigma
Walker & Silhouette
Little Blue Men
Dangerous Curves
Fail-Safe
Deadline
Fate
Kaged

Lists Used

As of today, 24th June, 2024:

IFDB Top 100
4x4 Archipelago
80 DAYS
A Beauty Cold and Austere
A Long Way to the Nearest Star
A Mind Forever Voyaging
A Study in Steampunk: Choice by Gaslight
Absence of Law
According to Cain
Alias ‘The Magpie’
All Things Devours
Anchorhead
And Then You Come to a House Not Unlike the Previous One
Augmented Fourth
Babel
Beautiful Dreamer
Birdland
Blue Lacuna
Bogeyman
Bronze
Cannery Vale
Chlorophyll
Choice of Robots
City of Secrets
Coloratura
Counterfeit Monkey
Cragne Manor
Cryptozookeeper
Digital: A Love Story
Dr Ludwig and the Devil
Eat Me
Enchanter
Endless, Nameless
Eric the Unready
Erstwhile
Fairest
Fallen London
First Things First
Foo Foo
Grimnoir
Grooverland
Hadean Lands
Harmonia
Heretic’s Hope
Illuminismo Iniziato
Inside the Facility
Junior Arithmancer
Known Unknowns
Lost Pig
Make It Good
Mentula Macanus: Apocolocyntosis
Metamorphoses
Midnight. Swordfight.
Of Their Shadows Deep
Open Sorcery
Oppositely Opal
Photopia
Planetfall
Repeat the Ending
Savoir-Faire
Slouching Towards Bedlam
Sorcery!
Sorcery! 2
Spider and Web
SPY INTRIGUE
Stay?
Sub Rosa
Sunless Sea
Superluminal Vagrant Twin
Suveh Nux
Tangaroa Deep
Tavern Crawler
The Axolotl Project
The Gostak
The Hitchhiker’s Guide to the Galaxy
The Impossible Bottle
The Impossible Stairs
The King of Shreds and Patches
The Little Match Girl 4: Crown of Pearls
The Lurking Horror II: The Lurkening
The Mulldoon Legacy, by Jon Ingold (1999)
The Shadow in the Cathedral
The Spectators
The Wand
The Weight of a Soul
The Wizard Sniffer
Toby’s Nose
Treasures of a Slaver’s Kingdom
Trinity
Turandot
Violet
Wayhaven Chronicles: Book One
Weird City Interloper
What Heart Heard Of, Ghost Guessed
Will Not Let Me Go
With Those We Love Alive
Worlds Apart
Worldsmith
You Will Select a Decision
Zozzled
:heart:Magical Makeover​:heart:

IFDB Top Rated (the first 100 search results
16 Ways to Kill a Vampire at McDonalds
80 DAYS
A Beauty Cold and Austere
A Long Way to the Nearest Star
A Mind Forever Voyaging
A Study in Steampunk: Choice by Gaslight
Absence of Law
According to Cain
Alabaster
Alias ‘The Magpie’
All Things Devours
Anchorhead
And Then You Come to a House Not Unlike the Previous One
Augmented Fourth
Babel
Bee
Birdland
Blue Lacuna
Bogeyman
Brain Guzzlers from Beyond!
Bronze
Cactus Blue Motel
Cannery Vale
Chlorophyll
Choice of Robots
City of Secrets
Coloratura
Counterfeit Monkey
Cragne Manor
Creatures Such As We
Curses
Dr Ludwig and the Devil
Eat Me
Enchanter
Endless, Nameless
Eric the Unready
Erstwhile
Fallen Hero: Rebirth
Foo Foo
Gun Mute
Hadean Lands
Harmonia
Inside the Facility
Junior Arithmancer
Known Unknowns
Lost Pig
Make It Good
Metamorphoses
Midnight. Swordfight.
Never Gives Up Her Dead
Of Their Shadows Deep
Open Sorcery
Oppositely Opal
Photopia
Planetfall
Plundered Hearts
Repeat the Ending
Savoir-Faire
Slouching Towards Bedlam
Sorcerer
Sorcery! 2
Spider and Web
SPY INTRIGUE
Stay?
Sub Rosa
Sunless Sea
Superluminal Vagrant Twin
Suveh Nux
Taco Fiction
Tangaroa Deep
The Axolotl Project
The Gostak
The Hitchhiker’s Guide to the Galaxy
The Impossible Bottle
The Impossible Stairs
The King of Shreds and Patches
The Lurking Horror
The Mulldoon Legacy
The Wand
The Weight of a Soul
The Wizard Sniffer
To Hell in a Hamper
Toby’s Nose
Treasures of a Slaver’s Kingdom
Trinity
Turandot
Varicella
Vespers
Violet
Wayhaven Chronicles: Book One
Wayhaven Chronicles: Book Two
Weird City Interloper
What Heart Heard Of, Ghost Guessed
Will Not Let Me Go
With Those We Love Alive
Worlds Apart
Worldsmith
You Will Select a Decision
Zozzled
:heart:Magical Makeover​:heart:

And if you want to play around, here’s a clean version of the top 100 wishlisted:

1893: A World’s Fair Mystery
A Mind Forever Voyaging
Ad Verbum
Aisle
Alabaster
All Roads
All Things Devours
An Act of Murder
Anchorhead
Augmented Fourth
Babel
Bad Machine
Bee
Birdland
Blighted Isle
Blue Lacuna
Bronze
Christminster
City of Secrets
Coloratura
Counterfeit Monkey
Cragne Manor
Creatures Such As We
Cryptozookeeper
Curses
Dangerous Curves
De Baron
Deadline
Delightful Wallpaper
Dual Transform
Eat Me
Endless, Nameless
Everybody Dies
Fail-Safe
Fate
First Things First
Floatpoint
For a Change
Galatea
Glowgrass
Gun Mute
Hadean Lands
Hoist Sail for the Heliopause and Home
howling dogs
Hunter, in Darkness
Jigsaw
Kaged
Kerkerkruip
Little Blue Men
Lock & Key
Lost Pig
Lydia’s Heart
Make It Good
Mentula Macanus: Apocolocyntosis
Metamorphoses
Midnight. Swordfight.
Nightfall
Open Sorcery
Photopia
Planetfall
Plundered Hearts
Pytho’s Mask
Rameses
Risorgimento Represso
Rogue of the Multiverse
Savoir-Faire
Shade
Shrapnel
Slouching Towards Bedlam
So Far
Spider and Web
Sunset Over Savannah
Superluminal Vagrant Twin
Suveh Nux
Taco Fiction
The Dreamhold
The Edifice
The Elysium Enigma
The Gostak
The Hitchhiker’s Guide to the Galaxy
The King of Shreds and Patches
The Lurking Horror
The Moonlit Tower
The Mulldoon Legacy
The Shadow in the Cathedral
The Wizard Sniffer
Theatre
To Hell in a Hamper
Toby’s Nose
Treasures of a Slaver’s Kingdom
Trinity
Varicella
Vespers
Violet
Walker & Silhouette
Wishbringer
With Those We Love Alive
Worlds Apart
Worldsmith
Zork I

7 Likes

That sounds about right! A lot of good games that aren’t really in vogue anymore. Almost all are parser games from before 2010. howling dogs is a notable exception

Very cool list!

4 Likes

Most of the top 10 are on my wishlist. :joy: Although I have played two!

2 Likes

Thanks! I was moved to make a list of the top 10 for the IFDB. They’re mostly the games everyone 15 years ago agreed were must-plays. Of them, I think some are notable because they did something groundbreaking (which now may have long since been imitated), or they hold up as very enjoyable experiences, and the best do both.

6 Likes