<?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 Flavours</title>
<link>http://www.prism.com/rss</link>
<description><![CDATA[RSS 2.0 List]]></description>
<item>
<title>Delicious Defined: Lifestyler visits this year&amp;#8217;s Delicious Food Show </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/16164/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;">We joined the gathers of foodies who were anxiously waiting to sample the decadent assortment of food (including many desserts) and to take...]]></description>
</item>
<item>
<title>Lifestyler visits Canada&amp;#8217;s Baking and Sweets Show for the ultimate sugar rush</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15582/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;">What can be sweeter than joining thousands of Canadians in a celebration filled with cakes, pastries and other desserts? That was the scene...]]></description>
</item>
<item>
<title>From No Reservations to The Layover: There's no stopping Anthony Bourdain</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15577/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;">The rebel chef is at it again. Anthony Bourdain is getting set to premiere his new show, </span></span><em><span><span style=" font-family:...]]></description>
</item>
<item>
<title> P.E.I. International Shellfish Festival: A Stone&amp;#8217;s throw away</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15258/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-right: 0cm; margin-left: 0cm; font-size: 10.0pt; font-family: Times;"><span style= " font-family: Verdana;"><span style=" font-size: small;">Chef Curtis Stone will be the celebrity chef at this year&#x2019;s Prince Edward Island International Shellfish Festival.</span></span><span...]]></description>
</item>
<item>
<title>A spirit-awakening experience at Spirit Ridge Vineyard</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15249/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-right: 0cm; margin-left: 0cm; font-size: 10.0pt; font-family: Times;"><span style= " font-family: Verdana;"><span style=" font-size: small;">It&#x2019;s been a busy summer and technically it&#x2019;s not over until later this month. But sometimes you have to remind yourself to stop...]]></description>
</item>
<item>
<title>A taste of the Island on Canada&amp;#8217;s smallest province</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15247/la_id/1.htm</link>
<description><![CDATA[<p style= " line-height: 150%; margin: 0cm; margin-bottom: .0001pt; font-size: 12.0pt; font-family: 'Times New Roman';"> <span style=" font-family: Verdana;"><span style=" font-size: small;">If Matt Moore&#x2019;s country music doesn&#x2019;t please the palate, his cooking sure will.</span></span><span...]]></description>
</item>
<item>
<title>Toronto Gets More Greek with Estiatorio Volos</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15235/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-top: 0cm; margin-right: 0cm; margin-bottom: 10.0pt; margin-left: 0cm; line-height: 115%; font-size: 11.0pt; font-family: Calibri;"> <span style=" font-family: Verdana;"><span style=" font-size: small;">Toronto&#x2019;s financial district gets a taste of Greece with the opening of...]]></description>
</item>
<item>
<title>Learning from the best at the CNE&amp;#8217;s Food Network Celebrity Stage</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15230/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;">Ever want to see your favourite Food Network chef cook something right before your eyes? Now&#x2019;s your chance, with the Food Network Celebrity...]]></description>
</item>
<item>
<title>LCBO&amp;#8217;s local movement</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15227/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;">Going local with fresh, seasonal ingredients is now considered the norm in the culinary industry, but who knew the same goes for beverages?</span></span><span...]]></description>
</item>
<item>
<title>Le Creuset unveils its Toronto flagship store</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15215/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;">Cooking with Le Creuset just got a whole lot easier.</span></span><span style=" font-size: small;"><br style=" font-family: Verdana;"> <br...]]></description>
</item>
<item>
<title>A flavour-filled weekend in Toronto</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15183/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=" font-family: Verdana;"><span style=" font-size: small;">The first weekend of August marks a busy one in the city of Toronto.&nbsp;<br...]]></description>
</item>
<item>
<title>A Taste of Whistler&amp;#8217;s Wildlife </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15163/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;"> <span style=" font-family: Verdana;"><span style=" font-size: small;">On Thursday, July 25, BC residents can enjoy a culinary celebration with </span></span><a href="http://www.feastinthemountains.com/"><span...]]></description>
</item>
<item>
<title>The Royal Caesar: Fit for a King and Queen (to-be)</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14998/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; letter-spacing: .25pt;"> <span style=" line-height: 115%;"><span style=" font-family: Verdana;"><span style=" font-size: small;">This Canada...]]></description>
</item>
<item>
<title>The Multi-Faceted Flavours of Peru</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14983/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0in; margin-bottom: .0001pt; font-size: 12.0pt; font-family: Cambria,serif;"><span style= " font-family: Verdana;"><span style=" font-size: small;">Enclosed between the Andes Mountains and the Amazon River basin sits Peru; a country with a distinct South American culture formed by...]]></description>
</item>
<item>
<title>Enjoy Fine Dining at its Finest at Restaurant Dubrovnick</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14956/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;">Few restaurants are actually truthful when making the claim that they are &#x201c;the best in North America,&#x201d; but the...]]></description>
</item>
<item>
<title>Eat in Tokyo &amp;#8212; Without Leaving the Neighbourhood</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14814/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-top: 0cm; margin-right: 0cm; margin-bottom: 10.0pt; margin-left: 0cm; line-height: 115%; font-size: 11.0pt; font-family: Calibri;"> <span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif;"><span style=" font-size: small;">If you&#x2019;re expecting to find the usual California...]]></description>
</item>
<item>
<title>An Authentic Taste of Greece</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14608/la_id/1.htm</link>
<description><![CDATA[<p>During these recent gloomy days, I never thought I&#x2019;d find a ray of sunshine through my tastebuds. With a succulent piece of lamb and a great wine accompaniment, the cloudy day didn&#x2019;t seem to bother me anymore.<br> <br> Pan Mediterranean Cuisine, located on Danforth Avenue in Toronto,...]]></description>
</item>
<item>
<title>Working Lunches</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13754/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: 'Times New Roman', serif; font-size: 12.0pt; margin-bottom: .0001pt; margin: 0in;"> <span style=" font-size: small; font-family: Verdana;">Mid-afternoon yesterday, a co-worker and I bonded over a beautiful meal. My senses couldn&#x2019;t have been more pleased while we waited...]]></description>
</item>
<item>
<title>iPad Menus</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13504/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: 'Times New Roman', serif; font-size: 12.0pt; margin-bottom: .0001pt; margin: 0in;"> <span style=" font-family: Verdana; font-size: small;">Bye-bye traditional wine menus; hello iPad app.<br> <br> When the <a href="http://www.154southgate.com/">South Gate restaurant</a> in New...]]></description>
</item>
<item>
<title>Ideas For A Summer-Fresh Menu </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13481/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: 'Times New Roman', serif; font-size: 12.0pt; margin-bottom: .0001pt; margin: 0in;"> <span style=" font-family: Verdana; font-size: small;">In this fast, crazy, workaholic pace of life, I&#x2019;ve found that nothing is more calming than calling up a few friends for a dinner party.<br>...]]></description>
</item>
<item>
<title>Becel Joins Vegan Bandwagon</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9916/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin: 0in; margin-bottom: .0001pt; font-family: 'Times New Roman', serif;"> <span style=" font-family: Verdana; font-size: small;">Health nuts, get ready to squeal: Becel has just come out with vegan margarine.<br> <br> The margarine is subsequently lactose-free, and...]]></description>
</item>
<item>
<title>Chocolate and Fibre: A Match Made In Granola Heaven</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9907/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; font-family: 'Times New Roman', serif; margin-bottom: .0001pt; margin: 0in;"> <span style=" font-size: small; font-family: Verdana;">I got 100% of my daily fibre intake the other day -- Did you?<br> <br> Weird question from a blogger you&#x2019;ve never met, I know. But...]]></description>
</item>
<item>
<title>Keep Carbs Under Wraps with Rice Paper Rolls</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9831/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: 'Times New Roman', serif; margin-bottom: .0001pt; margin: 0in; font-size: 12.0pt;"> <span style=" font-family: Verdana; font-size: small;">It&#x2019;s difficult to resist the allure of a spring roll. It is a Thai-cuisine favourite that boasts a flavourful filling of either vegetables...]]></description>
</item>
<item>
<title>Eating Healthier in 2010: Upcoming Menu Trends</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9698/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin-bottom: .0001pt; margin: 0in; font-family: 'Times New Roman';"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">On New Year&#x2019;s when you pledged that you&#x2019;d eat healthier in 2010, you weren&#x2019;t setting yourself...]]></description>
</item>
<item>
<title>I Scream for Springtime Ice Cream</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9697/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin-bottom: .0001pt; margin: 0in; font-family: 'Times New Roman';"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">You know it&#x2019;s spring in Canada when: people start wearing short-shorts in March, office water cooler conversations...]]></description>
</item>
<item>
<title>Introducing The Newest Wonder Food: The Chia Seed</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9470/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: 'Times New Roman'; margin-bottom: .0001pt; margin: 0in; font-size: 12.0pt;"><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">As in chia <em>pet?</em><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif; font-style:...]]></description>
</item>
<item>
<title>Noodles Fit For A King</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9442/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: Arial; font-size: 11.0pt; margin: 0in; margin-bottom: .0001pt;"><span style= " font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Many a college student knows the joy of ramen.&nbsp; Set a pot of water to boil, add half a teaspoon of chicken bouillon, drop...]]></description>
</item>
<item>
<title>Those Sweet Words</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9390/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-left: 0in; margin-right: 0in; font-family: 'Times New Roman'; font-size: 13.5pt;"><span style=" font-size: small; font-weight: normal; font-family: Verdana, Arial, Helvetica, Sans-Serif;">This Valentine&#x2019;s Day, send your sweetie a love note that even candy conversation hearts...]]></description>
</item>
<item>
<title>Crave-Worthy Valentine's Treats</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9227/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">If you&#x2019;re rushing around thinking of something to get your significant other, stop fretting! Everything you need is probably in your kitchen already. Baking is a wonderful way to show your spouse that you...]]></description>
</item>
<item>
<title>Your house is my house</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14443/la_id/1.htm</link>
<description><![CDATA[<p>Our visit was short and sweet. Just right. One evening to take a break from the everyday and remember who we are. A Monday night to gather closely around and savour a true fine dining experience with the ones I love.</p> <p>&nbsp;</p> <p>At the end of our meal at Mississauga&#x2019;s Tu Casa restaurant,...]]></description>
</item>
<item>
<title>Smaller Portions Means a Smaller Waist</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9202/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">It&#x2019;s not about sacrificing flavour and quality to be healthy.&nbsp; At Glow Fresh Grill and Wine Bar, there is no deep frying or use of heavy dressings to cover up the taste.&nbsp;<br> <br> Glow proves that...]]></description>
</item>
<item>
<title>Dining in Darkness &amp;#8211; A Sensual Experience</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9195/la_id/1.htm</link>
<description><![CDATA[<p style= " font-family: 'Times New Roman'; margin: 0in; font-size: 12.0pt; margin-bottom: .0001pt; text-indent: .5in;"> <br> <br> <span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">The darkness engulfs you completely. You are led forward, your hand on your companion&#x2019;s...]]></description>
</item>
<item>
<title>Sugar, Spice, and Everything Nice &amp;#8211; Literally</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9110/la_id/1.htm</link>
<description><![CDATA[<p><span style= " font-family: Verdana, Arial, Helvetica, Sans-Serif; color: #000000; background-color: #ffffff; font-size: small;">The words couture, boutique, sneakers and boulangerie-p&#xe2;tisserie may sound just a bit odd when they&#x2019;re all put together. However, restaurateurs Wilhelm Liebenberg...]]></description>
</item>
<item>
<title>Have Your Plate, And Eat It Too</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9105/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">At your next dinner party, when someone tells you to &#x201c;Save room for dessert,&#x201d; they might just be talking about your plate.<br> <br> After seeing piles of plastic plates in the garbage bins at her son&#x2019;s...]]></description>
</item>
<item>
<title>WWF brings home the bacon</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8802/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;"><em>The Idea:</em></span><span style= " font-style: normal; font-size: small;"> Imagine this; the average food product travels...]]></description>
</item>
<item>
<title>Angus Glenfiddich</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8801/la_id/1.htm</link>
<description><![CDATA[<p style= " font-family: 'Times New Roman'; margin-top: 0in; margin-left: 0in; font-size: 12.0pt; margin-right: 0in; margin-bottom: .0001pt;"> <span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">Toronto's Six Steps Lounge is trendier than the dives I usually frequent....]]></description>
</item>
<item>
<title>Holding down the Montfort</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8748/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small;">Last night, Mediterranean restaurant chain Montfort launched its first downtown Toronto location after previously setting up shop in Milton and Oakville. Three generations of family restaurateurs brought their culinary perspective to Canada from Europe and the Middle...]]></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.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: 7
*****************************************************************************************************************
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: 7
*****************************************************************************************************************
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: 2
*****************************************************************************************************************
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 = 5667				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 = '1181' 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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 16164
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15582
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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.001 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15577
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15258
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.001 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15249
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15247
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15235
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15230
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15227
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15215
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15183
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 15163
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14998
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14983
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14956
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 14814
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
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 (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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: 0
*****************************************************************************************************************
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 (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 14608
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 13754
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 13504
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 13481
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 9916
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9907
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9831
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 9698
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9697
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9470
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9442
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 9390
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9227
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14443
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9202
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9195
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9110
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9105
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 8802
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8801
*****************************************************************************************************************
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 12:40:55'and a.ci_archiving_date >'2012-02-08 12:40:55'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 12:40:55'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 = 8748
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Executing custom module for: ci_id: 5683, custom_module_id: 5684, execution time: 0.3868 seconds
*****************************************************************************************************************
Query, execution time: 0.036 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 12:40:55',
										:http_referer,
					:remote_addr,
					:query_string,
					:path_info,
					:member_uuid,
					:server_uuid
				)
*****************************************************************************************************************
Total number of run queries: 60
Total page execution time: 0.4439 seconds-->
