SELECT DISTINCT entry_blog_id, e.entry_id, entry_excerpt, entry_created_on, entry_title, author_name, topic_posts_approved, aux.topic_id, az.MediumImageURL img
                FROM mt_entry e, mt_author a, aux_mt_entry aux
                LEFT JOIN ". TOPICS_TABLE ." t ON (aux.topic_id = t.topic_id)
                LEFT JOIN az_main az ON (aux.ASIN = az.ASIN)
                WHERE entry_author_id = author_id
                    AND e.entry_id = aux.entry_id
                    AND e.entry_status = 2
                    AND e.entry_blog_id = 7
                ORDER BY entry_created_on DESC LIMIT 15";
                $result = $pdo->query($sql);
 
                $x = 0;
                $format = 'excerpt';
                while ($row = $result->fetch()) {
                    $x++;
                    $ts = strtotime($row['entry_created_on']);
                    $y = date('Y', $ts);
                    $m = date('m', $ts);
                    $ts_offset = $ts + $user->data['time_zone_offset'];
                    $entry = getEntryInfo($row['entry_blog_id']);
 
                    $entry['date'] = getDateString($ts);
                    $entry['link'] = "/$entry[blog_dir]/$y/$m/". dirify($row['entry_title']) .".php";
                    $entry['title'] = $row['entry_title'];
                    $entry['author'] = $row['author_name'];
                    $entry['excerpt'] = $row['entry_excerpt'];
                    $entry['entry_type'] = $entry_type;
                    $entry['topic_posts_approved'] = $row['topic_posts_approved'];
                    $entry['topic_id'] = $row['topic_id'];
                    $entry['image_src'] = $row['img'];
 
                    # Get categories
                    $sql = "
                    SELECT c.category_label, c.category_id FROM mt_category c, mt_placement p
                    WHERE {$row['entry_id']} = p.placement_entry_id
                        AND c.category_id = p.placement_category_id";
                    $res_categories = $pdo->query($sql);
                    $entry['catlinks'] = array();
                    while ($row_category = $res_categories->fetch()) {
                        $entry['catlinks'][] = '<a href="/category.php?id='. $row_category['category_id'] .'&category='. urlencode(stripslashes($row_category['category_label'])) .'">'. stripslashes($row_category['category_label']) .'</a>';