SELECT DISTINCT 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 phonogrammainartists cma ON cma.PhonogramID=p.ID INNER JOIN identities i ON cma.IdentityID=i.ID WHERE (p.WorkID IN (449439,449441,449444,449445,449446,449447,449448,449578,665030,449580,449582,449584,449794,449796,449975,548817,632595,665022,712990,450663,450664,450665,450666,450667,451035,665006,451036,665009,451037,665011,451038,665002,451039,665001,451040,665008,451041,451042,665010,451043,665005,451089,451212,664329,451304,665004,451325,451590,664337,451600,664333,451605,664334,451606,664335,451610,664338,451624,451800,451957,451969,452289,452295,452297,452298,452299,676371,452300,452301,452302,711410,452601,452606,452779,452886,453199,453218,665023,453220,665024,453225,665025,453230,453232,453234,453235,453236,453242,453243,453245,453247,453248,548818,453249,453250,538720,453251,453252,453254,453255,453258,453261,453264,453265,453267,453268,453270,453272,453274,632594,453275,453276,453277,453280,453429,632593,671776,682378,453433,665028,453434,665026,453445,453474,632598,453475,453476,453477,453479,453480,453484,453485,670984,453486,453487,453488,632590,665029,453489,682371,454156,695521,454554,454577,669623,669639,455589,455686,455687,455711,665003,455719,455932,457155,669618,457159,669622,457161,669619,698043,457163,669620,457165,669624,457166,669628,457169,669631,457172,669626,457174,669630,457176,669632,457180,669633,458505,718108,458507,458508,459198,459226,669621,459238,459242,459251,461629,465986,466007,466016,466028,466039,466056,466068,466074,466083,466090,466095,466103,466119,466126,466132,466151,468927,669625,468928,471755,473030,473038,473122,473226,473227,473376,473432,473469,473482,473834,474819,475320,477721,490648,664796,491325,495838,507681,518113,532696,709233,538739,540375,542248,547910,548310,664738,548796,548797,548798,548799,548800,548801,548802,548803,548804,548805,548806,548807,548808,548809,548810,548811,548812,548813,548815,548819,669629,548822,548825,665094,548826,549247,665281,550315,550316,550317,552953,552954,552956,552957,552958,562419,665007,567004,567009,567033,567036,567049,567055,567058,567061,567064,567067,567071,567075,567084,567104,567108,567113,567123,567125,568196,568381,568382,568383,568384,568385,665027,576417,576452,576457,585612,585613,585614,587005,632589,592018,595486,669627,601453,670958,605698,605844,609031,609093,609164,612790,612791,612951,615547,615548,615549,615550,615551,615552,615553,615554,615555,615556,615557,615558,615559,615560,615561,615562,615567,615886,616582,616733,623421,632591,632592,632596,632597,632607,632608,632609,632610,634690,635009,635066,637196,664055,637204,639084,640717,679690,642626,642627,643979,643980,643981,643982,643983,643984,643985,643986,643987,643988,643989,643990,655685,682925,682926,683867,694431,694432,694433,694434,694435,694436,694437,694438,694439,696138,696139,697923,697924,700991,700992,709316,709318,712989,718856,719034,725273,727869,727870,727871,727872,736097,736098,745053,745054,745055,745056,745057,745058,745059,745060,745061,745062,745063,745064,745065)) AND (c.Hidden = 0) AND ((c.Filter & 1)=1) AND (i.ID=132464) ORDER BY p.Title, p.ID, c.Title, CarrierReleaseYear

#0  Fmcr->query(SELECT DISTINCT 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 phonogrammainartists cma ON cma.PhonogramID=p.ID
	INNER JOIN identities i ON cma.IdentityID=i.ID
	WHERE (p.WorkID IN (449439,449441,449444,449445,449446,449447,449448,449578,665030,449580,449582,449584,449794,449796,449975,548817,632595,665022,712990,450663,450664,450665,450666,450667,451035,665006,451036,665009,451037,665011,451038,665002,451039,665001,451040,665008,451041,451042,665010,451043,665005,451089,451212,664329,451304,665004,451325,451590,664337,451600,664333,451605,664334,451606,664335,451610,664338,451624,451800,451957,451969,452289,452295,452297,452298,452299,676371,452300,452301,452302,711410,452601,452606,452779,452886,453199,453218,665023,453220,665024,453225,665025,453230,453232,453234,453235,453236,453242,453243,453245,453247,453248,548818,453249,453250,538720,453251,453252,453254,453255,453258,453261,453264,453265,453267,453268,453270,453272,453274,632594,453275,453276,453277,453280,453429,632593,671776,682378,453433,665028,453434,665026,453445,453474,632598,453475,453476,453477,453479,453480,453484,453485,670984,453486,453487,453488,632590,665029,453489,682371,454156,695521,454554,454577,669623,669639,455589,455686,455687,455711,665003,455719,455932,457155,669618,457159,669622,457161,669619,698043,457163,669620,457165,669624,457166,669628,457169,669631,457172,669626,457174,669630,457176,669632,457180,669633,458505,718108,458507,458508,459198,459226,669621,459238,459242,459251,461629,465986,466007,466016,466028,466039,466056,466068,466074,466083,466090,466095,466103,466119,466126,466132,466151,468927,669625,468928,471755,473030,473038,473122,473226,473227,473376,473432,473469,473482,473834,474819,475320,477721,490648,664796,491325,495838,507681,518113,532696,709233,538739,540375,542248,547910,548310,664738,548796,548797,548798,548799,548800,548801,548802,548803,548804,548805,548806,548807,548808,548809,548810,548811,548812,548813,548815,548819,669629,548822,548825,665094,548826,549247,665281,550315,550316,550317,552953,552954,552956,552957,552958,562419,665007,567004,567009,567033,567036,567049,567055,567058,567061,567064,567067,567071,567075,567084,567104,567108,567113,567123,567125,568196,568381,568382,568383,568384,568385,665027,576417,576452,576457,585612,585613,585614,587005,632589,592018,595486,669627,601453,670958,605698,605844,609031,609093,609164,612790,612791,612951,615547,615548,615549,615550,615551,615552,615553,615554,615555,615556,615557,615558,615559,615560,615561,615562,615567,615886,616582,616733,623421,632591,632592,632596,632597,632607,632608,632609,632610,634690,635009,635066,637196,664055,637204,639084,640717,679690,642626,642627,643979,643980,643981,643982,643983,643984,643985,643986,643987,643988,643989,643990,655685,682925,682926,683867,694431,694432,694433,694434,694435,694436,694437,694438,694439,696138,696139,697923,697924,700991,700992,709316,709318,712989,718856,719034,725273,727869,727870,727871,727872,736097,736098,745053,745054,745055,745056,745057,745058,745059,745060,745061,745062,745063,745064,745065)) AND (c.Hidden = 0) AND ((c.Filter & 1)=1) AND (i.ID=132464) ORDER BY p.Title, p.ID, c.Title, CarrierReleaseYear) called at [/var/www/html/muziekcentrum/muziekarchief.be/authoralbums.php:344]