clickhousedb error: :HTTPDriver for http://52.87.214.127:8123 returned response code 404) Code: 60. DB::Exception: Unknown table expression identifier 'b_random' in scope SELECT s.user_id AS user_id, s.paid_at, c.event_time, c.function_name, multiIf(s.member_cycle IN ('tried7_monthly', 'tried14_monthly', 'quarterly2', ''), 'unknown', concat(s.member_level, '_', s.member_cycle)) AS combination_div, multiIf(s.subtotal = s.amount_paid, 'no discount', 'discounted') AS discount_or_not, b.country, b.country_div FROM stripe_bills AS s LEFT JOIN chat_records AS c ON s.user_id = c.user_id LEFT JOIN b_random AS b ON (s.user_id = b.user_id) AND (b.rn = 1) WHERE (s.status = 'paid') AND (right(s.serial, 4) = '0001') AND (s.paid_at > c.event_time) ORDER BY s.user_id ASC LIMIT 10001. (UNKNOWN_TABLE) (version 24.3.2.23 (official build))

The error message you're seeing is coming from ClickHouse, a column-oriented database management system. It's saying that it doesn't recognize 'b_random' as a table expression identifier. This could be because the table doesn't exist, or there's a typo in the name.

Here's a step-by-step guide to troubleshoot this issue:

1. Check if the table 'b_random' exists: You can do this by running a simple SELECT statement like SELECT * FROM b_random LIMIT 1;. If you get a similar error, then the table doesn't exist.

2. Check for typos: Make sure that the table name in your query matches exactly with the actual table name. Remember that table names are case-sensitive.

3. Check your JOIN clause: The error could be due to the way you're joining the 'b_random' table with the 'stripe_bills' and 'chat_records' tables. Make sure that the ON condition is correct.

4. Check the version of ClickHouse you're using: The error message mentions version 24.3.2.23. You might want to check if there are any known issues with this version that could be causing the problem.

If none of these steps solve the issue, you might want to consider reaching out to the ClickHouse community or support for further assistance.