WITH productos_campaign AS ( SELECT DISTINCT cgp.rowid as fk_product FROM bks_product cgp WHERE cgp.rowid < 0 ) SELECT COUNT(DISTINCT P.rowid) as total_products FROM bks_product P left join bks_categorie_product Cp on (P.rowid = Cp.fk_product) left join bks_product_extrafields Pe on(P.rowid = Pe.fk_object) WHERE ((P.rowid<0) AND (P.entity IN (1,2)) AND (P.finished = 1) AND (P.tosell = 1) AND (Pe.moto_aplic = 'NO') AND ( Pe.mostrar_ps = 'SI' OR ( P.rowid IN (SELECT fk_product FROM productos_campaign))) )WITH productos_campaign AS ( SELECT DISTINCT cgp.rowid as fk_product FROM bks_product cgp WHERE cgp.rowid < 0 ) SELECT DISTINCT P.rowid FROM bks_product P left join bks_categorie_product Cp on (P.rowid = Cp.fk_product) left join bks_product_extrafields Pe on(P.rowid = Pe.fk_object) WHERE ((P.rowid<0) AND (P.entity IN (1,2)) AND (P.finished = 1) AND (P.tosell = 1) AND (Pe.moto_aplic = 'NO') AND ( Pe.mostrar_ps = 'SI' OR ( P.rowid IN (SELECT fk_product FROM productos_campaign))) ) ORDER BY P.ref ASC LIMIT 0,16
bkportal
