File:Semantic properties for 2013.png

Graph shows the number of semantic properties stored in Semantic MediaWiki sites (running 1.8+ of Semantic MediaWiki) that WikiApiary is monitoring.

Query to get this data is:

SELECT tbl.my_date, SUM(tbl.propcount) FROM (	SELECT		website_id,		YEARWEEK(`capture_date`) as my_date,		MAX(`propcount`) as propcount	FROM		`smwinfo`	GROUP BY	website_id, YEARWEEK(`capture_date`)	) AS tbl GROUP BY tbl.my_date