Skip to content

Instantly share code, notes, and snippets.

@ShippingGroup
Last active Jul 30, 2018
Embed
What would you like to do?
_ERP_ECOMMERCE
select
A.ID,
A.DESCRIPCION,
CAST(A._DESCRIPTION AS VARCHAR(8000)) as DESCRIPTION,
isnull(S.SAL_DISP,0) as SAL_DISP,
CAST(A._TAG AS VARCHAR(8000)) as TAG,
CAST(A._META_TITLE AS VARCHAR(8000)) as META_TITLE,
isnull(P.PRECIO,0) as PRECIO,
CAST(A._META_DESCRIPTION AS VARCHAR(8000)) as META_DESCRIPTION,
A.PESO,
CAST(A._META_KEYWORD AS VARCHAR(8000)) as META_KEYWORD,
A.VOLUMEN
from ERP_ARTICULOS A
join ERP_PARAMETROS T on 1=1
left join ERP_PRE_VEN P on P.FK_ERP_ARTICULOS = A.ID and P.FK_ERP_LIS_PRECIO = T._FK_LIS_PRE_ECOMMERCE
left join _SAL_DISP_ECO S on S.FK_ERP_ARTICULOS = A.ID
where A._ES_ECOMMERCE = 1 and
A.PESO is not null and
A.VOLUMEN is not null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment