Securing the Future PortalHealth and Social Care PortalEfficiency and Productivity Portal

The new benefit will continue to help disabled people live independent lives and will for the first time include regular reassessments to ensure that people are getting the right level of support when they need it most.

 

This follows one of the biggest ever consultations at the Department for Work and Pensions (DWP) with more than 5500 responses from disabled people and disability organisations.

Responding to the consultation today, Maria Miller, Minister for Disabled People said:

"Disabled people are at the heart of our welfare reform plans and severely disabled people who need extra help and support will always get it.  That’s why we have spent the last few months working closely with disabled people and disability organisations to make sure we are making the right changes to DLA.

"We’ve listened to what they have told us and we will be working with them to make sure that the new Personal Independence Payment does what it should.

"We have also said that we won’t remove the mobility component from care home residents in 2012 and instead we are reviewing the mobility component as part of our wider reforms of DLA."

  • DLA is paid to help people who cannot do things like walk or wash and dress themselves.
  • It provides a contribution to the extra costs severely disabled people incur.
  • DLA is claimed by 3.2 million people at an annual cost of £12bn.
  • Currently more than 2 million people get the benefit indefinitely which means there is no way of knowing if their condition has changed or if they actually need more help and support.
  • Nearly a quarter of all working age people on DLA have not had any review of their claim in 10 years.

The Personal Independence Payment can be claimed by disabled people whether they work or not. It will also:

  • Introduce a more objective assessment of need, which will be developed with the help of disability organisations and disabled people
  • Allow disabled people to be reassessed over time – something that is lacking in the current system - to ensure everyone receives the correct support if their needs change.

Source: DWP

Written by Scott Buckler
Monday, 04 April 2011 13:01

