SELECT cennikCategoriesMap.externalID AS katName ,cennikProductsMap.externalID AS prodName
FROM cennikProductsMap,cennikCategoriesMap, products_to_categories
WHERE products_to_categories.products_id='589676'
AND products_to_categories.categories_id=cennikCategoriesMap.oscID
AND cennikProductsMap.oscID='589676' LIMIT 1