$sql = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow('
SELECT cp.id_product, pl.link_rewrite, cp.position, pl.name
FROM '._DB_PREFIX_.'category_product cp
LEFT JOIN '._DB_PREFIX_.'product_lang pl ON (cp.id_product = pl.id_product)
LEFT JOIN '._DB_PREFIX_.'product p ON (cp.id_product = p.id_product)
WHERE p.id_category_default = '.(int)$this->id_category_default.' AND (cp.position < '. (int)($position ) .' ) AND cp.id_category = ' . (int)$this->id_category_default .' AND pl.id_lang = '.(Context::getContext()->language->id).'
ORDER BY cp.position DESC');