Comments   

 
0 #1 .photographerRoger Brightmore 2012-01-04 11:38
I suffer from epilepsy, I'd be happy to be without it and full health be on my side but I know that this will never happen, in my lifetime. What does this government think they are doing to people like myself? I understand the part where there are alot of scams going on but do I have to suffer at their hands and lose money that is a huge help to me? The conservative way of life is back with a vengeance, I try to work as hard as I can given my problems but no sympathy is returned?
Quote
 

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.049 seconds (+0.048); 6.35 MB (+5.200) - afterInitialise
Application 0.078 seconds (+0.029); 12.01 MB (+5.656) - afterRoute
Application 0.274 seconds (+0.196); 15.99 MB (+3.983) - afterDispatch
Application 0.282 seconds (+0.007); 16.29 MB (+0.296) - beforeRenderModule mod_footer (Footer)
Application 0.283 seconds (+0.001); 16.32 MB (+0.035) - afterRenderModule mod_footer (Footer)
Application 0.283 seconds (+0.000); 16.32 MB (-0.003) - beforeRenderModule mod_menu (Footer Menu)
Application 0.287 seconds (+0.004); 16.39 MB (+0.072) - afterRenderModule mod_menu (Footer Menu)
Application 0.287 seconds (+0.000); 16.38 MB (-0.007) - beforeRenderModule mod_gov_tv (Govtoday TV)
Application 0.290 seconds (+0.003); 16.42 MB (+0.042) - afterRenderModule mod_gov_tv (Govtoday TV)
Application 0.290 seconds (+0.000); 16.40 MB (-0.023) - beforeRenderModule mod_banners (FORTHCOMING EVENTS / POST-EVENT DEBATES)
Application 0.296 seconds (+0.006); 16.68 MB (+0.280) - afterRenderModule mod_banners (FORTHCOMING EVENTS / POST-EVENT DEBATES)
Application 0.296 seconds (+0.000); 16.66 MB (-0.017) - beforeRenderModule mod_gtsearch (GT Search)
Application 0.297 seconds (+0.001); 16.68 MB (+0.015) - afterRenderModule mod_gtsearch (GT Search)
Application 0.297 seconds (+0.000); 16.68 MB (-0.002) - beforeRenderModule mod_feature (Editor's Feature)
Application 0.353 seconds (+0.056); 16.72 MB (+0.040) - afterRenderModule mod_feature (Editor's Feature)
Application 0.353 seconds (+0.000); 16.72 MB (+0.001) - beforeRenderModule mod_comments_read (Comment and Most Read)
Application 0.375 seconds (+0.022); 16.77 MB (+0.048) - afterRenderModule mod_comments_read (Comment and Most Read)
Application 0.375 seconds (+0.000); 16.78 MB (+0.015) - beforeRenderModule mod_gttag (Most Read Tags)
Application 0.383 seconds (+0.008); 16.92 MB (+0.140) - afterRenderModule mod_gttag (Most Read Tags)
Application 0.383 seconds (+0.000); 16.88 MB (-0.039) - beforeRenderModule mod_menu (Gov Menu)
Application 0.391 seconds (+0.008); 16.91 MB (+0.026) - afterRenderModule mod_menu (Gov Menu)
Application 0.392 seconds (+0.000); 16.90 MB (-0.004) - beforeRenderModule mod_menu (Top Menu)
Application 0.394 seconds (+0.003); 16.92 MB (+0.014) - afterRenderModule mod_menu (Top Menu)
Application 0.394 seconds (+0.000); 16.91 MB (-0.013) - beforeRenderModule mod_syndicate (Syndication)
Application 0.396 seconds (+0.002); 16.95 MB (+0.048) - afterRenderModule mod_syndicate (Syndication)
Application 0.396 seconds (+0.000); 16.95 MB (+0.001) - beforeRenderModule mod_cblogin (CB Login)
Application 0.409 seconds (+0.013); 18.88 MB (+1.924) - afterRenderModule mod_cblogin (CB Login)
Application 0.415 seconds (+0.006); 18.95 MB (+0.072) - afterRender

Memory Usage

18.97 MB (19,888,696 Bytes)

77 Queries Logged

  1. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '7op7pud180fdav772gqv2ejns4'
  2. DELETE
      FROM `jos_session`
      WHERE `time` < 1330906457
  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 = 6859
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-03-05 02:14:17')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-03-05 02:14:17')
  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=109
      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 = 6859
  17. SELECT *
      FROM `jos_jcomments_objects`
      WHERE `object_id` = '6859'
      AND `object_group` = 'com_content'
      AND `lang` = 'en-GB'
  18. SELECT count(*)
      FROM jos_jcomments AS c
      WHERE c.object_id = 6859
      AND c.object_group = 'com_content'
      AND c.published = 1
  19. SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted , case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
      FROM jos_jcomments AS c
      LEFT JOIN jos_jcomments_votes AS v
      ON c.id = v.commentid
      AND v.userid = 0
      AND v.ip = '207.241.237.208'
      WHERE c.object_id = 6859
      AND c.object_group = 'com_content'
      AND c.published = 1
      ORDER BY c.date DESC
      LIMIT 0, 15
  20. UPDATE jos_content
      SET hits = hits + 1
      WHERE id = 6859
  21. select (a.catid)catid,(b.level)level
      from jos_content as a, jos_categories as b
      where a.catid = b.id
      and a.id = 6859
  22. SELECT *
      FROM jos_categories
      WHERE id='109'
  23. SELECT *
      FROM jos_categories
      WHERE id='109'
  24. 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 02:14:18')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-03-05 02:14:18')
      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
  25. select *
      from jos_web_media
      where active = 1
      and webtype = 'interview'
      and govtoday = 1
      order by id desc
      limit 10
  26. 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)
  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
  28. 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
  29. UPDATE jos_banners
      SET impmade = (impmade + 1)
      WHERE id = 6
  30. UPDATE jos_banners
      SET impmade = (impmade + 1)
      WHERE id = 7
  31. UPDATE jos_banners
      SET impmade = (impmade + 1)
      WHERE id = 1
  32. select *
      from jos_event_web as a
      inner join jos_web as b
      on b.id = a.webid
      where main = 1
      and webid = 2
  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 id,title,catid,introtext,created_by
      from jos_content
      where state = 1
      and attribs like '%"feature":"1"%'
      order by created desc
      limit 6
  35. 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
  36. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 43
  37. 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
  38. SELECT *
      FROM jos_categories
      WHERE id='31'
  39. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 31
  40. 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
  41. SELECT *
      FROM jos_categories
      WHERE id='12'
  42. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 12
  43. 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
  44. SELECT *
      FROM jos_categories
      WHERE id='106'
  45. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 106
  46. 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
  47. SELECT *
      FROM jos_categories
      WHERE id='21'
  48. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 21
  49. 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
  50. SELECT *
      FROM jos_categories
      WHERE id='106'
  51. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 106
  52. SELECT *
      FROM jos_categories
      WHERE id='43'
  53. select *
      from jos_jcomments
      where object_group = 'com_content'
      and published = 1
      order by id desc
      limit 5
  54. select *
      from jos_comprofiler
      where user_id = '703'
  55. select *
      from jos_content
      where id = 9836
  56. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  57. select *
      from jos_comprofiler
      where user_id = '702'
  58. select *
      from jos_content
      where id = 9836
  59. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  60. select *
      from jos_comprofiler
      where user_id = '27989'
  61. select *
      from jos_content
      where id = 9836
  62. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  63. select *
      from jos_comprofiler
      where user_id = '4322'
  64. select *
      from jos_content
      where id = 9836
  65. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  66. select *
      from jos_comprofiler
      where user_id = '0'
  67. select *
      from jos_content
      where id = 10013
  68. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 14
  69. select *
      from jos_content
      where state = 1
      and created >= '2011-11-14 02:11:18'
      order by hits desc
      limit 5
  70. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  71. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 16
  72. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 108
  73. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 109
  74. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 29
  75. select *
      from jos_tag_term
      order by hits desc
      limit 25
  76. SELECT id
      FROM jos_menu
      WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
      AND published=1
      AND access <= 1
  77. UPDATE `jos_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:46;s:19:\"session.timer.start\";i:1330907045;s:18:\"session.timer.last\";i:1330913644;s:17:\"session.timer.now\";i:1330913657;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` = 1330913658
      WHERE `session_id` = '7op7pud180fdav772gqv2ejns4'

34 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 c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted , case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner FROM jos_jcomments AS c LEFT JOIN jos_jcomments_votes AS v ON c.id = v.commentid AND v.userid = 0 AND v.ip = '207.241.237.208'
  17. 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
  18. 1 × SELECT * FROM jos_languages
  19. 1 × select * from jos_web
  20. 1 × SELECT * FROM jos_jcomments_setting
  21. 1 × SELECT folder AS type, element AS name, params FROM jos_extensions
  22. 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
  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 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
  25. 1 × SELECT count(*) FROM jos_jcomments AS c
  26. 1 × SELECT `data` FROM `jos_session`
  27. 1 × SELECT * FROM `jos_jcomments_objects`
  28. 1 × select * from jos_tag_term_content as a, jos_tag_term as b
  29. 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
  30. 1 × select (a.catid)catid,(b.level)level from jos_content as a, jos_categories as b
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:46;s:19:\"session.timer.start\";i:1330907045;s:18:\"session.timer.last\";i:1330913644;s:17:\"session.timer.now\";i:1330913657;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` = 1330913658
  3. 1 × UPDATE jos_content SET hits = hits + 1
  4. 1 × DELETE FROM `jos_session`