<?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 Spaces</title>
<link>http://www.prism.com/rss</link>
<description><![CDATA[RSS 2.0 List]]></description>
<item>
<title>Feeling at home at Toronto&amp;#8217;s Fall Home Show</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15580/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;">Last week saw the return of the annual Fall Home Show to Toronto&#x2019;s Better Living Centre at Exhibition Place.</span></span><span style="...]]></description>
</item>
<item>
<title>Remodelling Robie House</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15530/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;">In the September edition of </span></span><em><span><span style=" font-family: Verdana;"><span style= " font-size: small;">Lifestyler</span></span></span></em><span><span...]]></description>
</item>
<item>
<title>Camp and Win </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15123/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;">In celebration of this year&#x2019;s Parks Day on Saturday, July 16th, </span></span><a href="http://www.pc.gc.ca/" target=""...]]></description>
</item>
<item>
<title>Andrea Kantelberg's poetic design </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14894/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: 'Times New Roman'; letter-spacing: .25pt;"> <span style=" font-family: Verdana;"><span style=" font-size: small;">Want &#x201c;poetically modern, eco-chic design,...]]></description>
</item>
<item>
<title>Al Fresco elegance</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14874/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><span style=" font-size: small;">Many people spend a lot of time and money on the design and d&#xe9;cor for...]]></description>
</item>
<item>
<title>A Divine DIY</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13896/la_id/1.htm</link>
<description><![CDATA[<p style= " line-height: 115%; font-family: Calibri,sans-serif; margin-right: 0in; margin-left: 0in; margin-bottom: 10.0pt; margin-top: 0in; font-size: 11.0pt;"> <span style=" font-family: Verdana; font-size: small;">&#x201c;If you want something done, do it yourself&#x201d; is one of the most common...]]></description>
</item>
<item>
<title>Everything&amp;#8217;s coming up&amp;#8230; green</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9910/la_id/1.htm</link>
<description><![CDATA[<p style= " font-size: 12.0pt; font-family: 'Arial Unicode MS', sans-serif; margin: 0in; margin-bottom: .0001pt; margin-right: 0in; margin-left: 0in;"> <span style=" font-size: small; font-family: Verdana;">In growing urban landscapes, the famous phrase &#x201c;Stop and smell the roses&#x201d; is becoming...]]></description>
</item>
<item>
<title>The Future Looks Cozy</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9809/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-right: 0in; font-size: 12.0pt; font-family: 'Times New Roman', serif; margin-left: 0in;"> <span style=" font-family: Verdana; font-size: small; color: #000000;">With summer fast approaching, lazy days at home on the couch and in front of a television are (hopefully) on the horizon....]]></description>
</item>
<item>
<title>Eggcellent Decorating Ideas</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9784/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-left: 20.0px; font-size: 12.0pt; font-family: 'Times New Roman', serif; margin-bottom: .0001pt; margin: 0in;"> <span style=" font-family: Verdana; font-size: small;">It&#x2019;s that time of the year again: where grabbing more than three cartons of eggs is not out of the ordinary.<br>...]]></description>
</item>
<item>
<title>Bringing Spring Into Your Home</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9773/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; font-family: 'Times New Roman', serif; margin-bottom: .0001pt; margin: 0in;"> <strong><span style=" font-family: Verdana; font-size: small;">Bringing Spring Into Your Home<br> <br> </span></strong><span style=" font-family: Verdana; font-size: small;">Does your home look...]]></description>
</item>
<item>
<title>Samsung Adds New Dimension to 3D Evolution</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9735/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin-bottom: .0001pt; font-family: 'Times New Roman'; margin: 0in;"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">While it&#x2019;s not as widely publicized as <em>Avatar</em></span><span style= " font-size: small; font-style: normal;...]]></description>
</item>
<item>
<title>Brighten up your homes with this seasons&amp;#8217; &amp;#8216;It&amp;#8217; colour: Yellow! </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9730/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0in; margin-bottom: .0001pt; font-size: 12.0pt; font-family: 'Times New Roman';"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">As the weather begins to perk we can&#x2019;t help but turn our attention to thoughts of spring. Off come those dark...]]></description>
</item>
<item>
<title>Empty Nester</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9707/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;">A lot of us grew up in a world of video games.<br> <br> I can still remember blowing air into game cartridges before...]]></description>
</item>
<item>
<title>Erasing Home Decorating Headaches</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9689/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;">Bouclair Home is taking away the headache of decorating your home once and for all.&nbsp;<br> <br> Trying to put a...]]></description>
</item>
<item>
<title>Sleep With The Fishes</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9395/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-bottom: .0001pt; margin: 0in; font-family: 'Times New Roman'; font-size: 12.0pt;"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Most people have heard of &#x201c;breakfast in bed.&#x201d;&nbsp; Now you can also have &#x201c;sushi in bed,&#x201d;...]]></description>
</item>
<item>
<title>Once Upon A Valentine&amp;#8217;s</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9240/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Take a trip through time this Valentine&#x2019;s Day with a romantic visit to Toronto&#x2019;s very own castle.<br> <br> I&#x2019;m a hopeless romantic, so it comes as no surprise that I enjoy celebrating Valentine&#x2019;s...]]></description>
</item>
<item>
<title>Roses are Red &amp;#8211; and Orchids Are Too</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9213/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Red roses are a Valentine&#x2019;s Day staple &#x2013; and there&#x2019;s nothing wrong with that. A dozen long-stemmed roses are utterly breathtaking and are quite the sentiment.&nbsp;<br> <br> According to Joseph...]]></description>
</item>
<item>
<title>Who-o-o Can Say No?</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9206/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Have you ever been in the store Anthropology? It just opened up this past year in Canada with two locations in Toronto and one in Edmonton.&nbsp;<br> <br> It&#x2019;s quite the chic and trendy clothing store and...]]></description>
</item>
<item>
<title>Farming Grows Up</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9201/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">Have you ever stopped and looked at the origin label on an apple? How about a banana? The food we consume daily has travelled an average of 1,500 miles from farm to plate. For those of us living in cities, the distance...]]></description>
</item>
<item>
<title>Flash Me Some Colour</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9083/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">I love things that make big bold statements. You can see this trend not only making waves in the fashion world, but also in home d&#xe9;cor in 2010.<br> <br> Whether it&#x2019;s contrasting colours, graphic patterns...]]></description>
</item>
<item>
<title>Some Glitter Here And Tinsel There</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9074/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin: 0in; margin-bottom: .0001pt; font-family: 'Times New Roman';"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Bows, ribbons, tinsel, flowers, mesh, wrapping paper, tissue, hooks, fake snow, pipe cleaners, gold-tinted fruit, hand-blown...]]></description>
</item>
<item>
<title>Sleep (And Play) Like Royalty At The Ivy</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8874/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: 'Verdana, Arial, Helvetica, Sans-Serif'; font-size: small;">In the 1850s, 111 Queen St. East was the site of a bustling chocolate factory in the heart of downtown Toronto. Fast-forward 150 years and the restored building is now home to Toronto&#x2019;s newest downtown boutique...]]></description>
</item>
<item>
<title>The House That Cob Built</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8826/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-top: 0in; margin-right: 0in; margin-bottom: .0001pt; margin-left: 0in; font-size: 12.0pt; font-family: 'Arial Unicode MS';"> <span style=" font-size: small; font-family: 'Verdana, Arial, Helvetica, Sans-Serif';">You may remember the Three Little Pigs.&nbsp;Poor Pig No. 1&#x2019;s...]]></description>
</item>
<item>
<title>Doors Get Fancy With &amp;#8220;3-D&amp;#8221; Designs</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8783/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;">Here's an eye-popping idea if you're looking to jazz up your home in just a few minutes: Full-surface photo films for your door,...]]></description>
</item>
<item>
<title>Ty Pennington, Colin &amp; Justin To Appear At Vancouver Home Show</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8759/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;">Planning to update your digs? Here's something to mark on your calendar: The Vancouver Home + Interior Design Show is coming...]]></description>
</item>
<item>
<title>Citytv Announces Extreme Dream Home Build Contest</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8752/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-bottom: .0001pt; margin-left: 0in; font-family: 'Times New Roman'; font-size: 12.0pt; margin-top: 0in; margin-right: 0in;"> <span style=" color: #000000; font-size: small;">Let&#x2019;s imagine for a second that you could change whatever you wanted about your home.&nbsp; Would you...]]></description>
</item>
<item>
<title>Martha Stewart Brand Finds A New Home</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8735/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small;">The Martha Stewart brand will have a new place to call home beginning in 2010.</span><br> <br> <span style=" font-size: small;">Home Depot Inc. announced this month that it has teamed up with Martha Stewart Living Omnimedia Inc. (MSLO) to develop a Martha Stewart-branded...]]></description>
</item>
<item>
<title>Crate And Barrel Rolls Into Calgary This Fall</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8607/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-bottom: .0001pt; margin-right: 0in; font-family: 'Times New Roman'; margin-top: 0in; font-size: 12.0pt; margin-left: 0in;"> <span style=" font-size: small;">Attention furniture and houseware aficionados:</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>
</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.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.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: 5
*****************************************************************************************************************
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 = 5668				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.0001 seconds

            SELECT sl_name
            FROM stereotype_language
            WHERE st_id = '1180' AND la_id = '1'
*****************************************************************************************************************
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:35:09'and a.ci_archiving_date >'2012-02-08 12:35:09'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:35:09'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
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:35:09'and a.ci_archiving_date >'2012-02-08 12:35:09'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:35:09'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 = 15580
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15530
*****************************************************************************************************************
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:35:09'and a.ci_archiving_date >'2012-02-08 12:35:09'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:35:09'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 = 15123
*****************************************************************************************************************
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:35:09'and a.ci_archiving_date >'2012-02-08 12:35:09'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:35:09'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 = 14894
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14874
*****************************************************************************************************************
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:35:09'and a.ci_archiving_date >'2012-02-08 12:35:09'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:35:09'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 = 13896
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
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 (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 12:35:09'and a.ci_archiving_date >'2012-02-08 12:35:09'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:35:09'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 = 9910
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0009 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9809
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0015 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9784
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9773
*****************************************************************************************************************
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:35:10'and a.ci_archiving_date >'2012-02-08 12:35:10'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:35:10'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
Query affected rows: 4
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9735
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0009 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9730
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9707
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0013 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9689
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
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 (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 12:35:10'and a.ci_archiving_date >'2012-02-08 12:35:10'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:35:10'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.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9395
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9240
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0009 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9213
*****************************************************************************************************************
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:35:10'and a.ci_archiving_date >'2012-02-08 12:35:10'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:35:10'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.0009 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9206
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9201
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0607 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:35:10'and a.ci_archiving_date >'2012-02-08 12:35:10'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:35:10'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 = 9083
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9074
*****************************************************************************************************************
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:35:10'and a.ci_archiving_date >'2012-02-08 12:35:10'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:35:10'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.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8874
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8826
*****************************************************************************************************************
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:35:10'and a.ci_archiving_date >'2012-02-08 12:35:10'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:35:10'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.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8783
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8759
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8752
*****************************************************************************************************************
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:35:10'and a.ci_archiving_date >'2012-02-08 12:35:10'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:35:10'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 = 8735
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8607
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Executing custom module for: ci_id: 5683, custom_module_id: 5684, execution time: 0.2916 seconds
*****************************************************************************************************************
Query, execution time: 0.0082 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:35:10',
										:http_referer,
					:remote_addr,
					:query_string,
					:path_info,
					:member_uuid,
					:server_uuid
				)
*****************************************************************************************************************
Total number of run queries: 48
Total page execution time: 0.3231 seconds-->
