mysql> select * from locationExtension where campaignName like '%OAUTH03%'; +------+--------------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+----------------+----------------------------+ | id | locationIdentifier | campaignIdentifier | campaignId | campaignName | streetAddress1 | streetAddress2 | cityName | provinceName | countryCode | postalCode | phoneNumber | companyName | searchEngineUserIdentifier | +------+--------------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+----------------+----------------------------+ | 2317 | 830547809 | 236677889 | 1007983 | OAUTH03_1000000024_733_OAUTH03-1_GM | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | TEST Branch DN | 5227737804 | | 2318 | 830547929 | 236677769 | 1007982 | OAUTH03_1000000024_733_OAUTH03-1_GT | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | TEST Branch DN | 5227737804 | +------+--------------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+----------------+----------------------------+ 2 rows in set (0.00 sec) mysql> select * from locationExtensionFeed where campaignName like '%OAUTH03%'; +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------------+--------------+-------------+------------+-------------+-------------+----------------------------+ | id | feedId | feedItemId | feedMappingId | campaignIdentifier | campaignId | campaignName | streetAddress1 | streetAddress2 | cityName | provinceName | countryCode | postalCode | phoneNumber | companyName | searchEngineUserIdentifier | +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------------+--------------+-------------+------------+-------------+-------------+----------------------------+ | 1034 | 20303369 | 843673048 | 22076920 | 236677769 | 1007982 | OAUTH03_1000000024_733_OAUTH03-1_GT | Liberty House, 222, Regent Street | Oxford Circus, Oxford | United Kingdom | London | GB | W1B 5Tr | NULL | | 5227737804 | | 1035 | 20303369 | 843679588 | 22076920 | 236677889 | 1007983 | OAUTH03_1000000024_733_OAUTH03-1_GM | Liberty House, 222, Regent Street | Oxford Circus, Oxford | United Kingdom | London | GB | W1B 5Tr | NULL | | 5227737804 | +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------------+--------------+-------------+------------+-------------+-------------+----------------------------+ 2 rows in set (0.00 sec) mysql> select * from locationExtensionFeed where campaignName like '%OAUTH03%'; +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+-------------+----------------------------+ | id | feedId | feedItemId | feedMappingId | campaignIdentifier | campaignId | campaignName | streetAddress1 | streetAddress2 | cityName | provinceName | countryCode | postalCode | phoneNumber | companyName | searchEngineUserIdentifier | +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+-------------+----------------------------+ | 1034 | 20303369 | 843673048 | -1 | 236677769 | 1007982 | OAUTH03_1000000024_733_OAUTH03-1_GT | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | | 5227737804 | | 1035 | 20303369 | 843679588 | -1 | 236677889 | 1007983 | OAUTH03_1000000024_733_OAUTH03-1_GM | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | | 5227737804 | +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+-------------+----------------------------+ 2 rows in set (0.00 sec) mysql> select * from locationExtension where campaignName like '%OAUTH03%'; +------+--------------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+----------------+----------------------------+ | id | locationIdentifier | campaignIdentifier | campaignId | campaignName | streetAddress1 | streetAddress2 | cityName | provinceName | countryCode | postalCode | phoneNumber | companyName | searchEngineUserIdentifier | +------+--------------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+----------------+----------------------------+ | 2317 | 830547809 | 236677889 | 1007983 | OAUTH03_1000000024_733_OAUTH03-1_GM | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | TEST Branch DN | 5227737804 | | 2318 | 830547929 | 236677769 | 1007982 | OAUTH03_1000000024_733_OAUTH03-1_GT | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | TEST Branch DN | 5227737804 | +------+--------------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+----------------+----------------------------+ 2 rows in set (0.00 sec)