public function testget_all_prospect_lists()
 {
     $emailMarketing = new EmailMarketing();
     //execute the method and verify that it retunrs expected results
     $expected = "select prospect_lists.* from prospect_lists  left join prospect_list_campaigns on prospect_list_campaigns.prospect_list_id=prospect_lists.id where prospect_list_campaigns.deleted=0 and prospect_list_campaigns.campaign_id='' and prospect_lists.deleted=0 and prospect_lists.list_type not like 'exempt%'";
     $actual = $emailMarketing->get_all_prospect_lists();
     $this->assertSame($expected, $actual);
 }