Alias name is same as column name [closed]

You have aliased two columns as published.

a.published,

and

CASE a.type
WHEN N'component' THEN a.published+2*(e.enabled-1)
WHEN N'url' THEN a.published+2
WHEN N'alias' THEN a.published+4
WHEN N'separator' THEN a.published+6 END AS published,