SELECT DISTINCT(CASE
                    WHEN sourceSetting.id IN(1, 7)THEN'Customer'
                    WHEN sourceSetting.id IN(5, 8)THEN'Distributor'
                    WHEN sourceSetting.id IN(3, 14)THEN'Employee'
                    WHEN sourceSetting.id IN(2)THEN'Item'
                    WHEN sourceSetting.id IN(9)THEN'KPI'
                    WHEN sourceSetting.id IN(13)THEN'ScreenDefinition'
                    WHEN sourceSetting.id IN(15)THEN'MobileProfileSetting'
                    WHEN sourceSetting.id IN(6)THEN'PriceList'
                    WHEN sourceSetting.id IN(11)THEN'Campaign'
                    WHEN sourceSetting.id IN(4, 10)THEN'Route'
                    ELSE NULL
                END)AS needSyncTable
FROM AssignmentData ad
INNER JOIN AssignmentConfig c ON ad.assignmentConfigId=c.id
AND ad.isActive=1
AND c.isActive=1
AND c.sourceType='single'
INNER JOIN SettingData sourceSetting ON c.sourceId=sourceSetting.id
WHERE DATETIME(IFNULL(ad.modifiedDate, ad.createdDate))>DATETIME('$latestSingleTimestamp')
UNION
SELECT DISTINCT(CASE
                    WHEN destinationSetting.id IN(1, 7)THEN'Customer'
                    WHEN destinationSetting.id IN(5, 8)THEN'Distributor'
                    WHEN destinationSetting.id IN(3, 14)THEN'Employee'
                    WHEN destinationSetting.id IN(2)THEN'Item'
                    WHEN destinationSetting.id IN(9)THEN'KPI'
                    WHEN destinationSetting.id IN(13)THEN'ScreenDefinition'
                    WHEN destinationSetting.id IN(15)THEN'MobileProfileSetting'
                    WHEN destinationSetting.id IN(6)THEN'PriceList'
                    WHEN destinationSetting.id IN(11)THEN'Campaign'
                    WHEN destinationSetting.id IN(4, 10)THEN'Route'
                    ELSE NULL
                END)AS needSyncTable
FROM AssignmentData ad
INNER JOIN AssignmentConfig c ON ad.assignmentConfigId=c.id
AND ad.isActive=1
AND c.isActive=1
AND c.destinationType='single'
INNER JOIN SettingData destinationSetting ON c.destinationId=destinationSetting.id
WHERE DATETIME(IFNULL(ad.modifiedDate, ad.createdDate))>DATETIME('$latestSingleTimestamp')
UNION
SELECT DISTINCT(CASE
                    WHEN sourceSetting.id IN(1, 7)THEN'Customer'
                    WHEN sourceSetting.id IN(5, 8)THEN'Distributor'
                    WHEN sourceSetting.id IN(3, 14)THEN'Employee'
                    WHEN sourceSetting.id IN(2)THEN'Item'
                    WHEN sourceSetting.id IN(9)THEN'KPI'
                    WHEN sourceSetting.id IN(13)THEN'ScreenDefinition'
                    WHEN sourceSetting.id IN(15)THEN'MobileProfileSetting'
                    WHEN sourceSetting.id IN(6)THEN'PriceList'
                    WHEN sourceSetting.id IN(11)THEN'Campaign'
                    WHEN sourceSetting.id IN(4, 10)THEN'Route'
                    ELSE NULL
                END)AS needSyncTable
FROM AssignmentData ad
INNER JOIN AssignmentConfig c ON ad.assignmentConfigId=c.id
AND ad.isActive=1
AND c.isActive=1
AND c.sourceType='group'
INNER JOIN SettingData sourceSetting ON c.sourceId=sourceSetting.id
INNER JOIN AssignmentGroupDetail agd ON agd.groupId=ad.sourceId
AND agd.isActive=1
WHERE DATETIME(IFNULL(agd.modifiedDate, agd.createdDate))>DATETIME('$latestGroupTimestamp')
UNION
SELECT DISTINCT(CASE
                    WHEN destinationSetting.id IN(1, 7)THEN'Customer'
                    WHEN destinationSetting.id IN(5, 8)THEN'Distributor'
                    WHEN destinationSetting.id IN(3, 14)THEN'Employee'
                    WHEN destinationSetting.id IN(2)THEN'Item'
                    WHEN destinationSetting.id IN(9)THEN'KPI'
                    WHEN destinationSetting.id IN(13)THEN'ScreenDefinition'
                    WHEN destinationSetting.id IN(15)THEN'MobileProfileSetting'
                    WHEN destinationSetting.id IN(6)THEN'PriceList'
                    WHEN destinationSetting.id IN(11)THEN'Campaign'
                    WHEN destinationSetting.id IN(4, 10)THEN'Route'
                    ELSE NULL
                END)AS needSyncTable
FROM AssignmentData ad
INNER JOIN AssignmentConfig c ON ad.assignmentConfigId=c.id
AND ad.isActive=1
AND c.isActive=1
AND c.destinationType='group'
INNER JOIN SettingData destinationSetting ON c.destinationId=destinationSetting.id
INNER JOIN AssignmentGroupDetail agd ON agd.groupId=ad.destinationId
AND agd.isActive=1
WHERE DATETIME(IFNULL(agd.modifiedDate, agd.createdDate))>DATETIME('$latestGroupTimestamp')