Wikidata:WikiProject sum of all paintings/Top material combinations

This is an overview of the top material combinations (by number of paintings) of the sum of all paintings. See also the made from material documentation and the top materials.

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

SELECT ?item ?paint ?surface (COUNT(?item) AS ?count) WHERE {   ?painting wdt:P31 wd:Q3305213;             p:P186 ?paintstatement ;             p:P186 ?surfacestatement .   ?paintstatement ps:P186 ?paint .   ?paint wdt:P279* wd:Q174219 .   ?surfacestatement ps:P186 ?surface ;                     pq:P518 wd:Q861259 .   BIND(    IRI(       CONCAT(         "http://www.wikidata.org/entity/Q", STR(           xsd:integer(             SUBSTR(               STR(?paint), STRLEN("http://www.wikidata.org/entity/Q")+1             )           )*10000000 + xsd:integer(             SUBSTR(               STR(?surface),STRLEN("http://www.wikidata.org/entity/Q")+1)           )         )         )         ) AS ?item        ) } GROUP BY ?item ?paint ?surface ORDER BY DESC (?count) LIMIT 50

Paint	Painting surface	count
oil paint	canvas	425590
oil paint	panel	75293
oil paint	cardboard	12669
acrylic paint	canvas	6302
oil paint	paper	5726
oil paint	oak panel	5094
oil paint	copper	4608
watercolor paint	paper	3640
tempera	panel	3490
acrylic paint	paper	1245
tempera	canvas	1197
paint	canvas	1195
paint	panel	1033
tempera	paper	933
paint	poplar panel	585
tempera	cardboard	472
oil paint	poplar panel	307
watercolor paint	cardboard	285
gouache paint	paper	279
gouache paint	cardboard	245
watercolor paint	postcard	245
tempera	poplar panel	234
oil paint	paperboard	227
watercolor paint	ivory	199
oil paint	cardboard	197
oil paint	wood	194
oil paint	lime panel	177
acrylic paint	panel	156
paint	oak panel	142
paint	lime panel	140
tempera	oak panel	125
oil paint	plywood	112
oil paint	copper leaf	110
oil paint	pine panel	103
oil paint	canvas board	87
gouache paint	canvas	86
paint	fir panel	80
acrylic paint	cardboard	74
watercolor paint	vellum	72
oil paint	tin	70
paint	copper	64
distemper	canvas	60
oil paint	masonite	54
oil paint	fiberboard	52
oil paint	mahogany wood	49
watercolor paint	canvas	49
gouache paint	ivory	44
oil paint	linen	41
oil paint	fir panel	39
oil paint	sheet metal	37

End of automatically generated list.