$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 .= " ( "; }