A fatal MySQL error occurred.

Query:
SELECT pmd_images.num, pmd_images.ext, pmd_listings.selector as selector, pmd_listings.firmname,pmd_listing2category.cat_id, pmd_listings.listing_address1 as address, pmd_listings.listing_zip as zip, pmd_listings.custom_2 as telephone, pmd_listings.www, pmd_listings.custom_19 as custom_19, pmd_listings.custom_29, pmd_listings.custom_30, loc_id, pmd_category.title as subcategory, pmd_locations.title as district, jt_topcategory.friendly_url as iconname, jt_cities.title as city, jt_states.title as state,pmd_listings.custom_21 as custom_21, pmd_listings.friendly_url as friendly_url, jt_topcategory.id FROM pmd_listing2category, pmd_category, pmd_locations, pmd_category jt_topcategory, pmd_locations jt_cities, pmd_locations jt_states,pmd_listings LEFT OUTER JOIN pmd_images ON pmd_listings.selector = pmd_images.firmselector WHERE pmd_listings.selector = pmd_listing2category.list_id AND pmd_listings.membership > 1 AND pmd_listings.custom_35 != 'YES' AND pmd_category.id = pmd_listing2category.cat_id AND pmd_listings.selector = pmd_listing2category.list_id AND pmd_listings.loc_id = pmd_locations.id AND pmd_category.left_ > jt_topcategory.left_ AND pmd_category.right_ < jt_topcategory.right_ AND pmd_category.level = 2 AND jt_topcategory.level = 1 AND pmd_locations.left_ > jt_cities.left_ AND pmd_locations.right_ < jt_cities.right_ AND pmd_locations.level = 3 AND jt_cities.level = 2 AND jt_cities.left_ > jt_states.left_ AND jt_cities.right_ < jt_states.right_ AND jt_cities.level = 2 AND jt_states.level = 1 AND custom_45 = 'YES' GROUP BY firmname

Error:
(1146) Table 'chooselocal_dev.pmd_listing2category' doesn't exist