Digital Cinema

            <div align="center" style="margin:5px 0;">
                <? include(BASE_DIR .'/ads/mrectangle.php');?>
            </div>
            <br />
 
            <div class="item"><span class="corners-top"><span></span></span>
                <h2>Other Categories</h2>
                <ul class="brownsquare"><?
                    $qry = "
                    SELECT category_label label, COUNT(*) num
                    FROM mt_entry e, mt_placement p, mt_category c
                    WHERE e.entry_blog_id IN (". INCLUDE_BLOGS_ALL .")
                        AND entry_status = 2
                        AND entry_id = p.placement_entry_id
                        AND p.placement_category_id = c.category_id
                    GROUP BY label
                    ORDER BY label";
                    $result = mQuery($qry);
                    while ($category = mysql_fetch_assoc($result)) {
                        echo '<li><a href="/category.php?category='. urlencode($category[label]) .'">'. $category[label] .'</a><span class="grey"> ('. $category[num] .')</span></li>';
                    }
                ?></ul>
            <span class="corners-bottom"><span></span></span></div>
 
            <div class="item"><span class="corners-top"><span></span></span>
                <h2>Columnists</h2>
                <ul class="brownsquare"><?
                    $qry = "
                    SELECT author_id, author_name, COUNT(*) num
                    FROM mt_author a, mt_entry e
                    WHERE e.entry_blog_id IN (". INCLUDE_BLOGS_NO_BULLETINS .")
                        AND entry_status = 2
                        AND entry_author_id = author_id
                    GROUP BY author_id, author_name
                    ORDER BY num DESC";
                    $result = mQuery($qry);
                    while ($author = mysql_fetch_assoc($result)) {
                        echo '<li><a href="/author.php?author='. urlencode($author[author_name]) .'&id='. $author[author_id] .'">'. $author[author_name] .'</a><span class="grey"> ('. $author[num] .')</span></li>';
                    }
                ?></ul>