Town of St. Francisville, PO Box 400, St. Francisville, La. 70775 / Tel. (225) 635-3688 / This e-mail address is being protected from spambots. You need JavaScript enabled to view it. /

Scenic surroundings. Town with Plenty of Country
Town Hall located on Ferdinand St. Town Hall - St. Francisville, La.
Rest and Relax for a Spell. Take A Break
Festivals enjoyed by residents and visitors. Sweet Sales
Discover the history! St. Francisville Past
Living in Harmony Quiet Living
Activities on the River Mississippi River
Many Unique Shops Local Shopping
Activities along the banks of the Mississippi River. Industry
Everyone enjoys a parade. A Time to Celebrate.

Newsflash:

Mainstreet Program

How does The Program work?

The Louisiana Main Street is a community-driven revitalization program designed to promote the historic and economic redevelopment of traditional commercial districts in Louisiana

Area Tourism

What brings tourist to St. Francisville?

St. Francisville, La. is a tourist destination for visitors appreciating historic antebellum plantations, civil war history, 1830's culture, quiet small town, country setting, abundant wildlife and much more. Enjoy the historic district with historic churches, small shops, restaurants and bed & breakfast.

Film & Video

Why the film industry is so excited?

Promoting a thriving film and video production community in St. Francisville and West Feliciana Parish by providing a skilled liaison for one-on-one assisstance knowledgeable in local ordinances, permits, services, location scouting, traffic control, catering and lodging.

22
Oct 11

Mayor's Office

Super User

Welcome! Thank you for your interest in St. Francisville. I'm proud to share my beautiful little hometown with y'all. You will soon see how truly unique to Louisiana and the South, we are. I look forward to your visit here soon!
We are an "open-door" community, drop in for a visit anytime. Town Hall is located at, 11936 Ferdinand Street in the Historic District St. Francisville.

Mayor
Mayor Billy D'Aquilla Mayor of St. Francisville (225) 635-3282 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.		Responsibilities: All town activities, including postions appointments, oversees; town departments, etc. Position Status: elected by public vote for a four year term.

Town Clerk
Diane Tygres Town Clerk (225) 635-3688 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.		Responsibilities: All town activities, including postions appointments, oversees; town departments, etc. Position Status: elected by public vote for a four year term.

Accounts Receivable
Lisa Byrant Accounts Receivable (225) 635-3688 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.		Responsibilities: All town activities, including postions appointments, oversees; town departments, etc. Position Status: elected by public vote for a four year term.

Deputy Town Clerk
Melinda Foil Deputy Town Clerk (225) 635-3688		Responsibilities: All town activities, including postions appointments, oversees; town departments, etc. Position Status: elected by public vote for a four year term.

Accounts Payable
Becky Slade Accounts Payable (225) 635-3688 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.		Responsibilities: All town activities, including postions appointments, oversees; town departments, etc. Position Status: elected by public vote for a four year term.

About the Mayor

Mayor Billy D'Aquallia, through his leadership of over twenty years, has been instrumental in many of the recent milestones in commerce while keeping the quality of life which has made St. Francisville, soothing to the soul.

Mayor's Office

Photo Preview

Helpful Contacts

Profile Information

Application 0.002 seconds (+0.002); 1.16 MB (+1.158) - afterLoad

Application 0.125 seconds (+0.123); 6.18 MB (+5.026) - afterInitialise

Application 0.167 seconds (+0.043); 8.32 MB (+2.133) - afterRoute

Application 0.577 seconds (+0.409); 13.03 MB (+4.709) - afterDispatch

Application 0.720 seconds (+0.144); 17.34 MB (+4.313) - beforeRenderModule mod_roknavmenu ()

Application 0.887 seconds (+0.166); 19.33 MB (+1.990) - afterRenderModule mod_roknavmenu ()

Application 0.915 seconds (+0.028); 19.28 MB (-0.051) - beforeRenderModule mod_custom (icon town small copyright)

Application 0.920 seconds (+0.005); 19.29 MB (+0.016) - afterRenderModule mod_custom (icon town small copyright)

Application 0.920 seconds (+0.000); 19.29 MB (-0.003) - beforeRenderModule mod_custom (bottom - header)

Application 0.921 seconds (+0.002); 19.30 MB (+0.005) - afterRenderModule mod_custom (bottom - header)

