title: Return MYSQL results based on a sub query count?
body: <p>Is there a way to adjust the following MYSQL query so that it only shows results where the video count is greater than 0? I have tried the following but it doesn't recognise </p>
  
  <blockquote>
    <p>video_count</p>
  </blockquote>
  
  <pre><code>SELECT channels.*, 
  (SELECT COUNT(*) FROM videos WHERE videos.video_publisher_id = channels.channel_id) as `video_count` 
  FROM channels 
  WHERE  channel_active = 1
  AND video_count &gt; 0
  AND channel_thumbnail IS NOT NULL
  ORDER BY channel_subscribers DESC
  </code></pre>