<?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 Escapes</title>
<link>http://www.prism.com/rss</link>
<description><![CDATA[RSS 2.0 List]]></description>
<item>
<title>A week in Brittany part 1: Insight into France&amp;#8217;s rebel province</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15556/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 oysters were shucked with a deftness that suggests years opening the bivalves (although a plaster on her hand perhaps suggested the occasionally...]]></description>
</item>
<item>
<title>Let The Caves Ignite Your Intrigue </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14951/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=" font-family: Verdana;"><span style=" font-size: small;">The aroma of fresh Jamaican cooking entices you...]]></description>
</item>
<item>
<title>Ski through spring</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14900/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;">Sunglasses?&nbsp; Check.&nbsp; Sun tan lotion?&nbsp; Check.&nbsp; Skis?&nbsp; Check.&nbsp;...]]></description>
</item>
<item>
<title>Indulge&amp;#8230; the Organic Way</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14820/la_id/1.htm</link>
<description><![CDATA[<p>Organic eating, organic living, organic spa-ing? While spas may conjure up the notion of all-natural treatments like seaweed and mud wraps, most spas use skincare products containing synthetic ingredients that may, over time, build up toxins in one&#x2019;s body. As we all try to eat, live and breathe...]]></description>
</item>
<item>
<title>Feast Locally at CN Tower&amp;#8217;s 360 Restaurant</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13751/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana;">There are many welcoming aspects to the fall season. The crisp in the air and changing of the leaves are obvious highlights, but to our tastebuds&#x2019; content, it is also harvest season.<br> <br> With so many choices to pile up on our plates,...]]></description>
</item>
<item>
<title>Top 10 Romantic Vacations</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13544/la_id/1.htm</link>
<description><![CDATA[<p style= " margin: 0in; margin-bottom: .0001pt; font-family: 'Times New Roman', serif; background: white; font-size: 12.0pt;"> <span style=" font-size: small; color: #2C2C2C; font-family: Verdana;">Sometimes, life reminds us we need a break. It is important to listen to this request and even better,...]]></description>
</item>
<item>
<title>All Around the world</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13479/la_id/1.htm</link>
<description><![CDATA[<p style= " font-family: 'Times New Roman', serif; font-size: 12.0pt; text-indent: .5in; margin: 0in; margin-bottom: .0001pt;"> <span style=" font-size: small; font-family: Verdana;">Now, perhaps more than ever, touring the world has never been more accessible. The idea of signing up for one of these...]]></description>
</item>
<item>
<title>Nature Meets Luxury </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9796/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: 'Times New Roman', serif; margin: 0in; margin-bottom: .0001pt; font-size: 12.0pt;"> <span style=" font-family: Verdana; font-size: small;">In the heart of British Columbia&#x2019;s Great Bear Rainforest lies a unique vacation destination that boasts five-star service and an environmentally...]]></description>
</item>
<item>
<title>Sweet, Sweet Easter</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9737/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0in; font-size: 12.0pt; margin-bottom: .0001pt; font-family: 'Times New Roman';"><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">Easter, like most holidays, can mean a lot of different things to a lot of people. When I was a child, Easter meant...]]></description>
</item>
<item>
<title>A Sweet Experience Rooted in Canadian History</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9570/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin: 0in; font-family: 'Times New Roman'; margin-bottom: .0001pt;"><em><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Lifestyle</span></em><span style=" font-style: normal; font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size:...]]></description>
</item>
<item>
<title>Like A Bird</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9389/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-bottom: 10.0pt; margin-top: 0in; margin-left: 0in; line-height: 115%; margin-right: 0in; font-family: Calibri; font-size: 11.0pt;"> <span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">The term &#x2018;snowbird&#x2019; may take on quite a literal meaning...]]></description>
</item>
<item>
<title>A Familiar Place</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9386/la_id/1.htm</link>
<description><![CDATA[<p class="msonormal"><span style= " font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">Have you ever travelled and visited a place that looked very familiar but you know this is your first time being there? Your head tilts to the side, lines form on your forehead as your eyebrows...]]></description>
</item>
<item>
<title>Out For Some Fresh Air</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9209/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">For the most part, I think that the world is making a bit of a shift, and that people are all trying to live a little bit greener these days. I am also a big believer in the wonders of a good education.&nbsp;<br>...]]></description>
</item>
<item>
<title>Into the Sonoran Sunset</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9188/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">As I&#x2019;m blasted by yet another gust of frigid air, I can&#x2019;t help but think longingly of my Christmas vacation: the warm sun, the sand&#x2026; the cacti? This winter I gave up the beach in favour of a...]]></description>
</item>
<item>
<title>Movin' On Up</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9151/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">A new year usually means new resolutions. It seems that this year, Dubai resolves to be bigger, better, and more opulent than ever &#x2014; like that&#x2019;s even possible.<br> <br> Even with news about Dubai&#x2019;s...]]></description>
</item>
<item>
<title>Joie de Vivre&amp;#8230; On Vacation.</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9108/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">When the frost drops &#x2013; along with the temperatures &#x2013; most people daydream about sunny destinations and hot beaches. However, it seems that no one ever really thinks about going somewhere that is just...]]></description>
</item>
<item>
<title>Staying Inn</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9107/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">The holidays are coming to a close. This is a sad, but very true fact for those of us who haven&#x2019;t quite gotten our much-needed break yet. But fear not, there is still hope for some rest and relaxation in your...]]></description>
</item>
<item>
<title>Bring on the Waves this Holiday Season</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9061/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-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">I was walking downtown the other day and it was not a pleasant stroll.&nbsp;As the bitter cold cut through me like...]]></description>
</item>
<item>
<title>Road Tripping to the Canadian Slopes</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9044/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-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">As I waited for the streetcar in the cold the other day I couldn&#x2019;t help daydreaming about feeling the rays from...]]></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.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.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: 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 = 5666				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 = '1182' AND la_id = '1'
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
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 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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.0008 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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 = 15556
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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.001 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14951
*****************************************************************************************************************
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 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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 = 14900
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0009 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 14820
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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 = 13751
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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 = 13544
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
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 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 13479
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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 = 9796
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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.0013 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9737
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0009 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9570
*****************************************************************************************************************
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 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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 = 9389
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9386
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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 = 9209
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9188
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9151
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.001 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9108
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9107
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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 = 9061
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9044
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:19:54'and a.ci_archiving_date >'2012-02-08 11:19:54'and (
					select
						count(tr.re_activation_date)
					from
						revision tr
					where
						tr.ci_id = coalesce(a.ci_ghosted_item_id, a.ci_id)
                        and tr.re_workflow_approved_datetime is not null
                        and tr.re_activation_date <='2012-02-08 11:19:54'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
*****************************************************************************************************************
Executing custom module for: ci_id: 5683, custom_module_id: 5684, execution time: 0.2167 seconds
*****************************************************************************************************************
Query, execution time: 0.0687 seconds, affected rows: 1
	
			INSERT INTO
				log_visited_content_item
				(
					ci_id,
					la_id,
					lvci_http_user_agent,
					lvci_datetime,
					lvci_http_referer,
					lvci_remote_addr,
					lvci_query_string,
					lvci_path_info,
					lvci_member_uuid,
					lvci_server_uuid
				)
			VALUES
				(
					:ci_id,
					:la_id,
					:http_user_agent,'2012-02-08 11:19:54',
										:http_referer,
					:remote_addr,
					:query_string,
					:path_info,
					:member_uuid,
					:server_uuid
				)
*****************************************************************************************************************
Total number of run queries: 39
Total page execution time: 0.3062 seconds-->
