How to write an additional field is_x in SQL if the row id from this table is in another table?

Question

MySQL

Please tell me how can I write a SQL query so that a "dynamic" field is added to the current table, which will be true if the row ID is in another query, false if it is not there.
Example:
article -> popular
article.is_popular if exists in SELECT * FROM `articles` WHERE `views` > 10000
something like this

Answer 1

Issue resolved.

SELECT *, CASE 
            WHEN EXISTS (SELECT * FROM `articles` as trends WHERE `views` > 10000 AND WHERE trends.`id` = `articles`.id) 
               THEN 1 
               ELSE 0 
       END AS is_popular
FROM `articles`