$sql .= " LEFT JOIN " . $table_prefix . "articles_categories c ON c.category_id=a.category_id)";
$sql .= " WHERE a.article_id IN (" . $db->tosql($articles_ids, INTEGERS_LIST) . ") ";
$sql .= " AND c.category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")";
$db->query($sql);
$categories_ids = array();
$allowed_categories = array();
while ($db->next_record()) {
$article_id = $db->f("article_id");
$ic_id = $db->f("category_id");
$ic_name = get_translation($db->f("category_name"));
$ic_name = get_currency_message($ic_name, $currency);
$categories_ids[] = $ic_id;
$articles_categories[$article_id][] = array($ic_id, $ic_name);
}
if ($categories_ids) {
$allowed_categories = VA_Articles_Categories::find_all_ids("c.category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")", VIEW_CATEGORIES_ITEMS_PERM);
}
}
// use paging for showing articles list
$db->RecordsPerPage = $records_per_page;
$db->PageNumber = $page_number;
$sql = " SELECT a.article_id, a.article_title, a.friendly_url, a.article_date, a.date_end, ";
$sql .= " a.author_name, a.author_email, a.author_url, a.link_url, a.download_url, ";
$sql .= " a.short_description, a.is_html, a.full_description, a.is_remote_rss, a.details_remote_url, ";
$sql .= " a.image_small, a.image_small_alt, a.image_large, a.image_large_alt, a.stream_video, ";
$sql .= " a.stream_video_width, a.stream_video_height, a.stream_video_preview, ";
$sql .= " a.rating, a.allowed_rate, ";
$sql .= " a.keywords, a.notes FROM ";
if ($articles_order_column == "article_order" && !$is_search) {
$sql .= " ( ";
}
