Securing the Future PortalHealth and Social Care PortalEfficiency and Productivity Portal

SB: What role can Innovation play in driving growth within the UK?

RC: Innovation is very broad; it includes research and development, marketing, skills development, training, management and distribution. Innovation was responsible for two thirds of the UK’s productivity growth between 2000-07. The majority of this productivity growth was not R&D; but other forms of tangible investment. Innovative firms grow twice as fast as non-innovative firms and they typically see their turnover double compared to non-innovative firms.  63% of all the annual labour growth since 2000 has been through innovation so there is no doubt it plays a key role within this country.

SB: How important are the innovation hubs?

RC: Potentially so but it’s all down to delivery but there is no doubting the importance of what they are trying to achieve: innovation is at the heart of productivity growth and employment growth. Innovative firms typically internationalise faster than non-innovative companies. The great surge of employment growth in development countries has been down to innovation, so there is scope for hubs to deliver success.

SB: Can innovation help get people back to work?


RC: A complex question, if firms innovate then their productivity will be boosted where as non-innovative firms will struggle. Many non-innovative companies  can and do survive but  it gets harder and harder because of the growth in internationalisation; competition is increasingly fierce, again this is not simply R&D; it is much broader- such as how good is your marketing, distribution? And management skills? We must remember firms do not set out with a main goal to create employment that’s a by product of their desire to make profits. But unless we have more innovative firms we will not tackle the long-term threat of unemployment and, in order to do this firms must first be making profits and these come from being innovative.

SB: Is there still a north-south divide in terms of investment into innovation?

RC: Fast growing firms are distributed well across the UK, but a recent Sunday Times fast growing business report showed that within the top 100 there was an enormous number, well over 50%, of firms based in the South-East and London. The government says it is committed to re-balancing the economy in terms of moving away from financial services to manufacturing; however there are two issues with this re-balancing. Firstly, financial services are disproportionately located in the South-East and secondly the bulk of manufacturing output in the UK also comes from the South-East. Worryingly Regional divide is not narrowing, The abolition of the RDA’s, may worsen this situation  because they were an important source of investment capital the moment , looking at the data, you cannot see this divide closing and it will probably get worse and the re-balancing however well intended will not make much of a difference.

SB: What are the reasons for this shift in manufacturing from north to south?

RC: The North clearly has strong pockets of innovation innovation at its heart .For example, Nissan in the North East The North-West also has many good innovative firms but there are still some areas which are struggling to create fast growing innovative firms II worry that Liverpool is still struggling despite the revitalisation of the city centre which has been terrific. The big challenge is how to get higher value manufacturing  and innovation into the north. The south is still dominating in terms of driving growth, for instance; the South-East- Cambridge with life science, London with its financial services and creative industries. There are undoubtedly strong innovation areas in the north, however the capital is still disproportionately flowing into London and the South East and talent tends to follow this flow. There is a worry that the abolition of influential RDA’s may exacerbate this situation. The RDA’s were incredibly effective in pursuing inward investment and their loss raises the spectre of a serious disruption to this important flow. Also, remember that inward investors tend to have higher productivity and be more innovative.

SB: What are NESTA currently doing in terms of innovation development in the north?

RC: Our Chief Executive is determined to do more; however, we have already seen our investment arm take positions in companies as Plasma Clean, based in Stockport .growth. We have worked with local authorities such as Rossendale, Wigan, York and Stoke and Trent through our “Make it Local” campaign which brings local authorities together with digital agencies to unleash public data that authorities currently own for use as commercial purposes or web-based services for citizens. There is opportunity to do more in the north and take forward the message that innovation is at the heart of competiveness. The loss of RDA’s will leave a vacuum for a while, so we must make sure that the Local Enterprise Partnerships continue the RDA’s work and deliver progress to the north.

Written by Robert Crawford
Monday, 09 January 2012 11:11

Add comment



Refresh

Most Read Tags

Interviews

The Govtoday Debate

