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 '%BGERUP15%'; +--------+-----------+------------------------+------------------------------------+-----------------------------------------------------------------------+--------------------------------+----------------------------+---------------+--------+ | id | adGroupID | searchEngineIdentifier | title | text | displayURL | destinationURL | isDisapproved | status | +--------+-----------+------------------------+------------------------------------+-----------------------------------------------------------------------+--------------------------------+----------------------------+---------------+--------+ | 320993 | 54679 | 4054166945 | The Satellite TV Experts | Professional and Competitive. The Satellite TV Experts. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 320991 | 54679 | 4054166946 | Cable TV Installation | Expert Local Satellite TV Services. We Do The Tech. You Enjoy the TV! | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 320995 | 54679 | 4054166947 | {KeyWord:The Satellite TV Experts} | Professional and Competitive. The Satellite TV Experts. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 320997 | 54681 | 4054166948 | Cable TV Installation | Expert Local Satellite TV Services. We Do The Tech. You Enjoy the TV! | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 321001 | 54681 | 4054166949 | {KeyWord:The Satellite TV Experts} | Professional and Competitive. The Satellite TV Experts. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 320999 | 54681 | 4054166950 | The Satellite TV Experts | Professional and Competitive. The Satellite TV Experts. | http://www.martiantourism.com/ | http://martiantourism.com/ | false | Active | +--------+-----------+------------------------+------------------------------------+-----------------------------------------------------------------------+--------------------------------+----------------------------+---------------+--------+ 6 rows in set (0.01 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 '%BGERUP15%'; +--------+-----------+------------------------+------------------------------------+-----------------------------------------------------------------------+-------------------------+----------------------------+---------------+--------+ | id | adGroupID | searchEngineIdentifier | title | text | displayURL | destinationURL | isDisapproved | status | +--------+-----------+------------------------+------------------------------------+-----------------------------------------------------------------------+-------------------------+----------------------------+---------------+--------+ | 321019 | 54679 | 4054166988 | Cable TV Installation | Expert Local Satellite TV Services. We Do The Tech. You Enjoy the TV! | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 321023 | 54679 | 4054166989 | The Satellite TV Experts | Professional and Competitive. The Satellite TV Experts. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 321021 | 54679 | 4054166990 | {KeyWord:The Satellite TV Experts} | Professional and Competitive. The Satellite TV Experts. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 321027 | 54681 | 4054166985 | Cable TV Installation | Expert Local Satellite TV Services. We Do The Tech. You Enjoy the TV! | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 321025 | 54681 | 4054166986 | The Satellite TV Experts | Professional and Competitive. The Satellite TV Experts. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | | 321029 | 54681 | 4054166987 | {KeyWord:The Satellite TV Experts} | Professional and Competitive. The Satellite TV Experts. | www.martiantourism.com/ | http://martiantourism.com/ | false | Active | +--------+-----------+------------------------+------------------------------------+-----------------------------------------------------------------------+-------------------------+----------------------------+---------------+--------+ 6 rows in set (0.01 sec)