/**
   * Gets all items of category same gender
   *
   * @param   string  $gender    Male or female items
   * @param   string  $category  Category from which must be received the items
   * @access  public
   * @return  array              Product id as ID, product name as PRODUCT, brand name as BRAND
   */
  public function get_produts($gender, $category)
  {
    $sql = "SELECT products.`id` AS 'ID', products.`product` AS 'PRODUCT', products.`price` AS 'PRICE', products.`avilable` AS 'AVILABLE', brands.`brand` AS 'BRAND'" .
           " FROM products, categories, products_categories, sex, brands, products_brands" .
           " WHERE categories.`id` = :category" .
           " AND products_categories.`category_id` = categories.`id` "  .
           " AND products.`id` = products_categories.`product_id`" .
           " AND products.`sex_id` = sex.`id`" .
           " AND sex.`name` = :gender" .
           " AND products_brands.`product_id` = products.`id`" .
           " AND products_brands.`brand_id` = brands.`id`";

    return DB::query(Database::SELECT, $sql)
          ->parameters(array(':category' => $category))
          ->parameters(array(':gender' => $gender))
          ->execute();
  }