case
   when rd.project_id<>'pmd' then 'other'
   when rd.account='dgbeat' then 'DG Beat 3rd Party'
   when o.operator_id='Genting' and rd.account='TopRatedCasino' then 'Genting 3rd Party'
   when o.operator_id='iAffiliates' and rd.account='sportwiser' then 'Mansion 3rd Party'
   when o.operator_id='Gamesys' and rd.account='topratedbingo' then 'Virgin 3rd Party'
   when o.operator_id='iAffiliates' and rd.account='TopRatedSH' then 'SlotsHeaven 3rd Party'
   when o.operator_id='Casumo' and rd.account='SportWiser' then 'Casumo 3rd Party'
   when rd.account='monster' then 'Optionstars 3rd Party'
   when o.operator_id='PlayLand' then 'PlayLand 3rd Party'
   when o.operator_id='Broadway' and rd.account='sportwiser' then 'Broadway 3rd Party'
   when rd.account like 'PPCSW%' then 'SW 3rd Party'
   when rd.account like 'GM3D%' then 'GMP 3rd Party'
   else 'other'
  end as 'PublisherGroup',