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'))
bkportal
