SELECT b1.ownerId, p.name, COUNT( b1.ownerId ) bidCount, ( SELECT COUNT( b2.ownerId ) FROM tbl_BID_Bids b2 WHERE b1.ownerId = b2.ownerId AND b2.deleted = 'Y' ) deletedBidCount, ( SELECT COUNT( b2.ownerId ) FROM tbl_BID_Bids b2 WHERE b1.ownerId = b2.ownerId AND b2.sourceBidId IS NOT NULL ) copiedBidCount FROM tbl_BID_Bids b1 INNER JOIN fsenablers..tbl_CUS_Websites p ON b1.ownerId = p.portal_ownerId AND b1.ownerType = p.portal_ownerType GROUP BY b1.ownerId, p.name ORDER BY p.Name

Name	## of Bids Created	## of Bids Copied	## of Bids Deleted
#htmleditformat( name )#	#bidCount#	#copiedBidCount#	#deletedBidCount#