Article Categories

SELECT `data`
FROM `lor2_session`
WHERE `session_id` = 'db2702218512da762a4468174642c5c6'

DELETE
FROM `lor2_session`
WHERE `time` < 1337566855

SELECT folder AS type, element AS name, params
  FROM lor2_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 lor2_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'

SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
  FROM lor2_menu AS m
  LEFT JOIN lor2_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 lor2_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'

SELECT *
  FROM lor2_languages
  WHERE published=1
  ORDER BY lang_id ASC

SELECT id, home, template, params
FROM lor2_template_styles
WHERE client_id = 0

SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
  FROM lor2_categories as c
  LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_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
  LEFT JOIN `lor2_content` AS i
  ON i.`catid` = c.id
  AND i.state = 1
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1)
  AND c.published = 1
  AND s.id=14
  AND badcats.id is null
  GROUP BY c.id
  ORDER BY c.lft

SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
  FROM lor2_categories as c
  LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_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=19
  AND badcats.id is null
  GROUP BY c.id
  ORDER BY c.lft

SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
  FROM lor2_categories as c
  LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_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=26
  AND badcats.id is null
  GROUP BY c.id
  ORDER BY c.lft

SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
  FROM lor2_categories as c
  LEFT JOIN lor2_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 lor2_categories AS cat JOIN lor2_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=29
  AND badcats.id is null
  GROUP BY c.id
  ORDER BY c.lft

SELECT id, title, module, position, content, showtitle, params, mm.menuid
  FROM lor2_modules AS m
  LEFT JOIN lor2_modules_menu AS mm
  ON mm.moduleid = m.id
  WHERE m.published = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-05-21 02:35:55')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-21 02:35:55')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 272 OR mm.menuid <= 0)
  ORDER BY position, ordering

UPDATE `lor2_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:17;s:19:\"session.timer.start\";i:1337567101;s:18:\"session.timer.last\";i:1337567609;s:17:\"session.timer.now\";i:1337567755;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\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}}}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:13:\"session.token\";s:32:\"4237c2c960208ce672e017197a2e77e6\";s:16:\"com_mailto.links\";a:7:{s:40:\"bccf484ce085d0f83b0d0e25c0b0bd0b7d7c461e\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.villalorena.eu/index.php/directions\";s:6:\"expiry\";i:1337567206;}s:40:\"fd9a51f0cc17c5e1e5b506a134d73188befd02e1\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.villalorena.eu/index.php/growers/23-happy-orange-orchard\";s:6:\"expiry\";i:1337567257;}s:40:\"169add92f0db9eff173f8885d34af67de3e2725d\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.villalorena.eu/index.php/growers/58-wonderful-watermelon\";s:6:\"expiry\";i:1337567257;}s:40:\"2a0ec223c7e286c96a0375e91d04e04674581e10\";O:8:\"stdClass\":2:{s:4:\"link\";s:64:\"http://www.villalorena.eu/index.php/park-blog/17-first-blog-post\";s:6:\"expiry\";i:1337567412;}s:40:\"6f167af117da0e5cfd21e33f8270be1050529856\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"http://www.villalorena.eu/index.php/park-blog/18-second-blog-post\";s:6:\"expiry\";i:1337567412;}s:40:\"d5f754069f9ff1f96669652404ab6b35159ec1af\";O:8:\"stdClass\":2:{s:4:\"link\";s:95:\"http://www.villalorena.eu/index.php/using-joomla/extensions/components/administrator-components\";s:6:\"expiry\";i:1337567558;}s:40:\"41d6347b8a314f6ee81053c18b9496d43f5723b0\";O:8:\"stdClass\":2:{s:4:\"link\";s:88:\"http://www.villalorena.eu/index.php/using-joomla/extensions/components/content-component\";s:6:\"expiry\";i:1337567584;}}}', `time` = 1337567755
WHERE `session_id` = 'db2702218512da762a4468174642c5c6'

Call stack
#	Function	Location
1	JSite->dispatch()	/www/www.dobbelsteijn.net/data/villalorena/index.php:43
2	JComponentHelper::renderComponent()	/www/www.dobbelsteijn.net/data/villalorena/includes/application.php:188
3	JSite->getTemplate()	/www/www.dobbelsteijn.net/data/villalorena/libraries/joomla/application/component/helper.php:102
4	JError::raiseWarning()	/www/www.dobbelsteijn.net/data/villalorena/includes/application.php:466
5	JError::raise()	/www/www.dobbelsteijn.net/data/villalorena/libraries/joomla/error/error.php:194

Nav view search

Navigation

Search

Notice

About Joomla!

This Site

Errors

Information

Backtrace

Profile Information

Memory Usage

14 Queries Logged

11 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: