$products = $category->getProducts((int)($params['cookie']->id_lang), 1, ($nb ? $nb : 10));

$products = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
        SELECT p.`id_product`, pl.`name`
        FROM `'._DB_PREFIX_.'product` p
        LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product`)
        WHERE pl.`id_lang` = '.(int)($params['cookie']->id_lang).' AND p.`available_for_order` = 0
        ORDER BY pl.`name`');