SELECT Program.Numero,Program.Title,Program.Notes_E,Program.Notes_F,Program.NoMaster,Master.FirstName,Master.LastName,; MasterType.Title_E AS MasterType_E,MasterType.Title_F AS MasterType_F,Program4.VideoNumero,Video.Url; FROM Program; INNER JOIN; (SELECT Program2.Numero,MIN(Video2.Numero) AS VideoNumero FROM Program AS Program2 ; INNER JOIN Video AS Video2 ON Program2.Numero=Video2.NoProgram; WHERE Program2.Active AND Program2.Numero IN; (SELECT Program3.Numero FROM Program Program3; INNER JOIN Video AS Video3 ON Program3.Numero=Video3.NoProgram; INNER JOIN InvoiceI ON Video3.Numero=InvoiceI.NoVideo; INNER JOIN Invoice ON InvoiceI.NoInvoice=Invoice.Numero AND Invoice.AddUser=?); GROUP BY Program2.Numero) Program4 ON Program4.Numero=Program.Numero; INNER JOIN Master ON Program.NoMaster=Master.Numero; INNER JOIN MasterType ON Master.NoMasterT=MasterType.Numero; INNER JOIN Video ON Program4.VideoNumero=Video.Numero; ORDER BY 2