Дайте пожалуйста пример запроса
/**
* 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();
}