--
-- Host: localhost    Database: clqrwmmy_thenegotiators
-- ------------------------------------------------------


--
-- Table structure for table `account_permissions`
--

CREATE TABLE `account_permissions` (
  `account_id` bigint(20) NOT NULL DEFAULT '0',
  `role_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_id`,`role_id`),
  KEY `role_id` (`role_id`),
  CONSTRAINT `account_permissions_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`account_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `account_permissions_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `account_roles` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `account_permissions`
--

INSERT INTO `account_permissions` VALUES (10000,1),(10025,1),(10026,1),(10027,1),(10028,1),(10029,1),(10000,3),(10028,3),(10025,4),(10026,4),(10027,4),(10029,4);

--
-- Table structure for table `account_profiles`
--

CREATE TABLE `account_profiles` (
  `profile_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `account_id` bigint(20) NOT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `middle_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `name_prefix` varchar(50) DEFAULT NULL,
  `name_suffix` varchar(50) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `province` varchar(50) DEFAULT NULL,
  `postalcode` varchar(10) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `fax` varchar(15) DEFAULT NULL,
  `tollfree` varchar(15) DEFAULT NULL,
  `photo` tinytext,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`profile_id`),
  UNIQUE KEY `Account ID` (`account_id`),
  CONSTRAINT `account_profiles_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`account_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `account_profiles`
--

INSERT INTO `account_profiles` VALUES (1,10000,'Pixel',NULL,'Army',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2015-08-28 01:21:41'),(26,10025,'Pixel',NULL,'Army',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'160429043057.jpg','2016-04-29 21:30:58'),(27,10026,'Amber',NULL,'Pelechaty',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2016-07-25 20:30:47'),(28,10027,'Pete',NULL,'Desrochers',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017-02-25 20:06:53'),(32,10028,'Marks',NULL,'NxtGen',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-12-04 06:00:00'),(33,10029,'Rose',NULL,'NextGen',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-21 06:09:44');

--
-- Table structure for table `account_roles`
--

CREATE TABLE `account_roles` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `role_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`role_id`),
  UNIQUE KEY `role_name` (`role_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `account_roles`
--

INSERT INTO `account_roles` VALUES (1,NULL,'Admin'),(2,NULL,'User'),(3,1,'Master'),(4,1,'SEO');

--
-- Table structure for table `blog_authors`
--

CREATE TABLE `blog_authors` (
  `author_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `page` varchar(255) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `image_alt` tinytext,
  `content` text,
  `showhide` int(1) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '101',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`author_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blog_authors`
--

INSERT INTO `blog_authors` VALUES (1,'Admin','admin','','','',NULL,'','',0,101,'2015-11-03 11:44:25');

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `category_id` int(22) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `page` varchar(255) DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `image_alt` tinytext,
  `meta_title` varchar(100) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `focus_keyword` varchar(255) DEFAULT NULL,
  `seo_score` decimal(10,2) NOT NULL DEFAULT '0.00',
  `showhide` tinyint(1) NOT NULL DEFAULT '0',
  `ordering` int(3) NOT NULL DEFAULT '101',
  `date_added` datetime NOT NULL,
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` VALUES (1,'General','general',NULL,'','','','',16.70,0,101,'2015-10-22 11:40:02','2016-04-01 17:55:50'),(2,'Tips','tips',NULL,'','','','',41.70,0,101,'2016-04-28 13:30:31','2016-04-28 18:30:31');

--
-- Table structure for table `blog_comments`
--

CREATE TABLE `blog_comments` (
  `comment_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `message` text,
  `approved` int(1) NOT NULL DEFAULT '0',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`comment_id`),
  KEY `entry_id` (`entry_id`),
  CONSTRAINT `blog_comments_ibfk_1` FOREIGN KEY (`entry_id`) REFERENCES `blog_entries` (`entry_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blog_comments`
--


--
-- Table structure for table `blog_entries`
--

CREATE TABLE `blog_entries` (
  `entry_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(11) unsigned DEFAULT NULL,
  `author_id` int(11) unsigned DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `page` varchar(255) DEFAULT NULL,
  `description` text,
  `content` text,
  `image` varchar(500) DEFAULT '',
  `image_alt` tinytext,
  `meta_title` varchar(100) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `focus_keyword` varchar(255) DEFAULT NULL,
  `seo_score` decimal(10,2) NOT NULL DEFAULT '0.00',
  `showhide` int(1) NOT NULL DEFAULT '0',
  `post_date` date NOT NULL,
  `date_added` datetime NOT NULL,
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`entry_id`),
  KEY `author_id` (`author_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `blog_entries_ibfk_1` FOREIGN KEY (`author_id`) REFERENCES `blog_authors` (`author_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `blog_entries_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `blog_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blog_entries`
--

INSERT INTO `blog_entries` VALUES (5,1,1,'Exercising Your Negotiation Skills','exercising-negotiation-skills','Building and exercising your negotiation skills is much like building and exercising your body. After lots of exercises and working out you think you are in shape.','<p>Building and exercising your negotiation skills is much like building and exercising your body. After lots of exercises and working out you think you are in shape.</p>\r\n<p>Then an occasion arises that forces you to start using those lesser-used muscles and...Whoa! Where&rsquo;s the deep heating rub?</p>\r\n<p>How can an Olympic weight lifter possibly race with a sprinter? How does the sprinter compete in bench pressing?</p>\r\n<p>They&rsquo;re both athletes, they both train hard and they both develop their bodies. Yet they still come from different worlds.</p>\r\n<p>So it is with negotiations. We can&rsquo;t be negotiating (or even arguing) in a different world from the other party. We need to find commonality, starting from a position of at least understanding each other.</p>\r\n<p>We don&rsquo;t have to agree, but we must still appreciate the perspective of others if we hope to influence them to thinking more our way.</p>\r\n<p>So the first dispute resolution muscles we have to work on are those skills that keep us fully focused.</p>\r\n<p>We need to do our homework in advance. That might mean doing a bit of research or it may be as simple as anticipating why someone is reacting in a certain way. Others will only listen to us if we listen to them and can react intelligently to their positions or concerns.</p>\r\n<p>That&rsquo;s a lot harder than we realize. Can you sense the pending ache of those unused muscles that are about to get a workout?</p>\r\n<p>Focus and preparation are the muscles that will give us the perspective and control we need right at the starting gate. More on preparing for negotiating next week.&nbsp;</p>',NULL,'','','','',50.00,0,'2016-08-10','2016-08-10 11:08:17','2019-01-14 17:35:53'),(6,1,1,'Exercising Your Negotiation Skills – Pt. 2','exercising-negotiation-skills-pt-2','How fast will the weight lifter be on the track? What chance does the sleek sprinter have lifting several hundred kilos?','<p class=\"p1\"><span class=\"s1\">Last week we looked at the Olympic weight lifter and the sprinter. Both train hard to develop their bodies. Both are fit. Both are competitors. Both are disciplined. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">But where is the commonality? How fast will the weight lifter be on the track? What chance does the sleek sprinter have lifting several hundred kilos?</span></p>\r\n<p class=\"p1\"><span class=\"s1\">Their differences are obvious. Yet our Olympic sprinter and weight lifter still have lots in common, such as pride in representing their respective countries, the thrill of competing against the world&rsquo;s best, or the experience of travelling to and competing in exotic destinations.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">So an important negotiating muscle we need to exercise is our ability to find as many things as possible that we have in common with the other side.&nbsp;</span></p>\r\n<p class=\"p1\"><span class=\"s1\">Clearly there are going to be areas of disagreement. But if we can&rsquo;t balance those contentious points with at least a few things we have in common, we are going to appear stubborn and single minded.&nbsp;</span></p>\r\n<p class=\"p1\"><span class=\"s1\">Therefore, in preparing for an argument or negotiation we need to research the facts so we can make our points intelligently, and also reflect on why exactly the other party might have a different opinion. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">By the way, an argument is still a form of negotiation – although somewhat more emotional or animated. Applying the same skills in an argument as used in negotiation will lessen the intensity and bad feelings that can arise in arguments.&nbsp;</span></p>\r\n<p class=\"p1\"><span class=\"s1\">This holds true whether the issues are simple or complex, and regardless whether we know the other parties. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">We tend to resist doing this because it takes a little time, or because not every point we research will fall in our favor; and that&rsquo;s exactly why we need to do that research to come up with our counter argument. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">No one likes to get blindsided; but it often happens when we over-estimate our ability to “wing it” once negotiations actually begin. More on that next week.</span></p>',NULL,'','','','',57.70,0,'2016-08-17','2016-08-10 11:09:00','2019-01-14 17:35:03'),(7,1,1,'How we Might be Seen by Others','we-might-seen-others','We all function through frameworks we develop from an early age. These frameworks or “mindsets” determine how we react, how we analyze, how we plan and how we make decisions.','<p class=\"p1\"><span class=\"s1\">We all function through frameworks we develop from an early age. These frameworks or “mindsets” determine how we react, how we analyze, how we plan and how we make decisions. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">Professionally speaking, we negotiate with our “business” or external mindset, as opposed to our “personal values” mindset. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">Our business mindset starts to develop independently when we are first exposed to institutional behavior in daycare or school. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">Those infamous words “But my teacher says…” are a good example of a young mind trying to reconcile differences between the personal world and the external world.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">The more experience we gain, the stronger our external skills become. We continually develop those skills and fine tune them to meet our needs.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">Our business mindset is simply the skills we have learned to best function at work and in dealing with the real world. Who do we trust? How do we best approach our boss with a particular problem?<span class=\"Apple-converted-space\">&nbsp; </span>How do we convince the decision makers that our idea is right?</span></p>\r\n<p class=\"p1\"><span class=\"s1\">But what happens when our business mindset isn&rsquo;t enough? What do we do when it&rsquo;s clear we aren&rsquo;t making our points stick?</span></p>\r\n<p class=\"p1\"><span class=\"s1\">When sufficiently challenged, we fall back to our defense mechanisms. These defense mechanisms reflect our personal mindset…our values, beliefs and our instincts. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">We see ourselves as conveying the more fundamental arguments of common sense, or of right and wrong.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">However others may see us as no longer being objective. They may perceive us to be interjecting emotions or subjectivity. In turn, we might view their counter-arguments as now becoming personal.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">The better we understand how we might be seen by others, the better we can control our message and its effectiveness. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">An understanding of, not only our similar and differing professional goals, but also of possible shared or differing values, helps us to move each stage of negotiation to a new and higher level.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">Problems cannot be resolved at the same level that they were created. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">Similarly, we can&rsquo;t solve those problems at the same level we were at when we created them.</span></p>',NULL,'','','','',57.70,0,'2016-08-24','2016-08-10 11:10:32','2019-01-14 17:34:15'),(8,1,1,'Good Negotiators Always Prepare','good-negotiators-always-prepare','We often glide over important preparation prior to negotiating. We do this because it takes time, we don&rsquo;t like doing research that indicates we are not right on all points, and because we tend to over-estimate our ability to “wing it”.','<p><strong>We Need To Prepare…Because We Aren&rsquo;t Always Right!</strong></p>\r\n<p>We often glide over important preparation prior to negotiating. We do this because it takes time, we don&rsquo;t like doing research that indicates we are not right on all points, and because we tend to over-estimate our ability to “wing it”.</p>\r\n<p>If taking the time to do a good job is a problem, then let me save us a bit more time by suggesting that some of us need read no further. Good negotiators always prepare.</p>\r\n<p>For those still with us, let&rsquo;s talk a bit about human nature. It&rsquo;s actually is quite funny. If someone tells us we aren&rsquo;t particularly handy with tools or new technology, we smile and sometimes rationalize about our age or about not having had sufficient opportunity.</p>\r\n<p>If someone points out our notoriously unsuccessful or overly colorful love life, we blush. If someone points out we haven&rsquo;t always been the best judge of character, we embarrassingly nod.</p>\r\n<p>But let someone even hint that we may not be very good at dealing with others or that we don&rsquo;t do well standing up for ourselves, and we become defensive, emotional and argumentative.</p>\r\n<p>Serious negotiating has no room for pride. In preparing to negotiate we need to leave our ego at home. For preparation purposes, the other party is a far better negotiator and already has his or her ducks in a row. So we&rsquo;ll need to be all that much more prepared.</p>\r\n<p>That leaves just one more point: our research will often indicate we aren&rsquo;t always right.&nbsp; Bummer! So now what?</p>\r\n<p>Remember in high school English or language arts when we had to participate in those debates at the front of the class? We were put on teams, explained the rules and even given the topic to be debated. But the teacher never told us what side of the topic we would be debating. To make things worse, we ended up having to debate from the position we didn&rsquo;t even agree with.</p>\r\n<p>Skilled negotiators have to know more than just how to eloquently advance their strengths or best points. They should be able to credibly argue the other side&rsquo;s points almost as effectively.</p>\r\n<p>We, as negotiators, also need to be able to address minor issues before they become big ones. We need to know which points to concede, which points to highlight and to strategically know when to do each. No party is ever 100% right or 100% entitled.</p>\r\n<p>Knowing our weak points, knowing when we may even be wrong, knowing the other party&rsquo;s arguments and having thoroughly researched all options will help turn our weaknesses into strengths.</p>',NULL,'','','','',57.70,0,'2016-08-31','2016-08-10 11:11:18','2019-01-14 17:33:29'),(9,1,1,'Active Listening','active-listening','Everyone has his or her own idea of what active listening means. Many think it means paying close attention. Many think it means listening very aggressively looking for errors or inconsistencies. Both are incorrect.','<p>Everyone has his or her own idea of what active listening means. Many incorrectly associate this negotiating muscle with their concept of aggressive listening, where we stick to the other party&rsquo;s every word looking for a slip up or outright error upon which we can pounce.</p>\r\n<p>We see that in a happy context at the pub on NFL Sunday afternoons as friends merrily jostle on behalf of their favorite teams and football heroes. Sadly, we also often see this in domestic disputes. Either way, this type of aggressive listening for ‘one-upmanship&rsquo; has no place in true negotiations.&nbsp;&nbsp;&nbsp; &nbsp;</p>\r\n<p>Active listening is a negotiating muscle that helps us make the complicated more easily understood. It is a technique that helps us get facts easily, and in the proper perspective.<br>The first step in developing our active listening skills is to always use – and request - simple language.&nbsp; If there is something the other party is saying that we don&rsquo;t understand, we shouldn&rsquo;t hesitate to immediately ask for clarification.</p>\r\n<p>Generally, people will be appreciative that we care enough to thoroughly understand what they are trying to say. But there are far more important reasons for requesting simplicity.<br>All too often we assume we know what our counterparts are talking about, or that we&rsquo;ll be able to figure it out. That&rsquo;s when we get into trouble as other points are built upon what we don&rsquo;t fully understand.</p>\r\n<p>The further behind we fall, the more complex everything seems. Whaat we can no longer take in, we find boring. We start letting our thoughts wander, or start mentally preparing a response that has little to do with what was actually said.</p>\r\n<p>A frustrated “But I just explained that to you!” can be an embarrassing reminder and a potential loss of personal credibility.</p>\r\n<p>Another reason for asking for simplicity or clarification is to test the other party&rsquo;s knowledge of the issue. If others can&rsquo;t state their positions succinctly, they may not be entirely on top of their own facts. The less secure we are with our own understanding, the more we tend to talk in a non-descript manner. &nbsp;</p>\r\n<p>In active listening, we may also want to repeat and summarize the other party&rsquo;s point, before moving onto the next. We need not feel embarrassed doing this, as it gives other side the opportunity to correct us if there is something we didn&rsquo;t get.</p>\r\n<p>For those of us who are ADR practitioners, be wary of falling into reframing. At this point, at least, we are not out to reframe anything.</p>\r\n<p>Here is where we can ask for peripheral material or information that will back up (or potentially refute) someone&rsquo;s facts.</p>',NULL,'','','','',53.80,0,'2016-09-07','2016-08-10 11:12:18','2019-02-22 11:52:52'),(10,1,1,'Delayed Listening','delayed-listening','Delayed Listening should not be confused it with ‘Delayed Answering&rsquo;. Delayed Listening is more like “instant replay”, but through the eyes of another. (See “Paired Listening”) It is having someone else tell you what he or she heard during the negotiation or meeting. This isn&rsquo;t a James Bond thing, but a common negotiating tool.','<p>Let&rsquo;s look at another listening muscle: Delayed Listening.</p>\r\n<p>In mediation and conflict resolution training we are taught about the “Four Tongues” and the “Four Ears”. That&rsquo;s something we&rsquo;ll examine at a later date. But one of the overriding premises is that what we hear depends largely upon our mood and the situation. Ergo, we hear the words, but not necessarily the message.</p>\r\n<p>Delayed listening helps minimize misunderstands and miscomprehension. It gives us a second chance to properly interpret and to react appropriately.</p>\r\n<p>The first thing to remember about delayed listening is not to react instinctively. Our instincts are instantaneous. Most professionals have been exposed to the “Flight or Fight” concepts. But we don&rsquo;t want to react immediately. Easier said than done, right?</p>\r\n<p>We should be in the habit of carrying a pen and a small pad of paper with us at any negotiation. Regardless of its simplicity or complexity, what we most want to write down are:</p>\r\n<ul>\r\n<li>things we don&rsquo;t understand</li>\r\n<li>things we don&rsquo;t agree with</li>\r\n<li>things we don&rsquo;t accept as factual</li>\r\n<li>things we find insulting or hurtful</li>\r\n</ul>\r\n<p>We already talked about Active Listening and ways to get the other party to simplify his or her points. As for things we find offensive, there is nothing wrong with writing down what we think seems to be an attack or disrespectful… whether we think it was deliberate or inadvertent.</p>\r\n<p>This defuses some of our anger and allows us to review what was just said with a more even-tempered mind. First, we will have reduced a disrespectful attack or insult to just another strategic point we wrote down. Second, by writing and continuing to listen, a few more seconds pass before we respond.</p>\r\n<p>Don&rsquo;t forget, the most factual or revealing information from the other party often follows a verbal attack or putdown. So we should try to prolong that time following the other party&rsquo;s aggressiveness by posing more questions to precisely extract information he or she feels most supports their position.</p>\r\n<p>It is also wise to schedule regular break intervals or excuse ourselves for a nature call. If the other party has really pushed one of our buttons, the pause will allow us to take those deep breaths and count to ten. Either way, the results will be infinitely better than had we instinctively over-reacted.</p>\r\n<p>Yeah, listening… and even reading about listening… can be boring. But that, too, is just our instinct.</p>',NULL,'','','','',53.80,0,'2016-09-14','2016-08-10 11:13:04','2019-02-22 11:53:04'),(11,1,1,'Finding Commonality Among Differences','finding-commonality-among-differences','Building and exercising your negotiation skills is much like building and exercising your body. After lots of exercises and working out you think you are in shape. \r\n\r\nThen an occasion arises that forces you to start using those lesser-used muscles and...Whoa! Where&rsquo;s the deep heating rub? If you are interested in practical tools to help you be a better negotiator, a better salesperson or a better problem solver, these practical tools will help you build those lesser-used negotiating muscles.','<p>We last looked at the Olympic weight lifter and the sprinter. Both train hard to develop their bodies. Both are fit. Both are competitors. Both are disciplined.</p>\r\n<p>But where is the commonality? How fast will the weight lifter be on the track? What chance does the sleek sprinter have lifting several hundred kilos?</p>\r\n<p>Their differences are obvious. Yet our Olympic sprinter and weight lifter still have lots in common, such as pride in representing their respective countries, the thrill of competing against the world&rsquo;s best, or the experience of travelling to and competing in exotic destinations.</p>\r\n<p>So an important negotiating muscle we need to exercise is our ability to find as many things as possible that we have in common with the other side. &nbsp;</p>\r\n<p>Clearly there are going to be areas of disagreement. But if we can&rsquo;t balance those contentious points with at least a few things we have in common, we are going to appear stubborn and single minded. &nbsp;</p>\r\n<p>Therefore, in preparing for an argument or negotiation we need to research the facts so we can make our points intelligently, and also reflect on why exactly the other party might have a different opinion.</p>\r\n<p>By the way, an argument is still a form of negotiation – although somewhat more emotional or animated. Applying the same skills in an argument as used in negotiation will lessen the intensity and bad feelings that can arise in arguments. &nbsp;</p>\r\n<p>This holds true whether the issues are simple or complex, and regardless whether we know the other parties.</p>\r\n<p>We tend to resist doing this because it takes a little time, or because not every point we research will fall in our favor; and that&rsquo;s exactly why we need to do that research to come up with our counter argument.</p>\r\n<p>No one likes to get blindsided; but it often happens when we over-estimate our ability to “wing it” once negotiations actually begin. More on that next week.</p>',NULL,'','','','',50.00,0,'2019-01-14','2019-01-14 10:37:02','2019-02-22 11:50:24'),(12,1,1,'Professional Mindsets','professional-mindsets','We function through frameworks we develop from an early age. These frameworks or “mindsets” determine how we react, how we analyze, how we plan and how we make decisions. \r\n\r\nProfessionally speaking, we negotiate with our “business” or external mindset, which starts to develop when we are first exposed to institutional behavior in daycare or in school. Those infamous words “But my teacher says…” are a good example of a young mind trying to reconcile differences between the personal mindset and the external world.\r\n\r\nFrom that point forward, we all spend the rest of our lives struggling with who we are professionally vs. who we are personally. A good negotiator must always be mindful of what mindset he or she is in, especially when things get tense.','<p>We all function through frameworks we develop from an early age. These frameworks or “mindsets” determine how we react, how we analyze, how we plan and how we make decisions.</p>\r\n<p>Professionally speaking, we negotiate with our “business” or external mindset, as opposed to our “personal values” mindset.</p>\r\n<p>Our business mindset starts to develop independently when we are first exposed to institutional behavior in daycare or school.</p>\r\n<p>Those infamous words “But my teacher says…” are a good example of a young mind trying to reconcile differences between the personal world and the external world.</p>\r\n<p>The more experience we gain, the stronger our external skills become. We continually develop those skills and fine tune them to meet our needs.</p>\r\n<p>Our business mindset is simply the skills we have learned to best function at work and in dealing with the real world. Who do we trust? How do we best approach our boss with a particular problem?&nbsp; How do we convince the decision makers that our idea is right?</p>\r\n<p>But what happens when our business mindset isn&rsquo;t enough? What do we do when it&rsquo;s clear we aren&rsquo;t making our points stick?</p>\r\n<p>When sufficiently challenged, we fall back to our defense mechanisms. These defense mechanisms reflect our personal mindset…our values, beliefs and our instincts.</p>\r\n<p>We see ourselves as conveying the more fundamental arguments of common sense, or of right and wrong.</p>\r\n<p>However others may see us as no longer being objective. They may perceive us to be interjecting emotions or subjectivity. In turn, we might view their counter-arguments as now becoming personal.</p>\r\n<p>The better we understand how we might be seen by others, the better we can control our message and its effectiveness.</p>\r\n<p>An understanding of, not only our similar and differing professional goals, but also of possible shared or differing values, helps us to move each stage of negotiation to a new and higher level.</p>\r\n<p>Problems cannot be resolved at the same level that they were created.</p>\r\n<p>Similarly, we can&rsquo;t solve those problems at the same level we were at when we created them.</p>',NULL,'','','','',57.70,0,'2019-01-14','2019-01-14 10:38:33','2019-02-22 11:50:43'),(13,1,1,'Strategic Presenting','strategic-presenting','Any presentation, no matter how polished, will fail without a clear strategy. Too many are created for the quick sale, or to present a new idea. But there is no strategy…no end game. Of course, some presentations are for longer term goals and short-term goals. But both still need strategic parameters. Presenting in a strategic manner to advance our objectives means giving a “headline presentation”, as well as presenting simply and credibly.','<p>For the last number of weeks we have been looking at preparation, understanding our counterpart in negotiations, different types of “listening muscles”; and, of course, types of difficult people. We&rsquo;ll get back to identifying and dealing with other types of difficult people. But it&rsquo;s time to get back to our own negotiating skills.</p>\r\n<p>So let&rsquo;s roll up our proverbial sleeves and actually start presenting. No negotiations can begin without some sort of presentation by the parties involved; and how well we are able to negotiate largely depends on the quality and effectiveness of our initial presentation.</p>\r\n<p>Presenting in a strategic manner to advance our objectives means giving a headline presentation, as well as presenting simply and credibly.</p>\r\n<p>A headline presentation simply means “how, where, when, why, how long, who and cost. Our headline presentation is the very first part of our overall presentation. There is absolutely no selling in our headline presentation. There is no appeal or call to action in our headline presentation and there is certainly no rationalizing.</p>\r\n<p>Our presentation is neither our resume nor our organization&rsquo;s annual report. If we want to effectively lead parties down a particular path, we want to clearly show them the path and indicate where the path will take them. Only then can we start leading.</p>\r\n<p>Presenting simplistically is different from headline presenting; and it&rsquo;s important we don&rsquo;t confuse the two. There is no magic to presenting in a simplistic and comprehensive manner. We use simple words and simple sentences. We always use the active tense.</p>\r\n<p>There is no such thing as “extensive research has indicated…” It is always “My research has indicated…” or “Our research has indicated…”&nbsp; We lose credibility when we are non-descript with our validation. Let&rsquo;s leave the fight about unnamed sources to President Trump and the media.</p>\r\n<p>Nor do we need glitz, gimmicks or fanfare. We are still not trying to convince anyone of anything.&nbsp; Simplistic presenting is explaining our position, solidifying it with our facts and learning from reactions and feedback.</p>\r\n<p>Next, if our presentation isn&rsquo;t credible, any possible future negotiations are doomed. “Isn&rsquo;t our presentation credible if we headline and present in a simple, direct manner?” you ask.</p>\r\n<p>Well, we are off to a good start. But we establish credibility through sincerity, honesty, trust and professionalism. If there is a part of our presentation where our factual validation isn&rsquo;t as strong, it should be us who bring that to light… not a potential opponent.</p>\r\n<p>First, honesty is the single largest component of credibility. Second, we just took the steam out of a potential opponent who might love to expose us.</p>\r\n<p>Good presentations establish the ground rules in future negotiations for disclosure, honesty and even control. Unfortunately, credibility is the perception of the receiver; and we should never forget that.</p>',NULL,'','','','',57.70,0,'2019-01-14','2019-01-14 10:40:04','2019-02-22 11:50:55'),(14,1,1,'Presentation Practices','presentation-practices','When we negotiate we always start at the end. We must know precisely what we want and always keep the end clearly in mind, constantly being aware of cost of getting there.  \r\nThe price can be high, particularly in terms of personal satisfaction. There are always others who are not familiar with our ideas, just as there are others who simply don&rsquo;t like or care about them.  But there are negotiating tools for those who want to overcome these obstacles.','<p><em>Follow the Yellow Brick Road?&nbsp;&nbsp;&nbsp; Not!</em></p>\r\n<p>When we negotiate we always start at the end. We must know precisely what we want and always keep the end clearly in mind, constantly being aware of cost of getting there. &nbsp;</p>\r\n<p>The price can be high, particularly in terms of personal satisfaction. There are always others who are not familiar with our ideas, just as there are others who simply don&rsquo;t like or care about them.</p>\r\n<p>So we can be sure almost nobody has the time or patience to share our heroic or glamorous trip along the yellow brick road toward Oz, no matter how much it impassions us. Nor do they care how many encounters we might have had with the Wicked Witch of the West.&nbsp; &nbsp;</p>\r\n<p>Remember, we are still in the presentation stage. All we need to do is absolutely ensure that other parties see the same end as we do. As of yet, they don&rsquo;t have to agree and we don&rsquo;t have to convince them.</p>\r\n<p>So now we talk about the structure of our presentation:</p>\r\n<p><strong>Length:</strong> We&rsquo;ll likely be told how long we have to make our presentation. Our credibility will be heavily influenced by our ability to comfortably finish within the allotted timeline. We are precise in our message, accurate in our facts and thoroughly knowledgeable with the subject matter.</p>\r\n<p>If we think I&rsquo;m sounding like a broken record on preparation... too bad. But the more time we spend preparing the more we will have in actual presentation time. If we are accurate, precise and knowledgeable, the time element takes care of itself. &nbsp;</p>\r\n<p><strong>Audio Visual Aids:</strong>&nbsp; PowerPoint presentations, YouTube videos and other audio visual support are fine. But they are merely aids to our presentation. We are the show! Aids should reinforce our position, never usurp it.</p>\r\n<p><strong>Materials:</strong> Handouts should focus on the highlights of our presentation, not the highlights of our position. Resource materials can be far more detailed as long as they are not identical to any educational materials or briefing notes we already provided.</p>\r\n<p><strong>Stand Alone:</strong> We have to be sufficiently knowledgeable and confident that, if all our luggage is lost or all our materials destroyed, we could still effectively make our presentation. If we are co-presenting, we should not rely (or better stated – “depend”) on help from our partners unless it is a panel-type presentation by design.</p>\r\n<p><strong>Observation and Feedback:</strong> We need to be aware of people&rsquo;s reactions to us and observe behavior. Who wants to talk to us after the program? Who requests more information? Who ignores us? Post-presentation time is usually our best opportunity to reconcile, clarify, consolidate, identify targets and posture ourself for further negotiating.</p>\r\n<p><strong>Engagement:</strong>&nbsp; A non-engaging audience can be as detrimental as an over-engaging audience. We want our presentation to be stimulating, but not controversial. Audience engagement can be reasonably controlled. That is why we regularly identify types of difficult people.</p>\r\n<p><strong>Wrap Up:</strong>&nbsp;&nbsp; Now that we&rsquo;ve successfully made our pitch we briefly summarize the presentation (not our position) and take note of those individuals who stood out. We have the opportunity to offer them something, ask for something and promise something.</p>\r\n<p>Our wrap up includes our shopping list or actions that help us focus on the desired end. We never end a presentation with anyone wondering “what next?” or wondering what we want. Our presentation was the beginning of negotiations...not the end.</p>',NULL,'','','','',57.70,0,'2019-01-14','2019-01-14 10:42:14','2019-02-22 11:51:08'),(15,1,1,'Simplified Answering','simplified-answering','Simplified Answering follows from simplified listening. The better we can extract a simple message or thought, the better we can respond in an equally simple manner. Bottom line…the simpler the communications, the less chance for misunderstanding. No matter how well we think we are prepared, our seemingly clear message will become altered, misinterpreted and ultimately changed. If you want to simplify your complex messages,','<p>No matter how well we think we are prepared, our seemingly clear message will become changed. Make no mistake. The receiver has the power of communication. We control everything until the words leave our mouth.</p>\r\n<p>Then we have absolutely no control… not over how the message is received, not over whether it was received correctly, not over how our message is decoded and not over how other will react.</p>\r\n<p>What we can control, however, is ourselves… how we deliver the message, how we interpret the mood and situation of the other parties, and so on. The better we control ourselves in what we say, what we do, how we say it and how we do it…the more we can positively influence that which we cannot control.</p>\r\n<p>One of the reasons we spent so much time on building our listening muscles is that we now have the advantage of using some of those muscles again. The only difference now is that we are going to use them for answering.</p>\r\n<p>With Simplified Answering, “Less is more”. How little can we say to fully answer the question? We already discussed the notion that if someone rambles, is non-descript or can&rsquo;t use simple terms to relate his or her position, there is a good chance that person isn&rsquo;t fully prepared or sufficiently knowledgeable.</p>\r\n<p>The same applies to us. If we can&rsquo;t present our facts and explain our position in clear, simple, common sense terms, we haven&rsquo;t sufficiently done our homework and are not ready to negotiate. The more we babble, the less credible we become.</p>\r\n<p>One way to keep ourselves easily understood is to not talk about too much at the same time. We want to identify and isolate each component of our position, addressing each one separately and completely. What we are doing is compartmentalizing; and we can&rsquo;t do that unless we totally know our stuff.</p>\r\n<p>Saying less or keeping it simple does not mean withholding or concealing information. It means answering one specific question or addressing one specific issue, but not answering or addressing anything else until asked or questioned. That alone significantly reduces the risk of misinterpretation.</p>\r\n<p>Remember, the way we take in information listening to a presentation is different to how we take in information when we are actually questioning or challenging someone.</p>\r\n<p>So we want to avoid phrases like “…which leads me to my next point…” after having answered a question. First, we don&rsquo;t have to defend or justify when and why we are making our next point. Second, we need to give the other party time to disengage the targeted questioning mode of thinking and return to an open information-gathering mentality. &nbsp;</p>\r\n<p>A quick “Do you have more questions on this point?” is really all that is necessary for the other party to switch gear.</p>\r\n<p>Also, we want to resist the temptation of guessing why someone else asks a question. It&rsquo;s really none of our business. There could be any number of reasons somebody asks a question. Trying to guess why starts us down that slippery slope of misinterpretation, or even suspicion.</p>\r\n<p>We don&rsquo;t anticipate. We don&rsquo;t judge motives. We don&rsquo;t assume what the other party does or doesn&rsquo;t know and we don&rsquo;t answer anything beyond precisely what is asked. There will be time for all that later.</p>',NULL,'','','','',57.70,0,'2019-01-14','2019-01-14 10:43:54','2019-02-22 11:51:22'),(16,1,1,'Targeted Answering','targeted-answering','Targeted answering is a negotiating muscle for when there are multiple parties discussing something, each from their own perspectives. A department heads meeting would be a good example. This is a valuable negotiating and presentation tool because you must learn to identify, isolate and quickly determine diverse responses.','<p>When we talked about simplified answering we focused on the exchange of information…facts, figures, details and historical events.</p>\r\n<p>Targeted answering is a negotiating muscle for when there are multiple parties discussing something, each from their own perspectives. A department heads meeting would be a good example.</p>\r\n<p>Just as we identified and isolated compartments of information to answer factual questions, we are now going to identify and isolate our target audiences. Each party may be an individual or a number of people representing the same position. Each party with its own perspective or goal is one specific target audience.</p>\r\n<p>So in the room we may have 10 or 12 people, but only four or five target audiences. When we identify and isolate our audiences, we also prioritize them in terms of importance to us.</p>\r\n<p>This is where the negotiations chess game begins. Whenever we comment, or present opinions, we target our answers or statements to our most important audience. Of course we want to do this without alienating the other parties in the room.</p>\r\n<p>But that really isn&rsquo;t so hard. Remember, facts do not alienate. Opinions, positions, ambitions, emotions, goals and needs might alienate because they all reflect values…but facts do not alienate.</p>\r\n<p>So let&rsquo;s create our first scenario. We are going to be one of several presenters to department heads of our corporation. We have in the large corporate boardroom:</p>\r\n<table style=\"height: 161px; width: 787.5px;\">\r\n<tbody>\r\n<tr style=\"height: 128px;\">\r\n<td style=\"width: 396px; height: 128px;\">\r\n<ul>\r\n<li>The Director of Finance&nbsp;</li>\r\n<li>The Director of Sales</li>\r\n<li>The Director of Public Relations</li>\r\n<li>The Director of Stakeholder Relations</li>\r\n<li>Corporate General Counsel</li>\r\n</ul>\r\n</td>\r\n<td style=\"width: 373.5px; height: 128px;\">\r\n<ul>\r\n<li>The Director of Operations</li>\r\n<li>The Director of Customer Service</li>\r\n<li>The Director of Investment</li>\r\n<li>The Director of Regulatory Affairs</li>\r\n<li>The Director of Transportation</li>\r\n</ul>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p>There are a few people whom we don&rsquo;t know, including two or three people we think are other vice presidents, but we&rsquo;re not sure from what departments. These other two or three people keep casually leaving and re-entering the room.</p>\r\n<p>At the back is also a huge credenza. On it is an impressive tray of pastries, as well as a very large coffee urn. The scene is set and we are almost ready to go.&nbsp;</p>',NULL,'','','','',57.70,0,'2019-01-14','2019-01-14 10:45:02','2019-02-22 11:51:32'),(17,1,1,'Controlled Answering','controlled-answering','Everything in negotiations has to do with having control over our answering and our listening. There are many types of control; but right now, we will be controlling our anxieties, insecurities and weak points in our own argument.  If you are prone to being flustered or taken off -subject, this might be particularly interesting for you.','<p>The final answering muscle we will look at before entering into some serious negotiating is “controlled answering”. The reason it seems like a derivative of the other forms of answering is… because it is.</p>\r\n<p>Controlled answering is the temptation not to react, along with the other strategic answering techniques. It also incorporates identifying and isolating targeted audiences, compartmentalizing, and distinguishing facts from opinions and values.</p>\r\n<p>Controlled answering differs in what we are controlling. This time we are controlling our anxieties, insecurities and weak points in our own argument.&nbsp; &nbsp;</p>\r\n<p>The best way to control our anxiety is to know deep down we have done our homework completely, thoroughly and to best of our ability. If we are presenting in that fictitious boardroom we created last week, we are the subject experts. We are the proponents of a marvelous idea that has already been considered worthy of pursuing… at least to where we are now.</p>\r\n<p>What we present significantly affects how we present. Obvious, you think? Let&rsquo;s say we are attempting to negotiate the creation of a product or service that has merit, is feasible and logically sound. So we want to control the rate, pace and style of our answers to questions to befit the quality of our knowledge and our confidence in our proposal. &nbsp;</p>\r\n<p>This is opposed to trying to rally everyone to come out and cheer loudly for the home team. Yet believe it or not, many do not reconcile the manner in which they respond to the demeanor of product, service or action they are proposing.</p>\r\n<p>Controlled answering is disciplined answering. Again, we stick to exactly what is asked. We don&rsquo;t fear silence. We don&rsquo;t fear skeptical or disapproving looks. Oh, and long silences do <strong>not</strong> break the communication chain we are trying to build.</p>\r\n<p>Skilled opponents will use long silences to see if we become nervous and say more than we planned in order to break the awkward quiet and keep the communication chain. But we are sticking to what we have learned thus far as the meeting begins.</p>\r\n<p>The Vice president of Operations has called everyone to be seated, someone at the back closes the boardroom door, and two or three people quickly refill their coffee cups and take their place.</p>',NULL,'','','','',57.70,0,'2019-01-14','2019-01-14 10:46:38','2019-02-22 11:51:44'),(18,1,1,'Difficult People - Snipers','difficult-people-snipers','rom time to time we all must deal with difficult people who are very good at derailing our best efforts, confounding what we say and challenging us at every opportunity. One type of difficult person is the “Sniper”.  Snipers are most dangerous when we are making a presentation to clients or proposing something new to a group of peers. They hide in the background and suddenly shoot a malicious zinger right when you are speaking.','<p>As in real life, “Snipers” are dangerous and calculating opponents.&nbsp; Snipers don&rsquo;t face you head-on. They lurk in hiding or in the protection of their surroundings.</p>\r\n<p>They take aim at you and, when the opportunity presents itself, they take the shot.</p>\r\n<p>Snipers are most dangerous when we are making a presentation to clients or proposing something new to a group of peers, as in perhaps a staff meeting.<br>So how do we stop Snipers from shooting us down when we are front-and centre and the most exposed?</p>\r\n<p>First, expect them. Be prepared for something to suddenly come at you from left field. The best way to do this is to be prepared. This goes back to exercising those negotiating muscles.</p>\r\n<p>If we have done our research and preparation thoroughly, there won&rsquo;t be much we haven&rsquo;t considered. We know the strengths and weaknesses of our position and we know what questions people are going to ask.</p>\r\n<p>Unlike other types of difficult people, Snipers need to be out of the limelight and among others.&nbsp; It&rsquo;s when we are in the spotlight (and they are not) they are the most comfortable.</p>\r\n<p>So, here we are presenting and a Sniper has taken his or her first shot. All eyes are now on us again. If the question is a legitimate one, then we should just answer it and then continue. We might remind the group as a whole that we will be happy to answer questions at the end of our presentation.</p>\r\n<p>Still, it is a good idea for us to watch our rear. How we handle the first Sniper may affect how other potential Snipers behave.</p>\r\n<p>If the Sniper persists and we feel it is being disruptive to our message, we need to deal with the problem.</p>\r\n<p>One way is to concentrate attention on the Sniper. Ask questions back.</p>\r\n<p>“Oh, is this something of interest to you?”</p>\r\n<p>“Would you like to further explain your concerns?”</p>\r\n<p>“How would you address this issue?”</p>\r\n<p>“I&rsquo;d very much enjoy you sitting down with the presentation team and/or management to outline your views!”</p>\r\n<p>With the spotlight now on the Sniper, that person will likely scramble to get back into hiding. If the Sniper is sincere, he or she will indeed want to talk to us later and is likely to quiet down so as to learn as much as possible.</p>\r\n<p>If the Sniper is indeed just a troublemaker, he or she will not want to be put in the spotlight again. Knowing what to expect from us may well make other potential Snipers think twice before interrupting.</p>\r\n<p>Finally, as a follow up, we should assess the motives of Snipers and determine “why” they are taking pot shots. It usually isn&rsquo;t hard to figure out and may be something we can use going forward.</p>',NULL,'','','','',57.70,0,'2019-01-14','2019-01-14 10:48:35','2019-02-22 11:51:55'),(19,1,1,'Difficult People - Sherman Tanks','difficult-people-sherman-tanks','Sherman Tanks” are those who make it very clear “It&rsquo;s my way or the highway!” They are right and that&rsquo;s all there is to it; and they have no hesitation about running over us to achieve that end. But, as with other difficult people, there are ways to work around and work with Sherman Tanks.','<p>“Sherman Tank” is used in many communication courses to describe a type of difficult person. Sherman tanks are people who are absolutely compelled to make you see things their way. Getting us to agree with them is the single most important objective for Sherman Tanks.</p>\r\n<p>If we do agree, they can sometimes try to take partial ownership of our position or initiative. Sherman Tanks also will test your strength of character, confidence and subject matter knowledge.</p>\r\n<p>The trick is, they may or may not have much knowledge themselves, and that isn&rsquo;t always easy to determine.</p>\r\n<p>In making a presentation they are quite easy to identify because they will be fairly vocal about what we present. (They also won&rsquo;t hesitate to comment on what others say or ask.)</p>\r\n<p>Some Sherman Tanks can be quite helpful in moving a project forward. But they are always an additional worry and we need to be attuned to what they are up to.</p>\r\n<p>As strong and blustery as they may be, they can also be easily offended; and they make formidable adversaries.</p>\r\n<p>So in dealing with Sherman Tanks, we need to stand up to them without engaging them directly. While still being amiable, addressing them by name and looking them in the eye are good strategies, as they are compelled to test our metal.</p>\r\n<p>How much responsibility are they prepared to accept? What information or experience can they bring to the table? Are they prepared to back up their musings?&nbsp;</p>\r\n<p>The quicker we can the amount of knowledge / influence / power, the quicker we can determine what they want and where we see them in the greater scheme of things. <br>They may want to simply impress, or they may want a piece of the action. Neither is necessarily bad; but Sherman Tanks are among the highest maintenance of all difficult people.</p>\r\n<p>Many collaborative skills already know to experienced ADR practitioners work very well on Sherman Tanks. Once on board, we can cooperatively move forward with them.</p>',NULL,'','','','',57.70,0,'2019-01-14','2019-01-14 10:50:53','2019-02-22 11:52:15'),(20,1,1,'Difficult People – Exploders','difficult-people-exploders','We&rsquo;ve all had to deal with “Exploders” at one time or another. An Exploder will, with no warning, light up the room in a fiery rage that&rsquo;s likely to register 4.5 on the Richter scale. Let&rsquo;s be honest, some of can deal with Exploders better than others of us. So if you want to get a handle on how to better contain Exploders…','<p>Exploders make up the second category of difficult people we are going to look at; but they are totally opposite from the Snipers we dealt with before. Unlike the Sniper, who hides in the surroundings, the Exploder is totally in your face.</p>\r\n<p>So why is it that somebody, for no apparent reason, will light up the meeting room in a fiery rage while we are presenting or during negotiations?</p>\r\n<p>There are numerous possible answers, but the most common are fear or anger. The person may fear that our ideas will usurp his or her plans if they were to be implemented. If we are right, where might that leave the Exploder?</p>\r\n<p>The fear could be an instinctive response to a challenge. Simply stated, some people are just inclined to that temperament.</p>\r\n<p>Anger can emerge from territorialism. Perhaps our initiative treads into what someone considers his or her territory and we are becoming an unwelcome intruder. Perhaps this person is insulted that we didn&rsquo;t consult with him/her first.</p>\r\n<p>Whatever the reason, Exploders expect us to wilt under the firestorm of their rage, or to at least back off somewhat in order to accommodate or please.</p>\r\n<p>It&rsquo;s important to remember that most Exploders explode because it has worked for them before. They also depend upon the element of surprise.</p>\r\n<p>So the first rule for us in dealing with an Exploder is “Don&rsquo;t&rsquo; Panic”. We need to take a second or two to regain our internal composure.</p>\r\n<p>Rule number two… Don&rsquo;t defend ourselves.</p>\r\n<p>That is what the Exploder (and likely everyone else in the room) is expecting. Chances are that part of the tirade against us will include a few personal attacks such as “Didn&rsquo;t you have the sense to think about…?” or “what kind of idiot would assume…?”</p>\r\n<p>Part of the explosion is a performance. Exploders are aware they have to sufficiently justify their behavior; and one good way is belittling us.</p>\r\n<p>OK, great. We are not panicking and we are not defending. But we have this disturbance going on in the middle of our presentation. Now what?</p>\r\n<p>Let Exploders run on until they run down. When our Exploder finally runs out of steam a mild mannered question back might be “Is there anything else?”<br><br>Exploders will not have the energy or the wherewithal to repeat that kind of Academy performance. Nor are they likely to persist with personal insults or zingers, for fear of being seen by others as a bully or troublemaker.</p>\r\n<p>Their only option is to calm down and focus on the points of their contention. Chances are they are not nearly as prepared as we are and will soon be desperately looking for a way off center stage.</p>\r\n<p>We don&rsquo;t retaliate, we don&rsquo;t get redirected and we don&rsquo;t try to appease.</p>\r\n<p>We remain pleasant. Once the Exploder has calmed down we will synthesize the key points of the Exploder&rsquo;s tirade and restate. Typical reframing.</p>\r\n<p>We address anything in the Exploder&rsquo;s tirade that might be a question we&rsquo;d have to answer anyway.<br><br>We can then absorb the Exploders arguments into our own. “He brought up a very important concern that I will be addressing momentarily.”&nbsp; “It would seem from what she just stated that we envision similar goals, but as yet differ on how best to achieve them.”</p>\r\n<p>We are effectively making the Exploder&rsquo;s problem a group problem (or a group challenge), inviting further feedback and suggestions at the appropriate time; and that is definitely not what the Exploder wants.</p>',NULL,'','','','',57.70,0,'2019-01-14','2019-01-14 10:52:28','2019-02-22 11:52:05'),(21,1,1,'Dealing With Difficult People','dealing-difficult-people','We all have to deal with difficult people who are very good at derailing our best efforts, confounding what we say and challenging us at every opportunity.','<p>We all have to deal with difficult people who are very good at derailing our best efforts, confounding what we say and challenging us at every opportunity.</p>\r\n<p>But why? It doesn&rsquo;t get them anything…or does it? Why are some people difficult?</p>\r\n<p>The answer is simple:</p>\r\n<ol>\r\n<li>It works</li>\r\n<li>It satisfies</li>\r\n<li>It feels good</li>\r\n</ol>\r\n<p>That&rsquo;s it in a nutshell.&nbsp; If people are adverse to change, afraid to take risk, or view us as a competitor, they will throw out every roadblock they can.</p>\r\n<p>Ambitious or aggressive colleagues, managers who are more interested in protecting their positions, or anyone who sees us as a challenge to their status quo could resort to being difficult people.</p>\r\n<p>Then there are those who are simply poop disturbers (Sorry, this is a family newspaper); but they are a topic for another column.</p>\r\n<p>Let&rsquo;s be honest, we&rsquo;re all difficult at times. We all have values and beliefs that are non-negotiable. We all have buttons that shouldn&rsquo;t be pushed. Pushing those buttons is guaranteed to result in a reaction that won&rsquo;t impress anyone.</p>\r\n<p>Being difficult, especially if it gets us what we want now and then, can easily become addictive. If the behavior works we&rsquo;ll use it again, and again, and again.</p>\r\n<p>So we need to differentiate between difficult behavior and difficult people. They are certainly not the same; and how we recognize the difference will determine our success or failure on any given project.</p>\r\n<p>For strategic purposes, there are 11 types of difficult people. They are the:</p>\r\n<ol>\r\n<li>Snipers</li>\r\n<li>Exploders</li>\r\n<li>Sherman Tanks</li>\r\n<li>Complainers</li>\r\n<li>Negativists</li>\r\n<li>Know-It-Alls</li>\r\n<li>Non-Responsives</li>\r\n<li>Pretenders</li>\r\n<li>Super Agreeables</li>\r\n<li>Indecisives</li>\r\n<li>The Externally Empowereds</li>\r\n</ol>\r\n<p>Next week we will look at dealing with “Snipers”.</p>',NULL,'','','','',53.80,0,'2019-01-14','2019-01-14 10:54:42','2019-01-14 17:54:42'),(22,1,1,'Focussed Listening','focussed-listening','Believe it or not, we actually listen to only 25% of what we hear. Of that, we accurately process just over half. Wow! Is it any wonder we have trouble communicating? Focussed Listening is an exercise to retain more of what we hear and knowingly tone down our stronger senses such as sight and smell in achieving a better balance of stimulation and information we take in.','<p>We listen to only 25% of our capability to audibly intake and process. Simply stated, we listen to only 25% of what we hear. Of that, we accurately process just over half.</p>\r\n<p>For some reason, we assimilate audio stimuli less efficiently than any of our other senses. We react more strongly, for example, to pleasant or unpleasant smells than we do to pleasant or unpleasant sounds. If what we see conflicts with what we hear, we trust what we see.</p>\r\n<p>Interestingly, women process audio stimuli better than men.</p>\r\n<p>Any number of detractions can interfere with our accurately receiving important messages… including ourselves.</p>\r\n<p>We think four times faster than the normal rate of the spoken word. So if someone is talking too slowly, or about something uninteresting, we eventually tune that person out. Our mind starts to wander.<br><br>No matter how hard we try to pay attention, sometimes we just can&rsquo;t help it. Our brain is longing for stimuli that it can process more efficiently, and almost anything will do: remembering last night&rsquo;s America&rsquo;s Got Talent show, planning our next dinner party, anything!</p>\r\n<p>Have you ever wanted to finish people&rsquo;s sentences in advance of them? Sadly, once we are ahead of them, the chances of them totally regaining our attention are slim.</p>\r\n<p>We&rsquo;ll come back to this when we look at our presentation skills; but we all know the difference between a dynamic public speaker and boring one. Ever start to doze off at church if the sermon is boring?</p>\r\n<p>Our problem is that what they are saying could still be extremely important. So here is where we start developing some of those strategic muscles. The first will be “strategic” listening.</p>',NULL,'','','','',53.80,0,'2019-01-14','2019-01-14 10:55:42','2019-02-22 11:53:16');

--
-- Table structure for table `blog_entries_shares`
--

CREATE TABLE `blog_entries_shares` (
  `entry_id` int(11) NOT NULL,
  `account_id` bigint(22) DEFAULT NULL,
  `session_id` tinytext NOT NULL,
  `ip_address` tinytext NOT NULL,
  `hostname` tinytext NOT NULL,
  `pubid` varchar(255) DEFAULT '' COMMENT 'AddThis Profile ID',
  `service` varchar(255) NOT NULL DEFAULT '' COMMENT 'Social Media Site',
  `domain` varchar(255) NOT NULL,
  `url` text NOT NULL,
  `share_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blog_entries_shares`
--


--
-- Table structure for table `blog_settings`
--

CREATE TABLE `blog_settings` (
  `blog_id` int(20) NOT NULL AUTO_INCREMENT,
  `social_sharing` enum('0','1') NOT NULL DEFAULT '1',
  `comments` enum('0','1') NOT NULL DEFAULT '1',
  `comment_approval` enum('0','1') NOT NULL DEFAULT '1',
  `show_author` enum('0','1') NOT NULL DEFAULT '1',
  `empty_categories` enum('0','1') NOT NULL DEFAULT '1',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`blog_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blog_settings`
--

INSERT INTO `blog_settings` VALUES (1,'0','0','1','0','0','2016-08-10 21:57:22');

--
-- Table structure for table `cms_permissions`
--

CREATE TABLE `cms_permissions` (
  `account_id` bigint(20) NOT NULL DEFAULT '0',
  `section_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_id`,`section_id`),
  KEY `section_id` (`section_id`),
  CONSTRAINT `cms_permissions_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`account_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cms_permissions_ibfk_2` FOREIGN KEY (`section_id`) REFERENCES `cms_sections` (`section_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_permissions`
--

INSERT INTO `cms_permissions` VALUES (10025,5),(10026,5),(10027,5),(10029,5),(10025,6),(10026,6),(10027,6),(10029,6),(10025,7),(10026,7),(10027,7),(10029,7),(10025,8),(10026,8),(10027,8),(10029,8),(10025,13),(10026,13),(10027,13),(10029,13),(10025,23),(10026,23),(10027,23),(10029,23),(10025,30),(10026,30),(10027,30),(10029,30),(10025,31),(10026,31),(10027,31),(10029,31),(10025,33),(10026,33),(10027,33),(10029,33),(10025,34),(10026,34),(10027,34),(10029,34);

--
-- Table structure for table `cms_sections`
--

CREATE TABLE `cms_sections` (
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `page` varchar(100) DEFAULT NULL,
  `filelocation` varchar(100) DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `showhide` int(1) NOT NULL DEFAULT '0',
  `ordering` int(11) DEFAULT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_sections`
--



--
-- Table structure for table `cms_settings`
--

CREATE TABLE `cms_settings` (
  `id` int(11) NOT NULL,
  `enhanced_seo` int(1) NOT NULL DEFAULT '0' COMMENT '1 = enabled',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_settings`
--

INSERT INTO `cms_settings` VALUES (1,1);

--
-- Table structure for table `cms_user_panels`
--

CREATE TABLE `cms_user_panels` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) unsigned NOT NULL,
  `section_id` int(11) NOT NULL,
  `panel_index` int(2) NOT NULL,
  `action` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_user_panels`
--

INSERT INTO `cms_user_panels` VALUES (2,10027,9,1,'edit');

--
-- Table structure for table `email_events`
--

CREATE TABLE `email_events` (
  `event_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sg_event_id` varchar(225) DEFAULT NULL,
  `event` text,
  `location` varchar(200) DEFAULT NULL,
  `event_type` varchar(200) DEFAULT NULL,
  `email` text,
  `status` text,
  `response` text,
  `attempt` text,
  `reason` text,
  `type` text,
  `url` text,
  `category` text,
  `date` timestamp NULL DEFAULT NULL,
  `newsletter_id` varchar(20) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`event_id`),
  UNIQUE KEY `sg_event_id` (`sg_event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_events`
--

INSERT INTO `email_events` VALUES (1,NULL,'unsubscribe',NULL,NULL,'meryll@pixelarmy.ca',NULL,NULL,NULL,NULL,NULL,'','Newsletters','2016-05-13 14:02:21','2',NULL);

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `faq_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(11) unsigned DEFAULT NULL,
  `question` varchar(500) DEFAULT NULL,
  `answer` text,
  `ordering` int(1) NOT NULL DEFAULT '101',
  `showhide` int(1) NOT NULL DEFAULT '0',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`faq_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `faq_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `faq_categories` (`category_id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `faq`
--



--
-- Table structure for table `faq_categories`
--

CREATE TABLE `faq_categories` (
  `category_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `ordering` int(1) NOT NULL DEFAULT '101',
  `showhide` int(1) NOT NULL DEFAULT '0',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `faq_categories`
--

INSERT INTO `faq_categories` VALUES (1,'General',101,0,'2016-05-02 21:22:07'),(2,'Business',101,0,'2016-05-02 21:28:34'),(3,'Divorce',101,0,'2016-08-10 21:00:44'),(4,'Teenager',101,0,'2016-08-10 21:00:52'),(5,'Environmental',101,0,'2016-08-10 21:02:51'),(6,'Sexual Harassment',101,0,'2016-08-10 21:03:57'),(7,'Online Mediation',101,0,'2016-08-10 21:04:07');

--
-- Table structure for table `games`
--

CREATE TABLE `games` (
  `game_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `introduction` text,
  `description` text,
  `content` text,
  `image` varchar(100) DEFAULT NULL,
  `filename` varchar(100) DEFAULT NULL,
  `page` varchar(100) DEFAULT NULL,
  `ordering` int(1) NOT NULL DEFAULT '101',
  `showhide` int(1) NOT NULL DEFAULT '0',
  `meta_title` varchar(100) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `focus_keyword` varchar(100) DEFAULT NULL,
  `seo_score` decimal(10,2) NOT NULL DEFAULT '0.00',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`game_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `games`
--

INSERT INTO `games` VALUES (1,'Angry Neighbors','Sonia and Jim are neighbors. Sonia has poisoned Jim\'s plants by the excessive use of weed killer on her side of the fence and Jim wants compensation.','Sonia and Jim are neighbors. Sonia has poisoned Jim\'s plants by the excessive use of weed killer on her side of the fence and Jim wants compensation.',NULL,NULL,'angryneighbors.swf','angry-neighbors',101,0,NULL,NULL,NULL,0.00,'2016-07-28 15:18:17'),(2,'The Raise','Negotiate with your tight-wad boss to get the raise you deserve.','Negotiate with your tight-wad boss to get the raise you deserve.',NULL,NULL,'Theraisenewgeneric.swf','the-raise',101,0,NULL,NULL,NULL,0.00,'2016-07-28 15:18:30'),(3,'Union Management','Can you avert a strike by helping Union and Management representatives reach a deal? ','Can you avert a strike by helping Union and Management representatives reach a deal? ',NULL,NULL,'unionmanagement.swf','union-management',101,0,NULL,NULL,NULL,0.00,'2016-07-28 15:18:41'),(4,'Customer Service','Meet Lola. She really likes her job. She used to have an anger management problem. Now she smiles and passes the rage onto her clients.','Meet Lola. She really likes her job. She used to have an anger management problem. Now she smiles and passes the rage onto her clients.',NULL,NULL,'Customservice3.swf','customer-service',101,0,NULL,NULL,NULL,0.00,'2016-07-28 15:18:51');

--
-- Table structure for table `global_hours`
--

CREATE TABLE `global_hours` (
  `hours_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `region_code` varchar(50) DEFAULT NULL,
  `day` varchar(20) DEFAULT NULL,
  `start_time` time NOT NULL DEFAULT '00:00:00',
  `end_time` time NOT NULL DEFAULT '00:00:00',
  `closed` int(1) NOT NULL DEFAULT '0',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`hours_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `global_hours`
--

INSERT INTO `global_hours` VALUES (1,'','Monday','08:30:00','21:00:00',0,'2016-09-06 17:40:00'),(2,'','Tuesday','08:30:00','21:00:00',0,'2016-09-06 17:40:00'),(3,'','Wednesday','08:30:00','21:00:00',0,'2016-09-06 17:40:00'),(4,'','Thursday','08:30:00','21:00:00',0,'2016-09-06 17:40:00'),(5,'','Friday','08:30:00','22:00:00',0,'2016-09-06 17:40:00'),(6,'','Saturday','08:30:00','18:00:00',0,'2016-09-06 17:40:00'),(7,'','Sunday','12:00:00','18:00:00',0,'2016-09-06 17:40:00'),(8,'_2','Monday','09:00:00','17:00:00',0,'2016-09-01 15:02:25'),(9,'_2','Tuesday','09:00:00','17:00:00',0,'2016-09-01 15:02:27'),(10,'_2','Wednesday','09:00:00','17:00:00',0,'2016-09-01 15:02:28'),(11,'_2','Thursday','09:00:00','17:00:00',0,'2016-09-01 15:02:29'),(12,'_2','Friday','09:00:00','17:00:00',0,'2016-09-01 15:02:31'),(13,'_2','Saturday','00:00:00','00:00:00',1,'2016-09-01 15:02:32'),(14,'_2','Sunday','00:00:00','00:00:00',1,'2016-09-01 15:02:33'),(15,'_3','Monday','08:00:00','16:00:00',0,'2016-09-01 15:32:44'),(16,'_3','Tuesday','08:00:00','16:00:00',0,'2016-09-01 15:32:53'),(17,'_3','Wednesday','08:00:00','16:00:00',0,'2016-09-01 15:33:03'),(18,'_3','Thursday','08:00:00','16:00:00',0,'2016-09-01 15:33:14'),(19,'_3','Friday','08:00:00','16:00:00',0,'2016-09-01 15:33:21'),(20,'_3','Saturday','00:00:00','00:00:00',1,'2016-09-01 15:49:34'),(21,'_3','Sunday','00:00:00','00:00:00',1,'2016-09-01 15:49:34');

--
-- Table structure for table `global_numbers`
--

CREATE TABLE `global_numbers` (
  `number_id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(20) DEFAULT NULL,
  `tollfree` int(11) NOT NULL DEFAULT '0',
  `hearingimpaired` int(11) NOT NULL DEFAULT '0',
  `type` enum('customer support','technical support','billing support','bill payment') NOT NULL DEFAULT 'customer support',
  `region_code` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`number_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `global_numbers`
--

INSERT INTO `global_numbers` VALUES (1,'',0,0,'customer support',NULL),(2,'',0,0,'technical support',NULL),(3,'',0,0,'billing support',NULL),(4,'',0,0,'bill payment',NULL),(5,'',0,0,'customer support','_2'),(6,'',0,0,'technical support','_2'),(7,'',0,0,'billing support','_2'),(8,'',0,0,'bill payment','_2'),(9,'',0,0,'customer support','_3'),(10,'',0,0,'technical support','_3'),(11,'',0,0,'billing support','_3'),(12,'',0,0,'bill payment','_3');

--
-- Table structure for table `global_settings`
--

CREATE TABLE `global_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(100) DEFAULT NULL,
  `slogan` text,
  `disclaimer` text,
  `banner_image` varchar(100) DEFAULT NULL,
  `banner_image_alt` tinytext,
  `faq_image` varchar(100) DEFAULT NULL,
  `faq_image_alt` tinytext,
  `contact_address` varchar(50) DEFAULT NULL,
  `contact_address2` varchar(50) DEFAULT NULL,
  `contact_city` varchar(50) DEFAULT NULL,
  `contact_province` varchar(50) DEFAULT NULL,
  `contact_postal_code` varchar(10) DEFAULT NULL,
  `contact_country` varchar(50) DEFAULT NULL,
  `contact_phone` varchar(20) DEFAULT NULL,
  `contact_fax` varchar(20) DEFAULT NULL,
  `contact_toll_free` varchar(20) DEFAULT NULL,
  `contact_email` varchar(50) DEFAULT NULL,
  `contact_address_2` varchar(50) DEFAULT NULL,
  `contact_address2_2` varchar(50) DEFAULT NULL,
  `contact_city_2` varchar(50) DEFAULT NULL,
  `contact_province_2` varchar(50) DEFAULT NULL,
  `contact_postal_code_2` varchar(10) DEFAULT NULL,
  `contact_country_2` varchar(50) DEFAULT NULL,
  `contact_phone_2` varchar(20) DEFAULT NULL,
  `contact_fax_2` varchar(20) DEFAULT NULL,
  `contact_toll_free_2` varchar(20) DEFAULT NULL,
  `contact_email_2` varchar(50) DEFAULT NULL,
  `contact_address_3` varchar(50) DEFAULT NULL,
  `contact_address2_3` varchar(50) DEFAULT NULL,
  `contact_city_3` varchar(50) DEFAULT NULL,
  `contact_province_3` varchar(50) DEFAULT NULL,
  `contact_postal_code_3` varchar(10) DEFAULT NULL,
  `contact_country_3` varchar(50) DEFAULT NULL,
  `contact_phone_3` varchar(20) DEFAULT NULL,
  `contact_fax_3` varchar(20) DEFAULT NULL,
  `contact_toll_free_3` varchar(20) DEFAULT NULL,
  `contact_email_3` varchar(50) DEFAULT NULL,
  `email_contactform` varchar(50) DEFAULT NULL,
  `email_accounts` varchar(50) DEFAULT NULL,
  `email_orders` varchar(50) DEFAULT NULL,
  `google_map` int(1) NOT NULL DEFAULT '1' COMMENT '1 = show map',
  `gpslat` varchar(50) DEFAULT NULL,
  `gpslong` varchar(50) DEFAULT NULL,
  `zoom` int(2) DEFAULT NULL,
  `timezone` varchar(255) DEFAULT 'America/Edmonton',
  `show_hours` int(1) NOT NULL DEFAULT '0' COMMENT '1 = show hours',
  `google_map_2` int(1) NOT NULL DEFAULT '1',
  `gpslat_2` varchar(50) DEFAULT NULL,
  `gpslong_2` varchar(50) DEFAULT NULL,
  `zoom_2` int(2) DEFAULT NULL,
  `timezone_2` varchar(255) DEFAULT NULL,
  `show_hours_2` int(1) NOT NULL DEFAULT '0',
  `google_map_3` int(1) NOT NULL DEFAULT '1',
  `gpslat_3` varchar(50) DEFAULT NULL,
  `gpslong_3` varchar(50) DEFAULT NULL,
  `zoom_3` int(2) DEFAULT NULL,
  `timezone_3` varchar(255) DEFAULT NULL,
  `show_hours_3` int(1) NOT NULL DEFAULT '0',
  `meta_title` text,
  `meta_description` text,
  `sendgrid_key` varchar(200) DEFAULT NULL,
  `sendgrid_email` varchar(200) DEFAULT NULL,
  `sendgrid_sender` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `global_settings`
--

INSERT INTO `global_settings` VALUES (1,'The Negotiators','','The Negotiators follows the strictest possible code of confidentiality. Contact between The Negotiators and a client is always personal, privileged, and confidential.','211108013506.jpg','','211108013648.png','','11525 - 23 Avenue','#147','Edmonton','AB','T6J 4T3','Canada','780-901-2134','','1-800-737-6583','info@thenegotiators.com','9505 Clublands Drive','','John&rsquo;s Creek','GA','30022','United States','(770) 777-9177','','1-800-737-6583','info@thenegotiators.usa','4th Avenue SW','#342','Calgary','AB','T2G 0T9','Canada','','','','','info@thenegotiators.com',NULL,NULL,1,'53.4536548','-113.5285399',9,'America/Edmonton',1,1,'34.012448','-84.20336499999996',13,'America/Vancouver',0,1,'51.0495319','-114.06957290000003',11,NULL,0,'The Negotiators','The Negotiators is a full service ADR services company, co-located in Edmonton, Alberta, Canada and Atlanta, Georgia, USA serving all locations in North America; dedicated to providing dispute resolution, management, and prevention services worldwide. Our professionals are experienced mediators, arbitrators, and negotiators; who are highly trained and experienced in all types of dispute resolution and management. Our expertise addresses the specific needs of both our individual and corporate clients.','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','info@thenegotiators.com','169534');

--
-- Table structure for table `global_social`
--

CREATE TABLE `global_social` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `service` varchar(100) DEFAULT NULL,
  `url` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `global_social`
--

INSERT INTO `global_social` VALUES (1,'facebook',''),(2,'twitter',''),(3,'pinterest',''),(4,'google-plus',''),(5,'linkedin',''),(6,'youtube',''),(7,'instagram',''),(8,'houzz','');

--
-- Table structure for table `home_slideshow`
--

CREATE TABLE `home_slideshow` (
  `slide_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `image1` varchar(200) DEFAULT NULL,
  `image1_alt` tinytext,
  `image1_caption` varchar(200) DEFAULT NULL,
  `image2` varchar(200) DEFAULT NULL,
  `image2_alt` tinytext,
  `image2_caption` varchar(200) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`slide_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `home_slideshow`
--

INSERT INTO `home_slideshow` VALUES (1,'211108013917-1.jpg','','You can try your luck here.','211108013922-2.png','','You can meet with The Negotiators.','2021-11-08 08:39:37');

--
-- Table structure for table `inquiries`
--

CREATE TABLE `inquiries` (
  `inquiry_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `message` text,
  `subject` varchar(100) DEFAULT NULL,
  `inquiry` enum('General Inquiry') NOT NULL DEFAULT 'General Inquiry',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`inquiry_id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `inquiries`
--

INSERT INTO `inquiries` VALUES (1,'Meryll Test','meryll@pixelarmy.ca','',NULL,'Test...','General Inquiry','General Inquiry','2016-04-28 14:36:52'),(2,'Meryll','meryll@pixelarmy.ca','7801234567',NULL,'123','General Inquiry','General Inquiry','2016-04-28 14:38:18'),(3,'Meryll Test','meryll@pixelarmy.ca','',NULL,'Test123123','General Inquiry','General Inquiry','2016-04-28 14:39:25'),(4,'Meryll','meryll@pixelarmy.ca','',NULL,'Test on FF','General Inquiry','General Inquiry','2016-04-28 20:30:58'),(5,'Mweyll','meryll@pixelarmy.ca','',NULL,'asdasd','General Inquiry','General Inquiry','2016-04-29 21:41:00'),(6,'Test','meryll@pixelarmy.ca','7801234567',NULL,'a23123','General Inquiry','General Inquiry','2016-04-29 21:57:37'),(7,'Meryll','meryll@pixelarmy.ca','',NULL,'Shdhsbd','General Inquiry','General Inquiry','2016-04-29 22:06:23'),(8,'meryll','meryll@pixelarmy.ca','',NULL,'asd','General Inquiry','General Inquiry','2016-04-29 22:14:11'),(9,'Meryll','meryll@pixelarmy.ca','',NULL,'Testing contact form (site uploaded to cloud server)','General Inquiry','General Inquiry','2016-05-05 15:16:36'),(10,'Meryll','meryll@pixelarmy.ca','',NULL,'Test','General Inquiry','General Inquiry','2016-05-05 15:17:05'),(11,'Meryll Cruz','meryll@pixelarmy.ca','',NULL,'asdasd','General Inquiry','General Inquiry','2016-05-05 15:19:06'),(12,'Meryll','meryll@pixelarmy.ca','7801234567',NULL,'asdasds','General Inquiry','General Inquiry','2016-05-05 15:19:32'),(13,'Meryll Test','meryll@pixelarmy.ca','',NULL,'asdasdasd','General Inquiry','General Inquiry','2016-05-05 15:20:51'),(14,'Micaela Miller','redschroe@gmail.com','780-983-4018',NULL,'Good afternoon,\r\n\r\nI am in my first year taking a Masters in Conflict Analysis and Management through Royals Roads University. I live in Edmonton, Alberta and am currently employed as a policy analyst in the Department of Municipal Affairs with the Government of Alberta.\r\n\r\nI am searching for opportunities to gain experience in the field of conflict resolution. Do you ever post volunteer or job positions? Is there any way I could work with the organization and at the same time be mentored in different forms of conflict resolution? \r\n\r\nLooking forward to your reply,\r\n\r\nMicaela Miller','General Inquiry','General Inquiry','2016-10-21 19:40:58'),(15,'Torris Butterfield, Esq','butterfieldt@bellsouth.net','770-883-4681',NULL,'I am a local attorney and I am trying to reach Elmer Goble.  I would like for him to mediate a divorce case for me in Cobb County, GA.  Please have him to contact me asap at 770-883-4681 or 404-522-5056 or butterfieldt@bellsouth.net','General Inquiry','General Inquiry','2016-11-28 22:13:06'),(16,'Arley Leghorn','aleghorn@gmail.com','650 5771477',NULL,'Hello;\r\n\r\nI am a California certified mediator specializing in commercial transactions, automotive disputes and marital settlement agreements. \r\n\r\nPlease let me know if you can use my services.\r\n\r\nArley Leghorn','General Inquiry','General Inquiry','2016-12-02 18:10:21'),(17,'Pam Blackwell','pam@tfamilylaw.com','770-408-1015',NULL,'Could you please let me know what dates you are available in January?','General Inquiry','General Inquiry','2016-12-20 17:11:53'),(18,'Meryll Cruz','meryll@pixelarmy.ca','7804288089',NULL,'Testing success page.','General Inquiry','General Inquiry','2017-01-13 15:24:07'),(19,'Dennis Weegar','dennisw@abdexplumber.com','289-292-0441',NULL,'Hello Attorney,\r\n\r\nGood day.\r\n \r\nPlease kindly confirm if your schedule will permit you to take on a legal suit for us in your State? Do communicate back and I will furnish you with more information to the nature of our dispute.\r\n\r\nSincerely,\r\n\r\nDennis Weegar\r\nAbdex Plumbers Ltd.\r\n433 40 Ave NE\r\nCalgary, AB T2E 2M7\r\nP:  289 292 0441 EXT 225\r\nE-mail: dweegar@abdexplumbers.com\r\nhttp://www.abdexplumbers.com/intl','General Inquiry','General Inquiry','2017-01-19 19:01:29'),(20,'Christine','cbharr8408@gmail.com','',NULL,'Hello,\r\n\r\nI am thinking of leaving my husband.  We have 2 kids together (age 12 and 15).\r\nI have a few questions about your services:\r\nFirst, who needs to be at the initial consultation?  \r\nDo you help with separation agreements?\r\nDo you have lawyers to look after  filing a claim and finalizing the divorce?\r\nWhat a the typical cost for such services?\r\n\r\nThanks in advance for your help.\r\nChristine','General Inquiry','General Inquiry','2017-01-26 21:27:43'),(21,'Catherine Masson','catherinesimoneau83@gmail.com','403 850 3517',NULL,'I am wondering if my husband can demand my house keys to our marital home if I have moved out, but my name is on the title to the house. I also have furniture stored in the home that I need access too for a future move. We have drafted a legal separation (that he still needs to get signed) and it states that he is taking over all responsibility for the home (mortgage payment, bills etc). Does this mean that he also gets my keys even if I still have property there?\r\n\r\n\r\nAny info at all would be very much appreciated.\r\n\r\nKind regards,\r\n\r\n\r\nCatherine Masson','General Inquiry','General Inquiry','2017-01-28 23:01:16'),(22,'Ryan Trainer','rtrainer@mross.com','780-482-9153',NULL,'Good morning,\r\n\r\nI have a client who has a small construction/renovation dispute with a renovation company.  Their agreement contains a mandatory arbitration clause. \r\n\r\nMy client would like an estimate as to costs for arbitration services through your company.  Please let me know what further information you require to provide an estimate as to costs. \r\n\r\nThank you,\r\n\r\nRyan Trainer','General Inquiry','General Inquiry','2017-01-30 17:35:15'),(23,'Cheryl Graham','cheryl@grahamlawfirm.co','703-443-9360',NULL,'I am a divorce attorney/mediator in Virginia and I am very interested  the weekend divorce workshop you offer.  We have been discussing a similar program and would love to learn more about what you do.  I would greatly appreciate a few minutes of your time to discuss your success with this program.\r\nI look forward speaking with you.\r\nCheryl','General Inquiry','General Inquiry','2017-02-02 19:44:30'),(24,'Micaela Miller','micaela.miller@gov.ab.ca','780-983-4018',NULL,'Good morning,\r\n\r\nI am looking for ways to gain experience in alternative dispute resolution.  I am currently taking an MA in Conflict Analysis and Management through Royal Roads University. At the moment I am a policy analyst with the Department of Municipal Affairs in the Government of Alberta.\r\n\r\nIf you have any opportunities or insight into how I could gain ADR experience I would be grateful.\r\n\r\nSincerely,\r\n\r\nMicaela Miller','General Inquiry','General Inquiry','2017-02-22 17:51:05'),(25,'Meryll Cruz','meryll@pixelarmy.ca','7804288089',NULL,'Testing contact form -- removed Subject dropdown. Please ignore this message. (Pixel Army Web Developer)','General Inquiry','General Inquiry','2017-02-27 22:03:30'),(26,'georgina schneider','georginas@hotmail.com','403-630-1725',NULL,'Please advise if you do arbitration on a lease?  I have signed my option for renewal for another 5 years but can not come to an agreement on any matters.','General Inquiry','General Inquiry','2017-03-16 15:38:30'),(27,'David Marcinek','kdmarcine@telus.net','623-374-3238',NULL,'I&rsquo;m a Board member for Lake Arnault RV Resort, located close to the town of Darwell , Alberta.  I believe our Board is becoming dysfunctional and could use outside help.  Please contact me at your convenience.','General Inquiry','General Inquiry','2017-03-22 16:48:16'),(28,'Brian Hanley','bahanley56@gmail.com','870-706-7665',NULL,'I am looking for someone to help in the final stage of my workman&rsquo;s comp case. My case has already gone to trial and I&rsquo;ve been awarded a weekly disbursement. At this time the three year period for the insurance company to appeal is coming up and they are looking to settle (cheaply) before attempting to go back into court. The problem at hand is I do not trust my lawyer. Through out the ten years of my case it was to obvious that his relationship with the opposing attorney was to cozy, all the way up to and through my trial. They basically had decided together that I would settle just before trial (which I did not). The opposing attorney has played my lawyer and his team like an old fiddle, including hip bump greetings. I&rsquo;m looking for someone to do the final negotiations with my concerns as the priority not their friendship with their fellow lawyer. My entire future and well being is at stake here and I do not trust my attorney  to perform his duty to his client. I&rsquo;m not needing someone to take over my case, only to aid in the negotiating process, stay in between my lawyer and the opposing lawyer. You would be hired on just as I have hired other professionals to aid in my case.','General Inquiry','General Inquiry','2017-03-25 11:36:34'),(29,'Dianna @ Mullen & Co','dianna@mullenco.ca','403-271-9714',NULL,'WE RECEIVED YOUR TRUST DOCUMENTS YESTERDAY ON MACDONALD SALE TO ANDERSON.  WE REQUIRE YOUR AUTHORIZATION TO AMEND KATHY TO KATHLEEN ON THE TRANSFER OF LAND.\r\nTHANKS\r\nDIANNA','General Inquiry','General Inquiry','2017-05-03 13:37:57'),(30,'Sania Lorison','sania.lorison@gmail.com','206-309-5272',NULL,'We can put your website on 1st page of Google to drive relevant traffic to your site. Let us know if you would be interested in getting detailed proposal. We can also schedule a call & will be pleased to explain our services in detail. We look forward to hearing from you soon. Thanks!','General Inquiry','General Inquiry','2017-08-10 12:00:47'),(31,'Boyd England','boyd.england@gmail.com','7809032693',NULL,'Looking for mediation services for a relationship that has ended.\r\n\r\nThanks,\r\nBoyd','General Inquiry','General Inquiry','2017-08-25 00:30:16'),(32,'Pam','pam@tfamilylaw.com','770-408-1025',NULL,'Are you available on September 14, 2017 for mediation?','General Inquiry','General Inquiry','2017-08-31 15:46:58'),(33,'Jay Singh','jay@ibrokerdomain.com','4014020442',NULL,'Hi,\r\nWould you be interested in acquiring the domain Debtnegotiators.net ?\r\nLet me know.','General Inquiry','General Inquiry','2017-09-02 19:14:50'),(34,'Jennifer McClean','offerhercoffee@gmail.com','7805149261',NULL,'Looking for assistance with what we are hoping can be an amicable seperation/divorce.  Have two children, debts and assets.  Todd is currently in Calgary, I am in Edmonton with the kids (our farm is in Drayton Valley).  (So, Friday evenings or weekends would be best to be able to meet together)\r\n\r\nPlease contact after 3:30 (Teacher).\r\n\r\nThanks,\r\nJennifer','General Inquiry','General Inquiry','2017-10-06 14:12:44'),(35,'Jerry Welsh','jerry.welsh@sondemar.com','2143183754',NULL,'Hi,\r\n\r\nWhy don&rsquo;t you own the domain name realtynegotiator.com? I saw it for sale at Sedo.com.\r\n\r\nKind regards,\r\n\r\nJerry','General Inquiry','General Inquiry','2017-10-11 05:24:43'),(36,'Dave Zorniak','d.zorniak@shaw.ca','780 667-7953',NULL,'Hi  Pete,\r\n\r\nI&rsquo;m going into Arbitration (no date set), hopefully Feb/2018 or sooner. My daughter and I need you to help me in arbitration, so we can move on and start are new life. It has been a long road and I,m almost there. I just need your advise and retain you to help  me get through Arbitration.\r\nIf you have any questions please contact me.\r\n\r\nKing Regards,\r\nDave','General Inquiry','General Inquiry','2017-10-11 19:19:24'),(37,'Janet sian','Janet_Sian@gov.nt.ca','867-873-7424',NULL,'Good morning, I am the Manager of the NWT Family Law Mediation Program.  I am looking for a mediator for a bilingual English/French file that I have pending.  Issues for this file are custody, access and child support.  In this situation, the father resides in Quebec, while the mother lives in Yellowknife, so we are looking for someone to conduct the mediation by phone/computer.  I have been searching for a bilingual mediator for awhile, so it is possible that by the time I have heard from you I may I have found someone.  Therefore, if you are interested in this file, please contact me asap for more information.\r\n\r\nThanks.\r\n\r\nJanet','General Inquiry','General Inquiry','2017-10-18 14:43:44'),(38,'Adrienne Mckellar','adrienne.mckellar@rrcwb.ca','780 793-6950',NULL,'We are looking for a reputable negotiator to assist with our upcoming collective agreement renewal.  We are located in FFM.  Would you be able to send us the bios of those that may be available to assist.   \r\n\r\nThank you','General Inquiry','General Inquiry','2017-11-08 18:46:11'),(39,'Boston Dulcie','bdulcie@deflaw.com','404-885-6444',NULL,'Good morning. \r\n\r\nI am Matt Nanninga and Camile Hart&rsquo;s assistant at Drew Eckl & Farnham, LLP.  We have two depositions coming up on December 5th that we need a translator for.  Please let me know if Maria Ceballos Wallis would be available for this date.  \r\n\r\nBest regards.\r\nBoston Dulcie','General Inquiry','General Inquiry','2017-11-10 13:11:47'),(40,'Mae Nandlall','mae.nandlall@mac.com','(780) 910-9504',NULL,'Dear Sirs/Madam,\r\n\r\nI am writing to kindly request for an initial appointment for an initial consultation for my ongoing divorce settlement negotiation/dispute.\r\n\r\nI have been married for more than ten years in an abusive (used to be physically abusive but currently psychological, mental, verbal abuses) marriage relationship.  My husband has practically abandoned me emotionally and physically from the initial stage of our marriage.  Prior to our marriage, I already have three daughters which he accepted.\r\n\r\nWe met in Doha, Qatar where I used to work and had a business.  I left my job when he asked me to as we were embarking on a matrimonial relationship.  During my husband&rsquo;s proposition, he promised to marry me in any church I want, in which case, I told him I wish to be married in a cathedral back in the Philippines.  We left Qatar and moved to the Philippines to get married.  Then to Malaysia prior to settling down in Canada.  When we were in Qatar, my husband asked me to leave my job and said that he will give me the monthly salary I am getting.  After one time of doing what he promised in just one month, that stopped.  I did not mind as I really did not care.   (I was crazily in love).\r\n\r\nHowever, during our initial stay in the Philippines, my husband beat me up badly and subject me to various mental and emotional abuse.   I ran away but my brother and brought me back.  It was because my family is a staunch Catholic and such practice of running away from marriage is a big taboo and dishonorable to the family. Anyways, he promised my brother he will not hurt me again. I went back and stayed.  \r\n\r\nWe moved to Malaysia in 2009 until 2011 but the beating up continues as well as the psychological, mental and verbal abuse.  The abuse was just extreme that there were twice an incident that I tried to take my own life, one in the Philippines and one in Malaysia.\r\n\r\nThe physical beating up stopped when we moved to Canada (he is Canadian) after he suffered a mild heart attack in Malaysia.  In Canada, I learned that I have rights as a wife and that physical assault is a federal crime.  Though he stopped the grave physical assault, there were lots of incidences that he physically threw out of the house, shoved me on the wall and at one time, he threw our piano at me which I dodged but made a severe crack on the wall. Unfortunately, the psychological, emotional and verbal abuse did not stop though.  The nasty labelings continue.\r\n\r\nTwo years back, I informed him I want to separate which he responded with divorce suit on the ground of cruelty.  He told me to get a copy from his lawyers and upon seeing the ground, I was deeply heartbroken and felt deeply betrayed.  The subpoena scared me so deeply that I instantly took a lawyer in my defense.  At that time, I was ignorant of how and what divorce is all about.  I thought I was committing a crime. (We do not have divorce in the Philippines and it is deeply shunned in my family and in our society back home)\r\n\r\nAdded to the matter is that I learned that there is a negotiation in the divorce proceeding. (Well, I learned that I have human right in this country and that I have right to all we have accummulated during marriage).  My husband owns an oil and gas-servicing company and that I strongly feel that the settlement he and his lawyer are offering does not make sense.\r\n\r\nMore than a year after the divorce suit was filed, we are still living in the same house and I am still treated as abandoned inside the marriage being rejected and ignored every day.\r\n\r\nMy husband&rsquo;s abusive demeanor mellowed down a little bit last summer.\r\n\r\nAnyways, I am more focused on getting over with the divorce and on needing help as regards the negotiation process.\r\n\r\nI used to have a lawyer but the negotiation quite went awry as I noticed that my right is being undermined.  Upon my inquiries to my lawyer, she got offended and asked me to find another lawyer.  So after more than a year and lots of credit card charges, I am still left with no recourse.\r\n\r\nHence, my inquiry and my search for a new lawyer.\r\n\r\nAs such, may I kindly request an appointment/initial consultation?\r\n\r\nI will deeply appreciate it if it could be scheduled soonest as my husband&rsquo;s lawyer is asking me to find as soon as possible.\r\n\r\nYours sincerely,\r\n\r\nMae\r\nP: (780) 910-9504','General Inquiry','General Inquiry','2017-11-15 13:22:38'),(41,'Sharyn Burton','murphy_sharyn@yahoo.ca','7807901920',NULL,'Hi Pete, spoke to you today regarding the Gregoire Condo Assoc. in Ft. McMurray. Any info you can send me would be appreciated!','General Inquiry','General Inquiry','2017-11-16 20:00:00'),(42,'Leroy Glover','top40music@comcast.net','4044541127',NULL,'Met with you Elmer Goble  on 12-28-17 11am. Case # 2017CV291733\r\nA agreement was reached. I have a couple questions:\r\n1. I read that in email that I received on Dec 3, 2017 that after 5 days of the agreement at the mediation, the judge will receive the agreement and it is filed as an order at any time after 5 days from date of the execution of the agreement. How many days after the 5 days of execution can I expect the agreement and / or divorce to be final? \r\n2. Am I committed to pay alimony in January? If so, how soon will I only have to pay Child support? \r\nI am expecting this agreement is starting as of January 1st, 2018. I am in the mindset that after family counseling is attended on January 12th, it seals the agreement and the dissolution of marriage is confirmed final at that time. \r\n3. I haven&rsquo;t received an information on family counseling except the date. \r\nYour immediate reply will be appreciated. \r\nLeroy Glover III','General Inquiry','General Inquiry','2018-01-08 12:26:57'),(43,'Jasuo Hirose','hr.belcanengineeringfirm@engineer.com','(564) 787-7222',NULL,'Dear Counsel,\r\n\r\nMy name is Yasuo Hirose. I am the President / CEO of Sygma Engineering & Construction Company here in Hong Kong. We have just concluded negotiations on a merger deal with a customer company of ours in your jurisdiction. We have agreed to merge and carry on our businesses in the USA and Canada under an agreed name.\r\nWe would like to retain your services in drawing up the final Contract Agreement.Kindly advise us immediately on your initial retainer fee and terms of agreement and we shall forward you fuller details of this transaction. However, if this not your area of practice, a referral will be highly appreciated.\r\n\r\nYours Sincerely\r\nYasuo Hirose\r\nSygma Engineering & Construction co.\r\nHead Office,\r\nD114, Lot197, 148A-B, 149,\r\nSheung Shek Kong,\r\nHong Kong','General Inquiry','General Inquiry','2018-02-23 11:07:41'),(44,'Cory Hare','cory.hare@ata.ab.ca','7804479438',NULL,'I&rsquo;m the chair of the negotiation committee for the staff association at my workplace. As our agreement expires at the end of August, we are now preparing for the next round of negotiations and I am gathering information to help our group decide how to proceed.\r\n\r\nWith our last negotiation, we employed interest-based bargaining without a hired negotiator (we did have a lawyer review our agreement). This time around, we want to explore the available options so we can make an informed decision on how best to proceed.\r\n\r\nI&rsquo;m interested in finding out how it would work if our association were to hire your firm to conduct negotiations on our behalf, ie. the costs involved, the style of negotiation that would be employed, etc. \r\n\r\nThank you.','General Inquiry','General Inquiry','2018-02-23 17:16:18'),(45,'Rick Carlson','RickCarlson@AceBusinessBrokers.com','8009854939',NULL,'Over 25 Insurance Deals Closed in Last 14 Months. Average 90 Days to close.  19,000+ Buyer Pool.\r\n \r\nIf you&rsquo;ve been thinking about selling your agency or book of business, by starting an advisory relationship with Ace Business Brokers today we will seamlessly guide you through the process needed to close your sale before the end of 2018.  We sent a letter out around the holidays, hopefully you received it!\r\n\r\nOur average lead time is approximately 3 months from initial consultation to payout, and we will expose your company to our database of 19,797 insurance companies, fellow agency owners, private equity groups and wealthy individuals looking for deals across New England!  These are the parties that want to buy your non-standard auto or preferred book, commercial enterprise, E&O book, MGA, life/financial planning-focused entity or employee benefits firm and have the cash to close transactions with us!  \r\n\r\nWe have sold all of these types of agencies and have thousands of buyers in each category.  Our database is searching for everything from $10,000 portable books and $10,000,000+ companies.  You can sell a portion of your business as well, as many of our buyers are interested in acquiring partial books of clients across all carriers and disciplines.\r\n\r\n--Why do I need Ace Business Brokers to help me sell my business?\r\n\r\n\r\n* We orchestrate the entire transaction from initial consultation to the close of escrow.\r\n* We specialize in highly-sensitive and confidential sales, all buyers have an NDA on file.\r\n* We work together as a team to produce ad copy that excites buyers to write offers.\r\n* We build a comprehensive due diligence package or Confidential Information Memorandum that tells YOUR compelling story.\r\n* We pay for upgraded advertising to ensure maximum exposure beyond our database.\r\n* We negotiate the highest possible price for your business.\r\n* We are a success fee firm, unless we close escrow, there is no charge to you.\r\n\r\n\r\n--  What will my business sell for?\r\n\r\nWhile every business and sale are different, for benchmark purposes, we can tell you that we have sold (and in 2 cases resold) our last 25 insurance agencies/books for a range from 1.17x (100% non-standard auto) -to- 3.80x (commercial lines shop) prior year&rsquo;s gross renewal commissions.  We are highly skilled in all forms of transactions and deal structures, no firm is too big or too small to handle.\r\n\r\n--  I&rsquo;m ready to talk to someone, what now?\r\n\r\nPlease feel free to call me directly anytime, or send me an email directly to start the process.  I can be reached via phone at (800) 985-4939. You can also send an email to rickcarlson@acebusinessbrokers.com.\r\n\r\n--  Ready to expand, not sell?\r\n\r\nPerfect - we expect 2-3 transactions coming online each month for the balance of 2018!!  We are happy to add you to our database and inform you when future opportunities come in.  Feel free to contact me anytime or reply back to this message so we can add you to our active Buyer pool!\r\n\r\nCheers,\r\n\r\n-Rick.\r\n\r\n-- \r\nRick Carlson\r\nPresident\r\nAce Business Brokers\r\n70 Greenwich Ave. #14\r\nNew York, NY  10011\r\nPhone: (800) 985-4939\r\nEmail:  RickCarlson@AceBusinessBrokers.com\r\nWeb: http://www.AceBusinessBrokers.com','General Inquiry','General Inquiry','2018-03-09 06:26:12'),(46,'neha','nkarnik7@gmail.com','8976930247',NULL,'I am individual law practitioner and has recently established my firm. My specialisations are corporate, commercial and arbitration law. I would like to know whether The Negotiators outsource any work related to the above mentioned areas of laws and requires interference and assistance of Indian Courts? Thanks','General Inquiry','General Inquiry','2018-03-29 09:34:41'),(47,'Linda Keating','lindamkeating@yahoo.ca','7807172644',NULL,'We have ended a 14 year common-law relationship.  I am on AISH and CPP Disability and he is a Corrections Officer. We do not have a home or children together.  We need help resolving where we stand with regards to an RRSP, his pension, disability money I received and possible interdependent spousal support for me.  Can you please tell me what process you offer and the approximate cost that would be involved in resolving these financial issues?  Thanks','General Inquiry','General Inquiry','2018-04-04 22:12:59'),(48,'Dan','keelandan@shaw.ca','4038139344',NULL,'My wife and I are having major conflicts and have been fighting for months. We need someone to be in the room as we speak to each other so we don&rsquo;t blow up into a huge fight. I want to have a conversation about where we are going in life and I need some help. \r\n\r\nIs this something you do?','General Inquiry','General Inquiry','2018-04-18 04:06:36'),(49,'Brennon heitt','braaapr6@yahoo.com','3063460224',NULL,'I have been served with a restraining order from my girlfriends child&rsquo;s father who I have never met Until I was served on Monday the 14th,  I now have court on May 23 in Edmonton Alberta and based on your website your firm sounds absolutely fantastic. I know it is on short order but I am in Edmonton now and in need of a consultation and ready to Pay for a retainer if I feel good and confident after the meeting','General Inquiry','General Inquiry','2018-05-17 18:44:48'),(50,'Peter Sartore','peter@sartorelawgroup.com','403-230-9400',NULL,'I&rsquo;m inquiring into the estimated costs of conducting an arbitration for two parties disputing a vehicle purchase.  The purported seller states that the vehicle was sold to the purchaser per a written agreement.  The purchaser states that the seller had entered into a contract with a third party and had already transferred the vehicle to the third party according to registries.  The seller claims that the buyer instructed the seller to do up the transfer to the third party and use the third party to register the vehicle on the buyer&rsquo;s behalf as the buyer could not do so under his own name which the buyer disputes.','General Inquiry','General Inquiry','2018-05-17 20:35:22'),(51,'Chris Marshall','marshall.chris44@gmail.com','07802632589',NULL,'We are looking for mediation to assist in changing a parenting order. \r\n\r\nThanks, \r\n\r\nChris Marshall','General Inquiry','General Inquiry','2018-05-18 15:17:41'),(52,'Toni','toni.harrold@PrintyLawfirm.com','(813) 434-0649',NULL,'Our office is in the process of trying to schedule a meditation on very short notice. Gary asked me to see if  Attorney Munoz would be available for  any of theses dates.\r\n\r\n \r\n\r\nJune 6 or the 7,all day- June 11 in the pm, June 12, all day- June 13 in the pm, June 14 all day or June 15 all day to meditate.\r\n\r\n \r\n\r\nCan you  let me know if you have anything available ?','General Inquiry','General Inquiry','2018-06-01 19:05:07'),(53,'masongsong','rico_bom.0207@yahoo.com','4034837366',NULL,'Hi,\r\n We live in ground floor of a condo unit that we purchased 6 years ago.\r\nPat knocked on our unit (I believe he is one of the board member) telling us that there is a leak coming from my unit.I told him that I am aware and I know what the problem is. I told him that I already called my plumber to come by and fix the problem which was the loose cartridge of the shower faucet .\r\n\r\nI told him that  I turned off the valve in that shower so that it won&rsquo;t instigate further damage while i am waiting for the plumber to install the needed part.\r\n\r\nThen after 2 days  , contractors came in, did measurement and started ripping out the dry wall adjacent to the tub. We were never asked or given notice prior to the extraction so we do not have any idea what they were doing.Needless to say the project that they were working on is unnecessary, if what they want is to find out the root cause of the leak cause we already know what the problem was.\r\n\r\n       They sealed the dry wall and now we got a bill of $850  from the board  for the extraction and repair of the dry wall.\r\n\r\nMy wife is unemployed and we do not know what to do.\r\n\r\nSeeking for help,\r\nRico','General Inquiry','General Inquiry','2018-06-08 17:29:53'),(54,'Reagan','Billy_kibaki@yahoo.com','4032800099',NULL,'Hi\r\nMy wife and I are in a state where the love just isn&rsquo;t there anymore and arguing most of the time... I think a divorce is the best thing for both of us, because I fear thing might get out of hands one day really bad, and we only have one child that is 3yr old. It wouldn&rsquo;t be the best thing for our child but I think it&rsquo;s the safest thing to do before it&rsquo;s too late.\r\nMy question is Can you walk me through the steps.','General Inquiry','General Inquiry','2018-06-10 10:11:26'),(55,'Roey','copia.roey@gmail.com','',NULL,'Please contact me','General Inquiry','General Inquiry','2018-06-15 15:11:41'),(56,'David Smith','smithd3001@gmail.com','2263896545',NULL,'\"Hello,\r\n\r\nMy name is David and I am a Digital Marketing Specialists for a Creative Agency.\r\nI was doing some industry benchmarking for a client of mine when I came across your website.\r\nI noticed a few technical errors which correspond to a drop of website traffic over the last 6-8 months which I thought I would bring to your attention.\r\nAfter closer inspection, it appears your site is lacking in 4 key criteria.\r\n\r\n1- Website Speed\r\n2- Link Diversity\r\n3- Domain Authority\r\n4- Competition Comparison\r\n\r\nWe would be happy to send you a proposal using the top search phrases for your area of expertise. Please contact me at your convenience so we can start saving you some money.\r\n\r\nIn order for us to respond to your request for information, please include your Name, company&rsquo;s website address (mandatory) and /or phone number.\r\n\r\nRegards,\r\nDavid Smith\r\nsmithd3001@gmail.com\r\n\"','General Inquiry','General Inquiry','2018-06-18 08:26:53'),(57,'Anne Daly','belleek56@gmail.com','780-490-0699',NULL,'I am searching for a mediator who can assist me in obtaining a divorce. We have been separated for three years now. Nothing is being contested.\r\n\r\nE-mail is the best way to contact me.','General Inquiry','General Inquiry','2018-06-18 19:27:04'),(58,'Sharon Howe','SharonHowe@Shaw.ca','403-236-2709',NULL,'I am inquiring if you do mediation services in Calgary.  I am inquiring as I life in a condo complex just outside of Calgary.  I am not on the Bosrd but have grave concerns as they are wanting to go through litigation with an entity that we border on and share certain services with.  We are having a general meeting this week and I believe the board wants to go to court with out doing any other research.  I therefore would like to bring this other opportunity to the meeting, including hourly fees, what would be expected of us as well.  Thank you for your time.','General Inquiry','General Inquiry','2018-08-04 03:42:27'),(59,'misc','sha.lien@yahoo.com','misc',NULL,'robots are heartless. meanwhile a 3 year old child&rsquo;s life is at stake.\r\n\r\nHannah\r\n3:05 am\r\nWelcome to The Negotiators. If you have any questions, please feel free to begin a completely confidential chat.\r\nThe Negotiators Visitor\r\nare you a robot?\r\nHannah\r\nI&rsquo;m a real person.\r\nHow may I help you?\r\nThe Negotiators Visitor\r\nwhere were you born?\r\nHannah\r\nMay I know a little about what is it regarding?\r\nThe Negotiators Visitor\r\nyou didn&rsquo;t answer my question. the last chat sounded like I was talking to an AI bot as I said my 3 year old daughter and I are about to be homeless after my husband&rsquo;s child abuse, and the reply reflected no comprehension of what I had said. are you real or a chat bot?\r\nHannah\r\nI&rsquo;m a real person.\r\nAnd I&rsquo;m sorry to hear about your situation.\r\nThe best way for you would be to contact one of our attorneys at (888) 411-9710 or drop us an email at info@thenegotiators.com.\r\nIs there anything else I can help you with?\r\nThe Negotiators Visitor\r\nstill not convinced you&rsquo;re real ;)\r\nHannah\r\nAlright.\r\nThe Negotiators Visitor\r\nok then, you guys have just lost a very big job. next time you should invest in real people.\r\n Read\r\nHannah\r\nThank you for contacting us.','General Inquiry','General Inquiry','2018-08-13 10:18:05'),(60,'Jenny Test','jennyfus.nextgen@gmail.com','232323',NULL,'THIS IS A TEST','General Inquiry','General Inquiry','2020-06-29 07:59:48'),(61,'Mark','markdev.nextgen@gmail.com','123-1234',NULL,'TEST ONLY','General Inquiry','General Inquiry','2020-06-29 08:09:56'),(62,'Jenny Test','jennyfus.nextgen@gmail.com','4565656',NULL,'SFSSS','General Inquiry','General Inquiry','2020-06-29 08:32:36'),(63,'Jenny Test','jennyfus.nextgen@gmail.com','55434343',NULL,'R4EWRWRWQR','General Inquiry','General Inquiry','2020-06-29 08:45:21'),(64,'Jenny','jennyfus.nextgen@gmail.com','933931',NULL,'FINAL TEST 2020-06-29 5:37 PM PST','General Inquiry','General Inquiry','2020-06-29 09:38:00'),(65,'Jenny','jennyfus.nextgen@gmail.com','323232',NULL,'FINAL TEST 2 2020-06-29 06:01 PM PST','General Inquiry','General Inquiry','2020-06-29 10:01:19'),(66,'Jenny Test','jennyfus.nextgen@gmail.com','323223',NULL,'FINAL TEST 2020-06-29 06:02 PM PST','General Inquiry','General Inquiry','2020-06-29 10:02:16'),(67,'Jenny Test','jennyfus.nextgen@gmail.com','45454545',NULL,'FINAL TEST 3 2020-06-29 06:011 PM PST','General Inquiry','General Inquiry','2020-06-29 10:11:26'),(68,'MARK','markdev.nextgen@gmail.com','123-1234',NULL,'DEV TEST ONLY','General Inquiry','General Inquiry','2020-06-29 10:35:08'),(69,'Mel','Mephoto937@aol.com','16471425477',NULL,'Hello there!\r\n\r\nThis is Mellie and I am a certified illustrator.\r\n\r\nI was discouraged, frankly speaking, when I came across my images at your web-site. If you use a copyrighted image without my permission, you need to be aware that you could be sued by the copyright holder.\r\n\r\nIt&rsquo;s illicitly to use stolen images and it&rsquo;s so mean!\r\n\r\nCheck out this document with the links to my images you used at www.thenegotiators.com and my earlier publications to get evidence of my copyrights.\r\n\r\nDownload it right now and check this out for yourself:\r\n\r\nhttps://sites.google.com/site/case000522/googledrive/share/downloads/file/storage?ID=8997080423191 \r\n\r\nIf you don&rsquo;t delete the images mentioned in the document above within the next few days, I&rsquo;ll write a complaint on you to your hosting provider stating that my copyrights have been infringed and I am trying to protect my intellectual property. \r\n\r\nAnd if it doesn&rsquo;t work, you may be pretty damn sure I am going to report and sue you! And I will not bother myself to let you know of it in advance.','General Inquiry','General Inquiry','2020-07-13 14:02:22'),(70,'Jamie-Ann Barker','j.barker@toqueandjustice.ca','5875775211',NULL,'Hi there!\r\n\r\nI am Jamie-Ann Barker, and I own and run a business in YYC for mediation and also work as an Agent in family law disputes in the Provincial Courts all across Alberta Canada. \r\n\r\nI am very interested in some of your training and also if you are looking to add to your roster of mediators and negotiators.  \r\n\r\nI am a Paralegal and also I have continued to further my capacity by completing training with ARDIA here in AB, and still plan on always continuing to add qualities to my skills for my clients.  \r\n\r\nI would love the opportunity to chat with someone in the coming week. Please contact me at 587-577-5211 or my work email j.barker@toqueandjustice.ca\r\n\r\nI look forward to hearing from you in the near future! \r\n\r\nWarmly,\r\n\r\nJamie-Ann Barker','General Inquiry','General Inquiry','2020-07-24 03:45:02'),(71,'Steven David CARSON','funkydred44@gmail.com','8162106687',NULL,'Kcwster dept quoted amount of 463.81 to restore service once payment made they cancelled turn on and charged additional$619 for equipment never removed and the water employee was able to partially turn service on before directed by water supervisor to stop restore further more wet request why was a allowed to incur such HIGH CHARGES IF IN FACT WAS DISCONNECTED FOR NOON PAYMENT MAKES NO SENSE $4700 the high before disconnect making ducks to pay curvy along WTH pay due','General Inquiry','General Inquiry','2020-11-16 09:28:10'),(72,'Evan Park','evan@trndsttrs.media','9132160448',NULL,'Hello,\r\n\r\nI&rsquo;m in B2B Client Services (at a marketing agency). \r\n\r\nRecently, we had a client of ours refuse to pay an invoice, which in the contract of course is stipulated as a material breach. They are now requesting to \"terminate\" the agreement. Was seeking legal support/advice & potentially to see what your services looked like.','General Inquiry','General Inquiry','2020-11-20 18:08:20'),(73,'Sanjeev Yadav','sanjeev@website-on-top.com','7077060205',NULL,'Hello Sir Good Day\r\nI am Sanjeev Yadav, Marketing Manager with a reputable online marketing company based in India.\r\nWe can fairly quickly promote your website to the top of the search rankings with no long term contracts!\r\nWe can place your website on top of the Natural Listings on Google, Yahoo and MSN. Our Search Engine Optimization team delivers more top rankings than anyone else and we can prove it. We do not use \"link farms\" or \"black hat\" methods that Google and the other search engines frown upon and can use to de-list or ban your site. The techniques are proprietary, involving some valuable closely held trade secrets. Our prices are less than half of what other companies charge.\r\nWe would be happy to send you a proposal using the top search phrases for your area of expertise. Please contact me at your convenience so we can start saving you some money.\r\nIn order for us to respond to your request for information, please include your company&rsquo;s website address (mandatory) and or phone number.\r\nSo let me know if you would like me to mail you more details or schedule a call. We&rsquo;ll be pleased to serve you.\r\nI look forward to your mail.\r\nThanks and Regards\r\nSanjeev Yadav','General Inquiry','General Inquiry','2020-11-21 12:31:56'),(74,'Courtney Rosenfeld','courtneyrosenfeld@gigspark.biz','3217103400',NULL,'Hi!\r\n\r\nI&rsquo;m so excited by the rise in “solopreneurs” like me! It&rsquo;s been incredibly rewarding to grow my side gig into a full-time pursuit.\r\n\r\nStill, I&rsquo;ve learned that solopreneurs don&rsquo;t have to do it completely on their own. Working with freelancers and the right software helps offload certain tasks so solopreneurs have time to focus on more important business matters.\r\n\r\nOn that note: Can I write an article for you to use on your site that offers helpful tips for solopreneurs on the kinds of freelance and tech-based help that can boost their businesses? With everything going on right now, I think a lot of people are exploring their options for starting their own business, so it could really help your readers.\r\n\r\nLet me know what you think, and thanks in advance!\r\n\r\nThanks!\r\nCourtney\r\n\r\n\r\nCourtney Rosenfeld :: courtneyrosenfeld@gigspark.biz :: gigspark.biz','General Inquiry','General Inquiry','2020-12-01 19:56:24'),(75,'Katlyn Eriksen','katlyn.eriksen@eagremail.com','3232323232',NULL,'Hi there,\r\n\r\nMy name is Katlyn and I&rsquo;m writing because I&rsquo;d love to contribute a full article on the technical and legal aspects of changing your name after divorce.\r\n\r\nPlease let me introduce myself a little. After spending almost a decade working in a family law firm, I have taken a step back to spend more time with my family and write about my favorite legal and parenting topics.\r\n\r\nI&rsquo;m sure your readers will find this article intriguing and useful when you publish it on thenegotiators.com. All I&rsquo;d ask for in return is a mention of a site I&rsquo;ve worked on before within the resources.\r\n\r\nPlease let me know what you think, I&rsquo;d be happy to get started right away.\r\n\r\nBest Regards,\r\nKatlyn','General Inquiry','General Inquiry','2020-12-15 17:43:49'),(76,'Marcie Carson','mk.carson@hotmail.com','3068937840',NULL,'I am checking  out different places so I am wondering about a phone consult? Also interested in the weekend workshop','General Inquiry','General Inquiry','2021-02-08 17:57:46'),(77,'Bill Eggertson','president@email.com','6136635900',NULL,'Pete,  I have contacted every other Canadian during this pandemic,  so your name finally came up.\r\nDo you have any personal time over the next while, to do a catch-up of the past decades?\r\nIt would be almost nice to chat.\r\nBill','General Inquiry','General Inquiry','2021-02-09 14:40:32'),(78,'Francyne Dion','cabarete_girl@icloud.com','7806916819',NULL,'My husband an I have been seperated since 2017. Married in 2013. \r\nIt is amicable. We have already separated the finances and reached an agreed upon settlement . He still lives in a room in my house for economic reasons at this time . \r\nI have been in Dominican Republic due to Covid since January 2020. We would like to get our divorce . He&rsquo;s German and doesn&rsquo;t like to do paperwork and stuff so has asked me to arrange . He can go sign there if needed I have to sign from here for now . \r\nCan you help? And how much would it cost ? Email is best way to reach me or text ( or what&rsquo;s app) which is even better . Phone is sometimes not good connection . \r\n780-691-6819\r\nFrancyne Dion\r\nWe have no joint property except one truck which he is paying and it&rsquo;s his completely once paid off . He is not interested in any claim on the house we live in ( his name is not on it as he could not get credit when he arrived from Germany ) . There is no equity in it anyways just debt. He&rsquo;s a permanent resident in Canada . I had paid many things for him to come here and he paid me back by taking out a loan when we separated.  We have no children together . We agree on the division of furniture and things and it&rsquo;s already done . \r\nIt&rsquo;s a very private reason why we separated which I don&rsquo;t want to make public in the divorce but I could probably even file for annulment ? Shortly after he arrived we stopped being intimate and he informed me and my family he was transgendered and asexual ( not interested in sexual relations ) . I suggested counselling and various other things to no avail. I feel he  married me on false pretences to come to Canada but it&rsquo;s irrelevant to me at this point I just want to be divorced .','General Inquiry','General Inquiry','2021-02-09 23:09:41'),(79,'John Paquin','tribetradingllc@gmail.com','8573140440',NULL,'Hello I run a business and looking to initiate a claim for a dispute through arbitration.','General Inquiry','General Inquiry','2021-03-15 15:08:02'),(80,'Kendra Hart','Kendra@commercialcleanrs.net','6128888872',NULL,'Hi!\r\n\r\nI&rsquo;m in Atlanta area and would be happy to visit your business and submit a bid for your recurring weekly (or more) janitorial and disinfection needs.\r\nWould you like to compare pricing on your office cleaning service?\r\n\r\nI&rsquo;d be happy to provide you with a no-obligation quote on your facilities cleaning.\r\n\r\nRegards,\r\nKendra\r\n--\r\nKendra Hart\r\nDirector of Operations\r\nCommercial Cleanrs\r\n(612) 888-8872\r\nKendra@commercialcleanrs.net\r\n\r\n3508 West 22nd St, Minneapolis, MN 55416\r\n\r\nRespond with stop to optout.','General Inquiry','General Inquiry','2021-12-01 12:56:25'),(81,'James P.','adi@ndmails.com','8102440753',NULL,'Just wanted to ask if you would be interested in getting external help with graphic design? We do all design work like banners, advertisements, photo edits, logos, flyers, etc. for a fixed monthly fee. \r\n\r\nWe don&rsquo;t charge for each task. What kind of work do you need on a regular basis? Let me know and I&rsquo;ll share my portfolio with you.','General Inquiry','General Inquiry','2021-12-27 09:05:13'),(82,'Kendra Hart','kendra@commercialcleaninginc.net','6128888872',NULL,'I am in Atlanta area and would be happy to visit your business and submit a bid for your recurring weekly (or more) janitorial and disinfection needs.  \r\n\r\nWould you like to compare pricing on your office cleaning service?\r\n\r\nI&rsquo;d be happy to provide you with a no-obligation quote on your facilities cleaning.\r\n\r\nPlease simply respond and I will send next steps.\r\n\r\nRegards,\r\nKendra\r\n\r\nKendra Hart\r\nDirector of Operations\r\nCommercial Cleanrs\r\n(612) 888-8872\r\nkendra@commercialcleaninginc.net\r\n\r\nRespond with stop to optout.','General Inquiry','General Inquiry','2022-01-14 09:54:17'),(83,'Jared McLaughlin','jaredmc87@gmail.com','17808864565',NULL,'Hello, I&rsquo;m looking for an arbitrator dealing with my ex and a court order granting her sole medical decision making. I have asked my ex on 3 separate occasions to provide me with the safety and efficacy of the covid 19 jab along with my son&rsquo;s doctors. They haven&rsquo;t provided me with any information. This is unlawful and I want swift and immediate action taken before my son is to receive a second dose of this toxin. Thank you kindly.','General Inquiry','General Inquiry','2022-02-03 03:12:23'),(84,'Jim Norton','jim@jantize-atlanta.com','8645238657',NULL,'Jantize Atlanta is locally owned and operated. \r\n\r\nWe would be glad to stop by your office to provide you with a no-obligation quote for your office cleaning. \r\n\r\nWould you like to compare pricing or have a higher level of service for your facility?\r\n\r\n“Jim and his team at Jantize have done an amazing job with cleaning our building. We have been nothing but impressed with the work they do, their communication, and their attention to detail. If you are looking for a team to keep your offices clean and looking great, I would highly recommend Jim and Jantize!” —5-star Google review\r\n\r\nLet us know if you have 30 minutes to meet with us.\r\n\r\nSincerely,\r\nJim\r\n\r\nJim Norton\r\nFacility Service Operations\r\nJantize Commercial Cleaning Service\r\n(864) 523-8657\r\njim@jantize-atlanta.com\r\n\r\nPlease respond with \"stop\" to opt out.','General Inquiry','General Inquiry','2022-02-28 11:07:48'),(85,'Eva Benoit','eva@evabenoit.com','9197125782',NULL,'Hi,\r\n\r\nEvery business has data flowing in, from sales figures to social media likes to website page views and more, but only a few are properly exploiting it.\r\n\r\nI felt this would be an interesting point for your website to address. Is it possible for me to produce an article for you about how firms may use data analytics into their operations, strategy, and growth?\r\n\r\nThank you very much.\r\nEva Benoit\r\neva@evabenoit.com','General Inquiry','General Inquiry','2022-03-16 02:19:18'),(86,'Jeff Nichols','jeff@vanguardcleaningga.com','7706298923',NULL,'Is the company you&rsquo;re paying to clean your business doing a great job? In too many cases, there&rsquo;s a big drop-off in quality and responsiveness in just a short period of time after the sale.\r\n\r\nHere&rsquo;s what you&rsquo;ll get when you choose Vanguard Cleaning Systems:\r\n\r\n• Dedicated customer service professionals to ensure your satisfaction\r\n• Highly trained and motivated providers who deliver excellent service\r\n• Advanced cleaning technologies that are eco-friendly and efficient\r\n• Diverse and specialized capabilities customized for your needs\r\n• Disciplined approach: we do what we say we will do\r\n• And best of all, no contracts!\r\n\r\nWould you like to schedule a visit from one of our representatives and receive a complimentary quote for your facility needs? \r\n\r\nPlease reply or call us at 770-629-8923 to schedule a time for us to meet and discuss your exact cleaning needs.\r\n\r\nSincerely,\r\nJeff\r\n\r\nJeff Nichols\r\nExecutive\r\nVanguard Cleaning Systems\r\n770-629-8923\r\njeff@vanguardcleaningga.com\r\n\r\nPlease respond with \"stop\" to opt out.','General Inquiry','General Inquiry','2022-03-16 10:18:42'),(87,'Greg Gibson','greg@system4georgia.net','6782142098',NULL,'Hi! I&rsquo;m in your area and would be happy to visit your business and submit a bid for your recurring weekly (or more) janitorial and disinfection needs.  \r\n\r\nWould you like to compare pricing on your office cleaning service?\r\n\r\nI&rsquo;d be happy to provide you with a no-obligation quote on your facilities cleaning.\r\n\r\nPlease simply respond and I will send next steps.\r\n\r\nRegards,\r\nGreg\r\n\r\nGreg Gibson\r\nVP/Franchise Owner\r\nSystem4 Georgia\r\n(678) 214-2098\r\ngreg@system4georgia.net\r\n\r\nRespond with stop to optout.','General Inquiry','General Inquiry','2022-04-25 09:45:07');

--
-- Table structure for table `newsletter_contact_lists`
--

CREATE TABLE `newsletter_contact_lists` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `list_id` bigint(22) unsigned NOT NULL,
  `list_name` varchar(200) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `list_id` (`list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `newsletter_contact_lists`
--

INSERT INTO `newsletter_contact_lists` VALUES (1,2012031,'Newsletter Subscribers','2017-09-29 11:10:38','2017-09-29 17:11:22'),(2,2184279,'Pixel Army Test','2017-10-26 13:59:44','2017-10-26 18:59:46');

--
-- Table structure for table `newsletter_suppression_groups`
--

CREATE TABLE `newsletter_suppression_groups` (
  `group_id` bigint(22) unsigned NOT NULL AUTO_INCREMENT,
  `list_id` bigint(22) unsigned NOT NULL,
  `list_name` varchar(30) DEFAULT '',
  `description` varchar(100) DEFAULT '',
  `date_added` datetime DEFAULT NULL,
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`group_id`),
  KEY `list_id` (`list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `newsletter_suppression_groups`
--

INSERT INTO `newsletter_suppression_groups` VALUES (1,3557,'Newsletter Subscribers','Unsubscribe from Newsletter Subscribers','2017-09-29 11:10:38','2017-09-29 17:11:23');

--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `newsletter_id` int(11) NOT NULL AUTO_INCREMENT,
  `campaign_id` bigint(22) unsigned NOT NULL,
  `title` varchar(200) NOT NULL,
  `page` varchar(200) DEFAULT NULL,
  `subject` varchar(200) DEFAULT NULL,
  `description` text,
  `content` text,
  `showhide` int(1) NOT NULL DEFAULT '0',
  `image` varchar(200) DEFAULT NULL,
  `image_alt` varchar(200) DEFAULT NULL,
  `sent` int(1) NOT NULL DEFAULT '0',
  `date_sent` datetime DEFAULT NULL,
  `sent_to` varchar(50) DEFAULT NULL,
  `unsubscribe_code` varchar(30) NOT NULL,
  `unsubscribe_group` bigint(22) unsigned DEFAULT NULL,
  `meta_title` varchar(100) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `focus_keyword` varchar(255) DEFAULT NULL,
  `seo_score` decimal(10,2) NOT NULL DEFAULT '0.00',
  `date` datetime NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`newsletter_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `newsletters`
--

INSERT INTO `newsletters` VALUES (1,1850636,'z PA Test','z-pa-test',NULL,'Test Only','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec eu est euismod, maximus erat fringilla, ultrices lectus. Suspendisse imperdiet justo ut diam venenatis pharetra. Morbi nisi quam, blandit vitae nunc id, rhoncus auctor orci. Nunc egestas a nunc fermentum dapibus. Vivamus vehicula lectus sapien, id consequat ligula vestibulum quis. Vestibulum congue leo sit amet urna condimentum, id pharetra erat congue. Pellentesque id nibh non metus blandit finibus. Cras felis sem, pulvinar non massa ut, viverra blandit nibh. Integer scelerisque, mauris ac mollis dictum, urna urna aliquet leo, quis volutpat odio urna ac elit. Vivamus quis sapien pharetra, egestas risus sed, lacinia nunc. Donec mattis, nibh nec suscipit condimentum, dolor orci vulputate purus, eu mollis elit metus a est. Morbi faucibus, ipsum sed pharetra bibendum, ex urna sollicitudin magna, id tristique elit purus volutpat ante. Aliquam mattis, erat vitae sollicitudin imperdiet, nibh urna finibus neque, ac gravida augue mi a nibh. Vivamus urna orci, aliquam imperdiet nulla ac, auctor semper dui.</p>',1,NULL,'',0,'2017-10-26 13:00:37','2184279','38b911b2b5b0a183b3df1adeb7e3e9',3557,'','','',46.20,'0000-00-00 00:00:00','2017-10-26 13:00:10','2017-10-26 19:00:37');

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `page_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `page` varchar(100) DEFAULT NULL,
  `slug` varchar(500) DEFAULT NULL,
  `type` int(1) NOT NULL DEFAULT '0',
  `theme` enum('dark','light') DEFAULT NULL,
  `page_title` varchar(100) DEFAULT NULL,
  `sub_title` varchar(100) DEFAULT NULL,
  `meta_title` varchar(100) DEFAULT NULL,
  `meta_description` text,
  `meta_canonical` text,
  `focus_keyword` varchar(500) DEFAULT NULL,
  `seo_score` decimal(10,2) NOT NULL DEFAULT '0.00',
  `content` text,
  `introduction` text,
  `sidebar` text,
  `image` varchar(100) DEFAULT NULL,
  `image_alt` tinytext,
  `url` varchar(225) DEFAULT NULL,
  `urltarget` int(1) NOT NULL DEFAULT '0',
  `showhide` int(1) NOT NULL DEFAULT '0',
  `deletable` int(1) NOT NULL DEFAULT '1',
  `system_page` int(1) NOT NULL DEFAULT '0' COMMENT 'System pages cannot be moved',
  `ordering` int(1) NOT NULL DEFAULT '101',
  `google_map` int(1) NOT NULL DEFAULT '-1' COMMENT '-1 = global 0 = hide map 1 = show map',
  `cta_id` int(11) unsigned DEFAULT NULL,
  `faq_id` int(11) unsigned DEFAULT NULL,
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`page_id`),
  KEY `cta_id` (`cta_id`),
  KEY `faq_id` (`faq_id`),
  CONSTRAINT `pages_ibfk_1` FOREIGN KEY (`cta_id`) REFERENCES `pages_cta` (`cta_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `pages_ibfk_2` FOREIGN KEY (`faq_id`) REFERENCES `faq` (`faq_id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,NULL,'404 Error','404',NULL,0,NULL,'404: Page Not Found',NULL,'404: Page Not Found','404: Page Not Found',NULL,NULL,0.00,'<p>The page you requested has either been removed, renamed, or deleted.</p>\r\n<p>Go to the <a href=\"/\">home page</a> or view the <a href=\"/sitemap/\">site map</a>.</p>',NULL,NULL,NULL,NULL,NULL,0,0,0,1,101,0,NULL,NULL,'2015-10-14 20:09:39'),(2,NULL,'Site Map','sitemap',NULL,0,NULL,'Site Map',NULL,'','Site Map',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,101,0,NULL,NULL,'2015-10-29 12:39:20'),(3,NULL,'Home','home','',0,NULL,'North America&rsquo;s Premiere Dispute Resolution Practitioners','The Negotiators','Dispute Resolution Experts','Our team provides Alternative Dispute Resolution services across North America. Resolve corporate, personal and divorce disputes without going to court. Contact us today!','','alternative dispute',57.70,'<p class=\"p1\"><span class=\"s1\">The Negotiators is a team of experienced mediators, arbitrators, and conflict management professionals that provide </span><span class=\"s2\"><strong>Alternative Dispute Resolution (ADR)</strong></span><span class=\"s1\"> services throughout Canada and the United States, with offices in Atlanta, Calgary, Chicago, Edmonton, Las Vegas, Miami, Red Deer, and Saskatoon. Looking for information on divorce or separation? Learn more <a title=\"Divorce & Separation\" href=\"/services/safe-divorce-mediation-10/\">here.</a></span></p>\r\n<h2 class=\"p2\"><span class=\"s1\">Resolve Personal and Corporate Disputes Without Going to Court </span></h2>\r\n<p class=\"p3\"><span class=\"s1\">We understand that conflict is a part of life, whether at home, at work, or in the community. But more often than not, parties to a conflict think that formal processes like grievances, hearings, and going to court are their only means of finding a resolution. Our goal as a registered charity is to educate the public on the benefits of alternative dispute resolution techniques and provide a neutral, efficient, and cost-effective alternative to litigation by utilizing a variety of ADR methods, including:</span></p>\r\n<ul>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/negotiation-4/\">Negotiation</a> </span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/mediation-1/\">Mediation</a> </span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/arbitration-2/\">Arbitration</a> </span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/facilitation-3/\">Facilitation</a> </span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/reconciliation-6/\">Reconciliation</a> </span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/dispute-resolution-panels-7/\">Dispute Resolution Panels</a> </span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/conflict-management-training-8/\">Conflict Management Training</a> </span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/weekend-divorce-workshops-5/\">Weekend Divorce Workshops</a> </span></li>\r\n</ul>\r\n<p class=\"p3\"><span class=\"s1\">Don&rsquo;t put the fate in the hands of a judge. Whether your dispute is <a href=\"/areas-practice/personal/\">personal</a></span><span class=\"s1\"> or <a href=\"/areas-practice/corporate/\">corporate</a></span><span class=\"s1\">, our team of mediators, arbitrators, and negotiators will work with you to manage and prevent conflict without resorting to litigation.</span></p>\r\n<p class=\"p3\"><span class=\"s1\"><a id=\"bbblink\" class=\"ruhzbum\" style=\"display: block; position: relative; overflow: hidden; width: 150px; height: 68px; margin: 0px; padding: 0px;\" title=\"The Negotiators, Mediation Services, Johns Creek, GA\" href=\"http://www.bbb.org/atlanta/business-reviews/mediation-services/the-negotiators-in-johns-creek-ga-27004705#bbbseal\"><img id=\"bbblinkimg\" style=\"padding: 0px; border: none;\" src=\"https://seal-atlanta.bbb.org/logo/ruhzbum/the-negotiators-27004705.png\" alt=\"The Negotiators, Mediation Services, Johns Creek, GA\" width=\"300\" height=\"68\"></a></span></p>\r\n<p class=\"p3\"><span class=\"s1\">For more information on The Negotiators, our services, or to contact us, please see the links below:<span class=\"Apple-tab-span\"> </span></span></p>','<p>Whether it&rsquo;s construction contracts, labor negotiations, workplace issues or you&rsquo;re getting a divorce, you can go to court, pay expensive legal fees and put your fate in the hands of a judge or you can take charge of your own destiny by contacting The Negotiators.</p>\r\n<p>Looking for information on divorce or separation? Learn more <a href=\"/services/safe-divorce-mediation-10/\">here</a>.</p>','','211028065845.jpg','','',0,0,0,1,1,0,1,NULL,'2021-10-28 13:00:46'),(4,NULL,'About The Negotiators','about-negotiators','',0,NULL,'About The Negotiators','','Alternative Dispute Resolution Professionals','The Negotiators provides Alternative Dispute Resolution services, with offices in Atlanta, Calgary, Chicago, Edmonton, Las Vegas, Miami, Red Deer, and Saskatoon.','','',53.80,'<h2 class=\"p1\"><span class=\"s1\">Much More Than Just Negotiation</span></h2>\r\n<p class=\"p2\"><span class=\"s1\">We offer a wide spectrum of dispute resolution, management, and prevention services that work as an alternative to, or in conjunction with, litigation and formal grievances. Our team of experienced conflict management professionals educates clients on all options available to them, and facilitates the process to resolve matters quickly, efficiently, and confidentially. Services offered by our certified, licensed professionals include, but are not limited to:</span></p>\r\n<ul>\r\n<li class=\"li5\"><span class=\"s4\"><a href=\"/services/negotiation-4/\">Negotiation</a>&nbsp;</span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/mediation-1/\">Mediation</a>&nbsp;</span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/arbitration-2/\">Arbitration</a>&nbsp;</span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/facilitation-3/\">Facilitation</a>&nbsp;</span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/reconciliation-6/\">Reconciliation</a>&nbsp;</span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/dispute-resolution-panels-7/\">Dispute Resolution Panels</a>&nbsp;</span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/conflict-management-training-8/\">Conflict Management Training</a>&nbsp;</span></li>\r\n<li class=\"li5\"><span class=\"s3\"></span><span class=\"s4\"><a href=\"/services/weekend-divorce-workshops-5/\">Weekend Divorce Workshops</a>&nbsp;</span></li>\r\n</ul>\r\n<p class=\"p1\"><span class=\"s1\">For more information on these services and others not listed, please click the links above or <a href=\"/contact/\">contact us</a></span><span class=\"s1\">. If we cannot provide the specific service you&rsquo;re looking for, we&rsquo;d be happy to provide you with a qualified referral.</span></p>\r\n<h2 class=\"p1\"><span class=\"s1\">Who We Serve</span></h2>\r\n<p class=\"p2\"><span class=\"s1\">We serve both <a href=\"/areas-practice/personal/\">individuals</a> </span><span class=\"s1\">and <a href=\"/areas-practice/corporate/\">businesses</a> </span><span class=\"s1\">from a variety of backgrounds for a variety of reasons. For more information on where dispute resolution practices work, please see our <a href=\"/areas-practice/\">Areas of Practice</a> </span><span class=\"s1\">page.</span></p>','<p>The Negotiators is a full-service, North American provider of Alternative Dispute Resolution (ADR) services, with offices in Atlanta, Calgary, Chicago, Edmonton, Las Vegas, Miami, Red Deer, and Saskatoon.</p>','','160823111141.jpg','','',0,0,1,0,2,0,5,22,'2016-12-22 21:46:39'),(5,NULL,'Contact','contact','',0,NULL,'Contact the Negotiators','Contact Details & Hours of Operation','','Contact The Negotiators today to explore your options for Alternative Dispute Resolution or make a payment. A team member will reach out to you asap.','','contact',84.60,'','<p>The nature of our business dictates that we are often in mediations and other meetings that we cannot break out of.&nbsp;For that reason we recommend emailing us using the form below, although you are more than welcome to call our office and a team member will be in touch with you as soon as possible. Thank you in advance for your patience!</p>','','160823114150.jpg','','',0,0,0,0,6,-1,NULL,NULL,'2017-05-19 14:11:06'),(6,NULL,'Areas of Practice','areas-practice','',0,NULL,'Areas of Practice','','ADR Areas of Practice','There is almost no dispute that cannot be resolved by mediation, arbitration, negotiation, or some other ADR methodology.','','',61.50,'<h3>No Issue Too Big or Too Small</h3>\r\n<p>We provide a wide spectrum of dispute resolution and conflict management services to <a href=\"/areas-practice/personal/\">individuals</a> and <a href=\"/areas-practice/corporate/\">businesses</a> that address a variety of dispute types, and provide an efficient and cost-effective alternative to litigation and formal grievances.</p>\r\n<p>Below are just a sample of the dispute types we&rsquo;ve handled recently:</p>\r\n<ul>\r\n<li>Antitrust</li>\r\n<li>Banking</li>\r\n<li>Bankruptcy</li>\r\n<li>Breach of Contract</li>\r\n<li>Bullying</li>\r\n<li>Commerical</li>\r\n<li>Community/Neighborhood</li>\r\n<li>Congregational Disputes</li>\r\n<li>Construction</li>\r\n<li>Contacts</li>\r\n<li>Custoday</li>\r\n<li>Defamation</li>\r\n<li>Discrimination</li>\r\n<li>Diversity Issues</li>\r\n<li>Divorce</li>\r\n<li>Domestic Disputes</li>\r\n<li>Education</li>\r\n<li>Elder Care</li>\r\n<li>Entertainment Industry</li>\r\n<li>Environment</li>\r\n<li>Family Problems</li>\r\n<li>Government</li>\r\n<li>Healthcare</li>\r\n<li>Insurance</li>\r\n<li>Intellectual Property</li>\r\n<li>Internation/Bilateral Agreements</li>\r\n<li>Labor Disputes</li>\r\n<li>Landlord/Tenant</li>\r\n<li>Malpractice</li>\r\n<li>Mediation for Media</li>\r\n<li>Medical Malpractice</li>\r\n<li>Personal Injury</li>\r\n<li>Pharmaceuticals</li>\r\n<li>Police</li>\r\n<li>Post-Nuptial Mediation</li>\r\n<li>Probation</li>\r\n<li>Product Liability</li>\r\n<li>Professional Liability</li>\r\n<li>Real Estate</li>\r\n<li>Retaliation</li>\r\n<li>Securities</li>\r\n<li>Separation</li>\r\n</ul>','<p>There is almost no dispute that cannot be resolved by mediation, arbitration, negotiation, or some other ADR methodology.</p>','','160825104645.jpg','Alternative Dispute Resolution Areas of Practice','',0,0,1,0,4,-1,8,NULL,'2016-12-22 21:46:54'),(7,13,'The Negotiators Blog','our-blog','negotiators-blog',0,NULL,'The Negotiators Blog','','The Negotiators Blog','The Negotiators Blog is a collection of categorized posts with information, advice, and opinions written by our team of ADR and conflict management experts.','negotiators-blog','',0.00,'<h3>The Negotiators Blog</h3>\r\n<p>The Negotiators Blog is a collection of categorized posts with information, advice, and opinions written by our team of ADR and conflict management experts. Have a topic you&rsquo;d like us to discuss? <a href=\"/contact/\">Contact us today!</a></p>','','','160825103601.jpg','The Negotiators Blog','',0,0,0,0,1,-1,8,NULL,'2016-08-25 16:36:02'),(8,13,'The Negotiators Newsletter','newsletter','',0,NULL,'Newsletter','','','','','',46.20,'','','','160825113708.jpg','','',0,0,0,0,6,-1,NULL,NULL,'2016-08-25 17:37:09'),(9,5,'Success','success','',0,NULL,'Success','Thank You','','','','',42.30,'','','',NULL,'','',0,1,0,1,101,-1,NULL,NULL,'2016-04-29 20:58:56'),(10,13,'FAQs','faqs','',0,NULL,'FAQs','FAQs','Alternative Dispute Resolution FAQ','A categorized listing of the most frequently asked questions we receive in relation to alternative dispute resolution services and conflict management.','','',61.50,'<h3>FAQs</h3>\r\n<p>A categorized listing of the most frequently asked questions we receive in relation to alternative dispute resolution services and conflict management. Have a question that you don&rsquo;t see here? <a href=\"/contact/\">Contact us today!</a></p>','','','160825113348.jpg','Alternative Dispute Resolution FAQ','',0,0,0,0,2,-1,8,NULL,'2016-08-25 17:33:49'),(11,4,'Meet The Negotiators','meet-our-team','',0,NULL,'Meet The Negotiators','','Meet The Negotiators','Our team of mediators, arbitrators, and negotiators are the finest talents in the industry, managing and preventing conflict for clients across North America.','','negotiators',53.80,'<h2><span class=\"s1\">The Finest Talents in the North American ADR Industry</span></h2>\r\n<p class=\"p2\"><span class=\"s1\">All team members are trained facilitators and project managers, and are licensed and registered as required by the location(s) in which they practice. For more information on our team and the services they specialize in, please see the bios below:</span></p>','<p>Our talented team of mediators, arbitrators, and negotiators has over 300 years experience resolving, managing, and preventing disputes for individuals and businesses around the world.</p>','','160823111418.jpg','','',0,0,0,0,1,0,7,NULL,'2021-10-28 14:31:44'),(12,NULL,'Unsubscribe','unsubscribe','',0,NULL,'Unsubscribe','','','','','',50.00,'','','',NULL,'','',0,1,0,1,101,-1,NULL,NULL,'2016-09-06 18:52:47'),(13,NULL,'Resources','resources','',0,NULL,'Resources','','Alternative Dispute Resolution Resources','A collection of tools, advice, and information related to alternative dispute resolution and conflict management.','','',61.50,'<h3>Newsletter Signup</h3>\r\n<p><a href=\"/resources/newsletter/\">Click here</a> to sign up for our free, informative email newsletter.</p>\r\n<h3><a href=\"/resources/negotiators-blog/\">The Negotiators Blog</a></h3>\r\n<p>The Negotiators Blog is a collection of categorized posts with information, advice, and opinions written by our team of ADR and conflict management experts.</p>\r\n<h3><a href=\"/resources/faqs/\">FAQs</a></h3>\r\n<p>A categorized listing of the most frequently asked questions we receive in relation to alternative dispute resolution and conflict management.</p>\r\n<h3><a href=\"/resources/games/\">Games</a></h3>\r\n<p>A set of fun, interactive free games to educate on the benefits of negotiation and conflict management skills in real-world situations.</p>\r\n<h3><a href=\"/resources/useful-links/\">Useful Links</a></h3>\r\n<p>Links to organizations, websites, and resources, that we feel provide valuable information related to alternative dispute resolution and conflict management.</p>','<p>A collection of tools, advice, and information related to alternative dispute resolution and conflict management provided by The Negotiators.</p>','','160826084336.jpg','Alternative Dispute Resolution Resources','',0,0,1,0,5,-1,8,NULL,'2016-12-22 21:47:07'),(14,4,'Our Process','our-process','',0,NULL,'Our Process','','Heuristic Conflict Management','The Heuristic process is a creative, flexible, and non-linear approach we take to resolving issues and creating comprehensive road maps to resolution and beyond.','','',53.80,'','<p>The “Heuristic” process is a creative, flexible, and non-linear approach we use to resolve issues and create comprehensive road maps to resolution and beyond. It is a tried and tested mediation technique that often yields results quicker and more efficiently than alternate methods.</p>','','160825011920.jpg','','',0,0,1,0,2,0,1,6,'2016-12-22 21:47:14'),(15,NULL,'Services','services','',0,NULL,'Services','','','','','',57.70,'<h3>Alternative Dispute Resolution (ADR) Services</h3>\r\n<p>The Negotiators offers a wide spectrum of ADR services to manage, resolve, and prevent disputes. These services provide an alternative to litigation and formal grievances, often resolving disputes at a fraction of the time and cost associated with going to court.</p>\r\n<h3>Conflict Management and Prevention</h3>\r\n<p>Conflict is everywhere – it&rsquo;s at home, at work, and in our communities. While no conflict is insurmountable, the extent to which it affects our daily lives is largely dependent on our ability to manage and prevent it. At The Negotiators, we provide a range of tools and services to manage, resolve, and prevent conflict for both <a href=\"/areas-practice/personal/\">individuals</a> and <a href=\"/areas-practice/corporate/\">businesses</a>. Our <a href=\"/about-negotiators/meet-our-team/\">talented team of conflict management professionals</a> brings years of experience to every dispute, developing solutions that take into account the unique set of circumstances that each case entails. </p>\r\n<h3>Full-Service ADR Capabilities</h3>\r\n<p>While <a href=\"/services/negotiation-4/\">negotiation</a>, <a href=\"/services/mediation-1/\">mediation</a>, and <a href=\"/services/arbitration-2/\">arbitration</a> are some of the better-known ADR methods, The Negotiators provides a wide variety of dispute resolution services, including <a href=\"/services/facilitation-3/\">facilitation</a>, <a href=\"/services/reconciliation-6/\">reconciliation</a>, <a href=\"/services/weekend-divorce-workshops-5/\">weekend divorce workshops</a> and <a href=\"/services/dispute-resolution-panels-7/\">dispute resolution panels</a>. You can also <a href=\"/contact/\">contact us</a> for information on any services not listed here, and either we, or a qualified referral partner, will be able to address your needs.</p>\r\n<h3>Choose Your Degree of Control</h3>\r\n<p>Alternative dispute resolution allows disputants to determine the level of control they would like to exert over the proceedings, whereas with litigation, control is passed to the court. All of our services offer varying degrees of flexibility in regards to who hears the case, whether or not the results are binding, confidentiality, rules of evidence, and more. It really begs the question – why would anyone take his or her chances in court with the control ADR provides?</p>\r\n<h3>Conflict Management Training</h3>\r\n<p>Stress from change often leads to tension and conflict, but learning to properly communicate during these times is a valuable skill that mitigates the effect change can have on us. The Negotiators provides <a href=\"/services/conflict-management-training-8/\">conflict management training</a> to guide individuals, businesses, and organizations towards proactively preventing conflict and leveraging valuable tools to resolve disputes if and when they do arise. This often leads to less stress and higher morale, both at home and at work.</p>\r\n<p> Services offered by our certified, licensed conflict management professionals include, but are not limited to, those listed below. Please click the links for more information.</p>','','','160823112126.jpg','','',0,0,0,0,3,-1,NULL,NULL,'2021-12-08 16:20:25'),(24,6,'Personal','personal','',0,NULL,'Alternative Dispute Resolution (ADR) for Individuals','','ADR Services for Individuals','The Negotiators offers individuals a confidential and cost-effective alternative to litigation and formal grievances, through a wide variety of ADR services.','','',61.50,'<h3>ADR Services for Individuals</h3>\r\n<p>It&rsquo;s almost impossible to list all the types of conflict that can be resolved through mediation. Our conflict management professionals deal with a wide spectrum of clients with a variety of issues, and are always available to explore ways that ADR can provide. More importantly, we understand that personal disputes often carry the extra stress of affected relationships, and we work carefully to provide pragmatic solutions that take these relationships into account.</p>\r\n<h3>Divorce Specialist</h3>\r\n<p>Next to the death of a loved one, divorce can be the most stressful and painful time in one&rsquo;s life. Dealing with anger, the potential loss of your home, dividing your assets, and child custody can lead to tension and decisions to be made with emotion. Alternative dispute resolution allows the opportunity for a more positive, mutually agreeable settlement that will hold, without continuing hostilities, so all parties can move forward towards a new reality.</p>\r\n<p>The Negotiators are one of the first agencies to offer <a href=\"/services/weekend-divorce-workshops-5/\">Divorce Workshops</a>, a weekend course to help couples resolve their disputes over children, support, property, etc. and then help them prepare their divorce or separation agreements, and finally file for divorce.</p>\r\n<p>Below are just a few of the other areas where alternative dispute resolution can be especially helpful for individuals:</p>\r\n<ul>\r\n<li>Banking</li>\r\n<li>Bankruptcy</li>\r\n<li>Breach of Contract</li>\r\n<li>Bullying</li>\r\n<li>Community/Neighborhood</li>\r\n<li>Congregational Disputes</li>\r\n<li>Contracts</li>\r\n<li>Custody</li>\r\n<li>Defamation</li>\r\n<li>Discrimination</li>\r\n<li>Diversity Issues</li>\r\n<li>Divorce</li>\r\n<li>Domestic Disputes</li>\r\n<li>Education</li>\r\n<li>Elder Care</li>\r\n<li>Employment</li>\r\n<li>Environment</li>\r\n<li>Government</li>\r\n<li>Healthcare</li>\r\n<li>Insurance</li>\r\n<li>Intellectual Property</li>\r\n<li>Labor Disputes</li>\r\n<li>Landlord/Tenant</li>\r\n<li>Malpractice</li>\r\n<li>Personal Injury</li>\r\n<li>Pharmaceuticals</li>\r\n<li>Police</li>\r\n<li>Post-Nuptial Mediation</li>\r\n<li>Premises Liability</li>\r\n<li>Probation</li>\r\n<li>Product Liability</li>\r\n<li>Professional Liability</li>\r\n<li>Retaliation</li>\r\n</ul>','<p>The Negotiators offers individuals a confidential and cost-effective alternative to litigation and formal grievances, through a wide variety of ADR services.</p>','','160825103750.jpg','ADR Services for Individuals','',0,0,1,0,1,-1,8,NULL,'2016-12-22 21:47:21'),(25,6,'Corporate','corporate','',0,NULL,'Alternative Dispute Resolution (ADR) for Businesses','','ADR Services for Businesses','The Negotiators offers businesses a confidential and cost-effective alternative to litigation and formal grievances, through a wide variety of ADR services.','','',57.70,'<h2>ADR Services for Businesses</h2>\r\n<p>Business should always consider mediation, arbitration, negotiation, and all other ADR methodologies for dispute resolution, but sometimes it can also be compulsory as a part of contracts of local statutes. Alternative dispute resolution allows for disputes to be settled privately and confidentially, with the aid of subject matter experts and conflict management specialists, making these tools incredibly important for businesses.</p>\r\n<p>Below are just a few of the areas where alternative dispute resolution can be especially helpful for businesses:</p>\r\n<ul>\r\n<li>Antitrust</li>\r\n<li>Banking</li>\r\n<li>Bankruptcy</li>\r\n<li>Breach of Contract</li>\r\n<li>Commercial</li>\r\n<li>Congregational Disputes</li>\r\n<li>Construction</li>\r\n<li>Contracts</li>\r\n<li>Defamation</li>\r\n<li>Discrimination</li>\r\n<li>Diversity Issues</li>\r\n<li>Employment</li>\r\n<li>Entertainment Industry</li>\r\n<li>Environmental</li>\r\n<li>Government</li>\r\n<li>Healthcare</li>\r\n<li>Insurance</li>\r\n<li>Intellectual Property</li>\r\n<li>International/Bilateral Agreements</li>\r\n<li>Labor Disputes</li>\r\n<li>Landlord/Tenant</li>\r\n<li>Mediation for Media</li>\r\n<li>Medical Malpractice</li>\r\n<li>Personal Injury</li>\r\n<li>Pharmaceuticals</li>\r\n<li>Police</li>\r\n<li>Premises Liability</li>\r\n<li>Product Liability</li>\r\n<li>Professional Liability</li>\r\n<li>Real Estate</li>\r\n<li>Retaliation</li>\r\n<li>Securities</li>\r\n<li>Sexual Harassment</li>\r\n<li>Trade</li>\r\n<li>Workers Compensation</li>\r\n<li>Workplace Bullying</li>\r\n<li>Workplace Issues</li>\r\n<li>Wrongful Death</li>\r\n</ul>','<p>The Negotiators offers businesses a confidential and cost-effective alternative to litigation and formal grievances, through a wide variety of ADR services.</p>','','160825103905.jpg','ADR Services for Businesses','',0,0,1,0,2,-1,5,NULL,'2016-12-22 21:47:28'),(26,13,'Games','games','',0,NULL,'Games','','Conflict Management Games','A set of fun, interactive free games to educate on the benefits of negotiation and conflict management skills in real-world situations.','','',61.50,'<h3>Educational Tools for Building Conflict Management Skills</h3>\r\n<p>Below are a few real-world examples of situations in which negotiation and conflict management skills can help avert full-blown disaster. How will you fare?</p>','<p>Learn negotiation and conflict management skills with these fun and interactive free games.</p>','','160823113810.jpg','Conflict Management Games','',0,0,0,1,3,-1,NULL,NULL,'2016-12-22 21:47:35'),(27,13,'Useful Links','useful-links','',0,NULL,'Useful Links','','Alternative Dispute Resolution Links','Links to organizations, websites, and resources that we feel provide valuable information related to alternative dispute resolution and conflict management.','','',65.40,'<h2>Resources</h2>\r\n<p>Know of a resource we should include in this list? <a href=\"/contact/\">Contact us today!</a></p>\r\n<h3>Industry Organizations</h3>\r\n<p><a href=\"http://aams.ab.ca/\">Alberta Arbitration and Mediation Society</a></p>\r\n<p><a href=\"https://adralberta.com/\">ADR Institute of Alberta</a></p>\r\n<p><a href=\"http://www.justicecenter.org/\">Justice Center</a></p>\r\n<p><a href=\"http://godr.org/\">Georgia Commission on Dispute Resolution</a></p>\r\n<h3>Useful Links</h3>\r\n<p><a href=\"http://mysupportcalculator.ca/\">Child Support Calculator (Canada)</a></p>\r\n<p><a href=\"http://cscalc.gaaoc.us/\">Child Support Calculator (Georgia)</a></p>\r\n<p><a href=\"http://mortgagesimple.ca/\">Mortgage Simple</a></p>\r\n<h3>Divorce Links</h3>\r\n<p><a href=\"http://www.meetup.com/Weekend-Divorce-Workshops/\">I&rsquo;m Getting Divorced (Separated) Meetup</a></p>\r\n<ul>\r\n<li><a href=\"http://www.meetup.com/Weekend-Divorce-Workshop-Edmonton/\">Edmonton</a></li>\r\n<li><a href=\"http://www.meetup.com/Weekend-Divorce-Workshops-Ft-McMurray/\">Fort McMurray</a></li>\r\n<li><a href=\"http://www.meetup.com/Weekend-Divorce-Workshops-Calgary/\">Calgary</a></li>\r\n<li><a href=\"http://www.meetup.com/Weekend-Divorce-Workshops-Grande-Prairie/\">Grande Prairie</a></li>\r\n<li><a href=\"http://www.meetup.com/Wekend-Divorce-Workshops-Red-Deer/\">Red Deer</a></li>\r\n<li><a href=\"http://www.meetup.com/Weekend-Divorce-Workshops-Wetaskiwin/\">Wetaskiwin</a></li>\r\n</ul>\r\n<p><a href=\"http://www.meetup.com/Weekend-Divorce-Workshops/\">Weekend Divorce Workshops Listing</a></p>\r\n<p><a href=\"http://www.meetup.com/Moving-On-Food-Wine-Club-for-Newly-Singled-People/\">Moving on Food &amp; Wine Club for Newly Single People</a></p>','<p>Below are links to organizations, websites, and resources that we feel provide valuable information related to alternative dispute resolution and conflict management.</p>','','160823114009.jpg','Alternative Dispute Resolution Links','',0,0,1,0,4,-1,8,NULL,'2016-12-22 21:47:42'),(28,NULL,'Payments','payments','',0,NULL,'Online Payments','Online Payment Information','','','','',53.80,'<p class=\"p1\">Contacting us to make a payment?&nbsp; There&rsquo;s no need – simply use the buttons below to make your payment online. We accept all major credit cards.&nbsp;If you are reserving a mediation session we require a $300 deposit (please note - this fee is non-refundable). Thank you for your business!</p>','','',NULL,'','',0,0,0,0,101,-1,NULL,NULL,'2017-05-19 14:12:09'),(29,15,'Training','training','',0,NULL,'Training Services','Page Content Title','','','','',42.30,'<p>Page Content Text</p>','<p>Are you looking to become a skilled, certified, and effective Mediator, Arbitrator, or Resolution Conflict Expert? If so, you have come to the right place. Our skilled team members have over 100 years in combined Conflict Resolution experience and they have taught people just like you how to excel in these respective fields. Our courses are comprehensive, in-depth, and provide you with all the support and resources needed to become successful. When you sign up for our training courses, you will become a part of an ever growing community of like-minded individuals with access to our constantly developing database of knowledge and techniques.</p>','','180324032038.jpg','','',0,2,1,0,101,-1,7,NULL,'2021-12-08 16:27:31');

--
-- Table structure for table `pages_cta`
--

CREATE TABLE `pages_cta` (
  `cta_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(500) DEFAULT NULL,
  `subtitle` varchar(500) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `url` text,
  `url_target` int(1) NOT NULL DEFAULT '0',
  `url_text` varchar(200) DEFAULT NULL,
  `showhide` int(1) NOT NULL DEFAULT '0',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`cta_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages_cta`
--

INSERT INTO `pages_cta` VALUES (1,'Negotiations Have to be Fair...Not Necessarily Even','Get Started with a Free Initial Consultation','160422031911.jpg','/contact/',0,'Contact Us Today!',0,'2016-04-01 15:56:05'),(2,'Let Us Show You the Difference Mediation Can Make','Get Started with a Free Initial Consultation','160825114245.jpg','/contact/',0,'Contact Us Today!',0,'2016-07-25 19:34:06'),(3,'Let Us Show You the Difference Arbitration Can Make','Get Started with a Free Initial Consultation','160825114547.jpg','/contact/',0,'Contact Us Today!',0,'2016-07-25 19:34:47'),(4,'Let Us Show You the Difference Facilitation Can Make','Get Started with a Free Initial Consultation','160825102722.jpg','/contact/',0,'Contact Us Today!',0,'2016-07-25 19:35:19'),(5,'If You Let Your Emotions Control You, You Allow Someone Else to Control Your Future','Get Started with a Free Initial Consultation','160825094645.jpg','/contact/',0,'Contact Us Today!',0,'2016-07-25 19:35:59'),(6,'Let Us Show You the Difference Dispute Resolution Panels Can Make','Get Started with a Free Initial Consultation','160825114838.jpg','/contact/',0,'Contact Us Today!',0,'2016-07-25 19:36:30'),(7,'Let Us Show You the Difference Conflict Management Training Can Make','Get Started with a Free Initial Consultation','160825093947.jpg','/contact/',0,'Contact Us Today!',0,'2016-07-25 19:37:09'),(8,'Our Negotiators are Ready to Assist You','Get Started with a Free Initial Consultation','160810111645.jpg','/contact/',0,'Contact Us Today!',0,'2016-08-10 17:16:47');

--
-- Table structure for table `pages_promo`
--

CREATE TABLE `pages_promo` (
  `page_id` int(11) unsigned NOT NULL,
  `promo_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`page_id`,`promo_id`),
  KEY `promo_id` (`promo_id`),
  CONSTRAINT `pages_promo_ibfk_1` FOREIGN KEY (`page_id`) REFERENCES `pages` (`page_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `pages_promo_ibfk_2` FOREIGN KEY (`promo_id`) REFERENCES `promo_boxes` (`promo_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages_promo`
--

INSERT INTO `pages_promo` VALUES (3,1),(6,1),(10,1),(13,1),(14,1),(24,1),(27,1),(3,2),(4,2),(11,2),(13,2),(14,2),(25,2),(27,2),(3,3),(4,3),(6,3),(10,3),(11,3),(13,3),(14,3),(24,3),(25,3),(27,3),(4,4),(6,4),(10,4),(11,4),(24,4),(25,4);

--
-- Table structure for table `pages_services`
--

CREATE TABLE `pages_services` (
  `page_id` int(11) unsigned NOT NULL,
  `service_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`page_id`,`service_id`),
  KEY `service_id` (`service_id`),
  CONSTRAINT `pages_services_ibfk_2` FOREIGN KEY (`service_id`) REFERENCES `services` (`service_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages_services`
--

INSERT INTO `pages_services` VALUES (3,1),(4,1),(6,1),(11,1),(14,1),(24,1),(27,1),(3,2),(4,2),(6,2),(11,2),(13,2),(14,2),(24,2),(27,2),(3,3),(25,3),(3,4),(13,4),(25,4),(3,5),(4,5),(6,5),(11,5),(14,5),(24,5),(27,5),(3,6),(10,6),(3,7),(10,7),(13,7),(3,8),(10,8),(25,8),(3,10);

--
-- Table structure for table `pages_tabs`
--

CREATE TABLE `pages_tabs` (
  `tab_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) unsigned DEFAULT NULL,
  `service_id` int(11) unsigned DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `page` varchar(100) DEFAULT NULL,
  `content` text,
  `showhide` int(1) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '101',
  PRIMARY KEY (`tab_id`),
  KEY `page_id` (`page_id`),
  KEY `service_id` (`service_id`),
  CONSTRAINT `pages_tabs_ibfk_1` FOREIGN KEY (`page_id`) REFERENCES `pages` (`page_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `pages_tabs_ibfk_2` FOREIGN KEY (`service_id`) REFERENCES `services` (`service_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages_tabs`
--

INSERT INTO `pages_tabs` VALUES (1,4,NULL,'Mission Statement','mission-statement','<p class=\"p1\"><span class=\"s1\">The Negotiators&rsquo; mission is to provide a wide spectrum of best-in-industry<a href=\"/services/\"> ADR services</a>&nbsp;</span><span class=\"s1\">for <a href=\"/areasofpractice/personal/\">individuals</a></span><span class=\"s1\">&nbsp;and <a href=\"/areasofpractice/corporate/\">businesses</a> </span><span class=\"s1\">&nbsp;in Canada and the United States, guiding them to investigate and pursue all possible dispute resolution alternatives in a confidential and non-adversarial environment.</span></p>\r\n<blockquote>\r\n<p class=\"p1\"><span class=\"s2\">&nbsp;</span><span class=\"s1\">“Discourage litigation. Persuade your neighbors to compromise whenever you can. Point out to them how the nominal winner is often a real loser – in fees, expenses and waste of time.” - Abraham Lincoln</span><span class=\"s3\"> </span></p>\r\n</blockquote>',0,101),(2,4,NULL,'Vision Statement','vision-statement','<p class=\"p1\"><span class=\"s1\">The Negotiators&rsquo; vision is to be the most trusted mediation agency in North America, known and respected for reliability, as well as for helping individuals and businesses find practical and reasonable solutions to their domestic, national, and international disputes. We strive towards achieving our vision by providing unparalleled service and treating both clients and opposition with the utmost respect. </span></p>\r\n<blockquote>\r\n<p class=\"p2\"><span class=\"s2\">&nbsp;</span><span class=\"s1\">“Canada is free and freedom is its nationality… When I look about me, I see everywhere hope, calm resolution, courage, enthusiasm to face all difficulties, to settle all problems.” - Wilfred Laurier</span><span class=\"s1\"></span></p>\r\n</blockquote>',0,101),(3,4,NULL,'Core Values','core-values','<p class=\"p1\"><span class=\"s1\">We hold accountability and responsibility in the highest regard, for our clients as well as ourselves. This is achieved by adhering to our core values of:</span></p>\r\n<ul>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Integrity</span></li>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Respect</span></li>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Compassion</span></li>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Strength</span></li>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Honesty</span></li>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Self-Determination</span></li>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Objectivity</span></li>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Ethics</span></li>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Pragmatism</span></li>\r\n<li class=\"li1\"><span class=\"s2\"></span><span class=\"s1\">Level-Headedness</span></li>\r\n</ul>',0,101),(4,14,NULL,'Learn','learn','<p class=\"p1\"><span class=\"s1\">Parties agree to meet and volunteer information, data, documents, and ideas. This information is organized and prioritized according to the importance of each issue. While each party&rsquo;s perspective is different, the parameters become universal.</span></p>',0,101),(5,14,NULL,'Explore','explore','<p class=\"p1\"><span class=\"s1\">We actively observe which behaviors seem effective when participants are negotiating and which behaviors seem counter-productive. Our mediators do not hesitate to introduce non-traditional thought processes to encourage everyone&rsquo;s best performance and to minimize confrontation.</span></p>',0,101),(6,14,NULL,'Refine','refine','<p class=\"p1\"><span class=\"s1\">Our issue refinement techniques work so well because we never “back into” negotiations. We prefer to address the toughest issues first. Peripheral issues are pinpointed and addressed problematically. The realization of “how”, “when”, “where”, and “how to” creates a vision of settlement.</span></p>',0,101),(7,14,NULL,'Close','close','<p class=\"p1\"><span class=\"s1\">Decisions are made and agreements are put into action. All details are documented and a series of protocols are established in each agreement or partial agreement. These protocols address all possible contingencies. </span></p>',0,101);

--
-- Table structure for table `promo_boxes`
--

CREATE TABLE `promo_boxes` (
  `promo_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(500) DEFAULT NULL,
  `description` text,
  `image` varchar(500) DEFAULT NULL,
  `image_alt` tinytext,
  `url` text,
  `url_target` int(1) NOT NULL DEFAULT '0',
  `showhide` int(1) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '101',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`promo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `promo_boxes`
--

INSERT INTO `promo_boxes` VALUES (1,'Meet The Negotiators','Our team of licensed negotiators, arbitrators, and mediators are also trained facilitators and project managers','160825104609.jpg','','http://www.thenegotiators.com/about-negotiators/',0,0,101,'2016-03-31 20:58:33'),(2,'Areas of Practice','Managing personal and corporate conflict with a variety of Alternative Dispute Resolution services','160825104739.jpg','','/areas-practice/',0,0,101,'2016-03-31 20:58:59'),(3,'Contact The Negotiators','We&rsquo;re here to help you manage and prevent conflict. Contact us today!','160825104811.jpg','','/contact/',0,0,101,'2016-03-31 20:59:24'),(4,'Resources','Read our Blog or browse our extensive FAQs for insights and expertise on Alternative Dispute Resolution','160825104845.jpg','','/resources/',0,0,101,'2016-07-25 19:00:57');

--
-- Table structure for table `related_services`
--

CREATE TABLE `related_services` (
  `service_id` int(11) unsigned NOT NULL,
  `related_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`service_id`,`related_id`),
  KEY `related_id` (`related_id`),
  CONSTRAINT `related_services_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `services` (`service_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `related_services_ibfk_2` FOREIGN KEY (`related_id`) REFERENCES `services` (`service_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `related_services`
--

INSERT INTO `related_services` VALUES (3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(10,2),(5,4),(3,5),(4,5),(6,5),(7,5),(8,5),(10,5),(10,7);

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `service_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `page` varchar(100) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `image_alt` varchar(200) DEFAULT NULL,
  `description` text,
  `introduction` text,
  `cta_id` int(11) unsigned DEFAULT NULL,
  `content` text,
  `showhide` int(1) NOT NULL DEFAULT '0',
  `ordering` int(1) NOT NULL DEFAULT '101',
  `meta_title` varchar(100) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `focus_keyword` varchar(255) DEFAULT NULL,
  `seo_score` decimal(10,2) NOT NULL DEFAULT '0.00',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`service_id`),
  KEY `cta_id` (`cta_id`),
  CONSTRAINT `services_ibfk_1` FOREIGN KEY (`cta_id`) REFERENCES `pages_cta` (`cta_id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES (1,'Mediation','mediation','160823112529.jpg','Mediation Services','We bring to the table best in divorce/family, civil and corporate mediation, with expertise and experience from around the world. Our mediations are true \"safe zones\" conducive to resolving even the most intense disputes.','Mediation is an informal, confidential, and non-adversarial intervention between conflicting parties to promote settlement, compromise, or understanding. Mediation is usually the best, but last alternative to litigation.',2,'<h2 class=\"p1\"><span class=\"s1\">There are no Losers in Mediation</span></h2>\r\n<p class=\"p2\"><span class=\"s1\">Mediation provides an impartial, non-binding assessment of your dispute in a private and confidential environment. Mediators don&rsquo;t judge or counsel, but simply find avenues to reconciliation between disputing parties through the skills and experience they possess as a trained mediator. Benefits of mediation include:</span></p>\r\n<ul>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Mediation is </span><span class=\"s3\"><strong>fast</strong></span><span class=\"s1\">, resolving disputes that could take months or years in the courts in days or weeks</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Mediation is </span><span class=\"s3\"><strong>private and confidential</strong></span><span class=\"s1\">, whereas courts are public forums and information about your business and personal affairs become public knowledge</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Mediation </span><span class=\"s3\"><strong>costs less</strong></span><span class=\"s1\"> than other forms of dispute resolution</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Mediation can </span><span class=\"s3\"><strong>maintain relationships and goodwill</strong></span><span class=\"s1\">, by allowing parties to approach the dispute together and find a mutually agreeable outcome</span></li>\r\n</ul>\r\n<h3 class=\"p5\"><span class=\"s1\">Who Needs a Mediator?</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">A well-trained mediator acts as a third ear, not a third voice; organizing, facilitating, navigating, and refereeing between conflicting parties. Our mediators are great at sensing and recognizing the real vs. perceived needs of the parties, finding the message behind the message, and guiding the conversation towards an amicable resolution. The main goal is to keep everyone focused on resolving the issues at hand in a facilitative and confidential environment free from threat or intimidation. </span></p>\r\n<p class=\"p4\"><span class=\"s1\">Examples of where a mediator is beneficial include:</span></p>\r\n<h4 class=\"p5\"><span class=\"s1\">Personal Mediation</span></h4>\r\n<ul>\r\n<li class=\"li2\"><span class=\"s4\"></span><span class=\"s1\">Divorce/Separation</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Wills & Estate</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Family Mediation</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Landlord/Tenant Disputes</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Sports Mediation/Agency</span></li>\r\n</ul>\r\n<h3 class=\"p5\"><span class=\"s1\">Corporate Mediation</span></h3>\r\n<ul>\r\n<li class=\"li2\"><span class=\"s4\"></span><span class=\"s1\">Takeovers</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Contracts & subcontracts</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Dispute over the provision of a product or service (on time, quality, budget)</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Labor relations</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Wrongful dismissal and severance negotiations</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Sexual Harassment claims</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Workplace bullying</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Productivity Issues</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Non-confidence</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Ombudsman and investigative services</span></li>\r\n</ul>\r\n<p class=\"p2\"><span class=\"s1\">For more information on when mediation is recommended, our other Alternative Dispute Resolution services, or to contact us, just click the link below:</span></p>',0,1,'Mediation Services','Mediation Services is an informal, confidential, and non-adversarial intervention between conflicting parties to promote settlement, compromise, or understanding.','Mediation Services',61.50,'2021-12-09 06:25:12'),(2,'Arbitration','arbitration','160823112731.jpg','Arbitration Services','Sometimes when parties simply cannot agree they need a decision rendered for them, but still don&rsquo;t want to go to court. We have,either on staff or on contract, arbitrators, lawyers and a vast array of subject matter experts.','Arbitration is similar to litigation, except that parties agree to be bound by the decision of a mutually acceptable, knowledgeable, independent, and neutral third-party. The third-party may be an individual arbitrator or a panel of arbitrators, often referred to as a tribunal.',3,'<h2 class=\"p1\"><span class=\"s1\">Like Court, but with More Control</span></h2>\r\n<p class=\"p2\"><span class=\"s1\">Disputes taken to court are settled by judges who, while experts in law, may or may not have subject matter expertise in the particular area of dispute. Arbitration allows the parties to choose the arbitrator, whether they be a specific person or someone with a required level of expertise, and agree in advance to be bound by their decision. Because both parties are working together to set mutually-acceptable terms, arbitration also has the potential for flexibility, in that both parties may wish to suspend the arbitration in favor of <a href=\"/services/mediation-1/\">mediation</a> </span><span class=\"s1\">or <a href=\"/services/facilitation-3/\">facilitated negotiation</a></span><span class=\"s1\">.</span></p>\r\n<h3 class=\"p3\"><span class=\"s1\">The Arbitration Process</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">Once an arbitrator has been agreed upon and documents have been shared, hearings begin. At the hearings, which can be formal or informal, both parties have the opportunity to present evidence, opening and closing statements, and cross-examine witnesses. The rules of evidence usually apply in arbitration, as opposed to other forms of dispute resolution, such as mediation, and the arbitrator(s) has the ability to dismiss or prioritize evidence as they see fit. The arbitrator then imposes a decision that is often legally binding and not appealable to the courts, and in rare cases where an appeal is heard, courts generally uphold the arbitrator&rsquo;s ruling.</span></p>\r\n<h3 class=\"p3\"><span class=\"s1\">Confidentiality is Key</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">Because courts are public forums, information about your business and personal affairs becomes public knowledge available to others. Arbitration, on the other hand, is almost always conducted in private and only made public with the explicit consent of both parties. Arbitration awards are generally not a matter of public record.</span></p>\r\n<h3 class=\"p3\"><span class=\"s1\">Ideally Suited to Corporate Disputes</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">Being able to choose an arbitrator with industry-specific expertise is especially important in corporate disputes. In addition, arbitration is often preferred in disputes involving international transactions, as all parties may not be familiar with the rules and procedures of a foreign court system, which puts them at a disadvantage. </span></p>\r\n<h3 class=\"p3\"><span class=\"s1\">Arbitration is Faster and Costs Less Than Going to Court</span></h3>\r\n<p class=\"p4\"><span class=\"s1\">Disputes that can be settled in court can often take many months or years. With arbitration, these same disputes can be settled in weeks and at a fraction of the cost of pursuing litigation.</span></p>\r\n<p class=\"p4\"><span class=\"s1\">For more information on when arbitration is recommended, our other Alternative Dispute Resolution services, or to contact us, please see the links below:</span></p>',0,2,'Arbitration Services','Arbitration is similar to litigation, except parties agree to be bound by the decision of a mutually acceptable, knowledgeable, independent, and neutral third-party.','Arbitration Services',65.40,'2021-12-08 15:07:25'),(3,'Facilitation','facilitation','160823113023.jpg','','We facilitate everything from stormy community meetings, to AGMs, to corporate strategic planning exercises with complete neutrality and  objectivity. Whether you need \"disciplined and dispassionate\", or creative and motivational. We have your ideal facilitator.','Facilitation is the process of planning and conducting productive meetings to gather facts, opinions, and consensus on items of mutual concern. Facilitation is similar to mediation, but often employed pre-conflict to reconcile differing opinions or set out strategic plans.',5,'<h2 class=\"p1\"><span class=\"s1\">A Neutral Third-Party to Guide the Discussion</span></h2>\r\n<p class=\"p2\"><span class=\"s1\">Facilitators work with varying numbers of organizational groups - small and large, internal and external – to offer procedural support from a neutral point of view. Facilitations can range from a single board meeting to a public task force comprised of civic, corporate, and governmental groups that meet over months and years. </span></p>\r\n<p class=\"p4\"><span class=\"s1\">A good facilitator provides value by organizing and directing a meeting&rsquo;s content and tone to maximize efficiency, both in terms of time and results. Facilitators guide the conversation to capture key points and alleviate tension when necessary, acting as an impartial third-party to avoid individual agendas from getting in the way of group progress.</span></p>\r\n<h3 class=\"p5\"><span class=\"s1\">Boards and Associations </span></h3>\r\n<p class=\"p4\"><span class=\"s1\">Often facilitators sit as neutral chairs at board or association meetings where high conflict and strongly differing opinions can make it difficult to achieve consensus.</span></p>\r\n<h3 class=\"p5\"><span class=\"s1\">Multi-Party Negotiations</span></h3>\r\n<p class=\"p4\"><span class=\"s1\">Competing interests, opinions, and negotiation styles can quickly complicate negotiations involving three or more parties. In these situations, a facilitator is employed to keep discussions orderly and to track the changing positions of each group.</span></p>\r\n<h3><span class=\"s1\">Fact-Finding and Focus Groups</span></h3>\r\n<p class=\"p4\"><span class=\"s1\">Facilitation usually entails fact-finding sessions to gain a clearer understanding of personal opinions, concerns, and observations. Increased information and clearer understanding between parties usually results in better management decisions and fewer disagreements.</span></p>\r\n<h3 class=\"p5\"><span class=\"s1\">Focus Groups</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">Focus groups, historically used as marketing initiatives, identify and isolate issues, interests, motivations, and perceived results among key stakeholders. Usually this includes a limited number of people from within a single organization, but can also be conducted between departments and external groups. The purpose is not to negotiate, defend, or address any matter raised, but simply to gather focused information that might not otherwise be attainable.</span></p>\r\n<p class=\"p2\"><span class=\"s1\">For more information on when facilitation is recommended, our other Alternative Dispute Resolution services, or to contact us, please see the links below:</span></p>',0,4,'Facilitation Services','Facilitators plan and conduct meetings with key stakeholders to gather facts, opinions, and consensus on items of mutual concern, from a neutral point of view.','Facilitation Services',69.20,'2021-12-08 15:07:26'),(4,'Negotiation','negotiation','160823112336.jpg','','We are the original authors of the \"Blue Book on Negotiations\" which has been taught internationally. We train negotiators and act as negotiators in corporate disputes, labor relations, quality and delivery of services, sports contracts, entertainments, etc.','Whether you&rsquo;re setting out an agreement or attempting to resolve a conflict, negotiation is where the conversation starts. Let our team of experienced negotiators guide you through the process, finding an amicable solution that is timely and cost-efficient.',8,'<h2 class=\"p1\"><span class=\"s1\">Find Common Ground with the Help of The Negotiators </span></h2>\r\n<p class=\"p2\"><span class=\"s1\">In its simplest definition, negotiation is when two or more parties formally meet to reach an agreement on a matter of mutual concern. Structured negotiations usually take one of two forms: parties engage their own negotiators to bargain for their respective positions, or all parties agree on a neutral negotiator to ensure discussions remain relevant, cordial and timely. Negotiations may or may not include legal counsel (although this is usually recommended), and while conflict is generally present, negotiating agreements or contracts often involves friendly parties working together to prevent and mitigate any future conflict.</span></p>\r\n<h3 class=\"p3\"><span class=\"s1\">When do I need a Negotiator?</span></h3>\r\n<p class=\"p4\"><span class=\"s1\">Anyone can negotiate his or her position, we do this everyday; but most attempts at negotiation often result in arguments. Structured negotiation is a highly advanced skill, and trained negotiators utilize a variety of styles and tools to successfully bargain for an optimal result, while keeping the conversation civil. Examples of when a negotiator is recommended include:</span></p>\r\n<ul>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Entering into business agreements or contracts</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Buying, selling, merging, downsizing</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Collective bargaining</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">Divorce</span></li>\r\n</ul>\r\n<h3 class=\"p3\"><span class=\"s1\">Who Negotiates?</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">Business associates, management and labor, congregations, communities, customer groups, and even families are examples of those who we have worked with to successfully prevent and manage conflict through structured negotiations.</span></p>\r\n<h3 class=\"p3\"><span class=\"s1\">Multi-Party Negotiations</span></h3>\r\n<p class=\"p4\"><span class=\"s1\">Most negotiations are between two parties, but in the case of multi-party negotiations, which can quickly become complicated, a <a href=\"/services/facilitation-3/\">facilitator</a> </span><span class=\"s1\">may be required to keep discussions focused and balanced.<span class=\"Apple-converted-space\"> <span class=\"Apple-tab-span\"> </span></span></span></p>',0,5,'Negotiation Services','Our team of experienced negotiators utilizes a variety of negotiation styles and tools to provide the optimal result for our clients. Find common ground with the help of The Negotiators','Negotiation Services',65.40,'2021-12-08 15:07:28'),(5,'Weekend Divorce Workshops','weekend-divorce-workshops','160825102912.jpg','','Divorce after a single weekend? Yes! Experienced, independent lawyers and mediators came together to help you get it done that fast. It is quick, inexpensive and comparatively stress-free. The results have been amazing, and the service is growing.','You can be ready to file your divorce after just one weekend. No expensive legal bills, no going to court.',8,'<h2 class=\"p1\"><span class=\"s1\">Can Filing for Divorce be This Easy? Yes!!!</span></h2>\r\n<p class=\"p2\"><span class=\"s1\">This is a proto-type workshop to help couples resolve their disputes over children, support, property, etc. and then help them prepare their divorce or separation agreements, and actually help them file for divorce.</span></p>\r\n<p class=\"p3\"><span class=\"s1\">Our divorce workshops provide you with all the tools to complete your own agreement and divorce filing. Or, if you choose, we can write your agreements for you and/or file your divorce for a minimal fee, available only to participants in this workshop. </span></p>\r\n<h3 class=\"p4\"><span class=\"s1\">A Team of Experts at Your Disposal</span></h3>\r\n<p class=\"p3\"><span class=\"s1\">You will have an entire weekend with access to divorce lawyers and mediators who can answer all your questions, explain your options and help you move forward with dignity and without fear. Nothing like this has ever been offered. A number of conscientious and independent lawyers and mediators got together to create a process where couples can get divorced for 1/10th the cost and in 1/10th the time of going to court. One intense but satisfying weekend...as opposed to months or years of stress, fear, uncertainty, continuing hostilities and never-ending legal bills. All the hard issues are dealt with and all the correct procedures are followed. </span></p>\r\n<h3 class=\"p4\"><span class=\"s1\">A Neutral Third-Party</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">Our lawyers and mediators are absolutely neutral and will give you the straight facts. You will learn what the laws state, what happened in cases similar to yours, and about numerous possible options to resolve any issues where you are deadlocked. Furthermore, the Workshop will take the myth and mystery out of filing for divorce. Everything will be explained to you in detail. Now is not the time you should be broken by exorbitant legal bills when you are already going through one of the most difficult, emotional and financially stressful times of your life. There is another way!<br></span><span class=\"s1\"><br> These Workshops Really Work!! Grateful clients have been delighted with the results. To participate in the weekend divorce workshops, both parties must attend. And yes, it can all be done in a weekend. The process developed by this group of independent lawyers and mediators can have you ready to jointly file your divorce papers, regardless if you are separated, just commencing your divorce or have been locked in legal battles forever.</span></p>\r\n<ul>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">The process leaves out absolutely nothing </span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">You will be ready to file your divorce after just one weekend </span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">You will have several lawyers and mediators at your disposal</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">All lawyers and mediators are neutral. So they will tell it to you “like it is” </span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">All lawyers and mediators are from different firms, but work together extremely well.</span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">All professionals have total trust and confidence in each other&rsquo;s integrity and professionalism. </span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">You will be working with among the most senior and/or respected lawyers and mediators in Alberta. </span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">We make it as light, amiable and as &rsquo;fun&rsquo; as possible, given the circumstances </span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">You can work in groups, or enjoy the privacy of “breakout rooms” when needed. </span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">If there are children, we will always put them first (just as the courts will). </span></li>\r\n<li class=\"li2\"><span class=\"s2\"></span><span class=\"s1\">The Weekend Workshop Team has very close ties to the very best psychologists, real-estate lawyers, business planners, accountants, mortgage brokers, tax experts, investigators, grief recovery specialists, wills &amp; estate specialists, and social workers. You now have an incredible infrastructure at your disposal – just like that.</span></li>\r\n</ul>\r\n<p class=\"p5\">&nbsp;</p>\r\n<p class=\"p2\"><span class=\"s3\"><strong>Maximum of 10 couples. </strong></span><span class=\"s1\">(If more couples wish to register, other workshops may be arranged.)</span></p>\r\n<p class=\"p2\"><span class=\"s1\">For more information on divorce workshops, our other Alternative Dispute Resolution services, or to contact us, please see the links below:</span></p>',0,8,'Weekend Divorce Workshops','Our divorce workshops help couples file for divorce in a single weekend. No expensive legal bills, no going to court. Move forward with dignity and without fear.','Weekend Divorce Workshops',76.00,'2021-12-08 15:07:30'),(6,'Reconciliation','reconciliation','160823113227.jpg','','Embattled couples or business partners sometimes seek help reconciling. Once the primary dispute is resolved between two parties, there is often a desire to reconcile the rest of their problems and re-establish former relationships.','Reconciliation provides parties in disagreement with an informal discussion forum, individually or in joint sessions, to promote understanding, empathy, and resolution. While reconciliation may or may not reform the root of the issue, it provides a framework for moving forward conflict-free.',5,'<h2 class=\"p1\"><span class=\"s1\">Reconciliations That Last</span></h2>\r\n<p class=\"p2\"><span class=\"s1\">Reconciliation is much more than bringing conflicting parties to the table and making nice. In order to reach an understanding that provides consensus for the mid to long-term, proper steps need to be taken to ensure that the reconciliation is credible, viable, and sustainable. Our mediators are great at sensing and recognizing the real vs. perceived needs of the parties, finding the message behind the message, and guiding the conversation towards an amicable resolution. This is a valuable skill learned over years and decades of conducting mediations, and can often mean the difference between reconciliation and escalation.</span></p>\r\n<blockquote>\r\n<p class=\"p4\"><span class=\"s1\">\"As I walked out the door toward the gate that would&nbsp;lead to my freedom, I knew if I didn&rsquo;t leave my bitterness and hatred behind,&nbsp;I&rsquo;d still be in prison.” – Nelson Mandela<span class=\"Apple-tab-span\"> </span></span></p>\r\n</blockquote>\r\n<h3 class=\"p5\"><span class=\"s1\">Client-Driven Resolution</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">Reconciliation provides the most value, but is also the most under-utilized dispute resolution service we offer, because the process needs to be client-driven. In our experience, for a reconciliation to be truly viable over the long-term, all parties must express a mutual interest in pursuing it as an option, at which point our mediators will pivot and change the focus of the conversation. No matter how bitter a dispute may be, reconciliation should always be on the table.</span></p>\r\n<p class=\"p6\">Areas where reconciliation is especially beneficial:</p>\r\n<ul>\r\n<li class=\"li2\"><span class=\"s3\"></span><span class=\"s1\">Separation</span></li>\r\n<li class=\"li2\"><span class=\"s3\"></span><span class=\"s1\">Divorce</span></li>\r\n<li class=\"li2\"><span class=\"s3\"></span><span class=\"s1\">Custody</span></li>\r\n<li class=\"li2\"><span class=\"s3\"></span><span class=\"s1\">Domestic Disputes</span></li>\r\n<li class=\"li2\"><span class=\"s3\"></span><span class=\"s1\">Wills &amp; Estates</span></li>\r\n</ul>\r\n<p class=\"p2\"><span class=\"s1\">For more information on when reconciliation is recommended, our other Alternative Dispute Resolution services, or to contact us, please see the links below:</span></p>',0,7,'Reconciliation Services','Reconciliation services provide parties in disagreement with an informal discussion forum, in individual or joint sessions, to promote an amicable resolution.','Reconciliation Services',68.00,'2021-12-08 15:07:29'),(7,'Dispute Resolution Panels','dispute-resolution-panels','160823113435.jpg','','This dispute resolution process has been around forever in specific industries and is sort of a cross between mediation and arbitration. We&rsquo;ve adapted this technique to domestic, civil and workplace disputes with great success.','Dispute Resolution Panels usually consist of three people – an arbitrator, a mediator, and a subject matter expert – who sit as a unit and make collective findings. The results can either be binding or for the general information and education of the disputants.',6,'<h2 class=\"p1\"><span class=\"s1\">Balance, Control, and Flexibility</span></h2>\r\n<p class=\"p2\"><span class=\"s1\">Dispute resolution panels offer all the control and flexibility of mediation and arbitration, but with findings rendered by a panel of conflict management experts with varying degrees of subject matter expertise. Conflicting parties agree to the hearing&rsquo;s terms beforehand, including the panel&rsquo;s composition, procedures, confidentiality, and whether or not to be bound by the findings, which ensures that the process is non-adversarial and produces an informed, balanced decision.</span></p>\r\n<h3 class=\"p3\"><span class=\"s1\">Ideally Suited to Corporate Disputes</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">Being able to choose a panel with industry-specific expertise is especially important in corporate disputes. In addition, dispute resolution panels are often preferred in disputes involving international transactions, as all parties may not be familiar with the rules and procedures of a foreign court system, which puts them at a disadvantage. </span></p>\r\n<h3 class=\"p3\"><span class=\"s1\">Always an Option</span></h3>\r\n<p class=\"p2\"><span class=\"s1\">Often, dispute resolution panels aren&rsquo;t necessarily the first method that parties utilize to resolve their dispute. If requested, mediation can be attempted first, and if that doesn&rsquo;t work, the mediator (with insight) can then transition to the panel. This then adds another level of subject matter expertise to a process that already leverages someone with relevant knowledge of the dispute&rsquo;s circumstances (subject matter expert).</span></p>\r\n<h3 class=\"p3\"><span class=\"s1\">Among Alberta&rsquo;s First to offer DRP</span></h3>\r\n<p class=\"p4\"><span class=\"s1\">The Negotiators is one of the first organizations in Alberta to offer dispute resolution panels as an option for our clients. Our mediators and arbitrators have sat on countless panels and bring that experience to every dispute.</span></p>\r\n<p class=\"p4\"><span class=\"s1\">Areas where dispute resolution panels are especially useful include:</span></p>\r\n<ul>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Antitrust</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Breach of Contract</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Commercial Disputes (including International)</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Employment</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Government</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Healthcare</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Insurance</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Intellectual Property</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">International/Bilateral Agreements</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Labor Disputes</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Malpractice</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Real Estate</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Securities</span></li>\r\n<li class=\"li4\"><span class=\"s2\"></span><span class=\"s1\">Trade</span></li>\r\n</ul>\r\n<p class=\"p4\"><span class=\"s1\">For more information on when dispute resolution panels are recommended, our other Alternative Dispute Resolution services, or to contact us, please see the links below:</span></p>',0,6,'Dispute Resolution Panels','Dispute Resolution Panels consist of three people – an arbitrator, a mediator, and a subject matter expert – who sit as a unit and make collective findings.','Dispute Resolution Panels',76.90,'2021-12-08 15:07:28'),(8,'Training','training','160810015459.jpg','','Whether it is family strife, wrongful dismissal, sexual harassment, bullying, condo boards, or any other personal or professional dispute - our first job is to resolve conflict and teach others how to resolve conflict.','',4,'<div id=\"traingin-container\">\r\n<h2>Communication Training</h2>\r\n<div class=\"accordion-training\"><!-- the content -->\r\n<h3><a href=\"#\">Useful Communication Techniques</a></h3>\r\n<div>\r\n<p>Today&rsquo;s business world is uniformly embracing good communication at all levels… because it has to. As the workplace becomes more global and complex, even the most basic communication skills now encompass productivity, workplace environments, planning, reputation and profitability.</p>\r\n<p>This one day course has you learning how you communicate and how you are perceived by others. Participants will work alone and in teams. They will discuss problems, learn how to better request information, better work with others and better understand others&rsquo; communication styles.</p>\r\n<p>The optional second day instills basic planning, presenting and dispute resolution principles into your individual communicating style with more complex break-outs, role plays, problem solving scenarios and cooperative protocols.</p>\r\n<p>Participants will leave the workshop knowing how to better collaborate, to convince others, to understand others&rsquo; perspectives, to control emotions, to strengthen self-control, to accept criticism and to more constructively address tough issues with others. Most importantly, they will be taught how to infuse these new skills into daily routines once they return to work.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n<h3><a href=\"#\">Communicating Through Stress and Change at Work</a></h3>\r\n<div>\r\n<p>Communicating calmly and maintaining composure under stress is an essential skill for employees and a vital skill for leaders. Communicating well under pressure instills trust, where there may not have been any before. It creates confidence, both laterally and upwardly during times of change or crisis.</p>\r\n<p>However such skills do not come naturally for most. They must be learned. Participants in this impactful two day course will be taught new ways of thinking to replace old defensive habits and new communication practices to more effectively reflect positive thinking. Warning, some people may find some aspects of this workshop slightly intense.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n</div>\r\n<div class=\"divider-hr\"><hr></div>\r\n<h2>Work Place Training</h2>\r\n<div class=\"accordion-training\"><!-- the content -->\r\n<h3><a href=\"#\">Dispute Resolution (Level 1)</a></h3>\r\n<div>\r\n<p>Workplace conflicts are far too common and surprisingly destructive to individuals and to overall corporate profitability. $35 billion is lost annually due to workplace strife in Canada and $400 billion is lost in the United States. That is why conflict resolution has become a critical workplace skill for employees and a necessary component for operational planning</p>\r\n<p>Participants in this two day workshop, using learned conflict resolution strategies leadership skills, problem solving abilities and decision making skills will help maintain a more healthy work environment for both employees and management. Further, they will be able to help resolve minor issues before they become major ones.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n<h3><a href=\"#\">Dispute Resolution ( Level II )</a></h3>\r\n<div>\r\n<p>This two day workshop is designed for those who have taken Dispute Resolution I and/or those in <em>senior management</em> who recognize there may be a problem within their respective organizations. Each of your employees loses <a href=\"http://robynshort.com/2016/02/16/the-cost-of-conflict-in-the-workplace/\" target=\"_blank\">2.5 - 3.0 hours of productivity every week to conflict</a>. Those are hours where they could be doing productive, profitable work for your organization. As a manager, you lose about 20 percent of your time to workplace conflict resolution.</p>\r\n<p>Do you have a conflict resolution training program to manage and prevent conflicts as they arise? If you do, is it proven to be effective? Do you understand the basic premises upon which conflict resolution is based? Senior management across the nation is turning to tested and proven conflict resolution training. Those in a leadership position are increasingly required to be skilled in conflict resolution techniques. Participants in this three day workshop will have the skills and training to accomplish everything they hope and need to accomplish. The rest is up to you.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n<h3><a href=\"#\">Come on, Can We Really Deal with Bullies?</a></h3>\r\n<div>\r\n<p>This two or three day workshop introduces participants to the core of workplace bullying and will also provide a general understanding of how to recognize, report, prevent eliminate unwanted aggressive behavior. </p>\r\n<p>Stopping it starts with you, and extends to everyone in your organization—from senior leaders to management to staff. This workshop gives you simple, but effective ways to:</p>\r\n<ul>\r\n<li>Identify bullying.</li>\r\n<li>Put policies into place.</li>\r\n<li>Manage your own behavior.</li>\r\n<li>Call bullying out when you see it.</li>\r\n<li>Stop it when it happens.</li>\r\n<li>Prevent it from occurring again</li>\r\n<li>Empower anti-bullying initiatives.</li>\r\n<li>Educate your entire staff as to their options if they feel victimized.</li>\r\n</ul>\r\n<p>This course will deal with intense and potentially sensitive material and is suitable to both senior management and supervisors.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n<h3><a href=\"#\">Sexual Harassment</a></h3>\r\n<div>\r\n<p>In the wake of the Harvey Weinstein sexual harassment scandal and even the consensual scandals involving Donald Trump, floodgates were opened for sexual harassment claims, which spilled across industries and workplaces in the United States and Canada. Employers are reeling in the wake of the “Me Too!” movement and desperate to re-evaluate their policies and end such potential liabilities in their workplace. Even one case can impact a company for years.</p>\r\n<p>However, indecisiveness remains as to what specifically constitutes sexual harassment. For example, “bullying” is not sexual harassment. So understanding what sexual harassment is, and is not, is critical. Participants in this two day course will have a clear understanding of what constitutes sexual harassment and learn concrete steps their companies can take to prevent sexual issues arising in their workplace. Further, they will learn what corrective measures can be undertaken if sexual harassment has already been an issue. Warning, this course may seem intense and pervasive to some.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n</div>\r\n<div class=\"divider-hr\"><hr></div>\r\n<h2>Leadership Training</h2>\r\n<div class=\"accordion-training\"><!-- the content -->\r\n<h3><a href=\"#\">Effective and “Workable” Leadership Skills</a></h3>\r\n<div>\r\n<p>Leadership…is it something you are born with or is it something that can it be taught? Bosses aren&rsquo;t necessarily leaders. Moreover, some bosses see leadership skills in others as a threat.</p>\r\n<p>Participants in this one day workshop are managers or directors needing reputation management tools to assist with building and protecting their organizations&rsquo; business objectives without endangering their own positions. Further, they will learn that being the best in one job is no guarantee they will succeed in another. Through role plays, team exercises and self-evaluating exercises they will become familiar with best practices in achieving field-force and organizational effectiveness.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n</div>\r\n<div class=\"divider-hr\"><hr></div>\r\n<h2>Advanced Training</h2>\r\n<div class=\"accordion-training\"><!-- the content -->\r\n<h3><a href=\"#\">The Bluebook on Advanced Negotiations</a></h3>\r\n<div>\r\n<p>We are the original authors of the Bluebook on Advanced Negotiations. People taking this five day course are already experienced and successful speakers, negotiators and presenters. For you, the stakes are high and anything short of success isn&rsquo;t an option. Whether you are an independent consultant or a high-ranking subject matter expert for your company, the ratification of the deal and the implementation of the initiative rests on you.</p>\r\n<p>Participants in this course will be exposed to the most grueling training exercises, role plays and scenarios based upon actual corporate initiatives, corruptions scandals and even United Nations emergencies. In short…if you already are considered among the best…this workshop is for you. You&rsquo;ll be even better.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n</div>\r\n<div class=\"divider-hr\"><hr></div>\r\n<h2>Personal Development Training</h2>\r\n<div class=\"accordion-training\"><!-- the content -->\r\n<h3><a href=\"#\">Basic Presentation Skills</a></h3>\r\n<div>\r\n<p>There is simply no way a presentation can fail if you are properly prepared, if you believe in what you are presenting, if facts back up your arguments and if you know exactly what you are trying to achieve. If a presentation bombs, it is because one or more of the above wasn&rsquo;t in place. Many presentation failures are because the presenter didn&rsquo;t have a focus on – or didn&rsquo;t even know – the true objective of his or her presentation.</p>\r\n<p>Participants in this two day course are those who need to strengthen their speaking and organizational presentation skills, as well as knowing who/what are the challenges and how to overcome them. They will learn that one presentation does not “fit all” and will develop skills to identify and isolate specific audiences and vested interests…and how to successfully address each of them. This course emphasizes evaluative and adjustment techniques.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n<h3><a href=\"#\">Write Better Proposals</a></h3>\r\n<div>\r\n<p>Writing is quickly becoming a lost skill due to social media, colloquialisms, poor language training, passive tense, a fear of being quoted, insufficient preparation, verbal diarrhea, ill-defined target reader(s) and lack of a clear objective.</p>\r\n<p>\"Americanization\" of contemporary grammar and unclear parameters also contribute to indecisive messaging and confusion. Participants in this two day writers&rsquo; workshop will be exposed to strenuous writing and editing exercises. Since one writes the way one thinks, considerable time will be spent helping participants prepare before they actually start writing. There will be no starting to write and then “see how it&rsquo;s going”. Participants will be required to bring samples of past writing for personal and group evaluations. While focussing on proposals, this workshop will also be of immense benefits to speech-writers, consultants, public relations practitioners and freelance authors.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n<h3><a href=\"#\">Basic Professional Etiquette</a></h3>\r\n<div>\r\n<p>For those who think that etiquette is a thing of the past or that it lacks relevance in contemporary business… think again. Why is it that some meetings go so well and follow up meetings bomb? Why is it that some banquets are a great success and others pale in comparison? Why do some merger discussions or union negotiations sometimes seem more or less productive?</p>\r\n<p>Participants in this one day workshop will learn that, in a global community, respect is a paramount value; and that respect is shown through actions, not words. Diversity figures prominently, but not solely, into potential transactions and agreements; and as is often states, deals depend more upon the people and personal interaction than on any other contributing factor. Participants will be drilled on classical etiquette (which can carry anyone through almost any situation), as well as cultural and social influences and overseeing corporate events.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n<h3><a href=\"#\">Advanced Media Relations Skills</a></h3>\r\n<div>\r\n<p>Technology, broadening concepts such as “infotainment” and media advocacy have changed the dynamics of engagement. This one day workshop does not explore technological details, but does update public relations and communications practitioners on successful techniques for multi - media interaction, such as:</p>\r\n<ul>\r\n<li>research,</li>\r\n<li>preparation,</li>\r\n<li>the strategic use (or non-use) of senior management</li>\r\n<li>more proficient media interaction,</li>\r\n<li>instantaneous transmissions vs. ”live” broadcasts,</li>\r\n<li>media advocacy,</li>\r\n<li>immediate follow up</li>\r\n<li>avoiding the “Fake News” dance.</li>\r\n</ul>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n<h3><a href=\"#\">Finding and Keeping the Relationships You Want</a></h3>\r\n<div>\r\n<p>This frank, intense, yet exhilarating workshop goes far beyond traditional singles seminars. In addition to learning how, where, and when to meet compatible people, participants will explore themselves and how they are different when not alone.</p>\r\n<p>Most participants are usually divorced, separated, or at least have experienced the rise and eventual fall of close relationships. Therefore trust, finances, children and possible repeating patterns in one&rsquo;s life are given special attention.</p>\r\n<p>This unique and out-of-the-box 2 day workshop will help participants identify and address their expectations, wants, needs, fears, fantasies, age differences and how to better manage intimacy.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n</div>\r\n<div class=\"divider-hr\"><hr></div>\r\n<h2>Training For Lawyers, Arbitrators and Mediators</h2>\r\n<div class=\"accordion-training\"><!-- the content -->\r\n<h3><a href=\"#\">Probate Mediation / Negotiations (Wills and Estates)</a></h3>\r\n<div>\r\n<p>The mediation of cases involving wills and estates is highly specialized and requires considerable subject matter expertise that goes beyond the training of most mediation courses. Probate mediation is often multi-party mediation with heirs, beneficiaries, lawyers and other advocates almost always be present.</p>\r\n<p>This form of mediation highlights the difference between mediators who are lawyers and career mediators. Wills and estate lawyers often challenge probate mediators, fearing they may not have a sufficient or substantive knowledge of a highly complex field. Conversely, lawyer-mediators often fail to identify, address and resolve the real issues behind the matters they are trying to settle.</p>\r\n<p>Therefore this 2 day workshop, complete with advanced role plays, will provide sufficient background knowledge to mediators and cast sufficient light on universal core issues in the mediation of wills and estates for lawyers. This workshop also has an optional 3rd day practicum for experienced wills and estate practitioners.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n<h3><a href=\"#\">Juvenile Mediation / Negotiation</a></h3>\r\n<div>\r\n<p>This 3 day course is divided into what we still refer to Juvenile Delinquency and Juvenile Deprivation. “Delinquency” mediation is similar to victim-offender mediation, whereby a minor has committed a crime and someone else has suffered loss or injury as a result of that crime. Therefore there are strong restorative justice components to this type of mediation.</p>\r\n<p>“Deprivation” refers to where children are not considered to be receiving the necessities of life in their current situations and there needs to be a determination of whether there needs be a change in guardianship or in their residence, as well as whether and to what extent the province / state should be involved.</p>\r\n<p>Both forms of juvenile mediation are intense and emotional, as both will have significant impact on the children&rsquo;s&rsquo; short term futures that could in turn affect the rest of their lives. Participants will learn the skills and techniques for mediating with minors, as well as conducting mediations with any combination of the children, their immediate families, extended families, lawyers, police officers, child welfare or child protection representatives, alleged accusers and alleged victims. Moreover, there is often a crossover in circumstances involving both delinquency and deprivation. Warning. Some may find the role plays stressful.</p>\r\n<p>For more information on this course, please <a href=\"/contact/\">contact us</a>.</p>\r\n</div>\r\n</div>\r\n</div>',0,9,'Conflict Management Training','The Negotiators provides conflict management training to educate individuals and organizations on how to manage and prevent conflict in times of stress and change.','Conflict Management Training',65.40,'2021-12-08 15:06:53'),(10,'\"Safe\" Divorce Mediation','safe-divorce-mediation','160925041736.jpg','','Sadly, some divorces can be extremely high conflict. \"The Negotiators\" has among the most experienced divorce mediators anywhere, especially trained for mediating cases involving abusive relationships and domestic violence. With us safe means \"safe\".','Sadly, some divorces can be extremely high conflict. \"The Negotiators\" has among the most experienced divorce mediators anywhere, especially trained for mediating cases involving abusive relationships and domestic violence. With us safe means \"safe\".',8,'<div id=\"yui_3_16_0_ym19_1_1474302502139_209710\">Whether or not your divorce is particularly high conflict, you are dealing with disappointment, anger, hurt,  betrayal, lack of trust and many fears about the future swirling within you. You may doubt your own ability to make the right decisions and your defense mechanisms are on high alert.</div>\r\n<div id=\"yui_3_16_0_ym19_1_1474302502139_209949\"> </div>\r\n<div id=\"yui_3_16_0_ym19_1_1474302502139_209996\">We create a totally \"safe\" environment for divorce mediation four (4) ways:</div>\r\n<div id=\"yui_3_16_0_ym19_1_1474302502139_209998\"> </div>\r\n<ul>\r\n<li id=\"yui_3_16_0_ym19_1_1474302502139_210000\" dir=\"ltr\">We diffuse many of the errant emotions and hostilities and help give you back your perspective. We do this with patience, compassion, common sense and a time-tested mediation process. \"The Negotiators\" uses the same mediation process used to resolve the Atlanta prison riot, the Iranian hostage crises and the Polish labour dispute.</li>\r\n<li id=\"yui_3_16_0_ym19_1_1474302502139_209805\" dir=\"ltr\">Your mediation is more than personal and confidential. It is also privileged, meaning we tell <strong>absolutely no-one</strong> what transpires in your mediation. You need that level of safety to talk freely.</li>\r\n<li id=\"yui_3_16_0_ym19_1_1474302502139_210343\" dir=\"ltr\">We establish communications protocols and procedures for disputing couples between mediation sessions so as not to undo the good that you have achieved so far. We even have a toll-free 24/7 emergency number if things seem to be breaking down.</li>\r\n<li id=\"yui_3_16_0_ym19_1_1474302502139_210440\" dir=\"ltr\">We are well trained and experienced in cases involving intimidation, abuse and violence. We can also mediate in spite of restraining orders, no-contact notices and peace bonds. </li>\r\n</ul>\r\n<div id=\"yui_3_16_0_ym19_1_1474302502139_210580\" dir=\"ltr\">There is a lot more to mediation than you might have imagined. When the going gets tough, the tough start mediating.</div>\r\n<div id=\"yui_3_16_0_ym19_1_1474302502139_213008\" dir=\"ltr\"> </div>',0,3,'','','',57.70,'2021-12-08 15:07:25');

--
-- Table structure for table `services_promo`
--

CREATE TABLE `services_promo` (
  `service_id` int(11) unsigned NOT NULL,
  `promo_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`service_id`,`promo_id`),
  KEY `promo_id` (`promo_id`),
  CONSTRAINT `services_promo_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `services` (`service_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `services_promo_ibfk_2` FOREIGN KEY (`promo_id`) REFERENCES `promo_boxes` (`promo_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services_promo`
--

INSERT INTO `services_promo` VALUES (2,1),(3,1),(4,1),(5,1),(7,1),(3,2),(4,2),(6,2),(8,2),(2,3),(3,3),(4,3),(5,3),(6,3),(7,3),(8,3),(2,4),(5,4),(6,4),(7,4),(8,4);

--
-- Table structure for table `slideshow`
--

CREATE TABLE `slideshow` (
  `slide_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `content` varchar(225) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `image_alt` tinytext,
  `url` text,
  `url_target` int(1) NOT NULL DEFAULT '0',
  `ordering` int(1) NOT NULL DEFAULT '101',
  `showhide` int(1) NOT NULL DEFAULT '0',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`slide_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `slideshow`
--


--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `staff_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `page` varchar(100) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `image_alt` varchar(200) DEFAULT NULL,
  `content` text,
  `showhide` int(1) NOT NULL DEFAULT '0',
  `ordering` int(1) NOT NULL DEFAULT '101',
  `meta_title` varchar(100) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `focus_keyword` varchar(255) DEFAULT NULL,
  `seo_score` decimal(10,2) NOT NULL DEFAULT '0.00',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`staff_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` VALUES (1,'Pete','Desrochers','pete-desrochers','Managing Director','Pete-2020-optimized.jpg','','<p class=\"p1\"><span class=\"s1\"><strong>Founding Director – Canada &amp; US</strong></span></p>\r\n<p class=\"p2\"><span class=\"s1\">Pete is one of Canada&rsquo;s Chartered Mediators and a Qualified Arbitrator, as well as being a Registered Mediator in the United States. He has completed over 3,300 mediations covering 13 countries and four continents. His portfolio of high-profile mediations includes working with the U.S. soldiers in Iraq, Afghanistan and Germany; a firefighters&rsquo; labor dispute; a wrongful death suit; several trade agreements between Asian countries; the kidnapping of a child to Japan during a custody battle and the murder of a celebrity.&nbsp;</span></p>\r\n<p class=\"p2\"><span class=\"s1\">His mediation firm, \"The Negotiators\", has offices in Edmonton, Calgary, Ft. McMurray, Saskatoon, Las Vegas, Chicago, Miami and Atlanta, where several years ago it was named one of Atlanta&rsquo;s top 10 Small Businesses of the Year.</span></p>\r\n<p class=\"p2\"><span class=\"s1\">Family mediations focus primarily on divorce /separation or wills and estates (Probate Mediation). He believes both are among the most emotional and volatile of all disputes.<br></span><span class=\"s1\"><br> Many of his corporate mediations focus on bullying, wrongful dismissal, sexual harassment, contracts and allegations of failure to deliver a product or service at an agreed price or within an agreed time frame. </span></p>\r\n<p class=\"p2\"><span class=\"s1\">He is also pioneering “Dispute Resolution Panels” of lawyers, mediators and arbitrators who can make awards or render findings in any corporate or personal conflict at a fraction of the cost of conventional options. </span></p>\r\n<p class=\"p2\"><span class=\"s1\">Pete teaches mediation and conflict management to organizations throughout Western Canada and North Western United States. He is the Executive Director of the Alberta Arbitration and Mediation Society, a federally registered charity with the mandate to educate people on various forms of Alternative Dispute Resolution and make these services more available to the general public.</span></p>\r\n<p class=\"p2\"><span class=\"s1\">Pete&rsquo;s record of success is formidable, his reputation is well-known, his compassion is obvious to those who meet him, and his dedication to fairness and professionalism is absolute.&nbsp;</span></p>',0,1,'','','',61.50,'2020-10-06 13:52:40'),(2,'Alasdair','MacKinnon','alasdair-mackinnon','','161104033150.jpg','','<p class=\"p1\"><span class=\"s1\"><strong>Red Deer, Edmonton, and Calgary, AB</strong></span></p>\r\n<p class=\"p2\"><span class=\"s1\">Alasdair MacKinnon has over 30 years experience in the conflict resolution field. Alasdair served in the Royal Canadian Mounted Police for over 20 years and was trained in negotiations. He then worked for 10 years with the Natural Resources Conservation Board often mediating land use issues in the agricultural sector in Alberta.<br> <br> Alasdair has a Certificate in Conflict Management in Mediation and Negotiation and a Certificate in Arbitration through the Alberta Mediation and Arbitration Society. Alasdair has a B.A. from Mount Allison University and a Certificate in Environmental Management from the University of Calgary. Alasdair is nationally recognized as a Chartered Mediator and a Registered Family Mediator and is Past President of the Alberta Family Mediation Society.</span></p>',0,101,'','','',57.70,'2016-11-04 21:31:50'),(3,'Jim','Reiman','jim-reiman','',NULL,'','<p class=\"p1\"><span class=\"s1\"><strong>Chicago, IL; Canada &amp; US</strong></span></p>\r\n<p class=\"p2\"><span class=\"s1\">Jim Reiman serves as an arbitrator and mediator in both North American and international disputes.</span><span class=\"s2\"> </span><span class=\"s1\">He also serves as a board director of public and private domestic and international businesses.&nbsp; Mr. Reiman is a Fellow of the Chartered Institute of Arbitrators and a Board Leadership Fellow of the National Association of Corporate Directors.&nbsp; He practiced law in US law firms for 18 years and has served as a business executive and board director for 15+ years.&nbsp; &nbsp; As an attorney, Mr. Reiman handled directly or led teams of attorneys negotiating and documenting complex business transactions, complex financings, and real estate development and construction projects.&nbsp; He also led, as \"billing partner,” teams of attorneys resolving patent and intellectual property disputes and transfers (both domestic and international), private equity transactions, strategic partnerships, corporate restructurings, and mergers/acquisitions, as well as exit strategies, generational transfers, and partnership dissolutions of smaller businesses.&nbsp;</span></p>',0,101,'','','',61.50,'2016-08-10 21:13:36'),(4,'Elmer','Goble','elmer-goble','','161104034915.jpg','','<p class=\"p1\"><span class=\"s1\"></span><span class=\"s1\">Elmer Goble has been mediating general/civil, EEO, special education, church, community, youth and deprivation cases since 1995. More recently he added divorce and family mediations to address the growing need. Elmer continues to teach mediation, conflict resolution, and facilitation to thousands of people in hundreds of classes throughout the US and in foreign countries through the Justice Center of Atlanta. He has been a distinguished instructor there for over 10 years and conducted mediation training for all branches of the military, the US State Department, UDSA organizations, state departments of education, Veterans Affairs, the US Mint and the NSA. Elmer is a trained facilitator, with expertise in coaching executives in business development, team development and strategic planning.</span></p>',0,101,'','','',61.50,'2016-11-04 21:49:15'),(5,'Melissa','Heard','melissa-heard','','161104035015.jpg','','<p class=\"p1\"><span class=\"s1\"></span><span class=\"s1\">Melissa is a master conflict resolution specialist, mediating since 1992 and actually training mediators since 1998. She is skilled at insurance cases, probate, divorce, custody, adoption, education, employment disputes, family, deprivation and juvenile issues. Melissa received her Masters of Science in Social Work Treatment from the University of Tennessee and worked in residential treatment facilities, for schools and crisis services and in counseling. </span></p>\r\n<p class=\"p3\"><span class=\"s1\">Melissa is an advanced practitioner member of the Association for Conflict Resolution, and the Association of Family and Conciliation Courts. She mediates in several states, and is expert in other forms of alternative dispute resolution. Melissa helps people through many mediums, including: radio, television, direct service and training. Oh, she was also a sports anchor for CBS News in Atlanta.</span></p>',0,101,'','','',61.50,'2016-11-04 21:50:15'),(6,'Max','Arrechea','max-arrechea','','161104035046.jpg','','<p class=\"p1\"><strong>Atlanta, GA</strong></p>\r\n<p class=\"p3\"><span class=\"s1\">Interested in providing help to the Hispanic community through mediation services, Max became a civil and family/domestic mediator while earning a master&rsquo;s degree in conflict resolution and reconciliation. He is a registered mediator with the Georgia Office of Dispute Resolution and is a member of the Association for Conflict Resolution.</span></p>\r\n<p class=\"p3\"><span class=\"s1\">Max has traveled to different cities in Mexico, as well as most countries in South America to become, not only linguistically, but also culturally fluent in the Hispanic culture. A native of Mexico, he worked for the Institute of Mexico in Atlanta and participated in the San Joaquin County Office of Education, Migrant Education in California.</span></p>',0,101,'','','',57.70,'2016-11-04 21:50:46'),(7,'Donald','Sykes','donald-sykes','','161104035437.jpg','','<p class=\"p1\"><span class=\"s1\"></span><span class=\"s1\"><strong>Atlanta, GA</strong></span></p>\r\n<p class=\"p3\"><span class=\"s1\">With a background in HR working in extremely large organizations Donald has expertise in employee-employer mediation and union negotiation.&nbsp; His specific experience relates to working with engineering teams, manufacturing groups, and computer scientists making him a natural for many of today&rsquo;s employment and commercial disputes.<br> <br> Registered as both a mediator and arbitrator, Donald also provides mentoring and career coaching services.</span></p>',0,101,'','','',53.80,'2016-11-04 21:54:37'),(8,'Maria','Ceballos-Wallis','maria-ceballos-wallis','','161104035143.jpg','','<p class=\"p1\"><span class=\"s1\"></span><span class=\"s1\"><strong>Atlanta, GA and Florida</strong></span></p>\r\n<p class=\"p3\"><span class=\"s1\">Maria Ceballos-Wallis has been practicing multilingual communications since 1990. She speaks fluent English and Spanish. <br> <br> As a Mediator, Maria provides custom services to her clients including bilingual mediations and translation services.&nbsp; She has trained in civil, divorce, domestic violence, special education and juvenile delinquency and deprivation mediation at the Justice Center of Atlanta and Atlanta Divorce Mediators. <br> <br> She is a Certified Court Interpreter (FL/GA) and translator, interpreting at all levels of court, among other venues, and provides bilingual (Spanish/English) mediation services for The Justice Center of Atlanta, private clients and individual county court systems in Atlanta. <br> <br> She has received diversity training through “Bridging the Gap” and mental health training through the Georgia Department of Health and Developmental Disabilities. She is on the board of Directors of the Atlanta Association of interpreters and Translators and a member in good standing of the Georgia Office of Dispute Resolution. </span></p>',0,101,'','','',65.40,'2016-11-04 21:51:43'),(9,'Kelly','Charles-Collins','kelly-charles-collins','','161104035304.jpg','','<p class=\"p1\"><strong>Miami, FL</strong></p>\r\n<p class=\"p3\"><span class=\"s1\">Kelly Charles-Collins is the founder of Charles-Collins Law, PA, boutique employment litigation and human resources consulting firm.&nbsp; Attorney Charles-Collins has extensive experience representing management in diverse industries, including those of Fortune 500 companies, in labor and employment matters.&nbsp; Her practice focuses on employment litigation, supervisory training, and counseling employers on day-to-day human resources issues including compliance with laws such as Title VII of the Civil Rights Act of 1964, the American with Disabilities Act, the Family and Medical Leave Act, The age Discrimination in Employment Act, and the Fair Labor Standards Act.&nbsp; Attorney Charles-Collins also represents individual employees who believe they have been discriminated against by their employer.&nbsp; </span></p>\r\n<p class=\"p3\"><span class=\"s1\">Additionally, Attorney Charles-Collins is an Arbitrator on the Employment, Commercial and Consumer Arbitration Panels of the American Arbitration Association and a Faculty member at the University of Phoenix and in the next few months will complete the certification process to become a Florida Supreme Court Certified Circuit Civil Mediator.&nbsp; She has been a member of the Florida Bar since 1995 and the Georgia Bar since 2003.&nbsp; Attorney Charles-Collins earned her Juris Doctorate from Golden Gate University in San Francisco, California and her M.B.A. from Johnson &amp; Wales University in Providence, Rhode Island.&nbsp; She enjoys shopping, traveling and spending time with her family and friends.&nbsp; Attorney Charles-Collins is an avid community volunteer and is also very passionate about inspiring others, particularly young people, and enjoys volunteering as a Miami-Dade County Teen Court Judge and as a Board Member on the Miami-Dade Economic Advisory Trust&rsquo;s Youth Action Committee.&nbsp; Attorney Charles-Collins is married and has one child, a son.</span></p>',0,101,'','','',61.50,'2016-11-04 21:54:05'),(10,'Robin','Gordon','robin-gordon','','161104032937.png','','<p class=\"p1\"><strong>Las Vegas, NV</strong></p>\r\n<p class=\"p3\"><span class=\"s1\">Robin is a Civil, Domestic and Juvenile Mediator in private practice, affiliated with alternative dispute resolution programs in county courts throughout Georgia. Although a master at both civil and domestic mediations, her real talents are in divorce and juvenile mediations. A certified trainer in mediation, Robin conducts civil and domestic mediation training through the Mediation Training Institute of Atlanta and Atlanta Divorce Mediation. An elementary school teacher, a former social worker and an accomplished author, Robin has presented papers across the country including: Mediation: Within &amp; Between Social Service Agencies, Fatal Attraction: Mediating Cases with Personality Disordered Clients, Orientation for Special Education Mediation, Designing Dispute Resolution Systems in the Workplace and Evaluative Mediation, among others.</span></p>',0,101,'','','',53.80,'2016-11-04 21:31:00'),(11,'Jill','Swan-Lussier','jill-swan-lussier','','161104032639.JPG','','<div id=\"x_yui_3_16_0_ym19_1_1474916497417_114972\">\r\n<div id=\"x_yui_3_16_0_ym19_1_1474916497417_114977\">Jill, having spent most of her working life as an RN in various disciplines, is the newest member of The Negotiators. She was&nbsp;also a&nbsp;Nurse Educator for the University of Alberta&nbsp;School of Nursing&nbsp;for nine (9) years. As far back as the 1970&rsquo;s Jill was a union rep in British Columbia and was introduced to high-level mediation and negotiation.&nbsp; <span><br></span></div>\r\n<div id=\"x_yui_3_16_0_ym19_1_1474916497417_114979\"><span>&nbsp;</span></div>\r\n</div>\r\n<div id=\"x_yui_3_16_0_ym19_1_1474916497417_114974\">\r\n<div id=\"x_yui_3_16_0_ym19_1_1474916497417_114981\">Jill retired in 2010 and soon after took up dispute resolution as her next career. She was an intern for the ADR Institute of Alberta (ADRIA), completing her Conflict Management Certificate and then her mediation training in 2012. She&nbsp;was also a Board Member for the St. Albert Further Education Association and presently the Edmonton Lifelong Learners Association, associated with the University of Alberta Extension.. Jill believes that the relationship between health care providers, patients and families is the cornerstone of healthcare. She believes that better communication in the healthcare system is paramount.</div>\r\n<div id=\"x_yui_3_16_0_ym19_1_1474916497417_114983\">&nbsp;</div>\r\n</div>\r\n<div id=\"x_yui_3_16_0_ym19_1_1474916497417_114975\">\r\n<div id=\"x_yui_3_16_0_ym19_1_1474916497417_114976\">Jill is a natural mediator. She brings to the team a great deal of wisdom and life experience in stressful and life-altering situations. Her stability and compassion are a rock for emotional people during difficult times – whatever the scenario. However her expertise in the public service, as an instructor and in union negotiations serve her well with The Negotiators.</div>\r\n</div>',0,101,'','','',61.50,'2016-11-04 21:27:43');

--
-- Table structure for table `staff_locations`
--

CREATE TABLE `staff_locations` (
  `staff_id` int(11) unsigned NOT NULL,
  `location` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`staff_id`,`location`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `staff_locations`
--

INSERT INTO `staff_locations` VALUES (1,'CA'),(1,'US'),(7,'US'),(9,'US'),(10,'US'),(11,'CA');

--
-- Table structure for table `staff_services`
--

CREATE TABLE `staff_services` (
  `staff_id` int(11) unsigned NOT NULL,
  `service_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`staff_id`,`service_id`),
  KEY `service_id` (`service_id`),
  CONSTRAINT `staff_services_ibfk_1` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `staff_services_ibfk_2` FOREIGN KEY (`service_id`) REFERENCES `services` (`service_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `staff_services`
--

INSERT INTO `staff_services` VALUES (1,1),(1,2),(1,3);

--
-- Table structure for table `word_filters`
--

CREATE TABLE `word_filters` (
  `filter_id` int(11) NOT NULL AUTO_INCREMENT,
  `word` varchar(255) NOT NULL,
  `type` enum('Profanity','System Reserved','Invalid') NOT NULL DEFAULT 'Profanity',
  PRIMARY KEY (`filter_id`),
  FULLTEXT KEY `word` (`word`)
) ENGINE=MyISAM AUTO_INCREMENT=465 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `word_filters`
--

INSERT INTO `word_filters` VALUES (1,'ahole ','Profanity'),(2,'anus ','Profanity'),(3,'ash0le ','Profanity'),(4,'ash0les ','Profanity'),(5,'asholes ','Profanity'),(6,'ass ','Profanity'),(7,'Ass Monkey ','Profanity'),(8,'Assface ','Profanity'),(9,'assh0le ','Profanity'),(10,'assh0lez ','Profanity'),(11,'asshole ','Profanity'),(12,'assholes ','Profanity'),(13,'assholz ','Profanity'),(14,'asswipe ','Profanity'),(15,'azzhole ','Profanity'),(16,'bassterds ','Profanity'),(17,'bastard ','Profanity'),(18,'bastards ','Profanity'),(19,'bastardz ','Profanity'),(20,'basterds ','Profanity'),(21,'basterdz ','Profanity'),(22,'Biatch ','Profanity'),(23,'bitch ','Profanity'),(24,'bitches ','Profanity'),(25,'Blow Job ','Profanity'),(26,'boffing ','Profanity'),(27,'butthole ','Profanity'),(28,'buttwipe ','Profanity'),(29,'c0ck ','Profanity'),(30,'c0cks ','Profanity'),(31,'c0k ','Profanity'),(32,'Carpet Muncher ','Profanity'),(33,'cawk ','Profanity'),(34,'cawks ','Profanity'),(35,'Clit ','Profanity'),(36,'cnts ','Profanity'),(37,'cntz ','Profanity'),(38,'cock ','Profanity'),(39,'cockhead ','Profanity'),(40,'cock-head ','Profanity'),(41,'cocks ','Profanity'),(42,'CockSucker ','Profanity'),(43,'cock-sucker ','Profanity'),(44,'crap ','Profanity'),(45,'cum ','Profanity'),(46,'cunt ','Profanity'),(47,'cunts ','Profanity'),(48,'cuntz ','Profanity'),(49,'dick ','Profanity'),(50,'dild0 ','Profanity'),(51,'dild0s ','Profanity'),(52,'dildo ','Profanity'),(53,'dildos ','Profanity'),(54,'dilld0 ','Profanity'),(55,'dilld0s ','Profanity'),(56,'dominatricks ','Profanity'),(57,'dominatrics ','Profanity'),(58,'dominatrix ','Profanity'),(59,'dyke ','Profanity'),(60,'enema ','Profanity'),(61,'f u c k ','Profanity'),(62,'f u c k e r ','Profanity'),(63,'fag ','Profanity'),(64,'fag1t ','Profanity'),(65,'faget ','Profanity'),(66,'fagg1t ','Profanity'),(67,'faggit ','Profanity'),(68,'faggot ','Profanity'),(69,'fagit ','Profanity'),(70,'fags ','Profanity'),(71,'fagz ','Profanity'),(72,'faig ','Profanity'),(73,'faigs ','Profanity'),(74,'fart ','Profanity'),(75,'flipping the bird ','Profanity'),(76,'fuck ','Profanity'),(77,'fucker ','Profanity'),(78,'fuckin ','Profanity'),(79,'fucking ','Profanity'),(80,'fucks ','Profanity'),(81,'Fudge Packer ','Profanity'),(82,'fuk ','Profanity'),(83,'Fukah ','Profanity'),(84,'Fuken ','Profanity'),(85,'fuker ','Profanity'),(86,'Fukin ','Profanity'),(87,'Fukk ','Profanity'),(88,'Fukkah ','Profanity'),(89,'Fukken ','Profanity'),(90,'Fukker ','Profanity'),(91,'Fukkin ','Profanity'),(92,'g00k ','Profanity'),(93,'gay ','Profanity'),(94,'gayboy ','Profanity'),(95,'gaygirl ','Profanity'),(96,'gays ','Profanity'),(97,'gayz ','Profanity'),(98,'God-damned ','Profanity'),(99,'h00r ','Profanity'),(100,'h0ar ','Profanity'),(101,'h0re ','Profanity'),(102,'hells ','Profanity'),(103,'hoar ','Profanity'),(104,'hoor ','Profanity'),(105,'hoore ','Profanity'),(106,'jackoff ','Profanity'),(107,'jap ','Profanity'),(108,'japs ','Profanity'),(109,'jerk-off ','Profanity'),(110,'jisim ','Profanity'),(111,'jiss ','Profanity'),(112,'jizm ','Profanity'),(113,'jizz ','Profanity'),(114,'knob ','Profanity'),(115,'knobs ','Profanity'),(116,'knobz ','Profanity'),(117,'kunt ','Profanity'),(118,'kunts ','Profanity'),(119,'kuntz ','Profanity'),(120,'Lesbian ','Profanity'),(121,'Lezzian ','Profanity'),(124,'masochist ','Profanity'),(125,'masokist ','Profanity'),(126,'massterbait ','Profanity'),(127,'masstrbait ','Profanity'),(128,'masstrbate ','Profanity'),(129,'masterbaiter ','Profanity'),(130,'masterbate ','Profanity'),(131,'masterbates ','Profanity'),(132,'Motha Fucker ','Profanity'),(133,'Motha Fuker ','Profanity'),(134,'Motha Fukkah ','Profanity'),(135,'Motha Fukker ','Profanity'),(136,'Mother Fucker ','Profanity'),(137,'Mother Fukah ','Profanity'),(138,'Mother Fuker ','Profanity'),(139,'Mother Fukkah ','Profanity'),(140,'Mother Fukker ','Profanity'),(141,'mother-fucker ','Profanity'),(142,'Mutha Fucker ','Profanity'),(143,'Mutha Fukah ','Profanity'),(144,'Mutha Fuker ','Profanity'),(145,'Mutha Fukkah ','Profanity'),(146,'Mutha Fukker ','Profanity'),(147,'n1gr ','Profanity'),(148,'nastt ','Profanity'),(149,'nigger; ','Profanity'),(150,'nigur; ','Profanity'),(151,'niiger; ','Profanity'),(152,'niigr; ','Profanity'),(153,'orafis ','Profanity'),(154,'orgasim; ','Profanity'),(155,'orgasm ','Profanity'),(156,'orgasum ','Profanity'),(157,'oriface ','Profanity'),(158,'orifice ','Profanity'),(159,'orifiss ','Profanity'),(160,'packi ','Profanity'),(161,'packie ','Profanity'),(162,'packy ','Profanity'),(163,'paki ','Profanity'),(164,'pakie ','Profanity'),(165,'paky ','Profanity'),(166,'pecker ','Profanity'),(167,'peeenus ','Profanity'),(168,'peeenusss ','Profanity'),(169,'peenus ','Profanity'),(170,'peinus ','Profanity'),(171,'pen1s ','Profanity'),(172,'penas ','Profanity'),(173,'penis ','Profanity'),(174,'penis-breath ','Profanity'),(175,'penus ','Profanity'),(176,'penuus ','Profanity'),(177,'Phuc ','Profanity'),(178,'Phuck ','Profanity'),(179,'Phuk ','Profanity'),(180,'Phuker ','Profanity'),(181,'Phukker ','Profanity'),(182,'polac ','Profanity'),(183,'polack ','Profanity'),(184,'polak ','Profanity'),(185,'Poonani ','Profanity'),(186,'pr1c ','Profanity'),(187,'pr1ck ','Profanity'),(188,'pr1k ','Profanity'),(189,'pusse ','Profanity'),(190,'pussee ','Profanity'),(191,'pussy ','Profanity'),(192,'puuke ','Profanity'),(193,'puuker ','Profanity'),(194,'queer ','Profanity'),(195,'queers ','Profanity'),(196,'queerz ','Profanity'),(197,'qweers ','Profanity'),(198,'qweerz ','Profanity'),(199,'qweir ','Profanity'),(200,'recktum ','Profanity'),(201,'rectum ','Profanity'),(202,'retard ','Profanity'),(203,'sadist ','Profanity'),(204,'scank ','Profanity'),(205,'schlong ','Profanity'),(206,'screwing ','Profanity'),(207,'semen ','Profanity'),(208,'sex ','Profanity'),(209,'sexy ','Profanity'),(210,'Sh!t ','Profanity'),(211,'sh1t ','Profanity'),(212,'sh1ter ','Profanity'),(213,'sh1ts ','Profanity'),(214,'sh1tter ','Profanity'),(215,'sh1tz ','Profanity'),(216,'shit ','Profanity'),(217,'shits ','Profanity'),(218,'shitter ','Profanity'),(219,'Shitty ','Profanity'),(220,'Shity ','Profanity'),(221,'shitz ','Profanity'),(222,'Shyt ','Profanity'),(223,'Shyte ','Profanity'),(224,'Shytty ','Profanity'),(225,'Shyty ','Profanity'),(226,'skanck ','Profanity'),(227,'skank ','Profanity'),(228,'skankee ','Profanity'),(229,'skankey ','Profanity'),(230,'skanks ','Profanity'),(231,'Skanky ','Profanity'),(232,'slut ','Profanity'),(233,'sluts ','Profanity'),(234,'Slutty ','Profanity'),(235,'slutz ','Profanity'),(236,'son-of-a-bitch ','Profanity'),(237,'tit ','Profanity'),(238,'turd ','Profanity'),(239,'va1jina ','Profanity'),(240,'vag1na ','Profanity'),(241,'vagiina ','Profanity'),(242,'vagina ','Profanity'),(243,'vaj1na ','Profanity'),(244,'vajina ','Profanity'),(245,'vullva ','Profanity'),(246,'vulva ','Profanity'),(247,'w0p ','Profanity'),(248,'wh00r ','Profanity'),(249,'wh0re ','Profanity'),(250,'whore ','Profanity'),(251,'xrated ','Profanity'),(252,'xxx','Profanity'),(253,'b!+ch','Profanity'),(254,'bitch','Profanity'),(255,'blowjob','Profanity'),(256,'clit','Profanity'),(257,'arschloch','Profanity'),(258,'fuck','Profanity'),(259,'shit','Profanity'),(260,'ass','Profanity'),(261,'asshole','Profanity'),(262,'b!tch','Profanity'),(263,'b17ch','Profanity'),(264,'b1tch','Profanity'),(265,'bastard','Profanity'),(266,'bi+ch','Profanity'),(267,'boiolas','Profanity'),(268,'buceta','Profanity'),(269,'c0ck','Profanity'),(270,'cawk','Profanity'),(271,'chink','Profanity'),(272,'cipa','Profanity'),(273,'clits','Profanity'),(274,'cock','Profanity'),(275,'cum','Profanity'),(276,'cunt','Profanity'),(277,'dildo','Profanity'),(278,'dirsa','Profanity'),(279,'ejakulate','Profanity'),(280,'fatass','Profanity'),(281,'fcuk','Profanity'),(282,'fuk','Profanity'),(283,'fux0r','Profanity'),(284,'hoer','Profanity'),(285,'hore','Profanity'),(286,'jism','Profanity'),(287,'kawk','Profanity'),(288,'l3itch','Profanity'),(289,'l3i+ch','Profanity'),(290,'lesbian','Profanity'),(291,'masturbate','Profanity'),(292,'masterbat*','Profanity'),(293,'masterbat3','Profanity'),(294,'motherfucker','Profanity'),(295,'s.o.b.','Profanity'),(296,'mofo','Profanity'),(297,'nazi','Profanity'),(298,'nigga','Profanity'),(299,'nigger','Profanity'),(300,'nutsack','Profanity'),(301,'phuck','Profanity'),(302,'pimpis','Profanity'),(303,'pusse','Profanity'),(304,'pussy','Profanity'),(305,'scrotum','Profanity'),(306,'sh!t','Profanity'),(307,'shemale','Profanity'),(308,'shi+','Profanity'),(309,'sh!+','Profanity'),(310,'slut','Profanity'),(311,'smut','Profanity'),(312,'teets','Profanity'),(313,'tits','Profanity'),(314,'boobs','Profanity'),(315,'b00bs','Profanity'),(316,'teez','Profanity'),(317,'testical','Profanity'),(318,'testicle','Profanity'),(319,'titt','Profanity'),(320,'w00se','Profanity'),(321,'jackoff','Profanity'),(322,'wank','Profanity'),(323,'whoar','Profanity'),(324,'whore','Profanity'),(325,'*damn','Profanity'),(326,'*dyke','Profanity'),(327,'*fuck*','Profanity'),(328,'*shit*','Profanity'),(329,'@$$','Profanity'),(330,'amcik','Profanity'),(331,'andskota','Profanity'),(332,'arse*','Profanity'),(333,'assrammer','Profanity'),(334,'ayir','Profanity'),(335,'bi7ch','Profanity'),(336,'bitch*','Profanity'),(337,'bollock*','Profanity'),(338,'breasts','Profanity'),(339,'butt-pirate','Profanity'),(340,'cabron','Profanity'),(341,'cazzo','Profanity'),(342,'chraa','Profanity'),(343,'chuj','Profanity'),(344,'Cock*','Profanity'),(345,'cunt*','Profanity'),(346,'d4mn','Profanity'),(347,'daygo','Profanity'),(348,'dego','Profanity'),(349,'dick*','Profanity'),(350,'dike*','Profanity'),(351,'dupa','Profanity'),(352,'dziwka','Profanity'),(353,'ejackulate','Profanity'),(354,'Ekrem*','Profanity'),(355,'Ekto','Profanity'),(356,'enculer','Profanity'),(357,'faen','Profanity'),(358,'fag*','Profanity'),(359,'fanculo','Profanity'),(360,'fanny','Profanity'),(361,'feces','Profanity'),(362,'feg','Profanity'),(363,'Felcher','Profanity'),(364,'ficken','Profanity'),(365,'fitt*','Profanity'),(366,'Flikker','Profanity'),(367,'foreskin','Profanity'),(368,'Fotze','Profanity'),(369,'Fu(*','Profanity'),(370,'fuk*','Profanity'),(371,'futkretzn','Profanity'),(372,'gay','Profanity'),(373,'gook','Profanity'),(374,'guiena','Profanity'),(375,'h0r','Profanity'),(376,'h4x0r','Profanity'),(377,'hell','Profanity'),(378,'helvete','Profanity'),(379,'hoer*','Profanity'),(380,'honkey','Profanity'),(381,'Huevon','Profanity'),(382,'hui','Profanity'),(383,'injun','Profanity'),(384,'jizz','Profanity'),(385,'kanker*','Profanity'),(386,'kike','Profanity'),(387,'klootzak','Profanity'),(388,'kraut','Profanity'),(389,'knulle','Profanity'),(390,'kuk','Profanity'),(391,'kuksuger','Profanity'),(392,'Kurac','Profanity'),(393,'kurwa','Profanity'),(394,'kusi*','Profanity'),(395,'kyrpa*','Profanity'),(396,'lesbo','Profanity'),(397,'mamhoon','Profanity'),(398,'masturbat*','Profanity'),(399,'merd*','Profanity'),(400,'mibun','Profanity'),(401,'monkleigh','Profanity'),(402,'mouliewop','Profanity'),(403,'muie','Profanity'),(404,'mulkku','Profanity'),(405,'muschi','Profanity'),(406,'nazis','Profanity'),(407,'nepesaurio','Profanity'),(408,'nigger*','Profanity'),(409,'orospu','Profanity'),(410,'paska*','Profanity'),(411,'perse','Profanity'),(412,'picka','Profanity'),(413,'pierdol*','Profanity'),(414,'pillu*','Profanity'),(415,'pimmel','Profanity'),(416,'piss*','Profanity'),(417,'pizda','Profanity'),(418,'poontsee','Profanity'),(419,'poop','Profanity'),(420,'porn','Profanity'),(421,'p0rn','Profanity'),(422,'pr0n','Profanity'),(423,'preteen','Profanity'),(424,'pula','Profanity'),(425,'pule','Profanity'),(426,'puta','Profanity'),(427,'puto','Profanity'),(428,'qahbeh','Profanity'),(429,'queef*','Profanity'),(430,'rautenberg','Profanity'),(431,'schaffer','Profanity'),(432,'scheiss*','Profanity'),(433,'schlampe','Profanity'),(434,'schmuck','Profanity'),(435,'screw','Profanity'),(436,'sh!t*','Profanity'),(437,'sharmuta','Profanity'),(438,'sharmute','Profanity'),(439,'shipal','Profanity'),(440,'shiz','Profanity'),(441,'skribz','Profanity'),(442,'skurwysyn','Profanity'),(443,'sphencter','Profanity'),(444,'spic','Profanity'),(445,'spierdalaj','Profanity'),(446,'splooge','Profanity'),(447,'suka','Profanity'),(448,'b00b*','Profanity'),(449,'testicle*','Profanity'),(450,'titt*','Profanity'),(451,'twat','Profanity'),(452,'vittu','Profanity'),(453,'wank*','Profanity'),(454,'wetback*','Profanity'),(455,'wichser','Profanity'),(456,'wop*','Profanity'),(457,'yed','Profanity'),(458,'zabourah','Profanity'),(459,'admin','System Reserved'),(460,'administrator','System Reserved'),(461,'user','System Reserved'),(462,'company','Invalid'),(463,'test','Invalid'),(464,'testing','Invalid');


