consulta dificil

[sicosis1]

la consulta 2

completa
"
SELECT
REPLACE(opor.cardcode, 'P', '') AS supplier_id,
opor.docnum AS purchase_id
FROM si_negocio_version snv
INNER JOIN opor ON (
opor.u_proyecto = (
RIGHT('000' + CONVERT(varchar, snv.Barrio), 3) +
RIGHT('00000' + CONVERT(varchar, snv.Codigo), 5)
)
)
WHERE
snv.Id_Negocio = %s AND
opor.u_codcategoria = 11 and
opor.canceled = 'n' and
opor.docstatus = 'o'
%s
",
$project_id,
(strlen($supplier_id) ? sprintf(" AND opor.cardcode = '%sP' ", $supplier_id) : NULL)