1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| SELECT DISTINCT Factory.idPrincipal, Factory.FactoryName, Factory.Country, Product.ModelName,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 57 AND ProductBeingProcessed.idProduct=Product.idProduct) AS AKL,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 57 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink0,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 2 AND ProductBeingProcessed.idProduct=Product.idProduct) AS IPAK,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 2 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink1,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 4 AND ProductBeingProcessed.idProduct=Product.idProduct) AS EC_Certificate,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 4 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink2,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 5 AND ProductBeingProcessed.idProduct=Product.idProduct) AS Certificate_of_conformity,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 5 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink3,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 9 AND ProductBeingProcessed.idProduct=Product.idProduct) AS Brochure,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 9 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink4,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 13 AND ProductBeingProcessed.idProduct=Product.idProduct) AS Manual,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 13 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink5,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 23 AND ProductBeingProcessed.idProduct=Product.idProduct) AS SIUP_or_SIUT,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 23 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink6,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 24 AND ProductBeingProcessed.idProduct=Product.idProduct) AS TDP,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 24 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink7,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 25 AND ProductBeingProcessed.idProduct=Product.idProduct) AS Deed_of_establishment,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 25 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink8,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 31 AND ProductBeingProcessed.idProduct=Product.idProduct) AS Certificate_of_company,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 31 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink9,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 58 AND ProductBeingProcessed.idProduct=Product.idProduct) AS Company_domicile_letter,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 58 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink10,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 59 AND ProductBeingProcessed.idProduct=Product.idProduct) AS Group_of_companies,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 59 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink11,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 60 AND ProductBeingProcessed.idProduct=Product.idProduct) AS Tax_letter,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 60 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink12,
(SELECT ValidDate FROM ProductBeingProcessed WHERE idProductDocumentType = 61 AND ProductBeingProcessed.idProduct=Product.idProduct) AS Tax_register_number,
(SELECT LinkedFile FROM ProductBeingProcessed WHERE idProductDocumentType = 61 AND ProductBeingProcessed.idProduct=Product.idProduct) AS FileLink13,
FROM Factory INNER JOIN Product ON Factory.idFactory = Product.idFactory; |
Partager