Mysql程序

create table tp_new as
select ProjectName, ModelCode, ‘TP_AppSolutionClosed‘ Component, TP_AppSolutionTotal as Total, TP_AppSolutionClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_AppSolutionResolved‘ Component,TP_AppSolutionTotal as Total,TP_AppSolutionResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_AppSolutionRejected‘ Component,TP_AppSolutionTotal as Total, TP_AppSolutionRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_AppSolutionPending‘ Component, TP_AppSolutionTotal as Total,TP_AppSolutionPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ExternalAppsPending‘ Component, TP_ExternalAppsTotal as Total,TP_ExternalAppsPending as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ExternalAppsRejected‘ Component, TP_ExternalAppsTotal as Total,TP_ExternalAppsRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ExternalAppsResolved‘ Component, TP_ExternalAppsTotal as Total,TP_ExternalAppsResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ExternalAppsPending‘ Component, TP_ExternalAppsTotal as Total,TP_ExternalAppsPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_AppFWClosed‘ Component, TP_AppFWTotal as Total,TP_AppFWClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_AppFWResolved‘ Component,TP_AppFWTotal as Total,TP_AppFWResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_AppFWRejected‘ Component, TP_AppFWTotal as Total,TP_AppFWRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_AppFWPending‘ Component, TP_AppFWTotal as Total,TP_AppFWPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_BroadcastAppClosed‘ Component, TP_BroadcastAppTotal as Total,TP_BroadcastAppClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_BroadcastAppResolved‘ Component,TP_BroadcastAppTotal as Total,TP_BroadcastAppResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BroadcastAppRejected‘ Component, TP_BroadcastAppTotal as Total,TP_BroadcastAppRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BroadcastAppPending‘ Component, TP_BroadcastAppTotal as Total,TP_BroadcastAppPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_BroadcastMWClosed‘ Component, TP_BroadcastMWTotal as Total,TP_BroadcastMWClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_BroadcastMWResolved‘ Component,TP_BroadcastMWTotal as Total,TP_BroadcastMWResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BroadcastMWRejected‘ Component, TP_BroadcastMWTotal as Total,TP_BroadcastMWRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BroadcastMWPending‘ Component, TP_BroadcastMWTotal as Total,TP_BroadcastMWPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_CoreAppClosed‘ Component, TP_CoreAppTotal as Total,TP_CoreAppClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_CoreAppResolved‘ Component,TP_CoreAppTotal as Total,TP_CoreAppResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CoreAppRejected‘ Component, TP_CoreAppTotal as Total,TP_CoreAppRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CoreAppPending‘ Component, TP_CoreAppTotal as Total,TP_CoreAppPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_JavaMWTVClosed‘ Component, TP_JavaMWTVTotal as Total,TP_JavaMWTVClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_JavaMWTVResolved‘ Component, TP_JavaMWTVTotal as Total,TP_JavaMWTVResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_JavaMWTVRejected‘ Component, TP_JavaMWTVTotal as Total,TP_JavaMWTVRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_JavaMWTVPending‘ Component, TP_JavaMWTVTotal as Total,TP_JavaMWTVPending as COUNT from defects_infor_component_tp


union
select ProjectName, ModelCode, ‘TP_SetupAppClosed‘ Component, TP_SetupAppTotal as Total,TP_SetupAppClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SetupAppResolved‘ Component, TP_SetupAppTotal as Total,TP_SetupAppResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SetupAppRejected‘ Component, TP_SetupAppTotal as Total,TP_SetupAppRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SetupAppPending‘ Component, TP_SetupAppTotal as Total,TP_SetupAppPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_ACMClosed‘ Component, TP_ACMTotal as Total,TP_ACMClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ACMResolved‘ Component, TP_ACMTotal as Total,TP_ACMResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ACMRejected‘ Component,TP_ACMTotal as Total, TP_ACMRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ACMPending‘ Component,TP_ACMTotal as Total, TP_ACMPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_ConnectedHomeClosed‘ Component, TP_ConnectedHomeTotal as Total,TP_ConnectedHomeClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ConnectedHomeResolved‘ Component,TP_ConnectedHomeTotal as Total, TP_ConnectedHomeResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ConnectedHomeRejected‘ Component,TP_ConnectedHomeTotal as Total, TP_ConnectedHomeRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ConnectedHomePending‘ Component,TP_ConnectedHomeTotal as Total, TP_ConnectedHomePending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_ConnectivityAppClosed‘ Component,TP_ConnectivityAppTotal as Total, TP_ConnectivityAppClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ConnectivityAppResolved‘ Component, TP_ConnectivityAppTotal as Total,TP_ConnectivityAppResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ConnectivityAppRejected‘ Component, TP_ConnectivityAppTotal as Total,TP_ConnectivityAppRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ConnectivityAppPending‘ Component, TP_ConnectivityAppTotal as Total,TP_ConnectivityAppPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_ConnectivityCoreClosed‘ Component,TP_ConnectivityCoreTotal as Total, TP_ConnectivityCoreClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ConnectivityCoreResolved‘ Component, TP_ConnectivityCoreTotal as Total,TP_ConnectivityCoreResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ConnectivityCoreRejected‘ Component, TP_ConnectivityCoreTotal as Total,TP_ConnectivityCoreRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ConnectivityCorePending‘ Component, TP_ConnectivityCoreTotal as Total,TP_ConnectivityCorePending as COUNT from defects_infor_component_tp


