An Error Was Encountered

Error Number: 1054

Unknown column 'ce_categories_link.cat_id' in 'where clause'

SELECT distinct ce_products.prod_id, ce_products.prod_design, prod_colour, prod_fabric_code, prod_description, prod_available_desc, prod_bedspread FROM ce_products INNER JOIN ce_designs_link ON ce_designs_link.prod_id = ce_products.prod_id INNER JOIN ce_colours_link ON ce_colours_link.prod_id = ce_products.prod_id INNER JOIN ce_products_sites ON ce_products_sites.ps_prod_id = ce_products.prod_id WHERE ce_colours_link.colour_id in (9) and ce_categories_link.cat_id not in (index.htm) and ce_designs_link.cat_id!=9 and ce_products_sites.ps_site_code='ABC' and ce_products_sites.ps_prod_type='1' and prod_available > 0 and prod_bedspread = 1 limit 0, 10