كم عدد مستخدمي TL3 لديك؟ هل متطلبات TL3 فعلاً منطقية؟

[ganncamp (G Ann Campbell)]

@Roi لقد نشرت تقريرًا عن فجوة TL3 منذ حوالي عام وقمّت بتحديثه عدة مرات منذ ذلك الحين:

Find the users which are more likely to become TL3

One more time! I’ve only just realized that the likes for TL3 are last-100-days! Corrected for that: WITH t as ( select CURRENT_TIMESTAMP - ((0 + 100) * (INTERVAL '1 days')) as start, CURRENT_TIMESTAMP - (0 * (INTERVAL '1 days')) as end ), -- Topic count last 100 days 25% -- lesser of 25% topics created in last 100 days -- OR 500, the system default max requirement for TL3 tclhd AS ( SELECT LEAST(floor(count(id)*.25)::REAL,500) as all_topics FROM topics, t …