Growers

We search the whole countryside for the best fruit growers.

You can let each supplier have a page that he or she can edit. To see this in action you will need to create a users who is in the suppliers group.  
Create one page in the growers category for that user and make that supplier the author of the page.  That user will be able to edit his or her page.

This illustrates the use of the Edit Own permission.

Happy Orange Orchard

  • Print

At our orchard we grow the world's best oranges as well as other citrus fruit such as lemons and grapefruit. Our family has been tending this orchard for generations.

Wonderful Watermelon

  • Print

Watermelon is a wonderful and healthy treat. We grow the world's sweetest watermelon. We have the largest watermelon patch in our country.

Profile Information

Application 0.001 seconds (+0.001); 0.94 MB (+0.94) - afterLoad
Application 0.087 seconds (+0.086); 5.01 MB (+4.06) - afterInitialise
Application 0.140 seconds (+0.053); 7.60 MB (+2.60) - afterRoute
Application 0.298 seconds (+0.158); 12.43 MB (+4.82) - afterDispatch
Application 0.388 seconds (+0.090); 13.11 MB (+0.68) - afterRender

Memory Usage

13.13 MB (13,764,832 Bytes)

17 Queries Logged

  1. SELECT `data`
      FROM `lor2_session`
      WHERE `session_id` = 'db2702218512da762a4468174642c5c6'
  2. 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
  3. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM lor2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  4. 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
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM lor2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  6. SELECT *
      FROM lor2_languages
      WHERE published=1
      ORDER BY lang_id ASC
  7. SELECT id, home, template, params
      FROM lor2_template_styles
      WHERE client_id = 0
  8. SELECT b.rules
      FROM lor2_assets AS a
      LEFT JOIN lor2_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM lor2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  10. 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=30
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  11. SELECT b.rules
      FROM lor2_assets AS a
      LEFT JOIN lor2_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content.category.30'
      ORDER BY b.lft
  12. 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 lor2_content AS a
      LEFT JOIN lor2_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN lor2_categories AS c
      ON c.id = a.catid
      LEFT JOIN lor2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN lor2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN lor2_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN lor2_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN lor2_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER 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 a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 30
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-21 02:27:37')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-21 02:27:37')
      ORDER BY c.lft, a.title, a.created
      LIMIT 0, 9
  13. 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 lor2_content AS a
      LEFT JOIN lor2_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN lor2_categories AS c
      ON c.id = a.catid
      LEFT JOIN lor2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN lor2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN lor2_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN lor2_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN lor2_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER 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 a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 30
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-21 02:27:37')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-21 02:27:37')
      ORDER BY c.lft, a.title, a.created
  14. 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=30
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  15. 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:27:37')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-21 02:27:37')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 431 OR mm.menuid <= 0)
      ORDER BY position, ordering
  16. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM lor2_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
  17. UPDATE `lor2_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1337567101;s:18:\"session.timer.last\";i:1337567230;s:17:\"session.timer.now\";i:1337567256;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:13:\"session.token\";s:32:\"4237c2c960208ce672e017197a2e77e6\";s:16:\"com_mailto.links\";a:3:{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;}}}', `time` = 1337567257
      WHERE `session_id` = 'db2702218512da762a4468174642c5c6'

12 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM lor2_extensions
  2. 2 × 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 lor2_content AS a LEFT JOIN lor2_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN lor2_categories AS c ON c.id = a.catid LEFT JOIN lor2_users AS ua ON ua.id = a.created_by LEFT JOIN lor2_users AS uam ON uam.id = a.modified_by LEFT JOIN lor2_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN lor2_categories as parent ON parent.id = c.parent_id LEFT JOIN lor2_content_rating AS v ON a.id = v.content_id LEFT OUTER 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
  3. 2 × SELECT b.rules FROM lor2_assets AS a LEFT JOIN lor2_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  4. 1 × 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
  5. 1 × 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
  6. 1 × 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
  7. 1 × SELECT id, home, template, params FROM lor2_template_styles
  8. 1 × SELECT folder AS type, element AS name, params FROM lor2_extensions
  9. 1 × 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
  10. 1 × SELECT * FROM lor2_languages
  11. 1 × SELECT `data` FROM `lor2_session`
OTHER Tables:
  1. 1 × UPDATE `lor2_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1337567101;s:18:\"session.timer.last\";i:1337567230;s:17:\"session.timer.now\";i:1337567256;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:13:\"session.token\";s:32:\"4237c2c960208ce672e017197a2e77e6\";s:16:\"com_mailto.links\";a:3:{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;}}}', `time` = 1337567257