Categorías
ARS 234.38
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 959 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1493.10
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 1587 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1015.64
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 1091 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1010.59
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 1081 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 935.52
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 1402 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 0.66
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 1403 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 374.31
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 1191 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1463.03
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 171 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1753.50
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 994 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1760.38
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 531 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1760.38
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 398 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1756.11
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 922 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 0.66
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 957 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 370.51
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 886 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 2075.45
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 130 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 413.26
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 568 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1760.38
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 397 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1763.78
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 778 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1763.78
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 582 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 1529.50
{{
GBP_LIST;
NAME:=stockb;
SQLSCRIPT:=
select
tpli.semaphoreValue
FROM tbitem ti
INNER JOIN tbBrand tbr
ON ti.brand_id = tbr.brand_id
INNER JOIN vwWebSiteII_ItemsData tpli
ON tpli.comp_id = ti.comp_id
AND tpli.item_id = ti.item_id
AND tpli.prli_id = {(GBP_PRICELIST)}
INNER JOIN tbsysCurrency tc
ON tc.curr_id = tpli.curr_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c
ON i4c.item_id = ti.item_id and i4c.ws_guid = '{(gbp_guid)}'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '{(gbp_guid)}'
AND ifav.wsif_isActive ='true'
INNER JOIN vwWebSiteII_ItemsStock tmp2
on tmp2.comp_id = ti.comp_id AND
tmp2.item_id = ti.item_id AND
tmp2.stor_id= {(GBP_STORAGE)}
Where
ti.item_id = 581 AND
tpli.ws_id = '{(GBP_WSID)}';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
{{GBP_INSERTSCRIPT;TEMPLATEPAGE:=BANNER_01}}
{{GBP_INSERTSCRIPT;TEMPLATEPAGE:=BANNER_05}}
{{GBP_INSERTFOOTERSCRIPT}}