Application 0.922 seconds (+0.000); 19.29 MB (-0.002) - beforeRenderModule mod_menu (Helpful Contacts)

Application 0.931 seconds (+0.009); 19.35 MB (+0.060) - afterRenderModule mod_menu (Helpful Contacts)

Application 0.931 seconds (+0.000); 19.35 MB (-0.004) - beforeRenderModule mod_rokgallery (Photo Preview)

Application 1.285 seconds (+0.354); 29.77 MB (+10.419) - afterRenderModule mod_rokgallery (Photo Preview)

Application 1.286 seconds (+0.000); 29.68 MB (-0.092) - beforeRenderModule mod_custom (About the Mayor)

Application 1.287 seconds (+0.002); 29.68 MB (+0.005) - afterRenderModule mod_custom (About the Mayor)

Application 1.288 seconds (+0.000); 29.68 MB (-0.002) - beforeRenderModule mod_fbfanbox (St. Francisville Fanbox)

Application 1.303 seconds (+0.016); 29.71 MB (+0.027) - afterRenderModule mod_fbfanbox (St. Francisville Fanbox)

Application 1.303 seconds (+0.000); 29.70 MB (-0.004) - beforeRenderModule mod_fbfanbox (Main Street - SF)

Application 1.304 seconds (+0.001); 29.71 MB (+0.007) - afterRenderModule mod_fbfanbox (Main Street - SF)

Application 1.304 seconds (+0.000); 29.70 MB (-0.005) - beforeRenderModule mod_custom (Film and Video - front page)

Application 1.306 seconds (+0.002); 29.71 MB (+0.005) - afterRenderModule mod_custom (Film and Video - front page)

Application 1.306 seconds (+0.000); 29.71 MB (-0.002) - beforeRenderModule mod_custom (Tourism - Area module)

Application 1.308 seconds (+0.002); 29.71 MB (+0.005) - afterRenderModule mod_custom (Tourism - Area module)

Application 1.308 seconds (+0.000); 29.71 MB (-0.002) - beforeRenderModule mod_custom (Mainstreet Program)

Application 1.310 seconds (+0.002); 29.71 MB (+0.005) - afterRenderModule mod_custom (Mainstreet Program)

Application 1.310 seconds (+0.000); 29.71 MB (-0.000) - beforeRenderModule mod_roknewsflash (NewsFlash Town)

Application 1.330 seconds (+0.020); 30.13 MB (+0.414) - afterRenderModule mod_roknewsflash (NewsFlash Town)

Application 1.330 seconds (+0.000); 30.12 MB (-0.010) - beforeRenderModule mod_rokgallery (FP RokGallery - Town)

Application 1.391 seconds (+0.061); 30.48 MB (+0.364) - afterRenderModule mod_rokgallery (FP RokGallery - Town)

Application 1.391 seconds (+0.000); 30.35 MB (-0.129) - beforeRenderModule mod_custom (Top Town Address)

Application 1.393 seconds (+0.002); 30.36 MB (+0.006) - afterRenderModule mod_custom (Top Town Address)

Application 1.728 seconds (+0.335); 30.50 MB (+0.144) - afterRender

Memory Usage

30.54 MB (32,022,160 Bytes)

32 Queries Logged

SELECT `data`
FROM `pyzm9_session`
WHERE `session_id` = 'b060503584aef3e8c36e77f29f8b2da5'
DELETE
FROM `pyzm9_session`
WHERE `time` < 1337451379
SELECT folder AS type, element AS name, params
  FROM pyzm9_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM pyzm9_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
SELECT `value`
FROM `pyzm9_admintools_storage`
WHERE `key` = 'cparams'
SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM pyzm9_menu AS m
  LEFT JOIN pyzm9_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  AND m.access IN (1,1)
  ORDER BY m.lft
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM pyzm9_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM pyzm9_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_rokcandy'
SELECT *
FROM pyzm9_rokcandy
WHERE published=1
SELECT id, home, template, s.params
  FROM pyzm9_template_styles as s
  LEFT JOIN pyzm9_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
SELECT *
  FROM pyzm9_languages
  WHERE published=1
  ORDER BY ordering ASC
