SELECT 
                p.id, 
                p.pvpub as preco, 
                p.peso, 
                p.old_pvpub as old_preco,
                p.perc_pvpub as perc,
                p.pvpub as pvpub,
                p.old_pvpub as old_pvpub,
                pc.imgs,
                pc.nome as nome,
                pc.descricao,
                p.stock,
                /*p.stars,*/
                p.marca,
                p.embalagem,
                p.acondicionamento,
                p.pai,
                c.id_categ,
                pc.pai_nome,
                pc.pai_descricao,
                pc.watermark,
                pc.button_txt,
                pc.pai_img,
                p.ean,
                CASE WHEN stock <= 0 THEN '0' ELSE '1' END AS stock_status ,
                prom.tipo as excl_tipo, prom.valor as excl_valor, prom.data_ate as excl_data_ate
                
            FROM (prods p, prods_map_categ c,prods_campos pc)
            
            LEFT JOIN prods_promocoes prom ON (p.id=prom.id_prod AND prom.data_de<=NOW() AND prom.data_ate>=NOW() AND prom.perms=1)
            
            WHERE 
                p.id IN ('800111','800005','800159','180578','800016','800020','136187','136259','800026')
                AND p.id=c.id_prod
                AND p.id=pc.id
                AND pc.lg='en'
                AND p.minperms<=1
                AND p.online=1
                AND (p.stock_lojas>50 AND p.stock>=1) 
                AND pvpub>0.10 
            GROUP BY p.id
            ORDER BY FIELD (p.id, '800111','800005','800159','180578','800016','800020','136187','136259','800026')