Error executing1: select distinct zzproducts.productid, productnamefr as productname from zzproducts, zcategories, zzbrandseq where zzproducts.catcode = zcategories.catcode and zcategories.lang = 'fr' and zcategories.catcode like 'BC%' and zzproducts.catcode = zzbrandseq.catcode and zzproducts.filterbrand = zzbrandseq.brand order by zseq, zzproducts.productid