SELECT

channel_id,

CAST(channel_name AS String) AS channel_name,

CAST(comments_about_channel AS String) AS comments_about_channel,

CAST(username AS String) AS username,

snapshot_datetime

FROM

(

SELECT

channel_id,

channel_name,

comments_about_channel,

username,

snapshot_datetime,

rank

FROM

(

SELECT

groupArray(channel_id) AS channel_ids,

groupArray(channel_name) AS channel_names,

groupArray(comments_about_channel) AS comments_about_channel,

groupArray(username) AS username,

groupArray(snapshot_datetime) AS snapshot_datetimes

FROM

(

SELECT

x.channel_id,

x.channel_name,

x.comments_about_channel,

x.username,

x.snapshot_datetime

FROM

adteam_backend.channels x

ORDER BY

x.channel_name ASC, x.snapshot_datetime DESC

)

) array JOIN channel_ids AS channel_id,

channel_names AS channel_name,

comments_about_channel AS comments_about_channel,

username AS username,

snapshot_datetimes AS snapshot_datetime,

arrayEnumerateUniq(channel_names) AS rank

)

WHERE

rank = 1

AND

channel_id IN (1365043287)