union
select ProjectName, ModelCode, ‘TP_ExternalSpeakerClosed‘ Component, TP_ExternalSpeakerTotal as Total,TP_ExternalSpeakerClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ExternalSpeakerResolved‘ Component,TP_ExternalSpeakerTotal as Total, TP_ExternalSpeakerResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ExternalSpeakerRejected‘ Component, TP_ExternalSpeakerTotal as Total,TP_ExternalSpeakerRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ExternalSpeakerPending‘ Component,TP_ExternalSpeakerTotal as Total, TP_ExternalSpeakerPending as COUNT from defects_infor_component_tp


union
select ProjectName, ModelCode, ‘TP_NetworkSpeakerClosed‘ Component, TP_NetworkSpeakerTotal as Total,TP_NetworkSpeakerClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_NetworkSpeakerResolved‘ Component,TP_NetworkSpeakerTotal as Total, TP_NetworkSpeakerResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_NetworkSpeakerRejected‘ Component,TP_NetworkSpeakerTotal as Total, TP_NetworkSpeakerRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_NetworkSpeakerPending‘ Component,TP_NetworkSpeakerTotal as Total, TP_NetworkSpeakerPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RMClosed‘ Component, TP_RMTotal as Total,TP_RMClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_RMResolved‘ Component,TP_RMTotal as Total, TP_RMResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RMRejected‘ Component,TP_RMTotal as Total, TP_RMRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RMPending‘ Component,TP_RMTotal as Total, TP_RMPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebServerClosed‘ Component, TP_WebServerTotal as Total,TP_WebServerClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_WebServerResolved‘ Component,TP_WebServerTotal as Total, TP_WebServerResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebServerRejected‘ Component,TP_WebServerTotal as Total, TP_WebServerRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebServerPending‘ Component,TP_WebServerTotal as Total, TP_WebServerPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ContentServiceClosed‘ Component,TP_ContentServiceTotal as Total, TP_ContentServiceClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ContentServiceResolved‘ Component, TP_ContentServiceTotal as Total,TP_ContentServiceResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ContentServiceRejected‘ Component, TP_ContentServiceTotal as Total,TP_ContentServiceRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ContentServicePending‘ Component, TP_ContentServiceTotal as Total,TP_ContentServicePending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DLNAClosed‘ Component, TP_DLNATotal as Total,TP_DLNAClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_DLNAResolved‘ Component, TP_DLNATotal as Total,TP_DLNAResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DLNARejected‘ Component,TP_DLNATotal as Total, TP_DLNARejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DLNAPending‘ Component, TP_DLNATotal as Total,TP_DLNAPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DualTVClosed‘ Component, TP_DualTVTotal as Total,TP_DualTVClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_DualTVResolved‘ Component, TP_DualTVTotal as Total,TP_DualTVResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DualTVRejected‘ Component, TP_DualTVTotal as Total,TP_DualTVRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DualTVPending‘ Component, TP_DualTVTotal as Total,TP_DualTVPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RemoteClosed‘ Component, TP_RemoteTotal as Total,TP_RemoteClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_RemoteResolved‘ Component, TP_RemoteTotal as Total,TP_RemoteResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RemoteRejected‘ Component, TP_RemoteTotal as Total,TP_RemoteRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RemotePending‘ Component, TP_RemoteTotal as Total,TP_RemotePending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PlatformCommonClosed‘ Component, TP_PlatformCommonTotal as Total,TP_PlatformCommonClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_PlatformCommonResolved‘ Component, TP_PlatformCommonTotal as Total,TP_PlatformCommonResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PlatformCommonRejected‘ Component, TP_PlatformCommonTotal as Total,TP_PlatformCommonRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PlatformCommonPending‘ Component, TP_PlatformCommonTotal as Total,TP_PlatformCommonPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MVPDClosed‘ Component, TP_MVPDTotal as Total,TP_MVPDClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_MVPDResolved‘ Component, TP_MVPDTotal as Total,TP_MVPDResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MVPDRejected‘ Component,TP_MVPDTotal as Total, TP_MVPDRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MVPDPending‘ Component, TP_MVPDTotal as Total,TP_MVPDPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PVODClosed‘ Component, TP_PVODTotal as Total,TP_PVODClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_PVODResolved‘ Component,TP_PVODTotal as Total, TP_PVODResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PVODRejected‘ Component,TP_PVODTotal as Total, TP_PVODRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PVODPending‘ Component, TP_PVODTotal as Total,TP_PVODPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_EnterprisePlatformClosed‘ Component, TP_EnterprisePlatformTotal as Total,TP_EnterprisePlatformClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_EnterprisePlatformResolved‘ Component, TP_EnterprisePlatformTotal as Total,TP_EnterprisePlatformResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_EnterprisePlatformRejected‘ Component, TP_EnterprisePlatformTotal as Total,TP_EnterprisePlatformRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_EnterprisePlatformPending‘ Component, TP_EnterprisePlatformTotal as Total,TP_EnterprisePlatformPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘App_MobileClosed‘ Component,App_MobileTotal as Total, App_MobileClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘App_MobileResolved‘ Component, App_MobileTotal as Total,App_MobileResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘App_MobileRejected‘ Component, App_MobileTotal as Total,App_MobileRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘App_MobilePending‘ Component,App_MobileTotal as Total, App_MobilePending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SocialPanelClosed‘ Component, TP_SocialPanelTotal as Total,TP_SocialPanelClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SocialPanelResolved‘ Component, TP_SocialPanelTotal as Total,TP_SocialPanelResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SocialPanelRejected‘ Component,TP_SocialPanelTotal as Total, TP_SocialPanelRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SocialPanelPending‘ Component, TP_SocialPanelTotal as Total,TP_SocialPanelPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘eManual_TizenClosed‘ Component,eManual_TizenTotal as Total, eManual_TizenClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘eManual_TizenResolved‘ Component, eManual_TizenTotal as Total,eManual_TizenResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘eManual_TizenRejected‘ Component, eManual_TizenTotal as Total,eManual_TizenRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘eManual_TizenPending‘ Component, eManual_TizenTotal as Total,eManual_TizenPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_GplayerClosed‘ Component, TP_GplayerTotal as Total,TP_GplayerClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_GplayerResolved‘ Component,TP_GplayerTotal as Total, TP_GplayerResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_GplayerRejected‘ Component, TP_GplayerTotal as Total,TP_GplayerRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_GplayerPending‘ Component,TP_GplayerTotal as Total, TP_GplayerPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CameraFWClosed‘ Component, TP_CameraFWTotal as Total,TP_CameraFWClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_CameraFWResolved‘ Component, TP_CameraFWTotal as Total,TP_CameraFWResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CameraFWRejected‘ Component,TP_CameraFWTotal as Total, TP_CameraFWRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CameraFWPending‘ Component, TP_CameraFWTotal as Total,TP_CameraFWPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ContentsAnalysisClosed‘ Component, TP_ContentsAnalysisTotal as Total,TP_ContentsAnalysisClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ContentsAnalysisResolved‘ Component,TP_ContentsAnalysisTotal as Total, TP_ContentsAnalysisResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ContentsAnalysisRejected‘ Component,TP_ContentsAnalysisTotal as Total, TP_ContentsAnalysisRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ContentsAnalysisPending‘ Component,TP_ContentsAnalysisTotal as Total, TP_ContentsAnalysisPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DialogEngineClosed‘ Component, TP_DialogEngineTotal as Total,TP_DialogEngineClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_DialogEngineResolved‘ Component, TP_DialogEngineTotal as Total,TP_DialogEngineResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DialogEngineRejected‘ Component, TP_DialogEngineTotal as Total,TP_DialogEngineRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DialogEnginePending‘ Component, TP_DialogEngineTotal as Total,TP_DialogEnginePending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_EnhancedFeaturesClosed‘ Component,TP_EnhancedFeaturesTotal as Total, TP_EnhancedFeaturesClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_EnhancedFeaturesResolved‘ Component, TP_EnhancedFeaturesTotal as Total,TP_EnhancedFeaturesResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_EnhancedFeaturesRejected‘ Component,TP_EnhancedFeaturesTotal as Total, TP_EnhancedFeaturesRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_EnhancedFeaturesPending‘ Component, TP_EnhancedFeaturesTotal as Total,TP_EnhancedFeaturesPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_FTVClosed‘ Component, TP_FTVTotal as Total,TP_FTVClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_FTVResolved‘ Component,TP_FTVTotal as Total, TP_FTVResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_FTVRejected‘ Component,TP_FTVTotal as Total, TP_FTVRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_FTVPending‘ Component,TP_FTVTotal as Total,TP_FTVPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_HdmiCecClosed‘ Component, TP_HdmiCecTotal as Total,TP_HdmiCecClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_HdmiCecResolved‘ Component,TP_HdmiCecTotal as Total, TP_HdmiCecResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_HdmiCecRejected‘ Component, TP_HdmiCecTotal as Total,TP_HdmiCecRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_HdmiCecPending‘ Component,TP_HdmiCecTotal as Total, TP_HdmiCecPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_InfoObjetClosed‘ Component,TP_InfoObjetTotal as Total, TP_InfoObjetClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_InfoObjetResolved‘ Component, TP_InfoObjetTotal as Total,TP_InfoObjetResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_InfoObjetRejected‘ Component, TP_InfoObjetTotal as Total,TP_InfoObjetRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_InfoObjetPending‘ Component, TP_InfoObjetTotal as Total,TP_InfoObjetPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MorningBriefClosed‘ Component, TP_MorningBriefTotal as Total,TP_MorningBriefClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_MorningBriefResolved‘ Component, TP_MorningBriefTotal as Total,TP_MorningBriefResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MorningBriefRejected‘ Component, TP_MorningBriefTotal as Total,TP_MorningBriefRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MorningBriefPending‘ Component,TP_MorningBriefTotal as Total, TP_MorningBriefPending as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RecogEngineMWClosed‘ Component,TP_RecogEngineMWTotal as Total, TP_RecogEngineMWClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_RecogEngineMWResolved‘ Component,TP_RecogEngineMWTotal as Total, TP_RecogEngineMWResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RecogEngineMWRejected‘ Component, TP_RecogEngineMWTotal as Total,TP_RecogEngineMWRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RecogEngineMWPending‘ Component,TP_RecogEngineMWTotal as Total, TP_RecogEngineMWPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_RecognitionClosed‘ Component,TP_RecognitionTotal as Total, TP_RecognitionClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_RecognitionResolved‘ Component,TP_RecognitionTotal as Total, TP_RecognitionResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RecognitionRejected‘ Component,TP_RecognitionTotal as Total, TP_RecognitionRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_RecognitionPending‘ Component, TP_RecognitionTotal as Total,TP_RecognitionPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_BdPlatformClosed‘ Component,TP_BdPlatformTotal as Total, TP_BdPlatformClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_BdPlatformResolved‘ Component, TP_BdPlatformTotal as Total,TP_BdPlatformResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BdPlatformRejected‘ Component,TP_BdPlatformTotal as Total, TP_BdPlatformRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BdPlatformPending‘ Component, TP_BdPlatformTotal as Total,TP_BdPlatformPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_BdplayerClosed‘ Component, TP_BdplayerTotal as Total,TP_BdplayerClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_BdplayerResolved‘ Component,TP_BdplayerTotal as Total, TP_BdplayerResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BdplayerRejected‘ Component,TP_BdplayerTotal as Total, TP_BdplayerRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BdplayerPending‘ Component, TP_BdplayerTotal as Total,TP_BdplayerPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_CMEMPClosed‘ Component, TP_CMEMPTotal as Total,TP_CMEMPClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_CMEMPResolved‘ Component, TP_CMEMPTotal as Total,TP_CMEMPResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CMEMPRejected‘ Component, TP_CMEMPTotal as Total,TP_CMEMPRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CMEMPPending‘ Component, TP_CMEMPTotal as Total,TP_CMEMPPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_CSFClosed‘ Component, TP_CSFTotal as Total,TP_CSFClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_CSFResolved‘ Component,TP_CSFTotal as Total, TP_CSFResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CSFRejected‘ Component, TP_CSFTotal as Total,TP_CSFRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CSFPending‘ Component,TP_CSFTotal as Total, TP_CSFPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_MMAppClosed‘ Component, TP_MMAppTotal as Total,TP_MMAppClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_MMAppResolved‘ Component,TP_MMAppTotal as Total, TP_MMAppResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMAppRejected‘ Component, TP_MMAppTotal as Total,TP_MMAppRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMAppPending‘ Component,TP_MMAppTotal as Total, TP_MMAppPending as COUNT from defects_infor_component_tp


