SELECT 
	so2.name AS OrganisationParent,
	so.name AS Organisation,
	ss.siteID AS SiteID,
	ss.socialType AS SocialChannel,
	ss.name AS PageName,
	ss.createDate AS ConnectionDate,
	CONCAT(cu.firstName, ' ', cu.lastName) AS CreatorUser 
FROM smd__social_site ss
INNER JOIN smd__organization_has_social_site sohss ON sohss.siteID = ss.siteID
INNER JOIN smd__organization so ON so.organizationID = sohss.organizationID
INNER JOIN smd__partner sp ON sp.partnerID = so.partnerID AND so.partnerID = 192
LEFT JOIN smd__organization so2 ON so.parentID = so2.organizationID
LEFT JOIN cms__user cu ON ss.userID = cu.userID
ORDER BY ss.createDate ASC