UI:ServiceMgmtMenuOverview:Title

UI-ServiceManagementOverview-CustomerContractToRenew

SELECT CustomerContract AS c WHERE c.end_date < DATE_ADD(NOW(), INTERVAL 30 DAY)

UI-ServiceManagementOverview-ProviderContractToRenew

SELECT ProviderContract AS c WHERE c.end_date < DATE_ADD(NOW(), INTERVAL 30 DAY)