SELECT
Query AS "Ключевая фраза",
SUM(CASE WHEN (Updated = '2021-05-20' AND RegionCode = 54) THEN Yandex ELSE 0 END) AS "Yandex ekb",
SUM(CASE WHEN (Updated = '2021-05-20' AND RegionCode = 193) THEN Yandex ELSE 0 END) AS "Yandex vor"
FROM Queries c
LEFT JOIN SitePositions o ON c.Id = o.QueryId
WHERE SiteId = 33
GROUP BY QueryId, Query;
SELECT
ID,
tel_balance1 * (tel1 LIKE "38090%") +
tel_balance2 * (tel2 LIKE "38090%") +
tel_balance3 * (tel3 LIKE "38090%") AS balance_38090
FROM
telephone
WHERE
tel1 LIKE "38090%"
OR tel2 LIKE "38090%"
OR tel3 LIKE "38090%"
;