xml feed

create table xmlfeed as
   select ad.assetId, ad.url, ad.title, ad.publishDate as date
    --   mdv_format.value as format,
       mdv_coverage.value as coverage,
       mdv_region.value as region,
       mdv_publisher.value as publisher,
       mdv_subject.value as subject,
       mdv_category.value as category,
    from assetData as ad,
     --    metaData_value as mdv_format,
         metaData_value as mdv_coverage,
         metaData_value as mdv_region,
         metaData_value as mdv_publisher,
         metaData_value as mdv_subject,
         metaData_value as mdv_category,

     --    metaData_properties as mdp_format,
         metaData_properties as mdp_coverage,
         metaData_properties as mdp_region,
         metaData_properties as mdp_publisher,
         metaData_properties as mdp_subject,
         metaData_properties as mdp_category

    where -- mdv_format.assetId    = ad.assetId and
          mdv_coverage.assetId  = ad.assetId
      and mdv_region.assetId    = ad.assetId
      and mdv_publisher.assetId = ad.assetId
      and mdv_subject.assetId   = ad.assetId
      and mdv_category.assetId  = ad.assetId

   --   and mdv_format.fieldId     = mdp_format.fieldId
      and mdv_coverage.fieldId   = mdp_coverage.fieldId
      and mdv_region.fieldId     = mdp_region.fieldId
      and mdv_publisher.fieldId  = mdp_publisher.fieldId
      and mdv_subject.fieldId    = mdp_subject.fieldId
      and mdv_category.fieldId   = mdp_category.fieldId

   --   and mdp_format.fieldId     = ''
      and mdp_coverage.fieldId   = 'Countries'
      and mdp_region.fieldId     = 'Regions'
      and mdp_publisher.fieldId  = 'Sub Head'
      and mdp_subject.fieldId    = 'Issues'
      and mdp_category.fieldId   = 'Website Section'