mysql> SELECT a.* FROM content_editor_bing.bce_keyword 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 '%BNV9UP04%'; +--------+-----------+------------------------+------------------------------+-------------+--------+------------------+------------------------------------------------------------------------------------------------------+----------+------------+--------+ | id | adGroupID | searchEngineIdentifier | text | keywordType | maxCPC | exemptionRequest | destinationURL | isPaused | isNegative | status | +--------+-----------+------------------------+------------------------------+-------------+--------+------------------+------------------------------------------------------------------------------------------------------+----------+------------+--------+ | 662798 | 10524 | NULL | courses | Broad | NULL | | NULL | false | true | Active | | 662805 | 10524 | NULL | apprenticeship | Broad | NULL | | NULL | false | true | Active | | 662806 | 10524 | NULL | college | Broad | NULL | | NULL | false | true | Active | | 662809 | 10524 | NULL | apprentices | Broad | NULL | | NULL | false | true | Active | | 662810 | 10524 | NULL | school | Broad | NULL | | NULL | false | true | Active | | 662814 | 10524 | NULL | schools | Broad | NULL | | NULL | false | true | Active | | 662816 | 10524 | NULL | apprentice | Broad | NULL | | NULL | false | true | Active | | 662817 | 10524 | NULL | careers | Broad | NULL | | NULL | false | true | Active | | 662818 | 10524 | NULL | job | Broad | NULL | | NULL | false | true | Active | | 662819 | 10524 | NULL | career | Broad | NULL | | NULL | false | true | Active | | 662823 | 10524 | NULL | course | Broad | NULL | | NULL | false | true | Active | | 662824 | 10524 | NULL | apprenticeships | Broad | NULL | | NULL | false | true | Active | | 662825 | 10524 | NULL | colleges | Broad | NULL | | NULL | false | true | Active | | 662826 | 10524 | NULL | jobs | Broad | NULL | | NULL | false | true | Active | | 662820 | 10524 | 42257546426 | guyliner | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662827 | 10524 | 42257546427 | male skin care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662801 | 10524 | 42257546428 | man hair removal | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662830 | 10524 | 42257546429 | man hair care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662804 | 10524 | 42257546430 | salon for men | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662811 | 10524 | 42257546431 | man makeup | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662815 | 10524 | 42257546432 | male hair removal | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662822 | 10524 | 42257546433 | man make up | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662800 | 10524 | 42257546434 | men haircare | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662829 | 10524 | 42257546435 | men make up | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662803 | 10524 | 42257546436 | men skincare | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662808 | 10524 | 42257546437 | men hair care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662813 | 10524 | 42257546438 | male make up | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662821 | 10524 | 42257546439 | men skin care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662799 | 10524 | 42257546440 | man grooming salons | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662828 | 10524 | 42257546441 | man skin care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662802 | 10524 | 42257546442 | men hair removal | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662831 | 10524 | 42257546443 | male grooming salons | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662807 | 10524 | 42257546444 | men makeup | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662812 | 10524 | 42257546445 | male makeup | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662871 | 10525 | 42257546446 | male skin care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662848 | 10525 | 42257546447 | Redhill male make up | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662864 | 10525 | 42257546448 | Redhill male hair removal | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662840 | 10525 | 42257546449 | male make up Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662851 | 10525 | 42257546450 | man hair care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662867 | 10525 | 42257546451 | man hair removal Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662854 | 10525 | 42257546452 | Redhill men skin care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662841 | 10525 | 42257546453 | Redhill man grooming salons | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662857 | 10525 | 42257546454 | male grooming salons Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662833 | 10525 | 42257546455 | Redhill guyliner | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662844 | 10525 | 42257546456 | Redhill men hair care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662860 | 10525 | 42257546457 | salon for men Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662836 | 10525 | 42257546458 | Redhill men makeup | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662870 | 10525 | 42257546459 | guyliner Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662847 | 10525 | 42257546460 | men hair care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662863 | 10525 | 42257546461 | Redhill men haircare | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662839 | 10525 | 42257546462 | man skin care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662850 | 10525 | 42257546463 | Redhill salon for men | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662866 | 10525 | 42257546464 | Redhill men skincare | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662869 | 10525 | 42257546465 | Redhill men hair removal | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662853 | 10525 | 42257546466 | Redhill men make up | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662856 | 10525 | 42257546467 | man makeup Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662832 | 10525 | 42257546468 | male makeup Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662843 | 10525 | 42257546469 | Redhill man makeup | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662859 | 10525 | 42257546470 | Redhill male makeup | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662835 | 10525 | 42257546471 | Redhill man hair removal | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662846 | 10525 | 42257546472 | men skincare Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662862 | 10525 | 42257546473 | men skin care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662838 | 10525 | 42257546474 | Redhill male skin care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662849 | 10525 | 42257546475 | Redhill man make up | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662865 | 10525 | 42257546476 | man make up Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662852 | 10525 | 42257546477 | men make up Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662868 | 10525 | 42257546478 | men hair removal Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662855 | 10525 | 42257546479 | Redhill man hair care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662842 | 10525 | 42257546480 | men makeup Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662858 | 10525 | 42257546481 | male hair removal Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662834 | 10525 | 42257546482 | men haircare Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662845 | 10525 | 42257546483 | Redhill male grooming salons | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662861 | 10525 | 42257546484 | Redhill man skin care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662837 | 10525 | 42257546485 | man grooming salons Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | +--------+-----------+------------------------+------------------------------+-------------+--------+------------------+------------------------------------------------------------------------------------------------------+----------+------------+--------+ 74 rows in set (0.00 sec) 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 '%BNV9UP04%' -> ; +-------+-----------+------------------------+-----------------------------------+------------------------------------------------------------------+--------------+------------------------------------------------------+---------------+--------+ | id | adGroupID | searchEngineIdentifier | title | text | displayURL | destinationURL | isDisapproved | status | +-------+-----------+------------------------+-----------------------------------+------------------------------------------------------------------+--------------+------------------------------------------------------+---------------+--------+ | 81039 | 10524 | 4868803351 | Skin Treatments for Men | Don't Let Your Looks Slip Away. Male Grooming To Keep You Sharp. | BNV9UP04.com | http://www.BNV9UP04.com/sem-malegroomingredhill.html | false | Active | | 81038 | 10524 | 4868803352 | Fast Male Grooming | Competitive Male Grooming Prices. Feel Good. Look Irresistible. | BNV9UP04.com | http://www.BNV9UP04.com/sem-malegroomingredhill.html | false | Active | | 81040 | 10524 | 4868803353 | {KeyWord:Skin Treatments for Men} | Don't Let Your Looks Slip Away. Male Grooming To Keep You Sharp. | BNV9UP04.com | http://www.BNV9UP04.com/sem-malegroomingredhill.html | false | Active | | 81041 | 10525 | 4868803354 | Fast Male Grooming | Competitive Male Grooming Prices. Feel Good. Look Irresistible. | BNV9UP04.com | http://www.BNV9UP04.com/sem-malegroomingredhill.html | false | Active | | 81043 | 10525 | 4868803355 | {KeyWord:Skin Treatments for Men} | Don't Let Your Looks Slip Away. Male Grooming To Keep You Sharp. | BNV9UP04.com | http://www.BNV9UP04.com/sem-malegroomingredhill.html | false | Active | | 81042 | 10525 | 4868803356 | Skin Treatments for Men | Don't Let Your Looks Slip Away. Male Grooming To Keep You Sharp. | BNV9UP04.com | http://www.BNV9UP04.com/sem-malegroomingredhill.html | false | Active | +-------+-----------+------------------------+-----------------------------------+------------------------------------------------------------------+--------------+------------------------------------------------------+---------------+--------+ 6 rows in set (0.00 sec) mysql> select * from content_editor_bing.bce_adGroupPendingChange; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_bingAccountPendingChange; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_campaignPendingChange; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_campaignTargetMapPendingChange; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_keywordPendingChange; +-----------+--------+----------+----------+---------------------+ | keywordID | type | tryCount | isFailed | requestTime | +-----------+--------+----------+----------+---------------------+ | 662799 | update | 0 | false | 2014-06-02 06:58:35 | | 662800 | update | 0 | false | 2014-06-02 06:58:35 | | 662801 | update | 0 | false | 2014-06-02 06:58:35 | | 662802 | update | 0 | false | 2014-06-02 06:58:35 | | 662803 | update | 0 | false | 2014-06-02 06:58:35 | | 662804 | update | 0 | false | 2014-06-02 06:58:35 | | 662807 | update | 0 | false | 2014-06-02 06:58:35 | | 662808 | update | 0 | false | 2014-06-02 06:58:35 | | 662811 | update | 0 | false | 2014-06-02 06:58:35 | | 662812 | update | 0 | false | 2014-06-02 06:58:35 | | 662813 | update | 0 | false | 2014-06-02 06:58:35 | | 662820 | update | 0 | false | 2014-06-02 06:58:35 | | 662821 | update | 0 | false | 2014-06-02 06:58:35 | | 662822 | update | 0 | false | 2014-06-02 06:58:35 | | 662827 | update | 0 | false | 2014-06-02 06:58:35 | | 662828 | update | 0 | false | 2014-06-02 06:58:35 | | 662829 | update | 0 | false | 2014-06-02 06:58:35 | | 662830 | update | 0 | false | 2014-06-02 06:58:35 | | 662831 | update | 0 | false | 2014-06-02 06:58:35 | | 662832 | update | 0 | false | 2014-06-02 06:58:36 | | 662833 | update | 0 | false | 2014-06-02 06:58:36 | | 662834 | update | 0 | false | 2014-06-02 06:58:36 | | 662835 | update | 0 | false | 2014-06-02 06:58:36 | | 662836 | update | 0 | false | 2014-06-02 06:58:36 | | 662837 | update | 0 | false | 2014-06-02 06:58:36 | | 662838 | update | 0 | false | 2014-06-02 06:58:36 | | 662839 | update | 0 | false | 2014-06-02 06:58:36 | | 662840 | update | 0 | false | 2014-06-02 06:58:36 | | 662841 | update | 0 | false | 2014-06-02 06:58:36 | | 662842 | update | 0 | false | 2014-06-02 06:58:36 | | 662843 | update | 0 | false | 2014-06-02 06:58:36 | | 662844 | update | 0 | false | 2014-06-02 06:58:36 | | 662845 | update | 0 | false | 2014-06-02 06:58:36 | | 662846 | update | 0 | false | 2014-06-02 06:58:36 | | 662847 | update | 0 | false | 2014-06-02 06:58:36 | | 662848 | update | 0 | false | 2014-06-02 06:58:36 | | 662849 | update | 0 | false | 2014-06-02 06:58:36 | | 662850 | update | 0 | false | 2014-06-02 06:58:36 | | 662851 | update | 0 | false | 2014-06-02 06:58:36 | | 662852 | update | 0 | false | 2014-06-02 06:58:36 | | 662853 | update | 0 | false | 2014-06-02 06:58:36 | | 662854 | update | 0 | false | 2014-06-02 06:58:36 | | 662856 | update | 0 | false | 2014-06-02 06:58:36 | | 662857 | update | 0 | false | 2014-06-02 06:58:36 | | 662858 | update | 0 | false | 2014-06-02 06:58:36 | | 662859 | update | 0 | false | 2014-06-02 06:58:36 | | 662860 | update | 0 | false | 2014-06-02 06:58:36 | | 662861 | update | 0 | false | 2014-06-02 06:58:36 | | 662862 | update | 0 | false | 2014-06-02 06:58:36 | | 662863 | update | 0 | false | 2014-06-02 06:58:36 | | 662864 | update | 0 | false | 2014-06-02 06:58:36 | | 662865 | update | 0 | false | 2014-06-02 06:58:36 | | 662866 | update | 0 | false | 2014-06-02 06:58:36 | | 662867 | update | 0 | false | 2014-06-02 06:58:36 | | 662868 | update | 0 | false | 2014-06-02 06:58:36 | | 662869 | update | 0 | false | 2014-06-02 06:58:36 | | 662870 | update | 0 | false | 2014-06-02 06:58:36 | | 662871 | update | 0 | false | 2014-06-02 06:58:36 | +-----------+--------+----------+----------+---------------------+ 58 rows in set (0.00 sec) mysql> select * from content_editor_bing.bce_placementPendingChange; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_textAdPendingChange; Empty set (0.00 sec) mysql> mysql> select * from content_editor_bing.bce_textAdPendingUpdate; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_adGroupPendingUpdate; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_bingAccountPendingUpdate; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_campaignPendingUpdate; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_campaignTargetMapPendingUpdate; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_keywordPendingUpdate; +-----------+--------------------------------+------------+----------+--------+ | keywordID | destinationURL | isNegative | isPaused | status | +-----------+--------------------------------+------------+----------+--------+ | 662799 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662800 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662801 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662802 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662803 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662804 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662807 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662808 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662811 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662812 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662813 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662820 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662821 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662822 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662827 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662828 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662829 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662830 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662831 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662832 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662833 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662834 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662835 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662836 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662837 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662838 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662839 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662840 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662841 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662842 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662843 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662844 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662845 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662846 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662847 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662848 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662849 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662850 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662851 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662852 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662853 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662854 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662856 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662857 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662858 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662859 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662860 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662861 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662862 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662863 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662864 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662865 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662866 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662867 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662868 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662869 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662870 | http://www.martiantourism.com/ | NULL | NULL | NULL | | 662871 | http://www.martiantourism.com/ | NULL | NULL | NULL | +-----------+--------------------------------+------------+----------+--------+ 58 rows in set (0.00 sec) mysql> select * from content_editor_bing.bce_placementPendingUpdate; Empty set (0.00 sec) mysql> select * from content_editor_bing.bce_campaignProximityTargetMapPendingUpdate; Empty set (0.00 sec) 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 '%BNV9UP04%'; +-------+-----------+------------------------+-----------------------------------+------------------------------------------------------------------+-------------------------+--------------------------------+---------------+--------+ | id | adGroupID | searchEngineIdentifier | title | text | displayURL | destinationURL | isDisapproved | status | +-------+-----------+------------------------+-----------------------------------+------------------------------------------------------------------+-------------------------+--------------------------------+---------------+--------+ | 81053 | 10524 | 4868803363 | Fast Male Grooming | Competitive Male Grooming Prices. Feel Good. Look Irresistible. | www.martiantourism.com/ | http://www.martiantourism.com/ | false | Active | | 81052 | 10524 | 4868803364 | Skin Treatments for Men | Don't Let Your Looks Slip Away. Male Grooming To Keep You Sharp. | www.martiantourism.com/ | http://www.martiantourism.com/ | false | Active | | 81054 | 10524 | 4868803365 | {KeyWord:Skin Treatments for Men} | Don't Let Your Looks Slip Away. Male Grooming To Keep You Sharp. | www.martiantourism.com/ | http://www.martiantourism.com/ | false | Active | | 81055 | 10525 | 4868803366 | Fast Male Grooming | Competitive Male Grooming Prices. Feel Good. Look Irresistible. | www.martiantourism.com/ | http://www.martiantourism.com/ | false | Active | | 81057 | 10525 | 4868803367 | Skin Treatments for Men | Don't Let Your Looks Slip Away. Male Grooming To Keep You Sharp. | www.martiantourism.com/ | http://www.martiantourism.com/ | false | Active | | 81056 | 10525 | 4868803368 | {KeyWord:Skin Treatments for Men} | Don't Let Your Looks Slip Away. Male Grooming To Keep You Sharp. | www.martiantourism.com/ | http://www.martiantourism.com/ | false | Active | +-------+-----------+------------------------+-----------------------------------+------------------------------------------------------------------+-------------------------+--------------------------------+---------------+--------+ 6 rows in set (0.00 sec) mysql> SELECT a.* FROM content_editor_bing.bce_keyword 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 '%BNV9UP04%'; +--------+-----------+------------------------+------------------------------+-------------+--------+------------------+------------------------------------------------------------------------------------------------------+----------+------------+--------+ | id | adGroupID | searchEngineIdentifier | text | keywordType | maxCPC | exemptionRequest | destinationURL | isPaused | isNegative | status | +--------+-----------+------------------------+------------------------------+-------------+--------+------------------+------------------------------------------------------------------------------------------------------+----------+------------+--------+ | 662798 | 10524 | NULL | courses | Broad | NULL | | NULL | false | true | Active | | 662805 | 10524 | NULL | apprenticeship | Broad | NULL | | NULL | false | true | Active | | 662806 | 10524 | NULL | college | Broad | NULL | | NULL | false | true | Active | | 662809 | 10524 | NULL | apprentices | Broad | NULL | | NULL | false | true | Active | | 662810 | 10524 | NULL | school | Broad | NULL | | NULL | false | true | Active | | 662814 | 10524 | NULL | schools | Broad | NULL | | NULL | false | true | Active | | 662816 | 10524 | NULL | apprentice | Broad | NULL | | NULL | false | true | Active | | 662817 | 10524 | NULL | careers | Broad | NULL | | NULL | false | true | Active | | 662818 | 10524 | NULL | job | Broad | NULL | | NULL | false | true | Active | | 662819 | 10524 | NULL | career | Broad | NULL | | NULL | false | true | Active | | 662823 | 10524 | NULL | course | Broad | NULL | | NULL | false | true | Active | | 662824 | 10524 | NULL | apprenticeships | Broad | NULL | | NULL | false | true | Active | | 662825 | 10524 | NULL | colleges | Broad | NULL | | NULL | false | true | Active | | 662826 | 10524 | NULL | jobs | Broad | NULL | | NULL | false | true | Active | | 662820 | 10524 | 42257546426 | guyliner | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662827 | 10524 | 42257546427 | male skin care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662801 | 10524 | 42257546428 | man hair removal | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662830 | 10524 | 42257546429 | man hair care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662804 | 10524 | 42257546430 | salon for men | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662811 | 10524 | 42257546431 | man makeup | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662815 | 10524 | 42257546432 | male hair removal | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662822 | 10524 | 42257546433 | man make up | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662800 | 10524 | 42257546434 | men haircare | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662829 | 10524 | 42257546435 | men make up | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662803 | 10524 | 42257546436 | men skincare | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662808 | 10524 | 42257546437 | men hair care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662813 | 10524 | 42257546438 | male make up | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662821 | 10524 | 42257546439 | men skin care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662799 | 10524 | 42257546440 | man grooming salons | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662828 | 10524 | 42257546441 | man skin care | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662802 | 10524 | 42257546442 | men hair removal | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662831 | 10524 | 42257546443 | male grooming salons | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662807 | 10524 | 42257546444 | men makeup | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662812 | 10524 | 42257546445 | male makeup | Broad | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662871 | 10525 | 42257546446 | male skin care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662848 | 10525 | 42257546447 | Redhill male make up | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662864 | 10525 | 42257546448 | Redhill male hair removal | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662840 | 10525 | 42257546449 | male make up Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662851 | 10525 | 42257546450 | man hair care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662867 | 10525 | 42257546451 | man hair removal Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662854 | 10525 | 42257546452 | Redhill men skin care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662841 | 10525 | 42257546453 | Redhill man grooming salons | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662857 | 10525 | 42257546454 | male grooming salons Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662833 | 10525 | 42257546455 | Redhill guyliner | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662844 | 10525 | 42257546456 | Redhill men hair care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662860 | 10525 | 42257546457 | salon for men Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662836 | 10525 | 42257546458 | Redhill men makeup | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662870 | 10525 | 42257546459 | guyliner Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662847 | 10525 | 42257546460 | men hair care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662863 | 10525 | 42257546461 | Redhill men haircare | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662839 | 10525 | 42257546462 | man skin care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662850 | 10525 | 42257546463 | Redhill salon for men | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662866 | 10525 | 42257546464 | Redhill men skincare | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662869 | 10525 | 42257546465 | Redhill men hair removal | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662853 | 10525 | 42257546466 | Redhill men make up | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662856 | 10525 | 42257546467 | man makeup Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662832 | 10525 | 42257546468 | male makeup Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662843 | 10525 | 42257546469 | Redhill man makeup | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662859 | 10525 | 42257546470 | Redhill male makeup | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662835 | 10525 | 42257546471 | Redhill man hair removal | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662846 | 10525 | 42257546472 | men skincare Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662862 | 10525 | 42257546473 | men skin care Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662838 | 10525 | 42257546474 | Redhill male skin care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662849 | 10525 | 42257546475 | Redhill man make up | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662865 | 10525 | 42257546476 | man make up Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662852 | 10525 | 42257546477 | men make up Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662868 | 10525 | 42257546478 | men hair removal Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662855 | 10525 | 42257546479 | Redhill man hair care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662842 | 10525 | 42257546480 | men makeup Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662858 | 10525 | 42257546481 | male hair removal Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662834 | 10525 | 42257546482 | men haircare Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662845 | 10525 | 42257546483 | Redhill male grooming salons | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662861 | 10525 | 42257546484 | Redhill man skin care | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | | 662837 | 10525 | 42257546485 | man grooming salons Redhill | Exact | NULL | | http://www.BNV9UP04.com/sem-malegroomingredhill.html?refcd=ms{OrderItemId}{MatchType}&tsacr=MS{AdId} | false | false | Active | +--------+-----------+------------------------+------------------------------+-------------+--------+------------------+------------------------------------------------------------------------------------------------------+----------+------------+--------+ 74 rows in set (0.01 sec)