<small>SELECT DISTINCT p.id, p.portes_continente, p.portes_ilhas, p.portes_oferta, p.ref,  l.preco_pvp, l.preco_promo, l.preco_antes, p.stock, p.ultimos, l.novidade, l.promocao, p.saldos, p.createdh, p.cores, l.nome, l.seo, p.marca, p.label1, p.label2, c.googletax, r.cat, p.sticker, p.outlet, p.leve3pague2 , 
            (SELECT path FROM media WHERE type = 'products' AND parent = p.id ORDER BY ord LIMIT 1)  imagem,
            IF( 
                ((l.preco_promo IS NOT NULL AND l.preco_promo != 0) 
                ), 
            l.preco_promo, l.preco_pvp) preco, IF( 
                (( l.promocao = 1 OR l.saldos = 1) OR (l.preco_promo != 0 AND l.preco_promo IS NOT NULL) 
                ), 
            'Y', 'N') promo,
            p.portes_continente, p.portes_ilhas, p.portes_oferta
        FROM products p
        LEFT JOIN products_lang l ON p.id = l.intid
        LEFT JOIN relations r ON r.prod = p.id
        LEFT JOIN categories c ON c.id = r.cat
        LEFT JOIN categories_lang cl ON c.id = cl.intid
        LEFT JOIN products_variations pv ON pv.product = p.id
        WHERE l.idioma = '1' AND c.type = 'catalogo' AND p.deletedh IS NULL AND p.arquivado IS NULL /* AND IF( 
                ((l.preco_promo IS NOT NULL AND l.preco_promo != 0) 
                ), 
            l.preco_promo, l.preco_pvp) > 0*/ AND l.status = 1 AND p.id IN (Array)  GROUP BY p.id  ORDER BY p.createdh DESC  LIMIT 0 ,12 </small><br>Unknown column 'Array' in 'where clause'