***error querying data: select prodnum, product_code, product_name, p.PRESENTATION,TYPEOF,FEATURED,cast(price as int) intprice,
case FEATURED when 1 then 'novid' else 'x' end novidade,
description, resume,
case
when categ_id=3 then
case
when ':perfilUsuario' in ('confederado','admin') then
case
--aluno
when exists (select nome_atleta from atleta where email=':codUsuario' and professor_graduacao =p.days_to_start ) then price*0.25
else price*0.5
end
when ':perfilUsuario'='atleta' then
case
--aluno
when exists (select nome_atleta from atleta where email=':codUsuario' and professor_graduacao =p.days_to_start ) then price*0.75
else price*1.0
end
else
price*1.0
end
when categ_id in (1,5) then -- inscricao
null
else
case
when ':perfilUsuario' in ('confederado','admin') then
price * (1 - coalesce(p.promo_value/100.0,0))
else price
end
end
showprice,
promo_value,featured,active,
m.*,
(select nome_atleta from atleta where atleta_id=p.days_to_start) autor1,
(select nome_atleta from atleta where atleta_id=p.WEIGHT_G) autor2,
/*case when p.categ_id=3 then prod_url --'/canal-luta-preview/'||cast(prodnum as varchar)
else prod_url --'/compra-produto/'||product_code
-- case when left(':codUsuario',7)='anonimo' then m.url_externa else p.prod_url end
end
*/
case when left(':codUsuario',7)<>'anonimo' then
prod_url
else
case when categ_id<>1 then 'https://canaldaluta.cblle.com.br/' else '' end || url_externa
end
page_name,
case
when p.categ_id=3 then
'https://img.youtube.com/vi/' || target_url || '/0.jpg'
else '/emp/1008/galeria/' || nome_url
--case when left(':codUsuario',7)='anonimo' then m.url_externa else p.prod_url end
end imageurl,
coalesce( (select 'ass' from sale s, sale_item i
where i.sale_id=s.sale_id and sale_status='P'
and s.customer_id in (select atleta_id from atleta where email = ':codUsuario')
and i.product_code='video-'||cast(p.prodnum as varchar)
), 'nas')
assinado
,case when product_code=':param1' then 1 else 2 end supord
, case when categ_id in (1,5) then 'consulte' else '' end compl_preco
from product p, ga_midia m
where p.active=1 and FEATURED=1 and price>0 and 0 in (0,p.categ_id)
and m.ATIV_PARA=p.prodnum
and m.ordem=1
-- and ( ( ':perfilUsuario' in ('confederado','admin') and left(':codUsuario',7)<>'anonimo') or (left(':perfilUsuario',4)='raiz' and m.url_externa is not null) )
and m.url_externa is not null
order by supord, FEATURED desc, prodnum desc error message: select prodnum, product_code, product_name, p.PRESENTATION,TYPEOF,FEATURED,cast(price as int) intprice,
case FEATURED when 1 then 'novid' else 'x' end novidade,
description, resume,
case
when categ_id=3 then
case
when 'raiz 018' in ('confederado','admin') then
case
--aluno
when exists (select nome_atleta from atleta where email='anonimos' and professor_graduacao =p.days_to_start ) then price*0.25
else price*0.5
end
when 'raiz 018'='atleta' then
case
--aluno
when exists (select nome_atleta from atleta where email='anonimos' and professor_graduacao =p.days_to_start ) then price*0.75
else price*1.0
end
else
price*1.0
end
when categ_id in (1,5) then -- inscricao
null
else
case
when 'raiz 018' in ('confederado','admin') then
price * (1 - coalesce(p.promo_value/100.0,0))
else price
end
end
showprice,
promo_value,featured,active,
m.*,
(select nome_atleta from atleta where atleta_id=p.days_to_start) autor1,
(select nome_atleta from atleta where atleta_id=p.WEIGHT_G) autor2,
/*case when p.categ_id=3 then prod_url --'/canal-luta-preview/'||cast(prodnum as varchar)
else prod_url --'/compra-produto/'||product_code
-- case when left('anonimos',7)='anonimo' then m.url_externa else p.prod_url end
end
*/
case when left('anonimos',7)<>'anonimo' then
prod_url
else
case when categ_id<>1 then 'https://canaldaluta.cblle.com.br/' else '' end || url_externa
end
page_name,
case
when p.categ_id=3 then
'https://img.youtube.com/vi/' || target_url || '/0.jpg'
else '/emp/1008/galeria/' || nome_url
--case when left('anonimos',7)='anonimo' then m.url_externa else p.prod_url end
end imageurl,
coalesce( (select 'ass' from sale s, sale_item i
where i.sale_id=s.sale_id and sale_status='P'
and s.customer_id in (select atleta_id from atleta where email = 'anonimos')
and i.product_code='video-'||cast(p.prodnum as varchar)
), 'nas')
assinado
,case when product_code='175' then 1 else 2 end supord
, case when categ_id in (1,5) then 'consulte' else '' end compl_preco
from product p, ga_midia m
where p.active=1 and FEATURED=1 and price>0 and 0 in (0,p.categ_id)
and m.ATIV_PARA=p.prodnum
and m.ordem=1
-- and ( ( 'raiz 018' in ('confederado','admin') and left('anonimos',7)<>'anonimo') or (left('raiz 018',4)='raiz' and m.url_externa is not null) )
and m.url_externa is not null
order by supord, FEATURED desc, prodnum desc - Connection is closed select prodnum, product_code, product_name, p.PRESENTATION,TYPEOF,FEATURED,cast(price as int) intprice,
case FEATURED when 1 then 'novid' else 'x' end novidade,
description, resume,
case
when categ_id=3 then
case
when 'raiz 018' in ('confederado','admin') then
case
--aluno
when exists (select nome_atleta from atleta where email='anonimos' and professor_graduacao =p.days_to_start ) then price*0.25
else price*0.5
end
when 'raiz 018'='atleta' then
case
--aluno
when exists (select nome_atleta from atleta where email='anonimos' and professor_graduacao =p.days_to_start ) then price*0.75
else price*1.0
end
else
price*1.0
end
when categ_id in (1,5) then -- inscricao
null
else
case
when 'raiz 018' in ('confederado','admin') then
price * (1 - coalesce(p.promo_value/100.0,0))
else price
end
end
showprice,
promo_value,featured,active,
m.*,
(select nome_atleta from atleta where atleta_id=p.days_to_start) autor1,
(select nome_atleta from atleta where atleta_id=p.WEIGHT_G) autor2,
/*case when p.categ_id=3 then prod_url --'/canal-luta-preview/'||cast(prodnum as varchar)
else prod_url --'/compra-produto/'||product_code
-- case when left('anonimos',7)='anonimo' then m.url_externa else p.prod_url end
end
*/
case when left('anonimos',7)<>'anonimo' then
prod_url
else
case when categ_id<>1 then 'https://canaldaluta.cblle.com.br/' else '' end || url_externa
end
page_name,
case
when p.categ_id=3 then
'https://img.youtube.com/vi/' || target_url || '/0.jpg'
else '/emp/1008/galeria/' || nome_url
--case when left('anonimos',7)='anonimo' then m.url_externa else p.prod_url end
end imageurl,
coalesce( (select 'ass' from sale s, sale_item i
where i.sale_id=s.sale_id and sale_status='P'
and s.customer_id in (select atleta_id from atleta where email = 'anonimos')
and i.product_code='video-'||cast(p.prodnum as varchar)
), 'nas')
assinado
,case when product_code='175' then 1 else 2 end supord
, case when categ_id in (1,5) then 'consulte' else '' end compl_preco
from product p, ga_midia m
where p.active=1 and FEATURED=1 and price>0 and 0 in (0,p.categ_id)
and m.ATIV_PARA=p.prodnum
and m.ordem=1
-- and ( ( 'raiz 018' in ('confederado','admin') and left('anonimos',7)<>'anonimo') or (left('raiz 018',4)='raiz' and m.url_externa is not null) )
and m.url_externa is not null
order by supord, FEATURED desc, prodnum desc param1=175 categid=0 codUsuario=anonimos perfilUsuario=raiz 018