$this->db->select('products.products_id, products_name, products_uri, products_ean, products_image_type, products_price, products_stock_quantity');
$this->db->from('products');
$this->db->join('products_stock', 'products.products_id = products_stock.products_id');
$this->db->where('products_is_displayed', 1);
$this->db->where('products_image_type !=', 'none');
$this->db->order_by('products_time_add', 'desc');
$this->db->limit($limit);
$query = $this->db->get();
return $query->result_array();