t966pk750

CREATE TABLE sandbox.yurbasov_t966pk750_secret
AS
WITH a AS
(
SELECT * FROM secret.regno s WHERE UPPER(regno) = 'Т966РК750'
), b AS
(
 SELECT * FROM a LEFT JOIN city_event_data.d_calc0a_regno_x_phoneno x ON x.carno = a.regno_hash
) SELECT * FROM b LEFT JOIN secret.phones s ON s.phone_hash = b.phoneno