SELECT
	 da.name
	, da.publication
	, ma.article
	, ds.UndelivCmdsInDistDB
	, ds.delivCmdsInDistDB 
FROM dbo.MSdistribution_status DS 
	INNER JOIN dbo.msdistribution_agents da ON da.id = ds.agent_id
	INNER JOIN dbo.msarticles ma ON ma.publisher_id = da.publisher_id and ma.article_id = ds.article_id
ORDER BY   
		UndelivCmdsInDistDB DESC
		,publication