Log Messages (84)
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [Logger.class.php] - Logger created.
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [Logger.class.php] - Logger thinks SITE_ID is 45
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [Mysql.class.php] - Established connection to db 'orchidsu_demos' on topaz.orchidsuites.net:3306
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select s.*, t.dataset, sc.county_id from demos_site s left join demos_theme t on (t.id = s.theme_id) left join demos_sitecounty sc on s.id = sc.site_id where s.id = 45 limit 1'
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select sk.* from demos_skin sk where sk.id = 1 limit 1'
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [Request.class.php] - Creating request object from POST and GET information...
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [Request.class.php] - ...precedence is 'get'...
2008-11-21 02:35:30 (INFO) 38.103.63.59:40881 [Request.class.php] - ...request created. URI is '/tutorial/ht/display/Articles/view//pid/840'
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [TemplateEngine.class.php] - Created instance of 'smarty' template engine.
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [SessionHandler.class.php] - SessionHandler created:
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [SessionHandler.class.php] - - session name is 'demossession'
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [SessionHandler.class.php] - - session id is ''
2008-11-21 02:35:30 (DEBUG) 38.103.63.59:40881 [OrchidUser.class.php] - Anonymous user created.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Context.class.php] - Context object created.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [orchid.php] - No action requested.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [orchid.php] - Using display class "Articles.class.php"
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select section_id from demos_sectiondisplay where displayname='Articles''
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select * from demos_stafferrole sr where staffer_id=1 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [BaseDisplay.class.php] - Rendering display 'Articles'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select p.survey_id from demos_page p where id = 840 and p.survey_id is not null limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - Checking for administrator rights for 'anonymous'...
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - ...anonymous user - administrator rights NOT granted.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - Checking for technician rights for 'anonymous'...
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - ...anonymous user - technician rights NOT granted.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'SELECT distinct e.* FROM demos_survey e left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = 5266 and sdm.site_id=45) left join demos_sitesurvey ss on (ss.survey_id = e.id and ss.site_id = 45) where e.id=5266 and ((e.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and e.membersonly = '')) and ss.publish = 'Y' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'SELECT sq.required, q.* FROM demos_question q LEFT JOIN demos_sitedatasetmemtype sdm on (sdm.dataset_id = q.id and sdm.site_id=45) left join demos_surveyquestion sq on (sq.question_id = q.id) where ((q.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and q.membersonly = '')) and sq.survey_id = 5266 order by sq.rank'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select * from demos_answer where question_id = 5267'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [TemplateEngine.class.php] - *** Trying to determine if 'Articles.tpl' is cached with id demos|45|Articles|47bca033bae82d033c284673b3ec8c78.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [TemplateEngine.class.php] - *** Touching: /usr/local/orchid-4-7-0/templates/cached/demos_/demos/45/Articles/timestamp
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [TemplateEngine.class.php] - *** Smarty says Articles.tpl is NOT cached.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [TemplateDisplay.class.php] - ++++++++++++++ BEGIN TPLVARS +++++++++++++++++++++++
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select name url from demos_personpersonalization where display='AdminTabs' and value='Y' and person_id=1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select id from demos_page where site_id=45 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - Checking if 'anonymous' is a staffer for THIS site...
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - ...anonymous user - not a staffer user for THIS site.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - Checking if 'anonymous' is a client for THIS site...
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - ...anonymous user - not a client user for THIS site.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - Checking if 'anonymous' is a student for THIS site...
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - ...anonymous user - not a student user for THIS site.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - Checking if 'anonymous' is a caregiver for THIS site...
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - ...anonymous user - not a caregiver user for THIS site.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - Checking if 'anonymous' is an organizational user...
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [OrchidUser.class.php] - ...anonymous user - not an organization user.
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='catproduct' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='catproduct' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct c.id, c.name, c.title, c.description, sc.publish, i.id as image_id, i.thumbbytes, i.imagebytes from demos_cat c left join demos_sitecat sc on ( sc.cat_id = c.id ) left join demos_datasetcat pc on (pc.cat_id = c.id) left join demos_product p on (pc.dataset_id = p.id) left join demos_catcomponent cc on (c.id = cc.cat_id_in) left join demos_catcomponent cp on (c.id = cp.cat_id_for) left join demos_siteprod sp on (p.id = sp.prod_id) left join demos_image i on (i.dataset_id = c.id) where cc.cat_id_for = '9' and (c.id = 9 or sc.site_id = 45 or sc.site_id = 1 ) and (c.dataset='catproduct') and sc.publish = 'Y' order by c.title'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='typeproduct' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select min(id) as id from demos_cat where dataset='typeproduct' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct c.id, c.name, c.title, c.description, sc.publish, i.id as image_id, i.thumbbytes, i.imagebytes from demos_cat c left join demos_sitecat sc on ( sc.cat_id = c.id ) left join demos_datasetcat pc on (pc.cat_id = c.id) left join demos_product p on (pc.dataset_id = p.id) left join demos_catcomponent cc on (c.id = cc.cat_id_in) left join demos_catcomponent cp on (c.id = cp.cat_id_for) left join demos_siteprod sp on (p.id = sp.prod_id) left join demos_image i on (i.dataset_id = c.id) where cc.cat_id_for = '10' and (c.id = 10 or sc.site_id = 45 or sc.site_id = 1 ) and (c.dataset='typeproduct') and sc.publish = 'Y' order by c.title'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select singular_linktext, plural_linktext from demos_theme where id = 5 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select l.*, s.name as state, s.abbreviation as st, s.abbreviation as state_abbr, s.name as state_name from demos_location l left join demos_state s on (s.id = l.state_id) left join demos_dataset ds on (ds.id = l.id) where ds.site_id=45 and l.main='Y' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select c.id, c.name,c.email,c.website from demos_organization c left join demos_dataset ds on (ds.id = c.id) where ds.site_id=45 order by c.id desc limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct p.*, if(b.public_display is null, b.details_display, b.public_display) public_display, b.details_display, b.public_cat_varname, b.parameters bead_parameters from demos_page p left join demos_bead b on (p.bead_id = b.id) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id=p.id and sdm.site_id=45) where p.floating <> 'Y' and p.publish = 'Y' and (p.publishon is null or p.publishon < now()) and (p.expireson is null or p.expireson > now()) and p.site_id=45 and ((sdm.memtype_id is null and p.membersonly <> 'Y') or (sdm.memtype_id is null and p.membersonly = '')) and (sdm.site_id is null or sdm.site_id =45 ) order by p.navloc, p.parent_id, p.rank'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select h.* from demos_home h left join demos_dataset ds on (ds.id = h.id) where ds.site_id=45 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct sb.*, i.id as image_id, i.imagefile, i.imagew, i.imageh, i.imagebytes from demos_sitesidebar si left join demos_sidebar sb on (si.sidebar_id = sb.id) left join demos_sitesidebarpage sp on (sp.sitesidebar_id = si.id) left join demos_image i on (i.dataset_id = sb.id) where si.site_id = 45 and si.publish = 'Y' and (sp.page_id=840) order by si.rank'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct sb.*, i.id as image_id, i.imagefile, i.imagew, i.imageh, i.imagebytes from demos_sitesidebar si left join demos_sidebar sb on (si.sidebar_id = sb.id) left join demos_sitesidebarpage sp on (sp.sitesidebar_id = si.id) left join demos_image i on (i.dataset_id = sb.id) where si.site_id = 45 and si.publish = 'Y' and sp.page_id is null order by si.rank'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct sb.*, i.id as image_id, i.imagefile, i.imagew, i.imageh, i.imagebytes from demos_sitesidebar si left join demos_sidebar sb on (si.sidebar_id = sb.id) left join demos_sitesidebarpage sp on (sp.sitesidebar_id = si.id) left join demos_image i on (i.dataset_id = sb.id) where si.site_id = 45 and si.publish = 'Y' and sp.page_id is not null limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select count(ht.id) as count from demos_hottip ht left join demos_dataset ds on (ht.id = ds.id) where ds.site_id=45 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select ht.* from demos_hottip ht left join demos_dataset ds on (ht.id = ds.id) WHERE ds.site_id = 45 order by rand() limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select count(q.id) as count from demos_quote q left join demos_dataset ds on (q.id = ds.id) where ds.site_id=45 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select q.* from demos_quote q left join demos_dataset ds on (q.id = ds.id) WHERE ds.site_id = 45 order by date desc limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select * from demos_faq f left join demos_faqcat fc on (fc.id = f.faqcat_id) left join demos_dataset ds on (ds.id = f.id and ds.site_id = 45) where fc.publish='Y' and f.publish='Y' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct fc.id, fc.name from demos_faq f left join demos_faqcat fc on (fc.id = f.faqcat_id) left join demos_dataset ds on (ds.id = fc.id and ds.site_id = 45) where fc.publish='Y' and fc.parent_id is null and f.publish='Y' order by fc.name'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct tc.id, tc.name, 'programcats' as thing from demos_siteprogram si left join demos_program tb on (tb.id = si.program_id) left join demos_issuecat tc on (tc.id = tb.issuecat_id) left join demos_siteissuecat sic on sic.issuecat_id = tc.id and (sic.site_id=45 or sic.site_id=1) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'program' ) where sic.publish='Y' and (sic.site_id=45 or sic.site_id=1) and tb.id is not null and tb.id <> 0 and si.publish='Y' and (tb.publishon is null or (tb.publishon is not null and tb.publishon <= now())) and (tb.expireson is null or (tb.expireson is not null and tb.expireson >= now())) and ((tb.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and tb.membersonly = '')) union select distinct tc.id, tc.name, 'linkcats' as thing from demos_sitelink sl left join demos_link tb on (tb.id = sl.link_id) left join demos_linkcat tc on (tc.id = tb.linkcat_id) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'link' ) where sl.site_id=45 and tb.id is not null and tb.id <> 0 and sl.publish='Y' and (tc.parent_id = 0 or tc.parent_id is null) and ((tb.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and tb.membersonly = '')) union select distinct tc.id, tc.name, 'issuecats' as thing from demos_siteissue si left join demos_issue tb on (tb.id = si.issue_id) left join demos_issuecat tc on (tc.id = tb.issuecat_id) left join demos_siteissuecat stc on stc.issuecat_id = tc.id and (stc.site_id=45 or stc.site_id=1) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'issue' ) where stc.publish='Y' and (si.site_id=45 or si.site_id=1) and tb.id is not null and tb.id <> 0 and si.publish='Y' and (tb.publishon is null or (tb.publishon is not null and tb.publishon <= now())) and (tb.expireson is null or (tb.expireson is not null and tb.expireson >= now())) and ((tb.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and tb.membersonly = '')) union select distinct tc.id, tc.name, 'eventcats' as thing from demos_event tb left join demos_eventcat tc on (tc.id = tb.eventcat_id) left join demos_siteevent se on tb.id = se.event_id left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = tb.id and sdm.dataset = 'event' ) where se.site_id=45 and tb.id is not null and tb.id <> 0 and se.publish='Y' and now() < date_add( tb.start_date, interval 2 day ) and ((tb.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and tb.membersonly = '')) order by thing, name'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct s.id from demos_site s left join demos_sitecounty sc on sc.site_id = s.id left join demos_dataset ds on ds.site_id = s.id where s.state_id = 0 and s.theme_id = 1 and sc.id is null order by s.id desc limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select * from demos_registertovote rtv left join demos_dataset ds on (ds.id=rtv.id) where ds.site_id=45 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select * from demos_votebymail vbm left join demos_dataset ds on (ds.id=vbm.id) where ds.site_id=45 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select * from demos_datasetdetails where dataset='article' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [TemplateDisplay.class.php] - ++++++++++++++ END TPLVARS +++++++++++++++++++++++
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select * from demos_datatype where id=4 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select h.* from demos_home h left join demos_dataset ds on (ds.id = h.id) where ds.site_id=45 and h.feature_dataset='article' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select s.id from demos_site s left join demos_sitecounty sc on (sc.site_id = s.id) where s.state_id is null and sc.county_id is null and s.theme_id=5 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select verbiage from demos_pagecontrol where site_id=45 and page='Articles' and tag='content_sorting' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select * from demos_datatype where id=4 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select h.* from demos_home h left join demos_dataset ds on (ds.id = h.id) where ds.site_id=45 and h.feature_dataset='article' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select s.id from demos_site s left join demos_sitecounty sc on (sc.site_id = s.id) where s.state_id is null and sc.county_id is null and s.theme_id=5 limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select verbiage from demos_pagecontrol where site_id=45 and page='Articles' and tag='content_sorting' limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct a.*, ds.site_id, i.id as image_id, i.imagebytes as imagebytes, i.imagew as imagew, i.imageh as imageh, i.thumbbytes as thumbbytes, i.thumbw as thumbw, i.thumbh as thumbh, ic.name as catname from demos_article a left join demos_dataset ds on (a.id = ds.id) left join demos_image i on (i.dataset_id = a.id) left join demos_sitearticle sa on (a.id = sa.article_id) left join demos_sitedatasetmemtype sdm on (a.id = sdm.dataset_id and sdm.site_id=45) left join demos_issuecat ic on (a.issuecat_id = ic.id) WHERE (ds.removedon is null) AND (ds.site_id=45 or a.shared='Y') AND ((a.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and a.membersonly = '') or a.pubblurb = 'Y') AND (a.publishon is null or (a.publishon is not null and a.publishon <= now())) AND (a.expireson is null or (a.expireson is not null and a.expireson >= now())) AND (( sa.site_id=45 and sa.publish='Y' ) or ( sa.site_id=1 and sa.publish='Y' and (a.pushlocal = 'Y' or a.pushstate = 'Y') )) order by a.date desc limit 0,500'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select count(*) as count from demos_article a left join demos_dataset ds on (a.id = ds.id) left join demos_image i on (i.dataset_id = a.id) left join demos_sitearticle sa on (a.id = sa.article_id) left join demos_sitedatasetmemtype sdm on (a.id = sdm.dataset_id and sdm.site_id=45) left join demos_issuecat ic on (a.issuecat_id = ic.id) WHERE (ds.removedon is null) AND (ds.site_id=45 or a.shared='Y') AND ((a.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and a.membersonly = '') or a.pubblurb = 'Y') AND (a.publishon is null or (a.publishon is not null and a.publishon <= now())) AND (a.expireson is null or (a.expireson is not null and a.expireson >= now())) AND (( sa.site_id=45 and sa.publish='Y' ) or ( sa.site_id=1 and sa.publish='Y' and (a.pushlocal = 'Y' or a.pushstate = 'Y') )) limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct a.*, ds.site_id, i.id as image_id, i.imagebytes as imagebytes, i.imagew as imagew, i.imageh as imageh, i.thumbbytes as thumbbytes, i.thumbw as thumbw, i.thumbh as thumbh, ic.name as catname from demos_article a left join demos_dataset ds on (a.id = ds.id) left join demos_image i on (i.dataset_id = a.id) left join demos_sitearticle sa on (a.id = sa.article_id) left join demos_sitedatasetmemtype sdm on (a.id = sdm.dataset_id and sdm.site_id=45) left join demos_issuecat ic on (a.issuecat_id = ic.id) WHERE (ds.removedon is null) AND (ds.site_id=45 or a.shared='Y') AND ((a.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and a.membersonly = '') or a.pubblurb = 'Y') AND (a.publishon is null or (a.publishon is not null and a.publishon <= now())) AND (a.expireson is null or (a.expireson is not null and a.expireson >= now())) AND (( sa.site_id=45 and sa.publish='Y' ) or ( sa.site_id=1 and sa.publish='Y' and (a.pushlocal = 'Y' or a.pushstate = 'Y') )) order by a.date desc limit 1'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select distinct tc.id, tc.name from demos_sitearticle si left join demos_article a on (a.id = si.article_id) left join demos_issuecat tc on (tc.id = a.issuecat_id) left join demos_siteissuecat sic on sic.issuecat_id = tc.id and (sic.site_id=45) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = a.id and sdm.dataset = 'article' ) where sic.publish='Y' and (sic.site_id=45 or sic.site_id=1) and a.id is not null and a.id <> 0 and si.publish='Y' and (a.publishon is null or (a.publishon is not null and a.publishon <= now())) and (a.expireson is null or (a.expireson is not null and a.expireson >= now()))and ((a.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and a.membersonly = '') or a.pubblurb = 'Y') order by tc.name'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select sf.*, a.*, ft.type as feedtype from demos_sitefeed sf left join demos_feed a on (a.id = sf.feed_id) left join demos_feedtype ft on (ft.id = a.feedtype_id) left join demos_sitedatasetmemtype sdm on (sdm.dataset_id = a.id and sdm.dataset = 'article' ) where sf.site_id=45 and sf.article_count > 0 and sf.publish = 'Y'and ((a.membersonly <> 'Y' and sdm.memtype_id is null) or (sdm.memtype_id is null and a.membersonly = ''))'
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [Mysql.class.php] - Executing SQL select: 'select tag,visible,verbiage,editable from demos_pagecontrol where site_id=45 and page='Articles''
2008-11-21 02:35:30 (DEBUG) [1] 38.103.63.59:40881 [TemplateEngine.class.php] - Caching ***ON*** for template 'screen-header-1.tpl', id is demos|45|Articles|47bca033bae82d033c284673b3ec8c78.
