Column 'cbc_super' in where clause is ambiguous

SELECT SQL_CALC_FOUND_ROWS 	distinct(products.PRODUCT_ID), 
				products.PARENT_PRODUCT_ID, 
				substr(products.TITLE,1,10) AS TITLE, 
				substr(products.AUTHOR,1,10) AS AUTHOR, 
				products.SALES_RANK, 
				products.SALES_RANK_INGRAM,
				IFNULL(products.SALES_RANK, 'Z') as SALES_RANK_SORT,
				products.stock_qty_sold,  
				products_store.store_qty_sold,
				products.image_has_small as IMAGE_HAS_SMALL  FROM products left join products_store             on (products.product_id = products_store.product_id and products_store.store_id = 8154)  , products_category_cbc  WHERE  products.store_id in (0, 8154)  AND  products.STORETYPE_ID1 = 'Y'  AND  cbc_super      in ('NAS', 'NA2')    AND  products.product_id = products_category_cbc.product_id and products_category_cbc.cbc_sub = 'LGP'  AND  (products.stock_available_flag in ('Y', 'P') or release_date >= curdate())  AND  (censorship_flag is null or censorship_flag <> 'Y')  AND  (products.PRICE 				> 0 or products.product_config in ('eBook', 'eBooks', 'mp3')) AND (products.STATUS in ('A', 'B', 'C', 'M'))  ORDER BY sales_rank_ingram desc, stock_qty_sold desc, TITLE  LIMIT 1000 



SELECT SQL_CALC_FOUND_ROWS distinct(products.PRODUCT_ID), products.PARENT_PRODUCT_ID, substr(products.TITLE,1,10) AS TITLE, substr(products.AUTHOR,1,10) AS AUTHOR, products.SALES_RANK, products.SALES_RANK_INGRAM, IFNULL(products.SALES_RANK, 'Z') as SALES_RANK_SORT, products.stock_qty_sold, products_store.store_qty_sold, products.image_has_small as IMAGE_HAS_SMALL FROM products left join products_store on (products.product_id = products_store.product_id and products_store.store_id = 8154) , products_category_cbc WHERE products.store_id in (0, 8154) AND products.STORETYPE_ID1 = 'Y' AND cbc_super in ('NAS', 'NA2') AND products.product_id = products_category_cbc.product_id and products_category_cbc.cbc_sub = 'LGP' AND (products.stock_available_flag in ('Y', 'P') or release_date >= curdate()) AND (censorship_flag is null or censorship_flag <> 'Y') AND (products.PRICE > 0 or products.product_config in ('eBook', 'eBooks', 'mp3')) AND (products.STATUS in ('A', 'B', 'C', 'M')) ORDER BY sales_rank_ingram desc, stock_qty_sold desc, TITLE LIMIT 1000