SELECT is_active FROM albums WHERE album_id = 3117;SELECT artist_id FROM rel_artist_album WHERE album_id = 3117 AND artist_id > 0 AND is_active = 1 ORDER BY artist_order ASC;SELECT album_name, is_sampler FROM albums WHERE album_id = '3117';SELECT aID, aName, aFName, aChar, aBanned, aLand FROM artist WHERE aid = '122';SELECT album_name, album_year, album_fullength, is_sampler, is_bootleg, is_live, is_boxset, is_compilation, is_movie, is_misc, is_demo, ratings_count, ratings_value, ratings_value_weighted, review_count, cover_id, 0 AS album_order FROM albums WHERE album_id = 3117;SELECT album_order FROM rel_artist_album WHERE album_id = 3117 AND artist_id = 122;SELECT aka_name FROM album_aka_names WHERE album_id = 3117;SELECT m.mID, m.lID, m.mEAN, m.mName, m.mTypeName, m.mYear, m.mLand, m.mCatalogNr, m.mAttributes, m.mOwnerId, m.sort_under, m.is_active, (SELECT l.lName FROM record_companies AS l WHERE l.lID = m.lID) AS lName FROM rel_album_media AS rma LEFT JOIN `medium` AS m ON m.mID = rma.medium_id WHERE rma.album_id = '3117' AND rma.is_active = 1 ORDER BY m.sort_under ASC, m.mYear ASC;SELECT medium_id, picture, width, height FROM medium_pictures WHERE medium_id IN (691417, 7044, 569413, 136133, 7937, 45146, 465103, 36652, 505662, 18044, 741462, 735428) AND cover = 1;SELECT a.album_id, a.album_name FROM albums AS a LEFT JOIN rel_artist_album AS raa ON raa.album_id = a.album_id WHERE a.is_sampler = 0 AND a.is_active = 1 AND raa.artist_id = 122 AND raa.album_order < 5 ORDER BY raa.album_order DESC LIMIT 0, 1SELECT a.album_id, a.album_name FROM albums AS a LEFT JOIN rel_artist_album AS raa ON raa.album_id = a.album_id WHERE a.is_sampler = 0 AND a.is_active = 1 AND raa.artist_id = 122 AND raa.album_order > 5 ORDER BY raa.album_order ASC LIMIT 0, 1SELECT main_genre_id, sub_genre_id FROM rel_album_genre WHERE album_id = '3117' ORDER BY main_genre_id ASC, sub_genre_id ASC;SELECT COUNT(review_id), rating FROM album_review WHERE album_id = 3117 GROUP BY rating ORDER BY rating ASC;SELECT ar.review_id, ar.user_id, ar.rating, DATE_FORMAT(ar.rating_time, '%d.%m.%Y %H:%i:%s') AS rtime, (SELECT u.uLogin FROM user AS u WHERE u.uID = ar.user_id) AS user_name FROM album_review AS ar WHERE album_id = 3117 ORDER BY review_id DESC LIMIT 10; Anathema: Eternity

Musik-Sammler.de

Die Musiksammlungs-Verwaltung im Internet

Künstlersuche

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
#

Position:

Home
Browse A
Anathema
Eternity

Hauptmenü

Login

[ Login-Daten vergessen? ]

Suche

Sonstiges

Folge Musik-Sammler.de:

Anathema

Eternity (1996)

Log dich ein, um ein Review zu verfassen.	Album:	Eternity
	Typ:	Album
	Album-ID:	3117
	Veröffentlichungsjahr:	1996
	Genre(s):	Metal: Gothic Metal, Doom Metal, Progressive Metal
	Zugeordnete Tonträger:	12
	Rating:	Durchschnittsnote: 9.04 Gewichteter Durchschnitt: 8.54 von 13 Abstimmungen

< vorheriges Album	nächstes Album >
Silent Enigma, The	Alternative 4
zurück zur kompletten Discographie

Neuen Tonträger für Album "Eternity" eintragen

Cover	Typ	Jahr	Land	EAN / Kat-Nr.	Plattenfirma	Besonderheiten
CDs
	CD	1996		EAN: 4988013654136 Kat.-Nr.: PCCY-01050	Peaceville Records
	CD	1996		EAN: 5020157106429 Kat.-Nr.: CDVILE 64	Peaceville Records
	CD	1996		EAN: 090861110024 Kat.-Nr.: 11100-2	Fierce Recordings
	Promo-CD	1996		EAN: Kat.-Nr.:	Peaceville Records	(Plastic PVC Sleeve)
	CD	1996		EAN: 5020157106405 Kat.-Nr.: CDXVILE 64	Peaceville Records	(Limited Edition, Digipack)
	CD	2000		EAN: 801056206428 Kat.-Nr.: CDVILEM 64 / 620642	Peaceville Records	(Re-Release 2000, Pappschuber)
	CD	2002		EAN: 4601250316222 Kat.-Nr.: CDVILEM 64 / 620642	Peaceville Records / Soyuz Music	(Re-Release 2002)
	CD	2003		EAN: 801056706423 Kat.-Nr.: CDVILED 64	Peaceville Records	(Re-Release 2003, Remastered, Digipack)
	CD	2003		EAN: 801056706423 Kat.-Nr.: CDVILED 64	Peaceville Records	(Re-Release 2003, Remastered)
Vinyl
	LP	1996		EAN: 5020157106412 Kat.-Nr.: VILE 64	Peaceville Records
	2-LP	2012	k.A.	EAN: 6430028552382 Kat.-Nr.: SVR038	Svart Records	(Limited Edition, Re-Release 2012, Special Edition, Gatefold)
	2-LP	2012	k.A.	EAN: 6430028552382 Kat.-Nr.: SVR038	Svart Records	(Limited Edition, Re-Release 2012, Gatefold, Marbled Vinyl, Weißes Vinyl)

Punktverteilung
0.5	1	1.5	2	2.5	3	3.5	4	4.5	5	5.5	6	6.5	7	7.5	8	8.5	9	9.5	10
(ein evtl. vorhandener roter Balken markiert dein abgegebenes Rating)

0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	2	3	3	3