Mine

SELECT `catalog_module-product_categories.product_id` AS id,`catalog_module-products.name` AS name,`catalog_module-products.product_code` AS code FROM `catalog_module-product_categories,catalog_module-products` WHERE category_id = 2 AND `catalog_module-product_categories.product_id` = `catalog_module-products.id`