MY-SQL:

SELECT KB_Topics.TOPICNAME 'Category / Topic',Solution.TITLE 'Subject / Title',Solution.DESCRIPTION 'Contents',Creator.FIRST_NAME 'Created By',DATE_FORMAT(FROM_UNIXTIME(SolutionInfo.CREATEDTIME/1000),'%d-%m-%Y %k:%i') 'Created Time',Updater.FIRST_NAME 'Last Modified By',DATE_FORMAT(FROM_UNIXTIME(SolutionInfo.LASTUPDATEDTIME/1000),'%d-%m-%Y %k:%i') 'Last Modified Time',Sol_StatusDefinition.STATUSNAME 'Status' FROM Solution INNER JOIN SolutionInfo ON Solution.SOLUTIONID=SolutionInfo.SOLUTIONID LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID LEFT JOIN SolutionCreationInfo ON SolutionInfo.SOLUTIONID=SolutionCreationInfo.SOLUTIONID LEFT JOIN SolutionUpdationInfo ON SolutionInfo.SOLUTIONID=SolutionUpdationInfo.SOLUTIONID LEFT JOIN AaaUser Updater ON SolutionUpdationInfo.LASTUPDATEDBY=Updater.USER_ID LEFT JOIN AaaUser Creator ON SolutionCreationInfo.CREATEDBY=Creator.USER_ID LEFT JOIN Solution_Keywords ON Solution.SOLUTIONID=Solution_Keywords.SOLUTIONID LEFT JOIN Sol_StatusDefinition ON Solution.STATUSID=Sol_StatusDefinition.STATUSID order by 1,2

MS-SQL:

SELECT KB_Topics.TOPICNAME 'Category / Topic',Solution.TITLE 'Subject / Title',Solution.DESCRIPTION 'Contents',Creator.FIRST_NAME 'Created By',dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (SolutionInfo.CREATEDTIME/1000),'1970-01-01 00:00:00') 'Created Time',Updater.FIRST_NAME 'Last Modified By',dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (SolutionInfo.LASTUPDATEDTIME/1000),'1970-01-01 00:00:00') 'Last Modified Time',Sol_StatusDefinition.STATUSNAME 'Status' FROM Solution INNER JOIN SolutionInfo ON Solution.SOLUTIONID=SolutionInfo.SOLUTIONID LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID LEFT JOIN SolutionCreationInfo ON SolutionInfo.SOLUTIONID=SolutionCreationInfo.SOLUTIONID LEFT JOIN SolutionUpdationInfo ON SolutionInfo.SOLUTIONID=SolutionUpdationInfo.SOLUTIONID LEFT JOIN AaaUser Updater ON SolutionUpdationInfo.LASTUPDATEDBY=Updater.USER_ID LEFT JOIN AaaUser Creator ON SolutionCreationInfo.CREATEDBY=Creator.USER_ID LEFT JOIN Solution_Keywords ON Solution.SOLUTIONID=Solution_Keywords.SOLUTIONID LEFT JOIN Sol_StatusDefinition ON Solution.STATUSID=Sol_StatusDefinition.STATUSID order by 1,2