Search Question

[paulmortlock]

How should I go about finding all games by a particular publisher? Ultimate Play the Game for example. Is there a way to list all publishers and what games were released and when.

How should I use the search to find Chuckie Egg?

[sam-ludlow]

Hello @paulmortlock

MAME-AO hasn't currently got any advanced search.

The filter page here isn't currently working, I need to fix, when I do, I'll let you know here. You will be able to use that for search on manufacture.

https://mame.spludlow.co.uk/MachineFilter.aspx

You can find all versions of a software here.

https://mame.spludlow.co.uk/SoftwareLists.aspx?Soft=Chuckie%20Egg

Cheers
Sam

[sam-ludlow]

Hello @paulmortlock

I fixed the filter page, have a play it does work just a bit wacky.

https://mame.spludlow.co.uk/MachineFilter.aspx

The idea was you can continue to filter stuff down, e.g. coins => 4players => decade

See what you think.

Cheers
Sam

[sam-ludlow]

Ahh I think you are talking about software not machines so the filter will be no good.

softwarelist.name	softwarelist.description	software.name	software.description	year	publisher
bbc_cass	Acorn BBC Micro cassettes	alien8	Alien 8	1984	Ultimate
bbc_cass	Acorn BBC Micro cassettes	aticatac	Atic Atac	1984	Ultimate
bbc_cass	Acorn BBC Micro cassettes	cosmicbz	Cosmic Battlezones	1986	Ultimate
bbc_cass	Acorn BBC Micro cassettes	jetpac	Jet-Pac	1984	Ultimate
bbc_cass	Acorn BBC Micro cassettes	knightl	Knight Lore	1984	Ultimate
bbc_cass	Acorn BBC Micro cassettes	sabrwulf	Sabre Wulf	1984	Ultimate
cpc_cass	Amstrad CPC cassettes	alien8	Alien 8 (UK)	1985	Ultimate Play the Game
cpc_cass	Amstrad CPC cassettes	bubbler	Bubbler (UK)	1987	Ultimate Play the Game
cpc_cass	Amstrad CPC cassettes	gunfrght	Gunfright (UK)	1985	Ultimate Play the Game
cpc_cass	Amstrad CPC cassettes	knightlru	Knight Lore (UK, Ultimate)	1984	Ultimate Play the Game
cpc_cass	Amstrad CPC cassettes	martnoid	Martianoids - The Game (UK)	1987	Ultimate Play the Game
cpc_cass	Amstrad CPC cassettes	nightshd	Nightshade (UK)	1985	Ultimate Play the Game
cpc_cass	Amstrad CPC cassettes	sabrewlf	Sabre Wulf (UK)	1985	Ultimate Play the Game
cpc_flop	Amstrad CPC disk images	alien8	Alien 8 (UK)	1985	Ultimate Play the Game
cpc_flop	Amstrad CPC disk images	alien8_t1	Alien 8 (UK, Trained)	1985	Ultimate Play the Game
cpc_flop	Amstrad CPC disk images	alien8_t1a	Alien 8 (UK, Trained, Alt)	1985	Ultimate Play the Game
cpc_flop	Amstrad CPC disk images	alien8_t2	Alien 8 (UK, Trained by CNGSOFT)	1985	Ultimate Play the Game
cpc_flop	Amstrad CPC disk images	alien8_t2a	Alien 8 (UK, Trained by CNGSOFT, Alt)	1985	Ultimate Play the Game
cpc_flop	Amstrad CPC disk images	alien8a	Alien 8 (UK, Alt)	1985	Ultimate Play the Game
cpc_flop	Amstrad CPC disk images	bubbler	Bubbler (UK)	1987	Ultimate Play The Game
cpc_flop	Amstrad CPC disk images	bubbler_c1	Bubbler (UK, Cracked by CNGSOFT)	1987	Ultimate Play The Game
cpc_flop	Amstrad CPC disk images	bubbler_t1	Bubbler (UK, Trained)	1987	Ultimate Play The Game
cpc_flop	Amstrad CPC disk images	bubblera	Bubbler (UK, Alt)	1987	Ultimate Play The Game
cpc_flop	Amstrad CPC disk images	bubblerb	Bubbler (UK, Alt 2)	1987	Ultimate Play The Game
cpc_flop	Amstrad CPC disk images	bubblerc	Bubbler (UK, Alt 3)	1987	Ultimate Play The Game
cpc_flop	Amstrad CPC disk images	bubblerd	Bubbler (UK, Alt 4)	1987	Ultimate Play The Game
cpc_flop	Amstrad CPC disk images	bubblere	Bubbler (UK, Alt 5)	1987	Ultimate Play The Game
msx1_cass	MSX1 cassettes	alien8	Alien 8 (Europe)	1985	Ultimate Play The Game
msx1_cass	MSX1 cassettes	bubbler	Bubbler (Europe)	1987	Ultimate Play The Game
msx1_cass	MSX1 cassettes	cyberun	Cyberun (Europe)	1985	Ultimate Play The Game
msx1_cass	MSX1 cassettes	gunfrght	Gunfright (Europe)	1985	Ultimate Play The Game
msx1_cass	MSX1 cassettes	gunfrghta	Gunfright (Europe, alt)	1985	Ultimate Play The Game
msx1_cass	MSX1 cassettes	knightlr	Knight Lore (Europe)	1985	Ultimate Play The Game
msx1_cass	MSX1 cassettes	martian	Martianoids (Europe)	1987	Ultimate Play The Game
msx1_cass	MSX1 cassettes	nightshd	Nightshade (Europe)	1985	Ultimate Play The Game
msx1_cass	MSX1 cassettes	pentagrm	Pentagram (Europe)	1986	Ultimate Play The Game
specpls3_flop	Sinclair ZX Spectrum +3 disk images	ultimtcw	Ultimate Play The Game: The Collected Works	1988	Ultimate Play The Game
spectrum_cart	Sinclair ZX Spectrum cartridges	cookie	Cookie	1983	Ultimate Play the Game ~ Sinclair Research
spectrum_cart	Sinclair ZX Spectrum cartridges	jetpac	Jet Pac	1983	Ultimate Play the Game ~ Sinclair Research
spectrum_cart	Sinclair ZX Spectrum cartridges	pssst	Pssst	1983	Ultimate Play the Game ~ Sinclair Research
spectrum_cart	Sinclair ZX Spectrum cartridges	tranzam	Tranz Am	1983	Ultimate Play the Game ~ Sinclair Research
spectrum_cass	Sinclair ZX Spectrum cassettes	alien8	Alien 8 (Set 1)	1985	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	alien8a	Alien 8 (set 2)	1985	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	alien8b	Alien 8	1985	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	alien8r	Alien 8 (Ricochet)	1985	Ultimate / Ricochet
spectrum_cass	Sinclair ZX Spectrum cassettes	aticatac	Atic Atac	1983	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	bubbler	Bubbler	1987	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	cookie	Cookie	1983	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	cyberun	Cyberun	1986	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	gunfrigh	Gunfright	1986	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	jetpac	Jetpac	1983	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	kngtlore	Knight Lore (set 1)	1984	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	kngtlorea	Knight Lore (set 2)	1984	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	kngtloreb	Knight Lore (set 4)	1984	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	ljetman	Lunar Jetman	1983	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	martiano	Martianoids	1984	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	ngtshade	Nightshade	1985	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	ngtshader	Nightshade (Ricochet)	1985	Ultimate / Ricochet
spectrum_cass	Sinclair ZX Spectrum cassettes	pentgram	Pentagram	1986	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	pentgramr	Pentagram (Review Copy)	1986	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	pssst	Pssst	1983	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	sabrwlf	Sabre Wulf (version 2)	1984	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	sabrwlfa	Sabre Wulf (version 1)	1984	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	sabrwlfab	Sabre Wulf	1984	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	tranzam	Tranz Am	1983	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	ucw	Ultimate - The Collected Works (PSST, Cookie, Trans AM, Atic Atac, Jetpac, Lunar Jetman, Sabre Wulf, Knight Lore, Alien 8, Night Shade, Gun Fright)	19??	Ultimate Play The Game
spectrum_cass	Sinclair ZX Spectrum cassettes	underwur	Underwurlde (set 1)	1984	Ultimate Play The Game
svi318_cass	Spectravision SVI-318 cassettes	alien8	Alien 8 (MSX conversion)	1985	Ultimate Play the Game
svi318_cass	Spectravision SVI-318 cassettes	gunfrght	Gun Fright (MSX conversion)	1985	Ultimate Play The Game

Thats tab deleimeted you can copy and paste to Excel

[sam-ludlow]

You can build such queries in MS access

You can download the data here

https://mame.spludlow.co.uk/Data.aspx

[sam-ludlow]

Or you can do directly in MAME-AO with a DB command.

.dbs SELECT softwarelist.name, software.name, software.description, software.publisher FROM softwarelist INNER JOIN software ON softwarelist.softwarelist_id = software.softwarelist_id WHERE (software.publisher LIKE '%ultimate%')

[sam-ludlow]

Hmm seems there is a line length maximum for the console, so long commands don't work.

I may add a query & results table to the UI?