ECC iProcurement, iProcurement Frequently Requested Items, SQL1

select
x.*
from
(
SELECT * FROM  ( SELECT /*+ leading(a.freqs) no_push_pred(a.ecc_items)*/
              ecc_spec_id,
	      org_id,
	      description,
	      display_price,
	      thumbnail_image,
	      language,
	      Sum(reqs_count) frequency,
              hide_addtocart,
              item_rating
              from icx_cat_ecc_freq_items_v a WHERE LANGUAGE in ( 'US')
              GROUP BY ecc_spec_id,
	      org_id,
	      description,
	      display_price,
	      thumbnail_image,
              language,
              hide_addtocart,
              item_rating ) PIVOT(
              MAX(description) AS DESCRIPTION,
              MAX(display_price) AS DISPLAY_PRICE,
              COUNT(1) AS IS_TRANSLATION_AVAILABLE
              FOR LANGUAGE IN ('US' "US"))
) x
where
2=2