Unknown column 'C.product_id' in 'where clause' --- SELECT DISTINCT A.*, B.type_name, C.* FROM AA_products A, AA_productTypes B,AA_products_accessories C WHERE (A.url_text = 'passport 8500 x50' OR A.id = '') AND C.product_id = A.id AND (A.product_type = B.id) AND A.deleted != '2'