MultiNodeTreePicker DataType PreValues

Umbraco 7.4

select umbracoNode.text, CmsDataTypePreValues.alias, CmsDataTypePreValues.value 
from CmsDataType
inner join umbracoNode on umbracoNode.Id = cmsDataType.nodeId
inner join CmsDataTypePreValues on CmsDataType.NodeId = CmsDataTypePreValues.dataTypeNodeId
where propertyEditorAlias = 'Umbraco.MultiNodeTreePicker'
order by umbracoNode.text

Content with start item

startNode:

{
  "type": "content",
  "id": 1462
}

filter: null
minNumber: null
maxNumber: null
showOpenButton: 0
showEditButton: 0
showPathOnHover: 0

Content with filter

startNode:

{
  "type": "content",
  "query": "$parent/newsArticle"
}

filter: null
minNumber: null
maxNumber: null
showOpenButton: 0
showEditButton: 0
showPathOnHover: 0

Media with start node

startNode:

{
  "type": "media",
  "id": 1471
}

filter: null
minNumber: null
maxNumber: null
showOpenButton: 0
showEditButton: 0
showPathOnHover: 0

Umbraco 7.6 / 7.13

select umbracoNode.text, CmsDataTypePreValues.alias, CmsDataTypePreValues.value  
from CmsDataType
inner join umbracoNode on umbracoNode.Id = cmsDataType.nodeId
inner join CmsDataTypePreValues on CmsDataType.NodeId = CmsDataTypePreValues.dataTypeNodeId
where propertyEditorAlias = 'Umbraco.MultiNodeTreePicker2'
order by umbracoNode.text

Content with start item

startNode:

{
  "type": "content",
  "id": "umb://document/a91f6fead9024d78b422cf2290b18edd"
}

filter: null
minNumber: null
maxNumber: null
showOpenButton: 0

Content with filter

startNode:

{
  "type": "content",
  "query": "$parent/newsArticle"
}

filter: null
minNumber: null
maxNumber: null
showOpenButton: 0

Media with start node

startNode

{
  "type": "media",
  "id": "umb://media/14fde3c7c1794bb9ac4469feca3ad6ce"
}

filter: null
minNumber: null
maxNumber: null
showOpenButton: 0

Umbraco 8.0

v8 Doesn't use individual Pre Values anymore.
Json is all in one field, config, in the umbracoDataType table.

select umbracoNode.Text, umbracoDataType.* from umbracoDataType
inner Join UmbracoNode on UmbracoNode.Id = umbracoDataType.NodeId
where propertyEditorAlias = 'Umbraco.MultiNodeTreePicker'

Content with start item

{"startNode":{"type":"content","query":null,"id":"umb://document/89fc8a013df948eb9f38b39e68dd6329"},"filter":null,"minNumber":0,"maxNumber":0,"showOpenButton":false}

Content with filter

{"startNode":{"type":"content","query":"$parent/newsArticle","id":null},"filter":null,"minNumber":0,"maxNumber":0,"showOpenButton":false}

Media with start node

{"startNode":{"type":"media","query":null,"id":"umb://media/9b6862d936c74624ab27dfc4060ce6ac"},"filter":null,"minNumber":0,"maxNumber":0,"showOpenButton":false}