select	 "PRODUCT_DESCRIPTIONS"."PRODUCT_ID" as "PRODUCT_ID",
	 "PRODUCT_DESCRIPTIONS"."TRANSLATED_NAME" as "TRANSLATED_NAME",
	 "PRODUCT_DESCRIPTIONS"."TRANSLATED_DESCRIPTION" as "TRANSLATED_DESCRIPTION",
         "PRODUCTS"."PRODUCT_NAME" as "PRODUCT_NAME",
         "PRODUCTS"."CATEGORY_ID" as "CATEGORY_ID"
 from	"OE"."PRODUCTS" "PRODUCTS", "OE"."PRODUCT_DESCRIPTIONS" "PRODUCT_DESCRIPTIONS"
 where  "PRODUCT_DESCRIPTIONS"."PRODUCT_ID"="PRODUCTS"."PRODUCT_ID"
 group by "PRODUCT_DESCRIPTIONS"."PRODUCT_ID", "PRODUCT_DESCRIPTIONS"."TRANSLATED_NAME", "PRODUCT_DESCRIPTIONS"."TRANSLATED_DESCRIPTION", "PRODUCTS"."PRODUCT_NAME", "PRODUCTS"."CATEGORY_ID"