-
-
Save ShippingGroup/4c6ecfe6fde140504d4c99ac91058754 to your computer and use it in GitHub Desktop.
_ERP_ECOMMERCE
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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