NUTRISHOP
*PAGE-EXECUTERROR-> 2- Query Error, enter in Design mode to visualize. {{ GBP_SQLREPLACE; SQLSCRIPT:= declare @catgrupo as int declare @buscar as int set @catgrupo = 2 set @buscar = 1 select TOP 1 CASE @buscar WHEN 1 THEN 'Categorias: ' ELSE '"BCAA's Aminoacidos Ramificados" en: ' END, CASE @catgrupo WHEN 1 THEN '' + tcatg.catg_desc + '' WHEN 2 THEN '' + tcatg.catg_desc + '' + ' » ' WHEN 3 THEN '' + tcatg.catg_desc + '' + ' » ' WHEN 5 THEN 'todas las categorias' END, CASE @catgrupo WHEN 1 THEN '' WHEN 2 THEN '' WHEN 3 THEN '' WHEN 5 THEN '' END, CASE @catgrupo WHEN 1 THEN '' WHEN 2 THEN '' + tcat.cat_desc + '' WHEN 3 THEN '' + tcat.cat_desc + '' WHEN 4 THEN '' + tcat.cat_desc + '' WHEN 5 THEN '' END, CASE @catgrupo WHEN 1 THEN '' WHEN 2 THEN '' WHEN 3 THEN '»' WHEN 5 THEN '' END, CASE @catgrupo WHEN 1 THEN '' WHEN 2 THEN '' WHEN 3 THEN '' + tsub.subcat_desc + '' WHEN 5 THEN '' END from tbitem ti inner join tbCategory tcat on ti.comp_id = tcat.comp_id and ti.cat_id = tcat.cat_id INNER JOIN TBSUBCATEGORY TSUB ON TSUB.COMP_ID = TI.COMP_ID and TSUB.CAT_ID = TI.CAT_ID and TSUB.subcat_id = TI.subcat_id INNER JOIN TBCATEGORYGROUP TCATG ON TCATG.COMP_ID = TI.COMP_ID and TCATG.CATG_ID = TCAT.CATG_ID where ( @catgrupo = 1 AND (1=1) OR @catgrupo = 2 AND (tcat.cat_id = '1064') OR @catgrupo = 3 AND (tsub.subcat_id = '') OR @catgrupo = 5 AND (1=1) ); SQLFIELDS4REPLACE:=§PATH1§,§PATH2§,§PATH3§,§PATH4§,§PATH5§,§PATH6§; }} {{ GBP_SQLREPLACE; SQLSCRIPT:= declare @catgrupo as int set @catgrupo = 2 select CASE @catgrupo WHEN 1 THEN 'Categorias' WHEN 2 THEN 'SubCategorias' WHEN 3 THEN '' WHEN 4 THEN '' WHEN 5 THEN 'Categorias' END; SQLFIELDS4REPLACE:=§CATTIT§; }}

BCAA's Aminoacidos Ramificados

§PATH1§ §PATH2§ §PATH3§ §PATH4§ §PATH5§ §PATH6§

Ordenar Por:

{{GBP_INSERTSCRIPT; TEMPLATEPAGE:=listado4;}}
{{GBP_INSERTSCRIPT; TEMPLATEPAGE:=listado4count;}}

{{GBP_INSERTFOOTERSCRIPT}}