SELECT pp.rowid as promid , pp.grupo, pp.prioridad, pp.niv_distr, pp.comis, pp.pricelist, pp.promo_type, pp.amount, pp.qty, pp.niv_compra_ini, pp.niv_compra_fin, pp.date_on, pp.date_off, pp.coupon_desc, p.rowid as prodid FROM bks_bkprec_promo pp, bks_categorie_promo cr, bks_categorie_product cp, bks_categorie c , bks_product p , bks_product_extrafields pe WHERE pp.status IN(1) AND cr.fk_promo = pp.rowid AND cr.fk_categorie = cp.fk_categorie AND cr.fk_categorie = c.rowid AND cp.fk_product = p.rowid AND p.rowid = pe.fk_object AND p.tosell = 1 AND (pe.mostrar_ps = 'SI' OR (p.rowid IN (SELECT fk_product FROM productos_campaign) )) ORDER BY pp.prioridad, pp.grupo, pp.rowid, c.label, p.ref
bkportal
