<!--cID: 0 -->
<!-- SELECT     Campaigns.CampaignID, 
							Campaigns.ADVISORID, 
							Campaigns.SeminarID, 
							Campaigns.lineID, 
							Campaigns.pieceID, 
							Campaigns.Extension,
							Campaigns.StartDate, 
							Campaigns.trackID, 
							Tracks.title as TRACKS_TITLE, Tracks.GMNAME as TRACKS_GMNAME, (SELECT     MIN(price) AS trackprice
	                            FROM          (SELECT     price
	                                                    FROM          Tracks
	                                                    WHERE      TrackID = Campaigns.TrackID
	                                                    UNION
	                                                    SELECT     price
	                                                    FROM         AdvisorTracks
	                                                    WHERE     AdvisorTracks.Active = 1 and AdvisorTracks.trackID = Campaigns.TrackID AND (AdvisorID = Campaigns.advisorID OR
	                                                                          CompanyID IN
	                                                                              (SELECT     companyID
	                                                                                FROM          Advisors
	                                                                                WHERE      (advisorID = Campaigns.advisorID)))) AS tbl)  as TRACKS_PRICE, 
							Campaigns.active, 
							MessageLines.number AS MESSAGELINES_NUMBER, 
							Pieces.splitvar1 AS PIECES_SPLITVAR1, 
							Pieces.splitvar2 AS PIECES_SPLITVAR2, 
							Pieces.splitvar3 AS PIECES_SPLITVAR3, 
							Pieces.cost /
                          (SELECT     COUNT(CampaignID) AS Expr1
                            FROM          Campaigns AS c2
                            WHERE      (pieceID = Pieces.pieceID)) AS PIECES_COST,
							Pieces.mailings /
                          (SELECT     COUNT(CampaignID) AS Expr1
                            FROM          Campaigns AS c2
                            WHERE      (pieceID = Pieces.pieceID)) AS PIECES_MAILINGS,
							Websites.url as WEBSITES_URL, 
							websites.personalizedURL as WEBSITES_PERSONALIZEDURL, 
							Pieces.AdvisorID as PIECES_ADVISORID,
							Campaigns.websiteID,
							Campaigns.pageURL,
							campaigns.pageTxt,
							campaigns.emailsubject,
							campaigns.emailbody,
							campaigns.recieptpagetext,		Advisors.Name as ADVISORS_NAME, 
						Advisors.disclosure as ADVISORS_DISCLOSURE, 
						Advisors.bio as ADVISORS_BIO, 
						Advisors.email as ADVISORS_EMAIL, 
						Advisors.imageURL as ADVISORS_IMAGEURL,
						Seminars.name as SEMINARS_NAME,
						Seminars.semdate as SEMINARS_SEMDATE,
						'' as PEOPLE_WEBKEY  FROM         Campaigns LEFT OUTER JOIN Tracks ON Campaigns.trackID = Tracks.TrackID LEFT OUTER JOIN
                      Pieces ON Campaigns.pieceID = Pieces.pieceID LEFT OUTER JOIN
                      Seminars ON Campaigns.SeminarID = Seminars.seminarID LEFT OUTER JOIN
                      MessageLines ON Campaigns.lineID = MessageLines.lineID LEFT OUTER JOIN  ADVISORS ON Campaigns.AdvisorID = Advisors.AdvisorID 
					  LEFT OUTER JOIN Websites ON Campaigns.WebsiteID = Websites.WebsiteID  WHERE WEBSITES.URL = 'carolinaestateplanners.net' AND Campaigns.ACTIVE = 1-->

