<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0"
					xmlns:content="http://purl.org/rss/1.0/modules/content/"
					xmlns:wfw="http://wellformedweb.org/CommentAPI/"
				  >
<channel>
<title>LifeStyle Featured Blog RSS List Section Wellbeing</title>
<link>http://www.prism.com/rss</link>
<description><![CDATA[RSS 2.0 List]]></description>
<item>
<title>An Upstream Mission</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/16029/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0cm; margin-bottom: .0001pt; font-size: 12.0pt; font-family: Cambria;"><span style= " font-family: Verdana;"><span style=" font-size: small;">&#x201c;Water, water everywhere, nor any drop to drink.&#x201d; Coleridge may have been referring to his beleaguered sailors aboard the Mariner&#x2019;s...]]></description>
</item>
<item>
<title>Seeing Green on the Runway</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15601/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0cm; margin-bottom: .0001pt; font-size: 12.0pt; font-family: Cambria;"><span style= " font-family: Verdana;"><span style=" font-size: small;">&#x201c;Fashions fade, style is eternal,&#x201d; Yves Saint Laurent famously said. Alas, the latter also applies to fashion&#x2019;s impact...]]></description>
</item>
<item>
<title>Think Pink with Mushrooms</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15541/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0cm; margin-bottom: .0001pt; font-size: 12.0pt; font-family: Cambria;"><span style= " color: #000000;"><span style=" font-family: Verdana;"><span style=" font-size: small;">How do you make a mushroom blush? By giving it a fantastic cause to support, that&#x2019;s how.</span></span></span><span...]]></description>
</item>
<item>
<title>Browsing into the past with Ancestry.ca</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15238/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-right: 0cm; margin-left: 0cm; font-size: 12.0pt; font-family: 'Times New Roman';"><span style=" font-family: Verdana;"><span style=" font-size: small;">Since launching in 2006, Ancestry.ca has been providing fee-based extensive and thorough historical records online for Canadians interested...]]></description>
</item>
<item>
<title>The Power of Giving &amp;#8211; Inspired by the Story of Leigh Anne Tuohy</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15214/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0cm; margin-bottom: .0001pt; font-size: 12.0pt; font-family: Cambria;"><span style= " font-family: Verdana;"><span style=" font-size: small;">Whether it&#x2019;s giving up your seat on the subway, or making a charitable donation to a good cause, giving back to others can be the greatest...]]></description>
</item>
<item>
<title>The Dukan Diet</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15143/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-top: 0in; margin-right: 0in; margin-bottom: 10.0pt; margin-left: 0in; line-height: 115%; font-size: 11.0pt; font-family: Calibri,sans-serif;"> <span style=" line-height: 115%;"><span style=" font-family: Verdana;"><span style=" font-size: small;">Who doesn&#x2019;t want to look like...]]></description>
</item>
<item>
<title>Andrew Zuckerman&amp;#8217;s &amp;#8220;Wisdom&amp;#8221;</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14978/la_id/1.htm</link>
<description><![CDATA[<p style= " text-indent: .5in; margin-top: 0in; margin-right: 0in; margin-bottom: 10.0pt; margin-left: 0in; line-height: 115%; font-size: 11.0pt; font-family: Calibri,sans-serif; letter-spacing: .25pt;"> <span style=" font-family: Verdana;"><span style=" font-size: small;">&#x201c;The greatest gift...]]></description>
</item>
<item>
<title>Tai Chi Offers an Exhaustion-Free Workout </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14941/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0in; margin-bottom: .0001pt; font-size: 12.0pt; font-family: 'Times New Roman', serif;"> <span style=" font-size: small;"><span style=" font-family: Verdana;">A common belief for many people has been that the only way to stay fit and healthy is through intense workouts at the gym....]]></description>
</item>
<item>
<title>The difference between LASIK and PRK with LASIK MD</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14924/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-right: 0in; margin-left: 0in; font-size: 12.0pt; font-family: 'Times New Roman', serif; line-height: 13.5pt;"> <span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif;"><span style=" font-size: small;">If you wear glasses or contacts chances are you&#x2019;ve thought about...]]></description>
</item>
<item>
<title>Lymphatic detox</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14905/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0cm; margin-bottom: .0001pt; font-size: 12.0pt; font-family: 'Times New Roman';"><span style=" font-family: Verdana;"><span style=" font-size: small;">With 100 trillion cells, 206 bones, 600 muscles, 22 internal organs and 11 vital systems, understanding the human body is, by no means,...]]></description>
</item>
<item>
<title>Can laser vision correction correct astigmatism?</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14792/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-right: 0in; margin-left: 0in; font-size: 10.0pt; font-family: Consolas; margin: 0in; margin-bottom: .0001pt;"> <span style=" font-family: Verdana;"><span style=" font-size: small;">In the past, many patients were told by their eye doctor that they were not a candidate for LASIK because...]]></description>
</item>
<item>
<title>Custom LASIK</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14791/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0in; margin-bottom: .0001pt; font-size: 12.0pt; font-family: 'Times New Roman', serif;"> <span style=" font-family: Verdana;"><span style=" font-size: small;">Historically, dry eyes and night time vision complaints were the two most common side-effects that followed LASIK. However,...]]></description>
</item>
<item>
<title>Financial Planning for Life</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14463/la_id/1.htm</link>
<description><![CDATA[<p>Since the downturn in the economy back in 2008, many people have questioned the value of their financial services advisor. Occasionally, I even questioned myself!<br> <br> This also raises the question of how does one define &#x201c;value&#x201d; when it comes to financial advice?&nbsp; If value...]]></description>
</item>
<item>
<title>No Pain And Everything To Gain</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14086/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-right: 0in; margin-left: 0in; font-family: 'Times New Roman', serif; font-size: 12.0pt;"> <span style=" font-size: 10.0pt; font-family: Arial,sans-serif;">Many people considering laser eye surgery want to know whether or not it really hurts. Fortunately you can have this life-changing...]]></description>
</item>
<item>
<title>The Long-Term Results are in, LASIK is 20 Years Old!</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14087/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-bottom: 10.0pt; line-height: 115%; margin-top: 0in; margin-right: 0in; font-size: 11.0pt; margin-left: 0in; font-family: Calibri,sans-serif;"> <span style=" font-family: Arial,sans-serif; font-size: 10.0pt;">Many people think LASIK is still a new medical procedure, but in fact, the...]]></description>
</item>
<item>
<title>Rise and Shine </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13825/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-bottom: .0001pt; margin: 0in; font-size: 12.0pt; font-family: 'Times New Roman';"><span style=" font-family: Verdana; font-size: small;">Probably the most dreaded and loathed sound in the world is that of an obnoxious alarm clock, jarring you from a peaceful and comfortable snooze.</span></p>...]]></description>
</item>
<item>
<title>It&amp;#8217;s a Beautiful Day, Don&amp;#8217;t Let It Get Away</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13732/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana;">Sundays have always been, and still are, a bit of a ritual in my family. Most days, I am rushing to get out the door. And while a lot of us are busy going about our own days Monday through Friday, there&#x2019;s still something so inviting about...]]></description>
</item>
<item>
<title>Goodbye End-of-Summer Blues</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13731/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana;">It&#x2019;s getting tougher to deny, but another summer has passed. Everyone has their places to go as we prepare ourselves to return to our routines. Nevertheless, I refuse to be saddened by the notion that the days are steadily becoming shorter...]]></description>
</item>
<item>
<title>Love Your Summer Workout</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13502/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: 'Times New Roman', serif; margin: 0in; margin-bottom: .0001pt; font-size: 12.0pt;"> <span style=" font-size: small; font-family: Verdana;">As we say good-bye to swimwear and shorts &#x2014; not to mention the warm weather that they accompany &#x2014; I can&#x2019;t seem to let...]]></description>
</item>
<item>
<title>The Slimy Ingredient </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/10155/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin-bottom: .0001pt; font-family: 'Times New Roman', serif; margin: 0in;"> <span style=" font-size: small; font-family: Verdana;">Forget about snails ridding your garden of dying plants and vegetables. And who even eats escargot anymore?<br> <br> These benefits of snails...]]></description>
</item>
<item>
<title>More To A Day Than The Game</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9897/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-bottom: 0in;"><span style=" font-size: small; font-family: Verdana;">I sat at the edge of my seat last night, utterly dumbfounded by what I had seen &#x2014; as I&#x2019;m sure many hockey fans had.<br> <br> Somehow the Canadians won. Somehow the Capitals choked. Somehow all those...]]></description>
</item>
<item>
<title>Clearing the Air </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9811/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: Cambria,serif; margin: 0in; margin-bottom: .0001pt; font-size: 12.0pt;"><span style= " color: #000000; font-size: small; font-family: Verdana;">There is nothing like stepping outside into the warm, fresh spring air.<br> <br> In fact, the idea of coming inside seems downright...]]></description>
</item>
<item>
<title>The Sixth Sense</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9807/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-right: 0in; font-family: Calibri,sans-serif; margin-left: 0in; font-size: 11.0pt; line-height: 115%; margin-bottom: 10.0pt; margin-top: 0in;"> <span style=" font-size: small; font-family: Verdana;">No, no, no&#x2026; not talking about the creepy movie with Bruce Willis playing a ghost...]]></description>
</item>
<item>
<title>Making the Right Home For A Real Easter Bunny</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9760/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-bottom: .0001pt; font-size: 12.0pt; font-family: 'Times New Roman', serif; margin: 0in;"> <span style=" font-family: Verdana; font-size: small;">Every Easter, there can be a big temptation to spoil the kids and one-up the Easter chocolate by actually getting them a bunny.<br> <br>...]]></description>
</item>
<item>
<title>Hit the Ground Running</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9713/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-bottom: .0001pt; font-family: 'Times New Roman'; font-size: 12.0pt; margin: 0in;"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">It&#x2019;s finally spring: The sun is shining, the temperature has warmed and we can walk the sidewalks in peace knowing...]]></description>
</item>
<item>
<title>Men: Spoil your Feet</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9712/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Even though spring is upon us and I&#x2019;ll be busting out the open-toe shoes pretty soon, you won&#x2019;t be seeing me getting a pedicure.&nbsp;<br> <br> I have the ultimate foot phobia.&nbsp;I can&#x2019;t imagine...]]></description>
</item>
<item>
<title>Dealing with Daylight Savings</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9623/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-bottom: .0001pt; font-family: 'Times New Roman'; font-size: 12.0pt; margin: 0in;"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Many of us believe there&#x2019;s nothing worse than Monday morning, but there&#x2019;s truly nothing worse than the...]]></description>
</item>
<item>
<title>Boosting Your Exercise Routine</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9430/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Forget the shuffle button when you exercise &#x2014; deliberately bring out all the ladies like Lady Gaga, Beyonce and Rihanna.<br> <br> Sitting stationary on a bike for an hour is extremely unexciting and monotonous....]]></description>
</item>
<item>
<title>Winter Lightens Up</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9207/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">January is one of the harshest winter months; it&#x2019;s long, freezing and relentlessly dark. It&#x2019;s no small surprise that most of us struggle to wake up in the morning and sit gloomily during the day, hoping...]]></description>
</item>
<item>
<title>Bundle Up, or Take Vitamin D3</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9198/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small;">Do these symptoms sound familiar &#x2013; runny nose, coughing or fever?<br> <br> Oh the flu; what a headache &#x2013; literally. On average a person can expect one or two every season and this winter season hasn&#x2019;t disappointed either.&nbsp; It&#x2019;s had...]]></description>
</item>
<item>
<title>Bra-wareness</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9185/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">Perusing through <a onclick= "w=window.open(this.href,'popupwindow','channelmode=no,directories=yes,fullscreen=no,location=yes,menubar=yes,resizable=yes,scrollbars=yes,status=yes,titlebar=yes,toolbar=yes');this.target='popupwindow';w.focus();"...]]></description>
</item>
<item>
<title>Viva la Vida</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9058/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin-bottom: .0001pt; font-family: Arial; margin: 0in;"><span style= " font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">It&#x2019;s 10 a.m. and the first bleary-eyed clients of Vida Spa, at the Sheraton Wall Center location in downtown Vancouver,...]]></description>
</item>
<item>
<title>Where There&amp;#8217;s Smoke, There&amp;#8217;s Wrinkles</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8909/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: 'Verdana, Arial, Helvetica, Sans-Serif';">Ever wondered what you would look like 30, 40 years down the road? Now, what about if you threw long-term smoking into the equation? My intrepid colleague Jessica (a non-smoker, by the way) agreed to find out,...]]></description>
</item>
<item>
<title>YOGA AND THE CITY: Q&amp;A WITH PASSPORT TO PRANA </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8900/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">After taking Toronto by storm, Passport to Prana continues to spread the yoga love by expanding this year to Ottawa, Vancouver and, starting next month, Montreal. The way the program works is simple: For a one-time...]]></description>
</item>
<item>
<title>Pipe Down! Study Finds Link Between Noisy Traffic And Hypertension</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8790/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-top: 0in; margin-bottom: .0001pt; font-size: 12.0pt; margin-right: 0in; margin-left: 0in; font-family: 'Times New Roman';"> <span style=" font-size: small;">So you wake up and there&#x2019;s a ruckus going on outside your bedroom window.&nbsp; Honking cars, rumbling trucks, rattling...]]></description>
</item>
<item>
<title>No TV And No Beer Make Homer&amp;#8230; Healthy? </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8769/la_id/1.htm</link>
<description><![CDATA[<p style= " font-family: Arial; margin-bottom: .0001pt; font-size: 12.0pt; margin-left: 0in; margin-top: 0in; margin-right: 0in;"> <span style=" font-size: small; font-family: 'Verdana, Arial, Helvetica, Sans-Serif';">One of my favourite <em>The Simpsons</em> episodes of all time is "King-Sized Homer."...]]></description>
</item>
<item>
<title>Weird Science: Doctor Cracks Knuckles For 60+ Years</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8760/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-right: 0in; font-family: 'Times New Roman'; font-size: 12.0pt; margin-bottom: .0001pt; margin-left: 0in; margin-top: 0in;"> <span style=" font-size: small;">If you or someone you know cracks their knuckles, you may have heard this warning: "Don't do that &#x2013; it'll give you arthritis!"&nbsp;...]]></description>
</item>
<item>
<title>Sunny Vacations May Lower Death Rate</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8737/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small;">There could be one more reason for you to like summer vacation.</span><br> <br> <span style=" font-size: small;">A new study in the</span> <a onclick= "w=window.open(this.href,'popupwindow','channelmode=no,directories=yes,fullscreen=no,location=yes,menubar=yes,resizable=yes,scrollbars=yes,status=yes,titlebar=yes,toolbar=yes');this.target='popupwindow';w.focus();"...]]></description>
</item>
<item>
<title>Colour-Blind Monkeys Cured By Gene Therapy</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8732/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small;">How do you make a colour-blind monkey see red and green?</span><br> <br> <span style=" font-size: small;">It's not the set-up for a riddle &#x2014; a team of researchers in the U.S. have figured out a way to do just that using gene therapy.</span><br> <br> <span style="...]]></description>
</item>
</channel>
</rss><!--
Successfully connected to MySQL, Host: 127.0.0.1
*****************************************************************************************************************
Start session
*****************************************************************************************************************
Set LanguageId: 1
*****************************************************************************************************************
Set Tree Id: 1003
*****************************************************************************************************************
Set Site: 1020
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (4)			
						
      			
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
Query affected rows: 3
*****************************************************************************************************************
Query, execution time: 0.0009 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (4)			
						
      			
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 8
*****************************************************************************************************************
Query, execution time: 0.0004 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (4)			
						
      			
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 6
*****************************************************************************************************************
Query, execution time: 0.0003 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (4)			
						
      			
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 4
*****************************************************************************************************************
Query, execution time: 0.0003 seconds

			SELECT a.st_id, b.st_name, c.sl_name
			FROM content_stereotype as a, stereotype as b, stereotype_language as c
			
			WHERE (b.st_delete IS NULL OR b.st_delete = 0) 
				AND b.st_parent_id = 1177				AND a.ci_id = 5671				AND a.st_id = b.st_id
				AND c.st_id = a.st_id
				AND c.la_id = 1
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0002 seconds

            SELECT sl_name
            FROM stereotype_language
            WHERE st_id = '1184' AND la_id = '1'
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
Query affected rows: 2
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 16029
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15601
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15541
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 2
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15238
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15214
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15143
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14978
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 3
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14941
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14924
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14905
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 2
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14792
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14791
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0591 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14463
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14086
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 4
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14087
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 13825
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 13732
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 13731
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 13502
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 4
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 10155
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9897
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9811
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9807
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 5
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9760
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9713
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9712
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9623
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9430
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 3
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9207
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9198
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9185
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 2
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9058
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8909
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8900
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 3
*****************************************************************************************************************
Query, execution time: 0.0175 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8790
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8769
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8760
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:20:47'and a.ci_archiving_date >'2012-02-08 11:20:47'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:20:47'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 2
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8737
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8732
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Executing custom module for: ci_id: 5683, custom_module_id: 5684, execution time: 0.3509 seconds
*****************************************************************************************************************
Query, execution time: 0.0334 seconds, affected rows: 1
	
			INSERT INTO
				log_visited_content_item
				(
					ci_id,
					la_id,
					lvci_http_user_agent,
					lvci_datetime,
					lvci_http_referer,
					lvci_remote_addr,
					lvci_query_string,
					lvci_path_info,
					lvci_member_uuid,
					lvci_server_uuid
				)
			VALUES
				(
					:ci_id,
					:la_id,
					:http_user_agent,'2012-02-08 11:20:47',
										:http_referer,
					:remote_addr,
					:query_string,
					:path_info,
					:member_uuid,
					:server_uuid
				)
*****************************************************************************************************************
Total number of run queries: 64
Total page execution time: 0.4041 seconds-->
