Seuraavilla skripteillä voit tarkistaa onko joku väri käytössä, ja jos on niin missä artikkeleissa ja väriryhmissä.

SELECT  col.Id as Color_Id,
        tr.Text as Color_Name,
        StructureBase.Id as Article_Id,
        StructureBase.Code as Article_Code
    FROM Translations tr, Color col
    JOIN Article_Color ac
        ON col.Id = ac.Colors_Id
    JOIN StructureBase
        ON ac.Articles_Id = StructureBase.Id
    WHERE tr.TranslationColor_Translation_Id = col.Id and 
    tr.Text = '010 Lakattu'

SELECT  col.Id as Color_Id,
        tr.Text as Color_Name,
        ColorGroup.Id as ColorGroup_Id,
        ColorGroup.Name as ColorGroup_Name
    FROM Translations tr, Color col
    JOIN ColorGroup_Color
        ON col.Id = ColorGroup_Color.Colors_Id
    JOIN ColorGroup
        ON ColorGroup_Color.ColorGroups_Id = ColorGroup.Id
    WHERE tr.TranslationColor_Translation_Id = col.Id and
     tr.Text = '010 Lakattu'