_ERP_ECOMMERCE

_ERP_ECOMMERCE.slq

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