<?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 Motion</title>
<link>http://www.prism.com/rss</link>
<description><![CDATA[RSS 2.0 List]]></description>
<item>
<title>The Best of Black Friday </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/16334/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0cm; margin-bottom: .0001pt; font-size: 12.0pt; font-family: 'Times New Roman';"><span style=" font-family: Verdana;"><span style=" font-size: small;">Today, our neighbours to the south celebrate American Thanksgiving &#x2014; which means one important thing: Black Friday is just...]]></description>
</item>
<item>
<title>Beyond the Numbers: Why the Strategy for Success in Sports is All About the People</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15675/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0cm; margin-bottom: .0001pt; font-size: 12.0pt; font-family: Cambria;"><span style= " color: black;"><span style=" font-family: Verdana;"><span style=" font-size: small;">He is the anti-</span></span><em><span><span style=" font-family: Verdana;"><span style=" font-size: small;">Moneyball...]]></description>
</item>
<item>
<title>Stormy Night Puts a Damper on Summer</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15232/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: Verdana;"><span style=" font-size: small;">No one would have thought that Ontario would be placed on a tornado watch this summer. But it happened last night, when a thunderous storm rattled through Toronto and the GTA.</span></span><span style=" font-size: small;"><br style=...]]></description>
</item>
<item>
<title>Atlantic Canada International Air Show&amp;#8217;s charitable sales campaign gets ready for take off</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15228/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-right: 0cm; margin-left: 0cm; font-size: 12.0pt; font-family: 'Times New Roman';"><span style=" font-family: Verdana;"><span style=" font-size: small;">Make a wish and fasten your seatbelts. The Atlantic Canada International Air Show is returning and as planes lift off at the former...]]></description>
</item>
<item>
<title>Watching on water</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15205/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0cm; margin-bottom: .0001pt; font-size: 12.0pt; font-family: 'Times New Roman';"><span style=" font-family: Verdana;"><span style=" font-size: small;">Boaters can now take the drive-in movie experience to a whole other level by heading over to Corus Quay on Sugar Beach, where the...]]></description>
</item>
<item>
<title>100 Years Later: Remembering the Titanic with a commemorative cruise</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15199/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;">Director James Cameron may be remaking his </span></span><em><span style=" font-family: Verdana;"><span style= " font-size:...]]></description>
</item>
<item>
<title>Walking on the edge of the CN Tower</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15176/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-top: 0in; margin-right: 0in; margin-bottom: 10.0pt; margin-left: 0in; line-height: 115%; font-size: 11.0pt; font-family: Calibri,sans-serif;"> <span style=" line-height: 115%;"><span style=" font-family: Verdana;"><span style= " font-size: small;">Although many Canadians are enjoying...]]></description>
</item>
<item>
<title>Google Street View Trike makes its way to Toronto </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15145/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;">The company that revolutionized the web with the biggest search engine in the world will bring the image of one of the busiest...]]></description>
</item>
<item>
<title>25 Years of the Honda Indy Toronto with Special Grand Marshal Dan Aykroyd</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/15044/la_id/1.htm</link>
<description><![CDATA[<p><span style=" line-height: 115%;"><span style=" font-size: small;"><span style= " font-family: Verdana;">Imagine</span></span><span style=" font-family: Verdana;"><span style= " font-size: small;"> the speed and embrace the sounds of the annual Honda Indy Toronto. The event is gearing up to take...]]></description>
</item>
<item>
<title>Getting Fit to Fly</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14818/la_id/1.htm</link>
<description><![CDATA[<p>Looking for a lift in your exercise regimen? A little Jukari Fit to Fly may just be the workout for you. The total-body workout created by Cirque du Soleil and Reebok uses a trapeze-like bar to give participants the sensation of flying while &#x201c;strengthening and lengthening the body through...]]></description>
</item>
<item>
<title>Catching Up with the Canada Games</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/14601/la_id/1.htm</link>
<description><![CDATA[<p>Winter is hardly a time to complain, but another opportunity for Canadians to play in the snow at the 2011 Canada Winter Games.<br> <br> The Games are being hosted in Halifax this year, bringing in great tourism and a variety of sports from alpine skiing to wheelchair basketball. With the large selection...]]></description>
</item>
<item>
<title>Glory in the Fall - Book Review</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13903/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin: 0in; font-family: 'Times New Roman', serif; margin-bottom: .0001pt;"> <span style=" font-size: small; font-family: Verdana;">Take a walk down memory lane and reminisce in some of &#x201c;the greatest moments in World Series history.&#x201d; <em>Glory in the Fall</em>...]]></description>
</item>
<item>
<title>Destination Yoga</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13894/la_id/1.htm</link>
<description><![CDATA[<p style= " font-size: 11.0pt; margin-top: 0in; line-height: 115%; margin-bottom: 10.0pt; margin-right: 0in; margin-left: 0in; font-family: Calibri,sans-serif;"> <span style=" font-size: small; font-family: Verdana;">It&#x2019;s commonly thought that when you go on vacation, you should spend your time...]]></description>
</item>
<item>
<title>Hockey Goes Back to the Future</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13865/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana;">Ladies, if you thought it was difficult enough to tear your boyfriend or husband away from the TV during Hockey Night in Canada, H-E Double-Hockey-Sticks, get ready.<br> <br> Now that the CBC has announced they will be broadcasting two games...]]></description>
</item>
<item>
<title>Most Expensive Cars To Insure</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/13528/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana;">Car insurance: Expensive. Driving off the sales lot in the ride of your dreams: Priceless.<br> <br> Saving up for the luxury vehicle of one&#x2019;s choice is a succession of hard work, but when it comes to insurance, some models may put a bigger...]]></description>
</item>
<item>
<title>Bring Back the &amp;#8216;Sunday Drive&amp;#8217;</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/10362/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;">Remember when it wasn&#x2019;t weird to plan a family day around a simple, relaxing drive? Volkswagen Canada does.<br> <br> With their Golf...]]></description>
</item>
<item>
<title>Halladay Becomes Pitcher Perfect</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/10210/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin-bottom: .0001pt; margin: 0in; font-family: 'Times New Roman', serif;"> <span style=" font-size: small; font-family: Verdana;">Roy &#x201c;Doc&#x201d; Halladay finally did it.<br> <br> Halladay, the ex-Jays pitcher, pitched a perfect game. There were no hits, walks...]]></description>
</item>
<item>
<title>Love Spyders? Here&amp;#8217;s A Trip For You</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9936/la_id/1.htm</link>
<description><![CDATA[<p style=" font-size: 12.0pt; margin-bottom: .0001pt; font-family: 'Times New Roman', serif; margin: 0in;"> <span style=" font-size: small; font-family: Verdana;">Chicago&#x2019;s a great city, but for Spyder enthusiasts it can get even better.</span></p> <p style=" font-size: 12.0pt; margin-bottom:...]]></description>
</item>
<item>
<title>Surf&amp;#8217;s up&amp;#8230; Montreal?</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9892/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-bottom: 0in;"><span style=" font-size: small; font-family: Verdana;">For surfing in Canada, the only spot that ever comes to mind is Tofino, B.C.<br> <br> Otherwise, you&#x2019;ve got to be off to the States or Australia or generally somewhere else. But for one group of Quebecers,...]]></description>
</item>
<item>
<title>Do I Spy iSpecs</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9859/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; font-family: Verdana;">I spy with my little eye something that is BIG&#x2026; woah! Where did that person&#x2019;s hand come from?<br> <br> Everything is becoming...]]></description>
</item>
<item>
<title>The Man of the Weekend</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9842/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0in; margin-bottom: .0001pt; font-family: 'Times New Roman'; font-size: 12.0pt;"><span style=" font-size: small; font-family: Verdana;">So how&#x2019;d he do?<br> <br> Of course I don&#x2019;t need to say who <em>he</em></span><span style= " font-size: small; font-style: normal; font-family:...]]></description>
</item>
<item>
<title>Vegetarian Sports Hall of Fame</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9714/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;">Inspired by thoughts of <a onclick= "w=window.open(this.href,'popupwindow','channelmode=no,directories=yes,fullscreen=no,location=yes,menubar=yes,resizable=yes,scrollbars=yes,status=yes,titlebar=yes,toolbar=yes');this.target='popupwindow';w.focus();"...]]></description>
</item>
<item>
<title>The Slippery Slope to Victory</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9481/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-bottom: .0001pt; text-indent: .5in; font-family: 'Times New Roman'; margin: 0in; font-size: 12.0pt;"> <span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">I think it&#x2019;s fair to say that I&#x2019;m obsessed with watching the Winter Olympics. I...]]></description>
</item>
<item>
<title>Canadian Ice Dancers Twirl their Way to Gold</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9479/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-bottom: .0001pt; font-family: Cambria; margin: 0in; font-size: 12.0pt;"><span style= " font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Speaking as somebody with two left feet, I thoroughly respect the brave souls who take to the ice and dance with <em>metal blades</em></span><span...]]></description>
</item>
<item>
<title>Avoiding the Post-Olympic Blues </title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9444/la_id/1.htm</link>
<description><![CDATA[<p style=" font-family: 'Times New Roman'; font-size: 12.0pt; margin: 0in; margin-bottom: .0001pt;"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">It&#x2019;s easy to feel bored now that the Olympics are over. You find yourself asking, &#x201c;What do I watch on...]]></description>
</item>
<item>
<title>Put the Petal to the Metal</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9392/la_id/1.htm</link>
<description><![CDATA[<p style= " margin-bottom: 4.5pt; 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;">It looks like a bike, you ride it like a bike &#x2014; but it&#x2019;s...]]></description>
</item>
<item>
<title>O (No), Canada!</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9350/la_id/1.htm</link>
<description><![CDATA[<p style=" margin-bottom: .0001pt; font-size: 12.0pt; font-family: 'Times New Roman'; margin: 0in;"><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">Our men&#x2019;s Olympic hockey team certainly isn&#x2019;t making this tournament easy for themselves.<br> <br> Already,...]]></description>
</item>
<item>
<title>Sky&amp;#8217;s Never the Limit</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9203/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">I know many people who just love a good thrill. Some of them play sports like rugby, while others make an annual trip to their favourite amusement parks to ride roller coasters for a day. However, these very people...]]></description>
</item>
<item>
<title>Yo, Ho, Ho, and a Bottle of Antiemetics</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9086/la_id/1.htm</link>
<description><![CDATA[<p style=" margin: 0in; font-family: 'Times New Roman'; font-size: 12.0pt; margin-bottom: .0001pt;"><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">There&#x2019;s nothing like a warm, ocean breeze through your hair and the view of the water to reinvigorate the senses...]]></description>
</item>
<item>
<title>Animal Instincts</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9079/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Part bike, part Discovery Channel feature, Argentine designer Pablo Lopez has created a prototype vehicle that imitates the movements of a cheetah in pursuit.</span></p> <p><span style=" font-size: small; font-family:...]]></description>
</item>
<item>
<title>&amp;#8216;Bear&amp;#8217;-ing the Cold</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9071/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">It&#x2019;s a season of giving. So, instead of celebrating the New Year with champagne and fireworks, why not give up a little warmth (and a few layers of clothing), make like a polar bear and dive into a freezing...]]></description>
</item>
<item>
<title>Vertical Limit</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/9063/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-family: Verdana, Arial, Helvetica, Sans-Serif; font-size: small;">Almost everyone who&#x2019;s seen the movie Cliffhanger has probably wanted to channel their inner Sylvester Stallone, or should I say, &#x201c;Gabe Walker&#x201d;. I know I certainly did.<br> <br> The only problem...]]></description>
</item>
<item>
<title>Shifting Gears</title>
<link>http://www.lifestylemagazine.ca//index.php/ci_id/8988/la_id/1.htm</link>
<description><![CDATA[<p><span style=" font-size: small; font-family: Verdana, Arial, Helvetica, Sans-Serif;">Oh, the life of the summer commuter &#x2013; leisurely walks to the cafe, invigorating morning jogs, and bike rides to work that are almost out of a scene from the movie <em>Now</em> <em>and</em> <em>Then</em>.<br>...]]></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.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: 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 = 5906				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 = '1185' AND la_id = '1'
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
			SELECT
				a.ci_id,
				a.ci_uuid,
				a.ci_name,
				a.ci_datetime,
				a.ci_publication_date,
				a.ci_archiving_date,
				a.ct_id,
				a.ci_subcontent,
				a.ci_ghosted_item_id,
				a.ci_order_index,
				(
					SELECT
						COUNT(*)
					FROM
						content_item b
					WHERE
						b.ci_parent_id = a.ci_id
				) as children_count
			FROM
				content_item a
			WHERE
				a.ci_parent_id = :ci_id
      				and a.ct_id in (1)			
						
      				and a.ci_show > 0
				and a.ci_publication_date <='2012-02-08 11:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0012 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 16334
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0012 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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 15675
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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.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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 15232
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15228
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15205
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0009 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15199
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15176
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0011 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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 15145
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 15044
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 14818
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 14601
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'and tr.la_id = :la_id
                ) > 0
        			
						
			ORDER BY ifnull(a.ci_order_index, 9999999) ASC,
				a.ci_name ASC
*****************************************************************************************************************
No compilation is involved, statement is taken from cache
*****************************************************************************************************************
Query affected rows: 3
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 13903
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 13894
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 13865
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 13528
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 10362
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 10210
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0009 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9936
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9892
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9859
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0005 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9842
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 9714
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9481
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9479
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9444
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 9392
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0009 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9350
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0011 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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 9203
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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 = 9086
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0008 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9079
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0012 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9071
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0007 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 9063
*****************************************************************************************************************
Query affected rows: 1
*****************************************************************************************************************
Query, execution time: 0.0006 seconds
SELECT *
					 FROM content_item
					 WHERE ci_id = 8988
*****************************************************************************************************************
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:12:57'and a.ci_archiving_date >'2012-02-08 11:12:57'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:12:57'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.3733 seconds
*****************************************************************************************************************
Query, execution time: 0.0062 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:12:57',
										:http_referer,
					:remote_addr,
					:query_string,
					:path_info,
					:member_uuid,
					:server_uuid
				)
*****************************************************************************************************************
Total number of run queries: 56
Total page execution time: 0.4001 seconds-->
