SELECT DISTINCT c.ID AS ID, c.ID AS CarrierID, c.Title AS CarrierTitle, c.VersionInfo AS CarrierVersionInfo, YEAR(c.ReleaseDate) AS CarrierReleaseYear, c.Concept AS ConceptID, cf.Name AS Format, p.ID AS PhonogramID, p.Title AS PhonogramTitle, p.VersionInfo AS PhonogramVersionInfo, p.RecordingYear AS PhonogramRecordingYear FROM carriers c LEFT JOIN carrierformats cf ON c.Format=cf.ID INNER JOIN carrierphonograms cp ON cp.CarrierID=c.ID INNER JOIN phonograms p ON cp.PhonogramID=p.ID INNER JOIN phonogrammembers pm ON pm.PhonogramID=p.ID INNER JOIN phonogrammainartists pma ON pma.PhonogramID=p.ID INNER JOIN identities i ON pma.IdentityID=i.ID WHERE (pm.IdentityID=119878) AND (c.Hidden = 0) AND ((c.Filter & 1)=1) AND (i.ID=7676) ORDER BY p.Title, p.ID, c.Title, CarrierReleaseYear

#0  Fmcr->query(SELECT DISTINCT c.ID AS ID, c.ID AS CarrierID, c.Title AS CarrierTitle, c.VersionInfo AS CarrierVersionInfo, YEAR(c.ReleaseDate) AS CarrierReleaseYear, c.Concept AS ConceptID, cf.Name AS Format, p.ID AS PhonogramID, p.Title AS PhonogramTitle, p.VersionInfo AS PhonogramVersionInfo, p.RecordingYear AS PhonogramRecordingYear
FROM carriers c
LEFT JOIN carrierformats cf ON c.Format=cf.ID
INNER JOIN carrierphonograms cp ON cp.CarrierID=c.ID
INNER JOIN phonograms p ON cp.PhonogramID=p.ID
INNER JOIN phonogrammembers pm ON pm.PhonogramID=p.ID
INNER JOIN phonogrammainartists pma ON pma.PhonogramID=p.ID
INNER JOIN identities i ON pma.IdentityID=i.ID
WHERE (pm.IdentityID=119878) AND (c.Hidden = 0) AND ((c.Filter & 1)=1) AND (i.ID=7676) ORDER BY p.Title, p.ID, c.Title, CarrierReleaseYear) called at [/var/www/html/muziekcentrum/muziekarchief.be/memberalbums.php:313]