Select image items from Sitecore Media Library via SQL.

Sitecore Media Library Image Pull

var imageTemplate = Guid.Parse("{F1828A2C-7E5D-4BBD-98CA-320474871548}");
var jpgTemplate = Guid.Parse("{DAF085E8-602E-43A6-8299-038FF171349F}");

var fileSizeField = Guid.Parse("{6954B7C7-2487-423F-8600-436CB3B6DC0E}");
// For checking image properties, the below can be used.
var imageWidthField = Guid.Parse("{22EAC599-F13B-4607-A89D-C091763A467D}");
var imageHeightField = Guid.Parse("{DE2CA9E4-C117-4C8A-A139-1FF4B199D15A}");

var mediaItems = (
	from item in Items
	join field in SharedFields on item.ID equals field.ItemId
	where (item.TemplateID == imageTemplate || item.TemplateID == jpgTemplate)
		//&& (field.FieldId == imageWidthField || field.FieldId == imageHeightField)
		&& field.FieldId == fileSizeField
	select new { field.Value }
	)
	.ToList()
	;

// Returns total size in MB
(mediaItems.Sum (i => i.Value == "" ? 0 : int.Parse(i.Value)) / 1000 / 1000).Dump();