User:Alex Cohn/missing P436

From Wikidata
Jump to navigation Jump to search

This is a list of every item representing a release group (Q108346082) (or a child of a release group) that has a performer (P175) with a MusicBrainz artist ID (P434), but is missing a MusicBrainz release group ID (P436). Given that MusicBrainz's notability policy is substantially more lax than ours, this query should return no results.

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT ?item ?mbaurl WHERE { wd:P434 wdt:P1630 ?formatterurl. ?item (wdt:P31/(wdt:P279*)) wd:Q108346082; (wdt:P175/wdt:P434) ?mba. MINUS { ?item wdt:P436 ?mbrg. } MINUS { ?item (wdt:P31/(wdt:P279*)) wd:Q134556. } MINUS { ?item wdt:P5813 ?mbre. } MINUS { ?item wdt:P175 wd:Q3108914. } MINUS { ?item wdt:P31 wd:Q59557805. } MINUS { ?item (wdt:P31/(wdt:P279*)) wd:Q20671381. } BIND(IRI(REPLACE(?mba, "^(.+)$", ?formatterurl)) AS ?mbaurl) } LIMIT 100
number item ?mbaurl description
1 10 Years of Revolutionary Rock and Roll https://musicbrainz.org/artist/3fec8b00-4142-4129-96f5-1c9bf65e8e8f video album
2 Abominable Dr. Phibes/American Psycho https://musicbrainz.org/artist/936addc3-91aa-49de-8ec0-0dc186de151f video album
3 All About Girls' Generation: Paradise in Phuket https://musicbrainz.org/artist/b7442f18-d9be-4185-8b51-482510046156 video album
4 All the Best https://musicbrainz.org/artist/00ed154e-8679-42f0-8f42-e59bd7e185af 2007 Zucchero Fornaciari video album
5 Alla mia età Live in Rome https://musicbrainz.org/artist/d12b05b0-a0af-4c2c-8c8c-ab8bcf49439e 2009 Tiziano Ferro video album
6 An Audience with Elton John https://musicbrainz.org/artist/b83bc61f-8451-4a5d-8b8e-7e9ed295e822 video album
7 Anniversary Waltz https://musicbrainz.org/artist/14cbab34-00dc-4c3b-97f1-71ef21618735
https://musicbrainz.org/artist/1884ed9c-6fe1-468d-a7f8-8d19c9c4e441 		video album
8 Anthology https://musicbrainz.org/artist/50698127-f6f4-4c0c-8010-db98c21100e1 Bruce Dickinson DVD
9 Aoi Yoru Complete Edition https://musicbrainz.org/artist/3f77449d-48e4-4ceb-b869-69af48da877b video album
10 Are You Ready for Love https://musicbrainz.org/artist/b83bc61f-8451-4a5d-8b8e-7e9ed295e822 video album
11 Art of Life 1993.12.31 Tokyo Dome https://musicbrainz.org/artist/3f77449d-48e4-4ceb-b869-69af48da877b 2003 concert video by X Japan
12 Back to Black (in Video) https://musicbrainz.org/artist/dfe9a7c4-8cf2-47f4-9dcb-d233c2b86ec3 2008 music video compilation album by Amy Winehouse
13 Beastie Boys Video Anthology https://musicbrainz.org/artist/9beb62b2-88db-4cea-801e-162cd344ee53 2000 film
14 Beat 'Em All https://musicbrainz.org/artist/9876cc18-e3c4-487a-b330-e67b08eee2b2 video album
15 Beyond the Beginning https://musicbrainz.org/artist/ad996aef-cc1c-42ac-af5c-619c370f4b8a video album by Emerson, Lake & Palmer
16 Black Sabbath – Rock Review https://musicbrainz.org/artist/5182c1d9-c7d2-4dad-afa0-ccfeada921a8 2005 video album by Black Sabbath
17 Black Sabbath's Paranoid https://musicbrainz.org/artist/5182c1d9-c7d2-4dad-afa0-ccfeada921a8 2005 video album by Black Sabbath
18 Blood, Sweat & Beers! https://musicbrainz.org/artist/4df5d35b-a9d4-4d4f-91f6-bae55693de31 video album
19 Blue https://musicbrainz.org/artist/83d8a06a-4145-444a-b4ae-49e1e986206f 2005 video album by The Birthday Massacre
20 Bump 'n' Grind https://musicbrainz.org/artist/c2fe2272-16af-402e-a68b-400b8984095b video album
21 Bye bye Patty - Patty Pravo Live al Piper https://musicbrainz.org/artist/0ac1c730-8510-4ee8-9fcb-5ad272da73ab video album
22 Campovolo https://musicbrainz.org/artist/d5b0dc28-2f22-4f7d-adfb-ebbc30fa6d48 video album
23 Cento giorni verso est... https://musicbrainz.org/artist/e68a900e-4fae-493a-84a8-f76ab62d23e4 video album
24 Church of Tiamat https://musicbrainz.org/artist/8930ec4e-51c7-4905-ac40-684459878085 video album
25 Circola un video su di me... https://musicbrainz.org/artist/0ac1c730-8510-4ee8-9fcb-5ad272da73ab video album
26 Classic Albums: Def Leppard – Hysteria https://musicbrainz.org/artist/7249b899-8db8-43e7-9e6e-22f1e736024e video album
27 Classic Albums: Duran Duran - Rio https://musicbrainz.org/artist/1a1cd7f3-e5df-4eca-bae2-2757c9e656b5 video album
28 Classic Albums: Elton John - Goodbye Yellow Brick Road https://musicbrainz.org/artist/b83bc61f-8451-4a5d-8b8e-7e9ed295e822 video album
29 Classic Albums: The Doors - The Doors https://musicbrainz.org/artist/9efff43b-3b29-4082-824e-bc82f646f93d video album
30 Classic Albums: U2 - The Joshua Tree https://musicbrainz.org/artist/a3cb23fc-acd3-4ce0-8f36-1e5aa6a18432 video album
31 Crazy Nights https://musicbrainz.org/artist/e1f1e33e-2e4c-4d43-b91b-7064068d3283 1988 video album by Kiss
32 Croce e delizia https://musicbrainz.org/artist/e68a900e-4fae-493a-84a8-f76ab62d23e4 1998 video album of the Italian rock band Litfiba
33 Céline sur les Plaines https://musicbrainz.org/artist/847e8a0c-cc20-4213-9e16-975515c2a926 2008 live album by Celine Dion
34 Dahlia Tour Final 1996 https://musicbrainz.org/artist/3f77449d-48e4-4ceb-b869-69af48da877b 1997 concert video by X Japan
35 Dentro Faber https://musicbrainz.org/artist/204db5a8-78f1-4078-801f-ae8f456eeb60 2011 video album by Fabrizio De André
36 Destiny Rules https://musicbrainz.org/artist/bd13909f-1c29-4c27-a874-d4aaf27c5b1a video album
37 Deuce https://musicbrainz.org/artist/ac865b2e-bba8-4f5a-8756-dd40d5e39f46 2002 DVD by Korn
38 Di palo in sesto https://musicbrainz.org/artist/a073ff49-6ccd-48e9-aadb-eadde45f94f4 2009 video album by Oblivion
39 Diario Carboni https://musicbrainz.org/artist/25ef3049-9199-4b30-9029-ec02f3b7c7c3 1993 live video album by Luca Carboni
40 Due anni di concerti https://musicbrainz.org/artist/19bad456-68df-4be4-a8f3-c016b11799e1 2004 video album, concert film by Fiorella Mannoia
41 Echoes of Fission City https://musicbrainz.org/artist/446caf73-83fa-481e-a65c-e9cffbf16be2 2009 split album by Roncsipar / Drone'osh Tot
42 El diablo Tour https://musicbrainz.org/artist/e68a900e-4fae-493a-84a8-f76ab62d23e4 video album
43 Elton in 2003 the Official DVD https://musicbrainz.org/artist/b83bc61f-8451-4a5d-8b8e-7e9ed295e822 video album
44 En V.O. https://musicbrainz.org/artist/323ed974-8bf6-4f54-9525-b774a659f805 1984 mini-album album by Johnny Hallyday
45 Exposed https://musicbrainz.org/artist/a1684a49-feaa-4150-b758-d9412fc59f12 2005 video by Mike Oldfield
46 Familiar to Millions https://musicbrainz.org/artist/39ab1aed-75e0-4140-bd47-540276886b60 video album
47 Famous in the Last Century https://musicbrainz.org/artist/14cbab34-00dc-4c3b-97f1-71ef21618735
https://musicbrainz.org/artist/1884ed9c-6fe1-468d-a7f8-8d19c9c4e441 		video album
48 Fat, Ugly and Still Alive https://musicbrainz.org/artist/619ce797-ddb3-4411-9e42-30eafe2ca5ec video album
49 First Blood Last Visions https://musicbrainz.org/artist/171cbc8f-8ab3-4aec-9916-f0bdbe26bb79 video album
50 Fronte del palco live 90 https://musicbrainz.org/artist/3bf74908-e8b3-4158-8fae-4fd795bb4474 video album
51 Fuori come va? Tour - Roma stadio Olimpico https://musicbrainz.org/artist/d5b0dc28-2f22-4f7d-adfb-ebbc30fa6d48 2003 video album
52 Genesis The Movie Box https://musicbrainz.org/artist/8e3fcd7d-bda1-4ca0-b987-b8528d2ee74e 2009 live DVD box set by Genesis
53 Girls on Film https://musicbrainz.org/artist/a0b2f210-cd3a-453d-937d-e4f2658d17c7 2005 video album by Girls Aloud
54 Girls' Generation Complete Video Collection https://musicbrainz.org/artist/b7442f18-d9be-4185-8b51-482510046156 2012 music video compilation by Girls' Generation
55 Gli anni Video LP https://musicbrainz.org/artist/618170ad-4957-4b7b-a3b0-489917be18d3 video album
56 Greatest: The Videos https://musicbrainz.org/artist/1a1cd7f3-e5df-4eca-bae2-2757c9e656b5 video album
57 Hell on Earth https://musicbrainz.org/artist/00eeed6b-5897-4359-8347-b8cd28375331 video album
58 Hell on Earth Part III https://musicbrainz.org/artist/00eeed6b-5897-4359-8347-b8cd28375331 video album
59 Hell on Earth Part IV https://musicbrainz.org/artist/00eeed6b-5897-4359-8347-b8cd28375331 video album
60 Highlights https://musicbrainz.org/artist/be540c02-7898-4b79-9acc-c8122c7d9e83 1990 video album by Pet Shop Boys
61 Hilary Duff: Live At Gibson Amphitheatre - August 15th, 2007 https://musicbrainz.org/artist/bfaf9b70-d1fd-4d3e-b730-3e67e6f8f9bb 2010 concert DVD by Hilary Duff
62 Il suono delle idee... 1963 - 1993 https://musicbrainz.org/artist/48fe77c4-cb39-4316-85e9-30669f317935 video album
63 In Concert - Mirage Tour '82 https://musicbrainz.org/artist/bd13909f-1c29-4c27-a874-d4aaf27c5b1a video album
64 In Their Own Words https://musicbrainz.org/artist/5182c1d9-c7d2-4dad-afa0-ccfeada921a8 2007 video album by Black Sabbath
65 Inside Black Sabbath – 1970–1992 https://musicbrainz.org/artist/5182c1d9-c7d2-4dad-afa0-ccfeada921a8 2003 live video album by Black Sabbath
66 Just Doin' It! Live https://musicbrainz.org/artist/14cbab34-00dc-4c3b-97f1-71ef21618735
https://musicbrainz.org/artist/1884ed9c-6fe1-468d-a7f8-8d19c9c4e441 		video album
67 Kajagoogoo Video EP https://musicbrainz.org/artist/7bc51021-6a84-4a04-ada3-0541615a97bc video album
68 Kiss Konfidential https://musicbrainz.org/artist/e1f1e33e-2e4c-4d43-b91b-7064068d3283 1993 live video album by Kiss
69 Kiss Symphony: The DVD https://musicbrainz.org/artist/e1f1e33e-2e4c-4d43-b91b-7064068d3283 2003 concert DVD by Kiss
70 Kiss Unplugged https://musicbrainz.org/artist/e1f1e33e-2e4c-4d43-b91b-7064068d3283 1996 video album
71 L'imperfetto https://musicbrainz.org/artist/5d2e11a9-08cf-4f43-993a-be5dc908e5d6 1994 live video album by Renato Zero
72 La donna il sogno & gli altri video https://musicbrainz.org/artist/618170ad-4957-4b7b-a3b0-489917be18d3 video album
73 Mano Negra: Out of time https://musicbrainz.org/artist/e024a3ca-c78e-459a-9a98-8029f49b5a5f 2005 double DVD by Mano Negra
74 Mariza & Duarte : Fado Today https://musicbrainz.org/artist/8cbb4d57-f44d-433a-90bf-a0892af886e1
https://musicbrainz.org/artist/3d4218a9-51a3-4108-887f-08827d5a25bb 		2004 unofficial video album by Mariza and Aldina Duarte
75 Nana Clips 1 https://musicbrainz.org/artist/a80b9231-3a25-44d3-bb3d-55526d8b278d 2003 DVD by Nana Mizuki
76 Nana Clips 3 https://musicbrainz.org/artist/a80b9231-3a25-44d3-bb3d-55526d8b278d 2006 DVD by Nana Mizuki
77 Never Trust a DVD ! https://musicbrainz.org/artist/46c6a335-6064-4118-8021-83fb37b1bc6a 2004 concert DVD by Les Wampas
78 Phase Two: Slowboat to Hades https://musicbrainz.org/artist/e21857d5-3256-4547-afb3-4b6ded592596 2006 video album by Gorillaz
79 Picture Show https://musicbrainz.org/artist/69ee3720-a7cb-4402-b48d-a02c366f2bcf 1991 video album directed by Tim Pope
80 Plein de vie https://musicbrainz.org/artist/5cad62bb-d08e-4ed7-9b22-7c2026587fc4 2004 concert DVD by Cali
81 Raoul Petite Live https://musicbrainz.org/artist/6e72f74b-0835-41b6-8a27-4a7b1184fb04 2007 live DVD by Raoul Petite
82 Raw Live https://musicbrainz.org/artist/8fa5d80d-37e8-4133-9d5c-6bad446c63f0 2010 live video album by Yngwie Malmsteen
83 Sanctuary - The EIS Christmas Concert 2002 https://musicbrainz.org/artist/43b58c98-3779-4b04-9a23-1c95cca3a145 2003 concert DVD by Erasure
84 Show https://musicbrainz.org/artist/69ee3720-a7cb-4402-b48d-a02c366f2bcf 1993 concert video by The Cure
85 Staring at the Sea - The Images https://musicbrainz.org/artist/69ee3720-a7cb-4402-b48d-a02c366f2bcf 1986 video album directed by Tim Pope
86 Tea Party https://musicbrainz.org/artist/69ee3720-a7cb-4402-b48d-a02c366f2bcf 1985 music video compilation album by The Cure
87 The Black Sabbath Story, Vol. 2 https://musicbrainz.org/artist/5182c1d9-c7d2-4dad-afa0-ccfeada921a8 1992 video album by Black Sabbath
88 The Cure Play Out https://musicbrainz.org/artist/69ee3720-a7cb-4402-b48d-a02c366f2bcf video album
89 The Essential Mike Oldfield https://musicbrainz.org/artist/a1684a49-feaa-4150-b758-d9412fc59f12 1980 concert video by Mike Oldfield
90 The Mama Tour https://musicbrainz.org/artist/8e3fcd7d-bda1-4ca0-b987-b8528d2ee74e 1984 concert video by Genesis
91 The Tank, the Swan & the Balloon https://musicbrainz.org/artist/43b58c98-3779-4b04-9a23-1c95cca3a145 1993 concert video by Erasure
92 The Video Show https://musicbrainz.org/artist/8e3fcd7d-bda1-4ca0-b987-b8528d2ee74e 2004 DVD compilation by Genesis
93 The Wailers Live https://musicbrainz.org/artist/1e46801d-c27b-4f07-a50d-51597a26df60 concert DVD by The Wailers Band
94 The Wind Chimes https://musicbrainz.org/artist/a1684a49-feaa-4150-b758-d9412fc59f12 1988 video by Mike Oldfield
95 Tiny Tour https://musicbrainz.org/artist/43b58c98-3779-4b04-9a23-1c95cca3a145 1998 concert video by Erasure
96 XXV Gathering! - The Band that Preys Together Stays Together https://musicbrainz.org/artist/f5aca88c-e3c1-4bc2-af33-68a9a9f7b56a 2005 concert DVD by Killing Joke

∑ 96 items.

End of automatically generated list.
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Alex_Cohn/missing_P436&oldid=2151683669"