SELECT * FROM itemVariations WHERE ItemVariationID = :ID AND Flag != 'deleted' LIMIT 1