Testing highlighting of code

Testing
1

Adding Inactive Users SQL, and wondering if I see the highlighting:

WITH posts_by_user AS (
  SELECT
    COUNT(*) AS posts,
    user_id
  FROM
    posts
  GROUP BY
    user_id
)
SELECT
  u.id,
  u.username_lower AS "username",
  u.trust_level,
  us.post_count,
  to_char(us.first_post_created_at, 'YYYY-MM-DD') as "first_post_created",
  to_char(u.created_at, 'YYYY-MM-DD') as "created_at",
  to_char(u.last_seen_at, 'YYYY-MM-DD') as "last_seen"

FROM
  users u
  LEFT JOIN posts_by_user pbu ON pbu.user_id = u.id
  LEFT JOIN user_stats us ON us.user_id = u.id
WHERE
  u.active = TRUE
  AND u.trust_level = 0
  AND u.last_seen_at::date < (CURRENT_TIMESTAMP - INTERVAL '2 years')
  AND posts IS NULL
--  AND us.posts_read_count < 10
--  AND us.first_post_created_at IS NULL
ORDER BY
  u.last_seen_at DESC
2

Testing Rails console commands (using Ruby):

[4] pry(main)> SiteSetting.display_name_on_posts
=> false
[5] pry(main)> User.where(trust_level: 4).count
  User Count (5.3ms)  SELECT COUNT(*) FROM "users" WHERE "users"."trust_level" = 4
=> 21

and this for my hosted site:

➜  discourse git:(main) ms c doerr
[mothership] Found site 'doerr' (http://doerr.trydiscourse.com cluster: 'doerr')
[1] pry(main)> GlobalSetting.s3_cdn_url
=> "https://global.discourse-cdn.com/doerr"
[2] pry(main)> GlobalSetting.cdn_url
=> "https://yyz1.discourse-cdn.com/doerr"
3

Nice. After a deploy, the fix was picked up and I’m getting the highlighted syntax.