An Error Was Encountered

Error Number: 1146

Table 'vickylingerie1.product_choiceinfo' doesn't exist

SELECT a.producer_id, COUNT(a.product_id) AS quantity, prod.name, prod.human_url FROM ( SELECT producer_id, product_id FROM product_choiceinfo WHERE lft >= 42 AND rgt <= 59 AND (price >= '2000' AND price < '5000') AND (color_id_1 = '14' OR color_id_2 = '14' OR color_id_3 = '14') GROUP BY product_id ) AS a JOIN producer prod ON prod.id = a.producer_id GROUP BY a.producer_id ORDER BY prod.name ASC