SELECT
        N_Item.id,
        N_Item.Description,
        N_Item.UnitPrice,
        G_LItemEntry_0.sQuantity
    FROM
        G_LItemEntry_0
        INNER JOIN N_Item ON
            N_Item.Id = G_LItemEntry_0.fItem_Id AND
            N_Item.Comp_Id = G_LItemEntry_0.fComp_Id
    WHERE
        G_LItemEntry_0.SLevel = 2 AND
        G_LItemEntry_0.sQuantity > 0 AND
        N_Item.ProductClass_Id IN ('TYRE', '40 GOODRIDE') AND
        N_Item.id = 'MICHELIN 195/65 R15 91H PRIMACY4'



    SELECT
        N_Item.id,
        N_Item.Description,
        N_Item.UnitPrice,
        G_LItemEntry_0.sQuantity
    FROM
        G_LItemEntry_0
        INNER JOIN N_Item ON
            N_Item.Id = G_LItemEntry_0.fItem_Id AND
            N_Item.Comp_Id = G_LItemEntry_0.fComp_Id
    WHERE
        G_LItemEntry_0.SLevel = 2 AND
        G_LItemEntry_0.sQuantity > 0 AND
        N_Item.ProductClass_Id IN ('TYRE', '40 GOODRIDE') AND
        N_Item.id = 'MICHELIN 195/65 R15 91H PRIMACY4'