On Deployment mysql> SELECT a.* FROM content_editor_bing.bce_textAd a join content_editor_bing.bce_adGroup b on a.adgroupid=b.id join content_editor_bing.bce_campaign c on c.id= b.campaignid where c.name like '%TXTCHK01%'; +-------+-----------+------------------------+--------------------------------+-----------------------------------------------------------------------+--------------------------------+----------------------------+---------------+--------+ | id | adGroupID | searchEngineIdentifier | title | text | displayURL | destinationURL | isDisapproved | status | +-------+-----------+------------------------+--------------------------------+-----------------------------------------------------------------------+--------------------------------+----------------------------+---------------+--------+ | 49745 | 5442 | 4054227513 | Grooming for Men | Grooming Treatments Just For Men. Full Range of Treatments & Products | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49747 | 5442 | 4054227514 | {KeyWord:Skin Therapy for Men} | Experience & Expertise. The Very Latest Male Grooming. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49746 | 5442 | 4054227515 | Skin Therapy for Men | Experience & Expertise. The Very Latest Male Grooming. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49749 | 5443 | 4054227516 | Skin Therapy for Men | Experience & Expertise. The Very Latest Male Grooming. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49748 | 5443 | 4054227517 | Grooming for Men | Grooming Treatments Just For Men. Full Range of Treatments & Products | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49750 | 5443 | 4054227518 | {KeyWord:Skin Therapy for Men} | Experience & Expertise. The Very Latest Male Grooming. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | +-------+-----------+------------------------+--------------------------------+-----------------------------------------------------------------------+--------------------------------+----------------------------+---------------+--------+ 6 rows in set (0.00 sec) On First Redeployment mysql> SELECT a.* FROM content_editor_bing.bce_textAd a join content_editor_bing.bce_adGroup b on a.adgroupid=b.id join content_editor_bing.bce_campaign c on c.id= b.campaignid where c.name like '%TXTCHK01%'; +-------+-----------+------------------------+--------------------------------+-----------------------------------------------------------------------+--------------------------------+----------------------------+---------------+--------+ | id | adGroupID | searchEngineIdentifier | title | text | displayURL | destinationURL | isDisapproved | status | +-------+-----------+------------------------+--------------------------------+-----------------------------------------------------------------------+--------------------------------+----------------------------+---------------+--------+ | 49759 | 5442 | NULL | Grooming for Men | Grooming Treatments Just For Men. Full Range of Treatments & Products | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49760 | 5442 | NULL | {KeyWord:Skin Therapy for Men} | Experience & Expertise. The Very Latest Male Grooming. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49761 | 5442 | NULL | Skin Therapy for Men | Experience & Expertise. The Very Latest Male Grooming. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49745 | 5442 | 4054227513 | Grooming for Men | Grooming Treatments Just For Men. Full Range of Treatments & Products | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49747 | 5442 | 4054227514 | {KeyWord:Skin Therapy for Men} | Experience & Expertise. The Very Latest Male Grooming. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49746 | 5442 | 4054227515 | Skin Therapy for Men | Experience & Expertise. The Very Latest Male Grooming. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49762 | 5443 | NULL | Skin Therapy for Men | Experience & Expertise. The Very Latest Male Grooming. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49763 | 5443 | NULL | Grooming for Men | Grooming Treatments Just For Men. Full Range of Treatments & Products | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49764 | 5443 | NULL | {KeyWord:Skin Therapy for Men} | Experience & Expertise. The Very Latest Male Grooming. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49749 | 5443 | 4054227516 | Skin Therapy for Men | Experience & Expertise. The Very Latest Male Grooming. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49748 | 5443 | 4054227517 | Grooming for Men | Grooming Treatments Just For Men. Full Range of Treatments & Products | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49750 | 5443 | 4054227518 | {KeyWord:Skin Therapy for Men} | Experience & Expertise. The Very Latest Male Grooming. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | +-------+-----------+------------------------+--------------------------------+-----------------------------------------------------------------------+--------------------------------+----------------------------+---------------+--------+ 12 rows in set (0.00 sec) Second redeployment mysql> SELECT a.* FROM content_editor_bing.bce_textAd a join content_editor_bing.bce_adGroup b on a.adgroupid=b.id join content_editor_bing.bce_campaign c on c.id= b.campaignid where c.name like '%TXTCHK01%'; +-------+-----------+------------------------+--------------------------------+-----------------------------------------------------------------------+-------------------------+----------------------------+---------------+--------+ | id | adGroupID | searchEngineIdentifier | title | text | displayURL | destinationURL | isDisapproved | status | +-------+-----------+------------------------+--------------------------------+-----------------------------------------------------------------------+-------------------------+----------------------------+---------------+--------+ | 49759 | 5442 | 4054231543 | Grooming for Men | Grooming Treatments Just For Men. Full Range of Treatments & Products | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49761 | 5442 | 4054231544 | Skin Therapy for Men | Experience & Expertise. The Very Latest Male Grooming. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49760 | 5442 | 4054231545 | {KeyWord:Skin Therapy for Men} | Experience & Expertise. The Very Latest Male Grooming. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49763 | 5443 | 4054231546 | Grooming for Men | Grooming Treatments Just For Men. Full Range of Treatments & Products | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49762 | 5443 | 4054231547 | Skin Therapy for Men | Experience & Expertise. The Very Latest Male Grooming. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 49764 | 5443 | 4054231548 | {KeyWord:Skin Therapy for Men} | Experience & Expertise. The Very Latest Male Grooming. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | +-------+-----------+------------------------+--------------------------------+-----------------------------------------------------------------------+-------------------------+----------------------------+---------------+--------+ 6 rows in set (0.00 sec)