Кирилл Новак

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`