<!-- SELECT     Campaigns.CampaignID, 
							Campaigns.ADVISORID, 
							Campaigns.SeminarID, 
							Campaigns.lineID, 
							Campaigns.pieceID, 
							Campaigns.Extension,
							Campaigns.StartDate, 
							Campaigns.trackID, 
							Tracks.title as TRACKS_TITLE, Tracks.GMNAME as TRACKS_GMNAME, (SELECT     MIN(price) AS trackprice
	                            FROM          (SELECT     price
	                                                    FROM          Tracks
	                                                    WHERE      TrackID = Campaigns.TrackID
	                                                    UNION
	                                                    SELECT     price
	                                                    FROM         AdvisorTracks
	                                                    WHERE     AdvisorTracks.Active = 1 and AdvisorTracks.trackID = Campaigns.TrackID AND (AdvisorID = Campaigns.advisorID OR
	                                                                          CompanyID IN
	                                                                              (SELECT     companyID
	                                                                                FROM          Advisors
	                                                                                WHERE      (advisorID = Campaigns.advisorID)))) AS tbl)  as TRACKS_PRICE, 
							Campaigns.active, 
							MessageLines.number AS MESSAGELINES_NUMBER, 
							Pieces.splitvar1 AS PIECES_SPLITVAR1, 
							Pieces.splitvar2 AS PIECES_SPLITVAR2, 
							Pieces.splitvar3 AS PIECES_SPLITVAR3, 
							Pieces.cost /
                          (SELECT     COUNT(CampaignID) AS Expr1
                            FROM          Campaigns AS c2
                            WHERE      (pieceID = Pieces.pieceID)) AS PIECES_COST,
							Pieces.mailings /
                          (SELECT     COUNT(CampaignID) AS Expr1
                            FROM          Campaigns AS c2
                            WHERE      (pieceID = Pieces.pieceID)) AS PIECES_MAILINGS,
							Websites.url as WEBSITES_URL, 
							websites.personalizedURL as WEBSITES_PERSONALIZEDURL, 
							Pieces.AdvisorID as PIECES_ADVISORID,
							Campaigns.websiteID,
							Campaigns.pageURL,
							campaigns.pageTxt,
							campaigns.emailsubject,
							campaigns.emailbody,
							campaigns.recieptpagetext,		Advisors.Name as ADVISORS_NAME, 
						Advisors.disclosure as ADVISORS_DISCLOSURE, 
						Advisors.bio as ADVISORS_BIO, 
						Advisors.email as ADVISORS_EMAIL, 
						Advisors.imageURL as ADVISORS_IMAGEURL,
						Seminars.name as SEMINARS_NAME,
						Seminars.semdate as SEMINARS_SEMDATE,
						'' as PEOPLE_WEBKEY  FROM         Campaigns LEFT OUTER JOIN Tracks ON Campaigns.trackID = Tracks.TrackID LEFT OUTER JOIN
                      Pieces ON Campaigns.pieceID = Pieces.pieceID LEFT OUTER JOIN
                      Seminars ON Campaigns.SeminarID = Seminars.seminarID LEFT OUTER JOIN
                      MessageLines ON Campaigns.lineID = MessageLines.lineID LEFT OUTER JOIN  ADVISORS ON Campaigns.AdvisorID = Advisors.AdvisorID 
					  LEFT OUTER JOIN Websites ON Campaigns.WebsiteID = Websites.WebsiteID  WHERE Campaigns.ADVISORID = NULLIF(71, 0) AND Campaigns.ACTIVE <> 0-->
<html>
	<head>
	<title>carolinaestateplanners.net</title>
	<link href="includes/general.css" type="text/css" rel="stylesheet">
	<meta name="MSSmartTagsPreventParsing" content="TRUE">
	<meta name="description" content="">
	<meta name="keywords" content="">
	<meta name="robots" content ="ALL">
</head>
<body marginwidth="0" marginheight="0" leftmargin="0" topmargin="0">
<div id="wholeDoc" height="100%" width="100%">
<div id="head" align="center">
<h1>carolinaestateplanners.net </h1>
</div>
<div id="main" align="center">

<br><br>
<form method="POST" id="enterForm" action="index.php">

<div id="rounded">
	<div class="top"><span></span></div>
    <div class="center-content">
			
					<h3>Enter Your Four Digit Offer Code:<br><br>
					<input type="text" name="extension" id="extension" value="" size="5" maxlength="4">	<br><br>
					<!---<a href="form.php" onClick="document.getElementById('enterForm').submit();">Enter</a>-->
					<input type="submit" name="sbmt" value="Enter">
					<br><br><br><br>
					</h3>
			
			
	</div>
    <div class="bottom"><span></span></div>
</div>
</form>
<!--
preview: 0~
ext: ~
cID: 0~
wID: 19~
advisor: 71~
wbkey: ~
url: carolinaestateplanners.net~
active: 1~
-->

</div>
<div id="footer" align="center">
<br>
	<div id="rounded">
		<div class="top"><span></span></div>
		<div class="center-content">
			Advisory Services offered through USA Wealth Management, LLC. Independent Insurance Services offered through Carolina Estate Planners, LLC. Carolina Estate Planners, LLC. and USA Wealth Management, LLC. are not affiliated.
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-4402086-1";
urchinTracker();
</script>			<br><br><br><br>
		</div>
		<div class="bottom"><span></span></div>
	</div><br><br><br>
<div id="leftSide">
&nbsp;
</div>
</div>
</body>
</html>