Currently we update translation record in CX database for save and publish actions. For both, we update the translation URL. But translation URL update should happen only when publishing happens. Otherwise, we just calculate a URL and add to record- a URL that does not exist. But it is ok to update translation title.
If we add translation URL only when translation is published(first time and any time), we can use it as an indication of "translation one published" statistics calculation.
When status changes from published to draft, we should not empty the translation URL if present.
The stats query can then assume that, translation is published at least once, if status = 'published' OR translation URL is not NULL
Also see T89442