LINQ sub query with count of records.

Dear All,
I have following query and result. I want expected result with following query or may be sub query.
Can anyone please help how to do the following scenario in linq.
Query:
 var varPublishingReport = (from product in listProduct                                        join productContent in listProductContent on product.Field<string>("ows_LinkTitle") equals productContent.Field<string>("ows_Product Number").Replace("#", "").Split(';')[1]                                        join workf ...