Mariana na Drogaria Cristal 24h

SELECT prd.PrdComReceita,prd.Prod_id,prd.Prod_loja,prd.Prod_nome,prd.Prod_complemento,prd.Descr_resumida,prd.Descr_detalhada,prd.Imagem,prd.Width,prd.Height,prd.Imagemp,prd.Widthp,prd.Heightp,prd.Imagemm,prd.Widthm,prd.Heightm,prd.Imagemg,prd.Widthg,prd.Heightg,prd.User_id,prd.Atual,prd.Destaque,prd.Data_cadastro,prd.Donativo,prd.Max_parc_CCC,prd.Max_parc_CCH,prd.Frete_gratis,prd.EntregaDigital,prd.Prd_personal,prd.Video_prd,prd.Max_parc_FAT,prd.Upload_config,prd.Frete_capital,prd.Combo_virtual,prd.Campo_informativo,prd.PrdComReceita,prd.IntervaloFracao,prd.SemDescontoNoPerfil, prd_var.Loja_id,prd_var.Codigo_barra,prd_var.Peso,prd_var.Preco_de,prd_var.Preco_por,prd_var.Altura,prd_var.Largura,prd_var.Profund,prd_var.Prazo_dias,prd_var.Prazo_data,prd_var.Estoque,prd_var.Qtd_max_compra,prd_var.Situacao,prd_var.Qtd_min_compra,prd_var.Apenas_qtd_multiplo, dep_sec_prd.Dep_id,dep_sec_prd.Sec_id,dep_sec_prd.Marca_id, dep.Dep_nome, dep.Dep_desc, sec.Sec_nome, prd.Relevancia_prd, contagem.Qtd FROM (SELECT COUNT(DISTINCT prd.Prod_id) AS Qtd FROM prd,prd_var,dep_sec_prd,dep,sec WHERE (sec.Sec_loja = 310) AND (sec.Sec_id = 34016) AND (sec.Sec_status = 1) AND (dep.Dep_loja = sec.Sec_loja) AND (dep.Dep_id = sec.Sec_dep) AND (dep.Dep_id = 9594) AND (dep.Dep_status = 1) AND (dep_sec_prd.Loja_id = dep.Dep_loja) AND (dep_sec_prd.Dep_id = dep.Dep_id) AND (dep_sec_prd.Sec_id = sec.Sec_id) AND (prd.Prod_loja = dep_sec_prd.Loja_id) AND (prd.Prod_id = dep_sec_prd.Prod_id) AND (prd_var.Loja_id = prd.Prod_loja) AND (prd_var.Prod_id = prd.Prod_id) AND prd_var.codigo_barra in ('7894900093001','7891991000840') AND (prd_var.Situacao IN (2,3,4,5,7)) ) AS contagem, (select prd_var.*, if(Preco_por, Preco_por, Preco_de) as Preco from prd_var , dep_sec_prd where prd_var.Loja_id=310 and prd_var.Situacao IN (2,3,4,5,7) and prd_var.Prod_id = dep_sec_prd.Prod_id and prd_var.Loja_id = dep_sec_prd.Loja_id and dep_sec_prd.Dep_id = 9594 and dep_sec_prd.Sec_id = 34016 order by Situacao, Preco) as prd_var, prd,dep_sec_prd ,dep,sec WHERE (sec.Sec_loja = 310) AND (sec.Sec_id = 34016) AND (sec.Sec_status = 1) AND (dep.Dep_loja = sec.Sec_loja) AND (dep.Dep_id = sec.Sec_dep) AND (dep.Dep_id = 9594) AND (dep.Dep_status = 1) AND (dep_sec_prd.Loja_id = dep.Dep_loja) AND (dep_sec_prd.Dep_id = dep.Dep_id) AND (dep_sec_prd.Sec_id = sec.Sec_id) AND (prd.Prod_loja = dep_sec_prd.Loja_id) AND (prd.Prod_id = dep_sec_prd.Prod_id) AND (prd_var.Loja_id = prd.Prod_loja) AND (prd_var.Prod_id = prd.Prod_id) AND prd_var.codigo_barra in ('7894900093001','7891991000840') AND (prd_var.Situacao IN (2,3,4,5,7)) GROUP BY prd.Prod_id ORDER BY IF (prd_var.Situacao in (4,5),CONCAT(000000000000000,prd.Data_cadastro), prd.Data_cadastro) DESC, Situacao LIMIT 0,20

Remover filtros

Filtrar resultados

Faixa de pre�o

Ordenar

Mariana

Agua Tonica Antarctica 350ml Sem estoque no momentoSem estoque no momento Adicionar ao carrinho

Fanta Guarana Lata 350ml Sem estoque no momentoSem estoque no momento Adicionar ao carrinho