David Wathey, Head of Sustainable Procurement, Department of Health

FORTHCOMING EVENTS / POST-EVENT DEBATES

GovToday Limited Peter House Oxford Street Manchester M1 5AN

Copyright © 2012 Govtoday. All Rights Reserved.

Profile Information

Application 0.001 seconds (+0.001); 1.15 MB (+1.150) - afterLoad
Application 0.051 seconds (+0.050); 6.35 MB (+5.200) - afterInitialise
Application 0.080 seconds (+0.029); 12.01 MB (+5.656) - afterRoute
Application 0.113 seconds (+0.033); 15.85 MB (+3.839) - afterDispatch
Application 0.118 seconds (+0.005); 16.14 MB (+0.296) - beforeRenderModule mod_footer (Footer)
Application 0.119 seconds (+0.001); 16.18 MB (+0.035) - afterRenderModule mod_footer (Footer)
Application 0.119 seconds (+0.000); 16.17 MB (-0.003) - beforeRenderModule mod_menu (Footer Menu)
Application 0.123 seconds (+0.004); 16.25 MB (+0.073) - afterRenderModule mod_menu (Footer Menu)
Application 0.124 seconds (+0.000); 16.24 MB (-0.007) - beforeRenderModule mod_gov_tv (Govtoday TV)
Application 0.127 seconds (+0.003); 16.28 MB (+0.042) - afterRenderModule mod_gov_tv (Govtoday TV)
Application 0.127 seconds (+0.000); 16.26 MB (-0.023) - beforeRenderModule mod_banners (FORTHCOMING EVENTS / POST-EVENT DEBATES)
Application 0.136 seconds (+0.010); 16.54 MB (+0.280) - afterRenderModule mod_banners (FORTHCOMING EVENTS / POST-EVENT DEBATES)
Application 0.136 seconds (+0.000); 16.52 MB (-0.017) - beforeRenderModule mod_gtsearch (GT Search)
Application 0.138 seconds (+0.001); 16.54 MB (+0.015) - afterRenderModule mod_gtsearch (GT Search)
Application 0.138 seconds (+0.000); 16.53 MB (-0.002) - beforeRenderModule mod_feature (Editor's Feature)
Application 0.199 seconds (+0.061); 16.57 MB (+0.040) - afterRenderModule mod_feature (Editor's Feature)
Application 0.199 seconds (+0.000); 16.57 MB (+0.001) - beforeRenderModule mod_comments_read (Comment and Most Read)
Application 0.228 seconds (+0.029); 16.62 MB (+0.048) - afterRenderModule mod_comments_read (Comment and Most Read)
Application 0.228 seconds (+0.000); 16.64 MB (+0.015) - beforeRenderModule mod_gttag (Most Read Tags)
Application 0.238 seconds (+0.010); 16.78 MB (+0.139) - afterRenderModule mod_gttag (Most Read Tags)
Application 0.238 seconds (+0.000); 16.74 MB (-0.039) - beforeRenderModule mod_menu (Gov Menu)
Application 0.246 seconds (+0.008); 16.76 MB (+0.026) - afterRenderModule mod_menu (Gov Menu)
Application 0.247 seconds (+0.000); 16.76 MB (-0.004) - beforeRenderModule mod_menu (Top Menu)
Application 0.249 seconds (+0.003); 16.77 MB (+0.014) - afterRenderModule mod_menu (Top Menu)
Application 0.249 seconds (+0.000); 16.76 MB (-0.013) - beforeRenderModule mod_syndicate (Syndication)
Application 0.251 seconds (+0.002); 16.81 MB (+0.048) - afterRenderModule mod_syndicate (Syndication)
Application 0.251 seconds (+0.000); 16.81 MB (+0.001) - beforeRenderModule mod_cblogin (CB Login)
Application 0.264 seconds (+0.013); 18.73 MB (+1.924) - afterRenderModule mod_cblogin (CB Login)
Application 0.271 seconds (+0.007); 18.81 MB (+0.072) - afterRender

Memory Usage

18.83 MB (19,739,528 Bytes)

76 Queries Logged

  1. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '7op7pud180fdav772gqv2ejns4'
  2. DELETE
      FROM `jos_session`
      WHERE `time` < 1330909325
  3. SELECT folder AS type, element AS name, params
      FROM jos_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_kunena'
  6. 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 jos_menu AS m
      LEFT JOIN jos_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
  7. SELECT *
      FROM jos_jcomments_settings
  8. select *
      from jos_web
      where weburl like '%http://www.govtoday.co.uk/%'
      LIMIT 0, 1
  9. SELECT id, home, template, s.params
      FROM jos_template_styles as s
      LEFT JOIN jos_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
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. SELECT *
      FROM jos_languages
      WHERE published=1
      ORDER BY ordering ASC
  12. SELECT b.rules
      FROM jos_assets AS a
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  13. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  14. 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 jos_content AS a
      LEFT JOIN jos_categories AS c
      on c.id = a.catid
      LEFT JOIN jos_users AS u
      on u.id = a.created_by
      LEFT JOIN jos_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_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 = 9326
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-03-05 03:02:05')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-03-05 03:02:05')
  15. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jos_categories as c
      LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=108
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  16. select *
      from jos_tag_term_content as a, jos_tag_term as b
      where a.tid = b.id
      and a.cid = 9326
  17. SELECT *
      FROM `jos_jcomments_objects`
      WHERE `object_id` = '9326'
      AND `object_group` = 'com_content'
      AND `lang` = 'en-GB'
  18. SELECT count(*)
      FROM jos_jcomments AS c
      WHERE c.object_id = 9326
      AND c.object_group = 'com_content'
      AND c.published = 1
  19. UPDATE jos_content
      SET hits = hits + 1
      WHERE id = 9326
  20. select (a.catid)catid,(b.level)level
      from jos_content as a, jos_categories as b
      where a.catid = b.id
      and a.id = 9326
  21. SELECT *
      FROM jos_categories
      WHERE id='108'
  22. SELECT *
      FROM jos_categories
      WHERE id='108'
  23. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_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-03-05 03:02:05')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-03-05 03:02:05')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  24. select *
      from jos_web_media
      where active = 1
      and webtype = 'interview'
      and govtoday = 1
      order by id desc
      limit 10
  25. SELECT *
      FROM jos_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  26. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM jos_banners as a
      LEFT JOIN jos_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN jos_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 2
      AND cl.state = 1
      AND a.catid IN (130)
      ORDER BY a.sticky DESC,a.ordering
  27. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM jos_banners as a
      LEFT JOIN jos_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN jos_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 2
      AND cl.state = 1
      AND a.catid IN (130)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 3
  28. UPDATE jos_banners
      SET impmade = (impmade + 1)
      WHERE id = 6
  29. UPDATE jos_banners
      SET impmade = (impmade + 1)
      WHERE id = 7
  30. UPDATE jos_banners
      SET impmade = (impmade + 1)
      WHERE id = 1
  31. select *
      from jos_event_web as a
      inner join jos_web as b
      on b.id = a.webid
      where main = 1
      and webid = 2
  32. select id,title,catid,introtext,created_by
      from jos_content
      where state = 1
      and attribs like '%"feature":"1"%'
      order by created desc
      limit 6
  33. select id,title,catid,introtext,created_by
      from jos_content
      where state = 1
      and attribs like '%"feature":"1"%'
      order by created desc
      limit 6
  34. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 28203
  35. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 43
  36. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 23436
  37. SELECT *
      FROM jos_categories
      WHERE id='31'
  38. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 31
  39. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 9264
  40. SELECT *
      FROM jos_categories
      WHERE id='12'
  41. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 12
  42. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 28076
  43. SELECT *
      FROM jos_categories
      WHERE id='106'
  44. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 106
  45. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 28034
  46. SELECT *
      FROM jos_categories
      WHERE id='21'
  47. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 21
  48. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 27984
  49. SELECT *
      FROM jos_categories
      WHERE id='106'
  50. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 106
  51. SELECT *
      FROM jos_categories
      WHERE id='43'
  52. select *
      from jos_jcomments
      where object_group = 'com_content'
      and published = 1
      order by id desc
      limit 5
  53. select *
      from jos_comprofiler
      where user_id = '703'
  54. select *
      from jos_content
      where id = 9836
  55. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  56. select *
      from jos_comprofiler
      where user_id = '702'
  57. select *
      from jos_content
      where id = 9836
  58. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  59. select *
      from jos_comprofiler
      where user_id = '27989'
  60. select *
      from jos_content
      where id = 9836
  61. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  62. select *
      from jos_comprofiler
      where user_id = '4322'
  63. select *
      from jos_content
      where id = 9836
  64. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  65. select *
      from jos_comprofiler
      where user_id = '0'
  66. select *
      from jos_content
      where id = 10013
  67. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 14
  68. select *
      from jos_content
      where state = 1
      and created >= '2011-11-14 03:11:05'
      order by hits desc
      limit 5
  69. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  70. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 16
  71. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 108
  72. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 109
  73. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 29
  74. select *
      from jos_tag_term
      order by hits desc
      limit 25
  75. SELECT id
      FROM jos_menu
      WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
      AND published=1
      AND access <= 1
  76. UPDATE `jos_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:65;s:19:\"session.timer.start\";i:1330907045;s:18:\"session.timer.last\";i:1330916518;s:17:\"session.timer.now\";i:1330916525;s:22:\"session.client.browser\";s:89:\"Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot)\";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;}}', `time` = 1330916525
      WHERE `session_id` = '7op7pud180fdav772gqv2ejns4'

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 16 × select (b.id)id from jos_categories as a,jos_menu as b
  2. 8 × SELECT * FROM jos_categories
  3. 6 × select * from jos_content
  4. 6 × select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar from jos_users as a,jos_comprofiler as b
  5. 5 × select * from jos_comprofiler
  6. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions
  7. 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM jos_banners as a LEFT JOIN jos_banner_clients AS cl ON cl.id = a.cid LEFT JOIN jos_categories as cat ON a.catid = cat.id
  8. 2 × select id,title,catid,introtext,created_by from jos_content
  9. 1 × select * from jos_web_media
  10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  11. 1 × SELECT * FROM jos_banners
  12. 1 × select * from jos_jcomments
  13. 1 × select * from jos_tag_term
  14. 1 × select * from jos_event_web as a inner join jos_web as b on b.id = a.webid
  15. 1 × SELECT id FROM jos_menu
  16. 1 × select (a.catid)catid,(b.level)level from jos_content as a, jos_categories as b
  17. 1 × select * from jos_web
  18. 1 × SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  19. 1 × SELECT * FROM jos_jcomments_setting
  20. 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 jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
  21. 1 × SELECT folder AS type, element AS name, params FROM jos_extensions
  22. 1 × SELECT * FROM jos_languages
  23. 1 × SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  24. 1 × SELECT * FROM `jos_jcomments_objects`
  25. 1 × SELECT count(*) FROM jos_jcomments AS c
  26. 1 × select * from jos_tag_term_content as a, jos_tag_term as b
  27. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_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 jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  28. 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 jos_content AS a LEFT JOIN jos_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  29. 1 × SELECT `data` FROM `jos_session`
OTHER Tables:
  1. 3 × UPDATE jos_banners SET impmade = (impmade + 1)
  2. 1 × UPDATE `jos_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:65;s:19:\"session.timer.start\";i:1330907045;s:18:\"session.timer.last\";i:1330916518;s:17:\"session.timer.now\";i:1330916525;s:22:\"session.client.browser\";s:89:\"Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot)\";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;}}', `time` = 1330916525
  3. 1 × UPDATE jos_content SET hits = hits + 1
  4. 1 × DELETE FROM `jos_session`