SELECT b.rules
  FROM pyzm9_assets AS a
  LEFT JOIN pyzm9_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.name = 'com_content'
  ORDER BY b.lft
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM pyzm9_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
  FROM pyzm9_content AS a
  LEFT JOIN pyzm9_categories AS c
  on c.id = a.catid
  LEFT JOIN pyzm9_users AS u
  on u.id = a.created_by
  LEFT JOIN pyzm9_contact_details AS contact
  on contact.user_id = a.created_by
  LEFT JOIN pyzm9_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN pyzm9_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM pyzm9_categories AS cat JOIN pyzm9_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published <= 0
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE a.id = 24
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 18:31:19')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:31:19')
  AND (a.state = 1 OR a.state =2)
SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
  FROM pyzm9_categories as c
  LEFT JOIN pyzm9_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM pyzm9_categories AS cat JOIN pyzm9_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1)
  AND c.published = 1
  AND s.id=11
  AND badcats.id is null
  GROUP BY c.id
  ORDER BY c.lft
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM pyzm9_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_phocadownload'
SELECT *
FROM pyzm9_contact_details
WHERE id =11
SELECT *
FROM pyzm9_contact_details
WHERE id =7
SELECT *
FROM pyzm9_contact_details
WHERE id =8
SELECT *
FROM pyzm9_contact_details
WHERE id =9
SELECT *
FROM pyzm9_contact_details
WHERE id =10
UPDATE pyzm9_content
SET hits = hits + 1
WHERE id = 24
SELECT id, home, template, params
FROM pyzm9_template_styles
WHERE client_id = 0
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM pyzm9_modules AS m
  LEFT JOIN pyzm9_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN pyzm9_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-05-19 18:31:20')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-19 18:31:20')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 101 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
SELECT template
  FROM pyzm9_template_styles
  WHERE home = 1
  AND client_id = 0
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM pyzm9_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_contact'
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM pyzm9_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_weblinks'
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM pyzm9_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_rokgallery'
SELECT id, rules
FROM `pyzm9_viewlevels`
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM pyzm9_content AS a
  LEFT JOIN pyzm9_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN pyzm9_categories AS c
  ON c.id = a.catid
  LEFT JOIN pyzm9_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN pyzm9_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN pyzm9_contact_details AS contact
  on contact.user_id = a.created_by
  LEFT JOIN pyzm9_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN pyzm9_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM pyzm9_categories AS cat JOIN pyzm9_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id ) AS badcats
  ON badcats.id = c.id
  WHERE a.access IN (1,1)
  AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND a.catid = 10
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 18:31:20')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:31:20')
  GROUP BY a.id
  ORDER BY a.id DESC
  LIMIT 0, 4
SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
  FROM pyzm9_categories as c
  LEFT JOIN pyzm9_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM pyzm9_categories AS cat JOIN pyzm9_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1)
  AND c.published = 1
  AND s.id=10
  AND badcats.id is null
  GROUP BY c.id
  ORDER BY c.lft
