Categorías
ARS 4817.08
}stock1.svg)
ARS 5121.43
ARS 5165.36
}stock2.svg)
ARS 7112.39
}stock4.svg)
ARS 2994.41
ARS 3742.97
ARS 3742.97
ARS 4268.16
{{
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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 1428 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 3201.12
{{
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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 653 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 3559.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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 88 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 2134.08
{{
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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 412 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 3557.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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 1156 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 2717.42
{{
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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 498 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 4338.81
{{
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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 246 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 3793.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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 1164 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 3443.60
{{
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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 609 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 3742.97
{{
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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 89 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 4475.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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 245 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 4268.16
{{
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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 800 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
ARS 3593.24
{{
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 = 5
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 = '3b8472e0-28f7-47b2-a241-accd439ed072'
LEFT JOIN tbWebSiteII_Items_Favorites ifav
ON ifav.item_id = ti.item_id and ifav.wsif_guid = '3b8472e0-28f7-47b2-a241-accd439ed072'
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= 1
Where
ti.item_id = 145 AND
tpli.ws_id = '708b8332-9b46-4219-9333-0db7bea760c5';
SQLFIELDS4REPLACE:=§STOCK§;
ITEMSBYPAGE:=8;
TEMPLATEPAGE:=STOCKLI;
}}
{{GBP_INSERTSCRIPT;TEMPLATEPAGE:=BANNER_01}}
{{GBP_INSERTSCRIPT;TEMPLATEPAGE:=BANNER_05}}
{{GBP_INSERTFOOTERSCRIPT}}