create table xmlfeed as
   select ad.assetId, ad.url, ad.title,
         ad.publishDate      as date,
         md_coverage.value  as coverage,
         md_region.value    as region,
         md_publisher.value as publisher,
         md_subject.value   as subject,
         md_category.value  as category
    from assetData           as ad,
         join metaData_values      as md_coverage on
             md_coverage.assetId   = ad.assetId and
             md_coverage.fieldId   in ( select fieldId
                            from metaData_properties
                            where fieldName   = 'Countries' ),
         join metaData_values      as md_region on
             md_region.assetId     = ad.assetId and
             md_region.fieldId     in ( select fieldId
                            from metaData_properties
                            where fieldName   = 'Regions' ),
         join metaData_values      as md_publisher on
             md_publisher.assetId  = ad.assetId and
             md_publisher.fieldId  in ( select fieldId
                            from metaData_properties
                            where fieldName   = 'Sub Head' ),
         join metaData_values      as md_subject on
             md_subject.assetId    = ad.assetId and
             md_subject.fieldId    in ( select fieldId
                            from metaData_properties
                            where fieldName   = 'Issues' ),
         join metaData_values      as md_category on
             md_category.assetId   = ad.assetId and
             md_category.fieldId   in ( select fieldId
                            from metaData_properties
                            where fieldName   = 'Website Section' )