UPDATE `pyzm9_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:12;s:19:\"session.timer.start\";i:1337451823;s:18:\"session.timer.last\";i:1337452256;s:17:\"session.timer.now\";i:1337452279;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:6:{s:40:\"d16d3ada3f11c04681ce8dfc0e6d6ffca5f761c6\";O:8:\"stdClass\":2:{s:4:\"link\";s:92:\"http://www.travelstfrancisville.com/index.php/2-uncategorised/5-welcome-st-francisville.html\";s:6:\"expiry\";i:1337451999;}s:40:\"2ce7089a465d1b111f182891e619ddf6841172c7\";O:8:\"stdClass\":2:{s:4:\"link\";s:87:\"http://www.travelstfrancisville.com/index.php/10-launcher-content/2-layout-options.html\";s:6:\"expiry\";i:1337451947;}s:40:\"0085919b3ef3013d589cfedbff3c3665676367fe\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://www.travelstfrancisville.com/index.php/12-tourism/16-events.html\";s:6:\"expiry\";i:1337452141;}s:40:\"c371f47ea80269b2e5a749632d18520670bf2431\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"http://www.travelstfrancisville.com/index.php/tourism/lodging-parish.html\";s:6:\"expiry\";i:1337452176;}s:40:\"9a5241bc9aab2b8fe57b9e92b90f2fe590012dfb\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.travelstfrancisville.com/index.php/tourism/restaurants-town-2.html\";s:6:\"expiry\";i:1337452204;}s:40:\"2d89ceaad49528d28497b7571c84e57e7b35d73b\";O:8:\"stdClass\":2:{s:4:\"link\";s:64:\"http://www.travelstfrancisville.com/index.php/mayors-office.html\";s:6:\"expiry\";i:1337452279;}}}com_rokgallery|a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}', `time` = 1337452281
WHERE `session_id` = 'b060503584aef3e8c36e77f29f8b2da5'

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

8 × SELECT extension_id AS "id", element AS "option", params, enabled FROM pyzm9_extensions
5 × SELECT * FROM pyzm9_contact_details
2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM pyzm9_categories as c LEFT JOIN pyzm9_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM pyzm9_categories AS cat JOIN pyzm9_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT id, home, template, params FROM pyzm9_template_styles
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM pyzm9_modules AS m LEFT JOIN pyzm9_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN pyzm9_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT template FROM pyzm9_template_styles
1 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM pyzm9_content AS a LEFT JOIN pyzm9_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN pyzm9_categories AS c ON c.id = a.catid LEFT JOIN pyzm9_users AS ua ON ua.id = a.created_by LEFT JOIN pyzm9_users AS uam ON uam.id = a.modified_by LEFT JOIN pyzm9_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN pyzm9_categories as parent ON parent.id = c.parent_id LEFT JOIN pyzm9_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM pyzm9_categories AS cat JOIN pyzm9_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT id, rules FROM `pyzm9_viewlevels
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM pyzm9_content AS a LEFT JOIN pyzm9_categories AS c on c.id = a.catid LEFT JOIN pyzm9_users AS u on u.id = a.created_by LEFT JOIN pyzm9_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN pyzm9_categories as parent ON parent.id = c.parent_id LEFT JOIN pyzm9_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM pyzm9_categories AS cat JOIN pyzm9_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT b.rules FROM pyzm9_assets AS a LEFT JOIN pyzm9_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `value` FROM `pyzm9_admintools_storage`
1 × SELECT folder AS type, element AS name, params FROM pyzm9_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM pyzm9_menu AS m LEFT JOIN pyzm9_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM pyzm9_rokcandy
1 × SELECT * FROM pyzm9_languages
1 × SELECT id, home, template, s.params FROM pyzm9_template_styles as s LEFT JOIN pyzm9_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT `data` FROM `pyzm9_session`

OTHER Tables:

1 × UPDATE `pyzm9_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:12;s:19:\"session.timer.start\";i:1337451823;s:18:\"session.timer.last\";i:1337452256;s:17:\"session.timer.now\";i:1337452279;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:6:{s:40:\"d16d3ada3f11c04681ce8dfc0e6d6ffca5f761c6\";O:8:\"stdClass\":2:{s:4:\"link\";s:92:\"http://www.travelstfrancisville.com/index.php/2-uncategorised/5-welcome-st-francisville.html\";s:6:\"expiry\";i:1337451999;}s:40:\"2ce7089a465d1b111f182891e619ddf6841172c7\";O:8:\"stdClass\":2:{s:4:\"link\";s:87:\"http://www.travelstfrancisville.com/index.php/10-launcher-content/2-layout-options.html\";s:6:\"expiry\";i:1337451947;}s:40:\"0085919b3ef3013d589cfedbff3c3665676367fe\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://www.travelstfrancisville.com/index.php/12-tourism/16-events.html\";s:6:\"expiry\";i:1337452141;}s:40:\"c371f47ea80269b2e5a749632d18520670bf2431\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"http://www.travelstfrancisville.com/index.php/tourism/lodging-parish.html\";s:6:\"expiry\";i:1337452176;}s:40:\"9a5241bc9aab2b8fe57b9e92b90f2fe590012dfb\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.travelstfrancisville.com/index.php/tourism/restaurants-town-2.html\";s:6:\"expiry\";i:1337452204;}s:40:\"2d89ceaad49528d28497b7571c84e57e7b35d73b\";O:8:\"stdClass\":2:{s:4:\"link\";s:64:\"http://www.travelstfrancisville.com/index.php/mayors-office.html\";s:6:\"expiry\";i:1337452279;}}}com_rokgallery|a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}', `time` = 1337452281
1 × UPDATE pyzm9_content SET hits = hits + 1
1 × DELETE FROM `pyzm9_session`

Mainstreet Program

Area Tourism

Film & Video

Mayor's Office

Mayor

Town Clerk

Accounts Receivable

Deputy Town Clerk

Accounts Payable

About the Mayor

Photo Preview

Helpful Contacts

Profile Information

Memory Usage

32 Queries Logged

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: