Подзапросы в SQL сначала могут казаться запутанными, но на деле это просто запросы, которые передают данные другому запросу. В этой статье Абдулла объясняет, как работают подзапросы и где они используются в SQL. Разбираются некоррелированные и коррелированные подзапросы, производные столбцы и таблицы, а также операторы IN, ANY, ALL, EXISTS и многое другое. https://freecodecamp.org/news/how-to-work-with-subqueries-…

Channel
Backend Portal | Программирование
@BackendPortal
On this record: Growth · Engagement · What this channel posts · Advertising · Posts · Posts edited after publishing · Citations · Telegram's recommendations · Cite this entry
16,227subscribers
-95 since we began measuring on 7 August 2026
Risers and fallers across the register · movement among entries of 10,000–31,623.
Register entry
| Telegram ID | -1001633059299 |
|---|---|
| Type | Channel |
| Username | @BackendPortal |
| Description | Присоединяйтесь к нашему каналу и погрузитесь в мир Backend-разработки Связь: @devmangx РКН: https://clck.ru/3FobxK |
| Created | Between 1 December 2021 and 30 April 2023— estimated from Telegram’s id allocation, not measured. How this range is calculated. |
| First recorded | 7 August 2026 |
| Last confirmed live | 21 August 2026 |
| Measurements held | 16 |
| Confirmed unchanged | 1 time, most recently 21 August 2026 |
| On Telegram | t.me/BackendPortal |
Growth
| Measured (UTC) | Subscribers | Change |
|---|---|---|
| 21 Aug 2026, 19:59 | 16,227 | -4 |
| 20 Aug 2026, 16:03 | 16,231 | -11 |
| 19 Aug 2026, 18:11 | 16,242 | -4 |
| 18 Aug 2026, 19:48 | 16,246 | -1 |
| 17 Aug 2026, 19:36 | 16,247 | -5 |
| 16 Aug 2026, 16:59 | 16,252 | -6 |
| 15 Aug 2026, 01:54 | 16,258 | -5 |
| 13 Aug 2026, 15:07 | 16,263 | -18 |
| 12 Aug 2026, 16:14 | 16,281 | -29 |
| 11 Aug 2026, 14:57 | 16,310 | +2 |
| 10 Aug 2026, 16:53 | 16,308 | -10 |
| 9 Aug 2026, 20:12 | 16,318 | +4 |
| 8 Aug 2026, 18:37 | 16,314 | -6 |
| 7 Aug 2026, 18:34 | 16,320 | -2 |
| 7 Aug 2026, 07:00 | 16,322 | no change |
| 7 Aug 2026, 06:58 | 16,322 | first reading |
Engagement
58 posts held, back to 29 July 2026 — the reader has not yet reached the start of this channel’s public history, so older posts may sit further back, unread. Read across 33 pagesof Telegram’s post history, 20 posts per page.
- ERR · 30 days
- 7.29%
- avg views ÷ 16,227 subscribers
- Avg views / post
- 1,180
- 58 posts measured
- Reaction rate
- —
- this channel exposes no reaction counts
- Posts in window
- 58
- of 58 held
ERR is average views per post over the last 30 days divided by subscribers, the definition TGStat uses, so this figure is comparable with the one you will see elsewhere. It falls structurally as a channel grows: a high ERR on a small channel and a low one on a large channel describe reach mathematics, not quality. We publish the figure and the sample it came from and pass no verdict on it.
ER is defined industry-wide as (forwards + reactions + comments) ÷ views— note the denominator is views, not subscribers. Telegram’s public web preview carries views and reactions but not forward or comment counts, so the reaction rate above is the reactions term only and is therefore a floor: the true ER for this channel is higher by an amount we have not measured and will not estimate.
| Window | Rolling 30 days · latest post in window 22 August 2026 |
|---|---|
| Posts held | 58 (29 July 2026 – 22 August 2026) |
| Views total | 68,658 |
| Reactions total | — |
| Forwards / comments | not exposed by the public surface — not measured, not estimated |
| Readings taken | 22 Aug 2026, 11:15 UTC |
Views are a single reading per post, taken at the time above. A post published in the last day or two is still accumulating views, which pulls the 30-day average down slightly. That is a property of the standard definition rather than a fault in it, so we keep the definition rather than “correcting” the number into something nobody can reproduce.
Precision. Telegram publishes view counts on its public widget in short form — 8.12K, 3.7M — so any reading at or above 1,000 reaches us rounded to three significant figures, and only counts below 1,000 are exact. Averages and rates derived from them are shown to the same precision rather than to the unit: a figure like 3,701,250 would assert digits nobody measured.
Reaction counts are published per emoji and rounded the same way, so a total below 1,000 is exact and a larger one is a sum that may carry a rounded component from each emoji above 1,000. Because it is a sum, it does not look rounded — read a large reaction total as three significant figures per contributing emoji rather than as the figure it prints.
What this channel posts
- Photos
- ≈1,770
- Videos
- ≈168
- Links
- ≈1,490
Lifetime counters from Telegram’s own channel header, read 22 August 2026 — not the date at the top of this page, which is when the subscriber count was last read. A count marked ≈ was rounded by Telegram before we ever saw it — t.me prints these counters in full below 1,000 and to three significant figures above, so ≈142,000 means somewhere between 141,500 and 142,499.
- Video runtime
- 1m 59s
- Average length
- 20s
Measured directly from 6 videos with a duration reading, out of the posts we hold for this channel — not this channel’s whole posting history, only the sample this register has actually read. An exact reading to the second, taken from the post itself rather than from Telegram’s own rounded chrome, so it carries no ≈ mark.
Advertising
- Ad load
- 5.17%
- 3 of 58 posts carry an ad marker
- Regulatory tokens
- 3
- posts carrying an erid · 3 distinct tokens
- Median views · ads
- 835
- over 3 measured posts
- Median views · rest
- 1,300
- over 55 measured posts
An ad marker, not a judgement about a post. A post is counted here because it carries one of two explicit markings: an erid token, which Russian law has required on paid placements since 2022 and which is issued against a specific advertising contract, or a #реклама / #ad hashtag in the body, which is the channel declaring it itself. The first is documentary; the second is a self-declaration and is weaker. No classifier reads the text and decides — nothing on this site guesses that a post is an advertisement.
This is a floor, and it can only ever be a floor.A channel that runs paid placements without marking them produces no marker for us to count, and an unmarked ad is indistinguishable from an ordinary post on the public surface. The ad load above therefore means “the share of posts that declared themselves”, never “the share of posts that were paid for”. A low figure is not evidence of a channel that runs few ads.
Both figures are medians, and no ratio between them is published. Each is a view reading that actually occurred on a post, picked by percentile_disc rather than averaged, so one viral post cannot move it and no interpolated value is invented between two readings. The sample on one side is under five posts, which is too thin to compare. The two figures are shown side by side with the count behind each, and deliberately not divided into a headline like “ads get x% fewer views” — an arithmetic that is easy to print and, at this sample size, means nothing.
| erid | Posts | First seen | Last seen |
|---|---|---|---|
| 2SDnjdAYnyZ | 1 | 11 August 2026 | 11 August 2026 |
| 2Vtzqw8Jxi7 | 1 | 21 August 2026 | 21 August 2026 |
| 2W5zFJ4QEWu | 1 | 20 August 2026 | 20 August 2026 |
A token repeated across several posts is one advertising contract placed more than once, which is what the identifier is for. The strings are reproduced exactly as they appeared in the post or in its click-through URL and are not validated against any registry — we record the marker a channel published, and whether it resolves to a real contract is a question for the register that issued it.
Measured over the 58 most recent posts we hold, published 29 July 2026 to 22 August 2026. Views are the latest single reading held for each post, and any reading at or above 1,000 is rounded by Telegram to three significant figures.
Recent posts
Shell Gym – интерактивный тренажёр командной строки Linux, созданный на основе многолетнего опыта преподавания. По сути, автор выделил ядро iximiuz Labs и превратил его в отдельный демон. https://github.com/iximiuz/shellgym 👉 @BackendPortal
Вам доклады по Go или Java? VK приглашает на митап с двойной начинкой 26 августа VK собирает Go- и Java-инженеров, чтобы прокачать знания. В программе два трека — Go и Java, по три доклада в каждом. Трек Go: • «Компиляция Go в динамическую либу, или как мы ускорили выкатку фичи в два раза, но нам не понравилось», Михаил Кичигин, бэкенд-разработчик, Avito Tech • «Go-платформа VK: как мы построили единую основу для с…
С Lazydocker работать с Docker становится заметно проще Lazydocker – это опенсорс TUI для управления Docker и Docker Compose прямо из терминала. В одном интерфейсе можно смотреть контейнеры, сервисы, логи и метрики, а также перезапускать, удалять и пересобирать контейнеры или подключаться к ним, без постоянного ввода Docker-команд. github.com/jesseduffield/lazydocker 👉 @BackendPortal
20 Kubernetes-челленджей Итак, вот 20 вопросов (и ответов): 1. Подсчёт endpoints 2. Ждём чуда 3. Я сказал стоп 4. Проектирование shared-кластеров 5. Kernel panic 6. Прыгай, кролик 7. Сколько — это слишком много 8. Держим свет включённым 9. Прожорливый etcd 10. Умножение pod’ов 11. В одиночку 12. Rollin’ 13. All you can eat 14. Bounce 15. В кроличью нору 16. Throttled 17. Липкий бардак 18. Жив или м…
Репозиторий TypeScript больше не на JavaScript. Теперь он на Go. TypeScript 7 только что влили в основную ветку. ✓ Нативный компилятор — до 10 раз быстрее ✓ Значительная часть JavaScript-кода уходит в прошлое Конец одной эпохи. И начало другой: https://github.com/microsoft/TypeScript/pull/63763
🐻 GitFlic — в учебный процесс МГТУ им. Баумана Кафедра «Защита информации» ИУ10 переводит лабораторные работы с Gitea на GitFlic. Студенты будут изучать практики безопасной разработки (РБПО) на реальном промышленном инструменте — не на учебных упрощенках. Бауманка готовит специалистов по ИБ, которые через несколько лет придут в компании, где уже стоит задача выстраивать безопасную разработку по российским стандарта…
Разработчику стоит знать основные концепции системного дизайна. Это помогает показать потенциальным работодателям, что вы умеете превращать требования к архитектуре в готовый к продакшену код. В курсе разбираются архитектура приложений, проектирование API, кэширование, сети, базы данных и многое другое. https://freecodecamp.org/news/learn-system-design-principles/ 👉 @BackendPortal
Когда Claude Code, Codex или Gemini работают с большим репозиторием, проблема уже не в генерации кода, а в потере контекста. Новая AI-сессия заново изучает проект, не помнит архитектурные решения и может нарушить внутренние правила разработки. AI Council добавляет AI-агентам постоянную память о проекте и связывает ее с реальным кодом. Что умеет: 🔸 строит граф по исходному коду 🔸 сохраняет архитектурные решения, к…
Этот репозиторий на GitHub собрал больше 1000 бесплатных публичных API практически на любой случай. Финансы, погода, карты, музыка, игры, машинное обучение, крипта, транспорт, наука, безопасность и десятки других категорий — всё собрано в одном месте. Полезная штука, если нужен готовый API для пет-проекта, прототипа или тестирования идеи. https://github.com/public-apis/public-apis 👉 @BackendPortal
Похоже, это один из самых полных справочников по самостоятельному хостингу. Огромный открытый гайд со всем, что нужно для старта и дальнейшего изучения self-hosting: Docker, Kubernetes, базы данных, LLM, сети, Raspberry Pi, Home Assistant, безопасность, программирование и ещё куча всего. Если давно хотели научиться запускать собственный софт вместо того, чтобы зависеть от SaaS-сервисов, это точно стоит сохранить. …
Бенчмарки – оружие массового заблуждения? E2E-бенчмарк может показать впечатляющие цифры, но при этом тестовые сценарии расходятся с реальностью. Что с этим делать расскажет Антон Курако на JVM Day от Т-Банка – конференции для Java-, Scala- и Kotlin-разработчиков, архитекторов и тимлидов. Спикер объяснит, где заканчивается полезное измерение и начинается погоня за красивыми показателями, а также как проверять произв…
Showing the 12 most recent of 58 posts we hold for @BackendPortal. View and reaction counts are the latest single reading for each post, not a live figure, and a recent post is still accumulating both. A view count marked ≈ was rounded by Telegram before we ever saw it — t.me prints views in full below 1,000 and to three significant figures above, so ≈1,200,000 means somewhere between 1,150,000 and 1,249,999. Unmarked counts are exact. Text is reproduced from the public post preview and truncated for length.
Posts edited after publishing
@BackendPortal edited 1 post after it first published — the same permalink now carries different wording than the one this register originally read, caught because our own crawl held a copy of the earlier text.
An edit is not deception. Typo fixes, price updates and corrections look exactly like this too — this register can tell you the wording changed and when, not why. How this is measured.
- First edit seen
- 10 August 2026
- Most recent edit
- 10 August 2026
Citation-graph rank
Citation-graph rank — 541,995 of 1,583,249entries in the measured graph. A weighted position computed from the forward and mention edges below — republished posts weigh more than named mentions — and recomputed periodically, over the whole graph. Published only as this ordinal position, never as a score: a position is a fact, and a score printed beside one channel’s name would read as a verdict this register does not make. The two counts beneath stay separate for the same reason mentions are never summed with forwards anywhere else on this page — a named-by count costs nothing to manufacture. The top 100 by this measure, or how it is computed.
Forward network
Republished by
Channels on the register that have forwarded this channel's posts into their own feed.
Built only from forwarded posts we have actually read, on both sides. Coverage is early and deliberately incomplete: a missing link means we have not read the post that would prove it, never that the relationship does not exist. Counts are distinct forwarded posts observed, so they only ever go up as we read more.
Mentions
Named by 2 registered channels — every channel on the register whose own posts have named this one, by its current username or any other username it currently holds, merged from two separately captured readings of the same fact so a namer caught by only one of them is not missed and a namer both caught is not counted twice. A username this channel has since dropped is not matched — that handle may belong to someone else now, and crediting today’s namer to yesterday’s owner would misattribute it.
Named by
Channels on the register whose posts name this channel's handle.
Names
Channels on the register whose handles appear in this channel's posts.
A mention is a weaker signal than a forward and is counted separately for that reason — naming a channel is not republishing it, and a handle in a post body is easy to place deliberately. The post counts beside each row below are distinct posts in which the handle appeared, from posts we have read on both sides — the “Named by N registered channels” figure above is a different count, of distinct NAMING CHANNELS rather than posts, and is not the sum of the rows under it.
Appears in Telegram’s recommendations for other channels
The reverse of the list above, and a different kind of signal. This does not require this channel to have ever been asked about directly — each row below is a channel we DID ask Telegram about, whose Telegram-generated list happened to include this one. A channel can appear here with an empty list above it, because being named by someone else’s query is independent of having been queried itself.
@IT_Portal · 101,232
Telegram ranks this channel #5 of 78 here — alongside 77 others — read 15 August 2026
@python_piton_javascript · 128,051
Telegram ranks this channel #23 of 84 here — alongside 83 others — read 13 August 2026
@trendo · 69,017
Telegram ranks this channel #29 of 90 here — alongside 89 others — read 20 August 2026
@ai4telegram · 872,570
Telegram ranks this channel #29 of 73 here — alongside 72 others — read 8 August 2026
@howdyho_official · 80,043
Telegram ranks this channel #30 of 90 here — alongside 89 others — read 18 August 2026
@sovuche · 104,937
Telegram ranks this channel #93 of 94 here — alongside 93 others — read 21 August 2026
This channel appears in 6 seed channels' Telegram-generated recommendation lists in total. Each is Telegram’s list for THAT channel, not this one — see how this is measured.
Cite this entry
A live page changes as we take new readings, so a citation should name the measurement it is based on, not just the URL. The line below cites the subscriber count as measured 21 August 2026 — this entry's latest reading, not the date you are reading this.
“Backend Portal | Программирование” (@BackendPortal), 16,227 subscribers as measured 21 August 2026. Telegram Register, tgregister.com/channel/BackendPortal.
Full measurement history, CC BY 4.0. Every reading this register holds for this entry, not just the latest one, as a dated, downloadable record: CSV · JSON. Free to use with attribution to tgregister.com. Each file carries its own generation timestamp, which is the figure to cite for exactly when the data was retrieved.