union
select ProjectName, ModelCode, ‘TP_MMAudioClosed‘ Component,TP_MMAudioTotal as Total, TP_MMAudioClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_MMAudioResolved‘ Component,TP_MMAudioTotal as Total, TP_MMAudioResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMAudioRejected‘ Component,TP_MMAudioTotal as Total, TP_MMAudioRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMAudioPending‘ Component, TP_MMAudioTotal as Total,TP_MMAudioPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_MMCameraClosed‘ Component,TP_MMCameraTotal as Total, TP_MMCameraClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_MMCameraResolved‘ Component, TP_MMCameraTotal as Total,TP_MMCameraResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMCameraRejected‘ Component,TP_MMCameraTotal as Total, TP_MMCameraRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMCameraPending‘ Component, TP_MMCameraTotal as Total,TP_MMCameraPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_MMMediaContentClosed‘ Component,TP_MMMediaContentTotal as Total, TP_MMMediaContentClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_MMMediaContentResolved‘ Component,TP_MMMediaContentTotal as Total, TP_MMMediaContentResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMMediaContentRejected‘ Component,TP_MMMediaContentTotal as Total, TP_MMMediaContentRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMMediaContentPending‘ Component, TP_MMMediaContentTotal as Total,TP_MMMediaContentPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_MMPlayerClosed‘ Component,TP_MMPlayerTotal as Total, TP_MMPlayerClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_MMPlayerResolved‘ Component, TP_MMPlayerTotal as Total,TP_MMPlayerResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMPlayerRejected‘ Component, TP_MMPlayerTotal as Total,TP_MMPlayerRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MMPlayerPending‘ Component, TP_MMPlayerTotal as Total,TP_MMPlayerPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_MultimediaMWClosed‘ Component,TP_MultimediaMWTotal as Total, TP_MultimediaMWClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_MultimediaMWResolved‘ Component, TP_MultimediaMWTotal as Total,TP_MultimediaMWResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MultimediaMWRejected‘ Component,TP_MultimediaMWTotal as Total, TP_MultimediaMWRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MultimediaMWPending‘ Component, TP_MultimediaMWTotal as Total,TP_MultimediaMWPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_OnScreenUIClosed‘ Component, TP_OnScreenUITotal as Total,TP_OnScreenUIClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_OnScreenUIResolved‘ Component, TP_OnScreenUITotal as Total,TP_OnScreenUIResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_OnScreenUIRejected‘ Component, TP_OnScreenUITotal as Total,TP_OnScreenUIRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_OnScreenUIPending‘ Component,TP_OnScreenUITotal as Total, TP_OnScreenUIPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_PXClosed‘ Component, TP_PXTotal as Total,TP_PXClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_PXResolved‘ Component,TP_PXTotal as Total, TP_PXResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PXRejected‘ Component,TP_PXTotal as Total, TP_PXRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PXPending‘ Component, TP_PXTotal as Total,TP_PXPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_CrossPlatformClosed‘ Component, TP_CrossPlatformTotal as Total,TP_CrossPlatformClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_CrossPlatformResolved‘ Component, TP_CrossPlatformTotal as Total,TP_CrossPlatformResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CrossPlatformRejected‘ Component, TP_CrossPlatformTotal as Total,TP_CrossPlatformRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CrossPlatformPending‘ Component, TP_CrossPlatformTotal as Total,TP_CrossPlatformPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SDKClosed‘ Component, TP_SDKTotal as Total,TP_SDKClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SDKResolved‘ Component, TP_SDKTotal as Total,TP_SDKResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SDKRejected‘ Component, TP_SDKTotal as Total,TP_SDKRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SDKPending‘ Component, TP_SDKTotal as Total,TP_SDKPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SecurityClosed‘ Component, TP_SecurityTotal as Total,TP_SecurityClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SecurityResolved‘ Component, TP_SecurityTotal as Total,TP_SecurityResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SecurityRejected‘ Component, TP_SecurityTotal as Total,TP_SecurityRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SecurityPending‘ Component, TP_SecurityTotal as Total,TP_SecurityPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_ADAgentClosed‘ Component, TP_ADAgentTotal as Total,TP_ADAgentClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ADAgentResolved‘ Component, TP_ADAgentTotal as Total,TP_ADAgentResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ADAgentRejected‘ Component, TP_ADAgentTotal as Total,TP_ADAgentRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ADAgentPending‘ Component, TP_ADAgentTotal as Total,TP_ADAgentPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_AppStoreClosed‘ Component, TP_AppStoreTotal as Total,TP_AppStoreClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_AppStoreResolved‘ Component, TP_AppStoreTotal as Total,TP_AppStoreResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_AppStoreRejected‘ Component, TP_AppStoreTotal as Total,TP_AppStoreRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_AppStorePending‘ Component,TP_AppStoreTotal as Total, TP_AppStorePending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_BillingClosed‘ Component,TP_BillingTotal as Total, TP_BillingClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_BillingResolved‘ Component, TP_BillingTotal as Total,TP_BillingResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BillingRejected‘ Component, TP_BillingTotal as Total,TP_BillingRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BillingPending‘ Component, TP_BillingTotal as Total,TP_BillingPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_ClipsClosed‘ Component, TP_ClipsTotal as Total,TP_ClipsClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ClipsResolved‘ Component, TP_ClipsTotal as Total,TP_ClipsResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ClipsRejected‘ Component, TP_ClipsTotal as Total,TP_ClipsRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ClipsPending‘ Component, TP_ClipsTotal as Total,TP_ClipsPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_ESPClosed‘ Component, TP_ESPTotal as Total,TP_ESPClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ESPResolved‘ Component, TP_ESPTotal as Total,TP_ESPResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ESPRejected‘ Component, TP_ESPTotal as Total,TP_ESPRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ESPPending‘ Component, TP_ESPTotal as Total,TP_ESPPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_EXTRA_KRClosed‘ Component, TP_EXTRA_KRTotal as Total,TP_EXTRA_KRClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_EXTRA_KRResolved‘ Component, TP_EXTRA_KRTotal as Total,TP_EXTRA_KRResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_EXTRA_KRRejected‘ Component,TP_EXTRA_KRTotal as Total, TP_EXTRA_KRRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_EXTRA_KRPending‘ Component, TP_EXTRA_KRTotal as Total,TP_EXTRA_KRPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_GameFrontClosed‘ Component,TP_GameFrontTotal as Total, TP_GameFrontClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_GameFrontResolved‘ Component, TP_GameFrontTotal as Total,TP_GameFrontResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_GameFrontRejected‘ Component,TP_GameFrontTotal as Total, TP_GameFrontRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_GameFrontPending‘ Component, TP_GameFrontTotal as Total,TP_GameFrontPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_MyContentsClosed‘ Component,TP_MyContentsTotal as Total, TP_MyContentsClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_MyContentsResolved‘ Component, TP_MyContentsTotal as Total,TP_MyContentsResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MyContentsRejected‘ Component,TP_MyContentsTotal as Total, TP_MyContentsRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_MyContentsPending‘ Component,TP_MyContentsTotal as Total, TP_MyContentsPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_NewsOnClosed‘ Component, TP_NewsOnTotal as Total,TP_NewsOnClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_NewsOnResolved‘ Component, TP_NewsOnTotal as Total,TP_NewsOnResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_NewsOnRejected‘ Component,TP_NewsOnTotal as Total, TP_NewsOnRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_NewsOnPending‘ Component,TP_NewsOnTotal as Total, TP_NewsOnPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_NotiCenterClosed‘ Component,TP_NotiCenterTotal as Total, TP_NotiCenterClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_NotiCenterResolved‘ Component,TP_NotiCenterTotal as Total, TP_NotiCenterResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_NotiCenterRejected‘ Component,TP_NotiCenterTotal as Total, TP_NotiCenterRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_NotiCenterPending‘ Component, TP_NotiCenterTotal as Total,TP_NotiCenterPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_OnTVClosed‘ Component, TP_OnTVTotal as Total,TP_OnTVClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_OnTVResolved‘ Component, TP_OnTVTotal as Total,TP_OnTVResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_OnTVRejected‘ Component, TP_OnTVTotal as Total,TP_OnTVRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_OnTVPending‘ Component, TP_OnTVTotal as Total,TP_OnTVPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SAFClosed‘ Component, TP_SAFTotal as Total,TP_SAFClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SAFResolved‘ Component, TP_SAFTotal as Total,TP_SAFResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SAFRejected‘ Component,TP_SAFTotal as Total, TP_SAFRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SAFPending‘ Component,TP_SAFTotal as Total, TP_SAFPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SSOClosed‘ Component, TP_SSOTotal as Total,TP_SSOClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SSOResolved‘ Component, TP_SSOTotal as Total,TP_SSOResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SSORejected‘ Component,TP_SSOTotal as Total, TP_SSORejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SSOPending‘ Component,TP_SSOTotal as Total, TP_SSOPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SearchAllClosed‘ Component, TP_SearchAllTotal as Total,TP_SearchAllClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SearchAllResolved‘ Component, TP_SearchAllTotal as Total,TP_SearchAllResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SearchAllRejected‘ Component,TP_SearchAllTotal as Total, TP_SearchAllRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SearchAllPending‘ Component, TP_SearchAllTotal as Total,TP_SearchAllPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SoccerClosed‘ Component,TP_SoccerTotal as Total, TP_SoccerClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SoccerResolved‘ Component,TP_SoccerTotal as Total, TP_SoccerResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SoccerRejected‘ Component, TP_SoccerTotal as Total,TP_SoccerRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SoccerPending‘ Component,TP_SoccerTotal as Total, TP_SoccerPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_TVPlusClosed‘ Component,TP_TVPlusTotal as Total, TP_TVPlusClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_TVPlusResolved‘ Component,TP_TVPlusTotal as Total, TP_TVPlusResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_TVPlusRejected‘ Component, TP_TVPlusTotal as Total,TP_TVPlusRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_TVPlusPending‘ Component, TP_TVPlusTotal as Total,TP_TVPlusPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SOCClosed‘ Component, TP_SOCTotal as Total,TP_SOCClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SOCResolved‘ Component,TP_SOCTotal as Total, TP_SOCResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SOCRejected‘ Component,TP_SOCTotal as Total, TP_SOCRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SOCPending‘ Component, TP_SOCTotal as Total,TP_SOCPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SOC_VENDORClosed‘ Component, TP_SOC_VENDORTotal as Total,TP_SOC_VENDORClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SOC_VENDORResolved‘ Component, TP_SOC_VENDORTotal as Total,TP_SOC_VENDORResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SOC_VENDORRejected‘ Component, TP_SOC_VENDORTotal as Total,TP_SOC_VENDORRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SOC_VENDORPending‘ Component,TP_SOC_VENDORTotal as Total, TP_SOC_VENDORPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SystemArchitectureClosed‘ Component, TP_SystemArchitectureTotal as Total,TP_SystemArchitectureClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SystemArchitectureResolved‘ Component, TP_SystemArchitectureTotal as Total,TP_SystemArchitectureResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SystemArchitectureRejected‘ Component, TP_SystemArchitectureTotal as Total,TP_SystemArchitectureRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SystemArchitecturePending‘ Component,TP_SystemArchitectureTotal as Total, TP_SystemArchitecturePending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SystemPlatformClosed‘ Component,TP_SystemPlatformTotal as Total, TP_SystemPlatformClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SystemPlatformResolved‘ Component,TP_SystemPlatformTotal as Total, TP_SystemPlatformResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SystemPlatformRejected‘ Component,TP_SystemPlatformTotal as Total, TP_SystemPlatformRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SystemPlatformPending‘ Component, TP_SystemPlatformTotal as Total,TP_SystemPlatformPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘AT_HUB_TizenClosed‘ Component, AT_HUB_TizenTotal as Total,AT_HUB_TizenClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘AT_HUB_TizenResolved‘ Component, AT_HUB_TizenTotal as Total,AT_HUB_TizenResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘AT_HUB_TizenRejected‘ Component, AT_HUB_TizenTotal as Total,AT_HUB_TizenRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘AT_HUB_TizenPending‘ Component,AT_HUB_TizenTotal as Total, AT_HUB_TizenPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_AVSystemMWClosed‘ Component,TP_AVSystemMWTotal as Total, TP_AVSystemMWClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_AVSystemMWResolved‘ Component, TP_AVSystemMWTotal as Total,TP_AVSystemMWResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_AVSystemMWRejected‘ Component, TP_AVSystemMWTotal as Total,TP_AVSystemMWRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_AVSystemMWPending‘ Component, TP_AVSystemMWTotal as Total,TP_AVSystemMWPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_BootServiceClosed‘ Component,TP_BootServiceTotal as Total, TP_BootServiceClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_BootServiceResolved‘ Component,TP_BootServiceTotal as Total, TP_BootServiceResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BootServiceRejected‘ Component,TP_BootServiceTotal as Total, TP_BootServiceRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BootServicePending‘ Component,TP_BootServiceTotal as Total, TP_BootServicePending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_BootService_avClosed‘ Component, TP_BootService_avTotal as Total,TP_BootService_avClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_BootService_avResolved‘ Component, TP_BootService_avTotal as Total,TP_BootService_avResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BootService_avRejected‘ Component, TP_BootService_avTotal as Total,TP_BootService_avRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_BootService_avPending‘ Component, TP_BootService_avTotal as Total,TP_BootService_avPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_ContentsDownloadClosed‘ Component,TP_ContentsDownloadTotal as Total, TP_ContentsDownloadClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_ContentsDownloadResolved‘ Component,TP_ContentsDownloadTotal as Total, TP_ContentsDownloadResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ContentsDownloadRejected‘ Component, TP_ContentsDownloadTotal as Total,TP_ContentsDownloadRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_ContentsDownloadPending‘ Component,TP_ContentsDownloadTotal as Total, TP_ContentsDownloadPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SWUpgradeClosed‘ Component, TP_SWUpgradeTotal as Total,TP_SWUpgradeClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SWUpgradeResolved‘ Component,TP_SWUpgradeTotal as Total, TP_SWUpgradeResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SWUpgradeRejected‘ Component, TP_SWUpgradeTotal as Total,TP_SWUpgradeRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SWUpgradePending‘ Component, TP_SWUpgradeTotal as Total,TP_SWUpgradePending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_SystemMWClosed‘ Component, TP_SystemMWTotal as Total,TP_SystemMWClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_SystemMWResolved‘ Component,TP_SystemMWTotal as Total, TP_SystemMWResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SystemMWRejected‘ Component, TP_SystemMWTotal as Total,TP_SystemMWRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_SystemMWPending‘ Component,TP_SystemMWTotal as Total, TP_SystemMWPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘e_Pop_TizenClosed‘ Component, e_Pop_TizenTotal as Total,e_Pop_TizenClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘e_Pop_TizenResolved‘ Component,e_Pop_TizenTotal as Total, e_Pop_TizenResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘e_Pop_TizenRejected‘ Component, e_Pop_TizenTotal as Total,e_Pop_TizenRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘e_Pop_TizenPending‘ Component,e_Pop_TizenTotal as Total, e_Pop_TizenPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_PlatformTestClosed‘ Component, TP_PlatformTestTotal as Total,TP_PlatformTestClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_PlatformTestResolved‘ Component, TP_PlatformTestTotal as Total,TP_PlatformTestResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PlatformTestRejected‘ Component,TP_PlatformTestTotal as Total, TP_PlatformTestRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_PlatformTestPending‘ Component,TP_PlatformTestTotal as Total, TP_PlatformTestPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TestAutomation_TizenClosed‘ Component, TestAutomation_TizenTotal as Total,TestAutomation_TizenClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TestAutomation_TizenResolved‘ Component, TestAutomation_TizenTotal as Total,TestAutomation_TizenResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TestAutomation_TizenRejected‘ Component,TestAutomation_TizenTotal as Total, TestAutomation_TizenRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TestAutomation_TizenPending‘ Component, TestAutomation_TizenTotal as Total,TestAutomation_TizenPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_UIFWClosed‘ Component, TP_UIFWTotal as Total,TP_UIFWClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_UIFWResolved‘ Component,TP_UIFWTotal as Total, TP_UIFWResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_UIFWRejected‘ Component,TP_UIFWTotal as Total, TP_UIFWRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_UIFWPending‘ Component,TP_UIFWTotal as Total, TP_UIFWPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_CSPClosed‘ Component, TP_CSPTotal as Total,TP_CSPClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_CSPResolved‘ Component, TP_CSPTotal as Total,TP_CSPResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CSPRejected‘ Component, TP_CSPTotal as Total,TP_CSPRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CSPPending‘ Component, TP_CSPTotal as Total,TP_CSPPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_OpenSourceClosed‘ Component, TP_OpenSourceTotal as Total,TP_OpenSourceClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_OpenSourceResolved‘ Component, TP_OpenSourceTotal as Total,TP_OpenSourceResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_OpenSourceRejected‘ Component, TP_OpenSourceTotal as Total,TP_OpenSourceRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_OpenSourcePending‘ Component, TP_OpenSourceTotal as Total,TP_OpenSourcePending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_VDLinuxClosed‘ Component, TP_VDLinuxTotal as Total,TP_VDLinuxClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_VDLinuxResolved‘ Component, TP_VDLinuxTotal as Total,TP_VDLinuxResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_VDLinuxRejected‘ Component,TP_VDLinuxTotal as Total, TP_VDLinuxRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_VDLinuxPending‘ Component, TP_VDLinuxTotal as Total,TP_VDLinuxPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_FirstScreenClosed‘ Component, TP_FirstScreenTotal as Total,TP_FirstScreenClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_FirstScreenResolved‘ Component, TP_FirstScreenTotal as Total,TP_FirstScreenResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_FirstScreenRejected‘ Component, TP_FirstScreenTotal as Total,TP_FirstScreenRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_FirstScreenPending‘ Component,TP_FirstScreenTotal as Total, TP_FirstScreenPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_VOLTClosed‘ Component, TP_VOLTTotal as Total,TP_VOLTClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_VOLTResolved‘ Component,TP_VOLTTotal as Total, TP_VOLTResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_VOLTRejected‘ Component,TP_VOLTTotal as Total, TP_VOLTRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_VOLTPending‘ Component,TP_VOLTTotal as Total, TP_VOLTPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_CBREClosed‘ Component,TP_CBRETotal as Total, TP_CBREClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_CBREResolved‘ Component,TP_CBRETotal as Total, TP_CBREResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CBRERejected‘ Component,TP_CBRETotal as Total, TP_CBRERejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_CBREPending‘ Component,TP_CBRETotal as Total, TP_CBREPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_GingaNCLClosed‘ Component,TP_GingaNCLTotal as Total, TP_GingaNCLClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_GingaNCLResolved‘ Component,TP_GingaNCLTotal as Total, TP_GingaNCLResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_GingaNCLRejected‘ Component, TP_GingaNCLTotal as Total,TP_GingaNCLRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_GingaNCLPending‘ Component, TP_GingaNCLTotal as Total,TP_GingaNCLPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_HbbTVClosed‘ Component,TP_HbbTVTotal as Total, TP_HbbTVClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_HbbTVResolved‘ Component,TP_HbbTVTotal as Total, TP_HbbTVResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_HbbTVRejected‘ Component,TP_HbbTVTotal as Total, TP_HbbTVRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_HbbTVPending‘ Component,TP_HbbTVTotal as Total, TP_HbbTVPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_InfoLinkClosed‘ Component, TP_InfoLinkTotal as Total,TP_InfoLinkClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_InfoLinkResolved‘ Component, TP_InfoLinkTotal as Total,TP_InfoLinkResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_InfoLinkRejected‘ Component,TP_InfoLinkTotal as Total, TP_InfoLinkRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_InfoLinkPending‘ Component, TP_InfoLinkTotal as Total,TP_InfoLinkPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_TogetherPlayClosed‘ Component,TP_TogetherPlayTotal as Total, TP_TogetherPlayClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_TogetherPlayResolved‘ Component, TP_TogetherPlayTotal as Total,TP_TogetherPlayResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_TogetherPlayRejected‘ Component,TP_TogetherPlayTotal as Total, TP_TogetherPlayRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_TogetherPlayPending‘ Component, TP_TogetherPlayTotal as Total,TP_TogetherPlayPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_WebAppCoreClosed‘ Component, TP_WebAppCoreTotal as Total,TP_WebAppCoreClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_WebAppCoreResolved‘ Component, TP_WebAppCoreTotal as Total,TP_WebAppCoreResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebAppCoreRejected‘ Component, TP_WebAppCoreTotal as Total,TP_WebAppCoreRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebAppCorePending‘ Component, TP_WebAppCoreTotal as Total,TP_WebAppCorePending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_WebBrowserClosed‘ Component,TP_WebBrowserTotal as Total, TP_WebBrowserClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_WebBrowserResolved‘ Component, TP_WebBrowserTotal as Total,TP_WebBrowserResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebBrowserRejected‘ Component, TP_WebBrowserTotal as Total,TP_WebBrowserRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebBrowserPending‘ Component,TP_WebBrowserTotal as Total, TP_WebBrowserPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_WebEngineClosed‘ Component, TP_WebEngineTotal as Total,TP_WebEngineClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_WebEngineResolved‘ Component,TP_WebEngineTotal as Total, TP_WebEngineResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebEngineRejected‘ Component, TP_WebEngineTotal as Total,TP_WebEngineRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebEnginePending‘ Component,TP_WebEngineTotal as Total, TP_WebEnginePending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_WebUIFrameworkClosed‘ Component,TP_WebUIFrameworkTotal as Total, TP_WebUIFrameworkClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_WebUIFrameworkResolved‘ Component, TP_WebUIFrameworkTotal as Total,TP_WebUIFrameworkResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebUIFrameworkRejected‘ Component, TP_WebUIFrameworkTotal as Total,TP_WebUIFrameworkRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WebUIFrameworkPending‘ Component,TP_WebUIFrameworkTotal as Total, TP_WebUIFrameworkPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_DisplayAudio_AppClosed‘ Component,TP_DisplayAudio_AppTotal as Total, TP_DisplayAudio_AppClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_DisplayAudio_AppResolved‘ Component, TP_DisplayAudio_AppTotal as Total,TP_DisplayAudio_AppResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DisplayAudio_AppRejected‘ Component, TP_DisplayAudio_AppTotal as Total,TP_DisplayAudio_AppRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_DisplayAudio_AppPending‘ Component,TP_DisplayAudio_AppTotal as Total, TP_DisplayAudio_AppPending as COUNT from defects_infor_component_tp

union
select ProjectName, ModelCode, ‘TP_WirelessAudioPlatformClosed‘ Component, TP_WirelessAudioPlatformTotal as Total,TP_WirelessAudioPlatformClosed as COUNT from defects_infor_component_tp
union 
select ProjectName, ModelCode, ‘TP_WirelessAudioPlatformResolved‘ Component,TP_WirelessAudioPlatformTotal as Total, TP_WirelessAudioPlatformResolved as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WirelessAudioPlatformRejected‘ Component, TP_WirelessAudioPlatformTotal as Total,TP_WirelessAudioPlatformRejected as COUNT from defects_infor_component_tp
union
select ProjectName, ModelCode, ‘TP_WirelessAudioPlatformPending‘ Component, TP_WirelessAudioPlatformTotal as Total,TP_WirelessAudioPlatformPending as COUNT from defects_infor_component_tp

order by ProjectName, COUNT desc ;

select ProjectName, Component, sum(Total) as Total,sum(COUNT) as COUNT from tp_new where total<>0 group by ProjectName, Component order by ProjectName, sum(Total) desc,component;