Download stats

The download archive contains currently 94 downloads in 15 categories. To date, these have been downloaded 3877 times.

Downloads top

Drehkreuze / Turnstile... 456
2010-04-16
Cafeen's Letters 378
2010-04-16
Surfingoz Track Compon... 217
2010-04-05
Coaster Buildings v1.0150
2010-04-11
Mayan Temple Set v2.0150
2010-04-11

•Profile Information•

Application afterLoad: 0.000 seconds, 0.38 MB
Application afterInitialise: 0.154 seconds, 7.93 MB
Application afterRoute: 0.183 seconds, 10.31 MB
Application get hook factory.skipUserCheck: 0.233 seconds, 13.88 MB
Application get hook core.constructorStart: 0.234 seconds, 13.88 MB
Application get hook core.afterTemplateFile: 0.237 seconds, 13.95 MB
Application get hook core.afterTemplateUser: 0.237 seconds, 13.95 MB
Application get hook core.loadLanguages: 0.826 seconds, 14.28 MB
Application get hook core.constructorEnd: 0.840 seconds, 14.39 MB
Application get hook core.beforeRender: 0.971 seconds, 16.39 MB
Application get hook html.afterCountModules: 0.973 seconds, 16.46 MB
Application get hook html.afterCountModules: 0.974 seconds, 16.46 MB
Application get hook html.afterCountModules: 0.974 seconds, 16.46 MB
Application get hook html.afterCountModules: 0.975 seconds, 16.46 MB
Application get hook core.afterRender: 0.977 seconds, 16.48 MB
Application get hook core.beforeParseTemplate: 0.978 seconds, 16.50 MB
Application get hook core.beforeUserApps: 0.979 seconds, 16.51 MB
Application get hook core.beforeAppRender: 0.982 seconds, 16.52 MB
Application get hook core.beforeUserApps: 1.004 seconds, 16.97 MB
Application get hook core.beforeUserApps: 1.006 seconds, 16.97 MB
Application get hook core.beforeAppRender: 1.008 seconds, 16.98 MB
Application get hook core.beforeUserApps: 1.035 seconds, 17.18 MB
Application get hook core.beforeAppRender: 1.038 seconds, 17.20 MB
Application get hook core.beforeUserApps: 1.050 seconds, 17.22 MB
Application get hook core.beforeAppRender: 1.052 seconds, 17.23 MB
Application get hook core.beforeUserApps: 1.057 seconds, 17.24 MB
Application get hook core.beforeAppRender: 1.060 seconds, 17.26 MB
Application get hook core.beforeAppRender: 1.066 seconds, 17.34 MB
Application get hook core.beforeAppRender: 1.087 seconds, 17.75 MB
Application get hook core.beforeAppRender: 1.109 seconds, 18.12 MB
Application get hook core.beforeAppRender: 1.114 seconds, 18.14 MB
Application get hook core.beforeAppRender: 1.121 seconds, 18.24 MB
Application get hook core.beforeAppRender: 1.141 seconds, 18.59 MB
Application get hook core.beforeAppRender: 1.151 seconds, 18.62 MB
Application get hook core.beforeAppRender: 1.182 seconds, 19.91 MB
Application get hook core.beforeUserApps: 1.185 seconds, 19.91 MB
Application get hook core.beforeAppRender: 1.187 seconds, 19.93 MB
Application afterDispatch: 1.271 seconds, 21.13 MB
Application afterRender: 1.274 seconds, 21.40 MB

•Memory Usage•

22565672

•141 queries logged•

  1. SELECT *
      FROM jos_session
      WHERE session_id = '509d2cea0c0cc1224b49272f55e2caa1'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1328757048' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '509d2cea0c0cc1224b49272f55e2caa1'
  4. UPDATE `jos_session`
      SET `time`='1328757948',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:15:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1328757225;s:18:\"session.timer.last\";i:1328757490;s:17:\"session.timer.now\";i:1328757910;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:6:\"global\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";i:20;}}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":20:{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:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/goopedg1/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}s:6:\"avatar\";s:82:\"http://www.goopedgamers.com/components/com_jsocialsuite/images/no_avatar_small.png\";}s:9:\"myfriends\";s:6:\"a:0:{}\";s:13:\"session.token\";s:32:\"01f1d535ea581a6302ae73dc3d59719c\";s:19:\"socialites_cachtime\";i:1328757911;s:12:\"currtemplate\";s:8:\"mystique\";s:17:\"currtemplatestyle\";s:0:\"\";s:22:\"currtemplate_is_joomla\";i:2;s:15:\"jssAppPositions\";s:137:\"a:8:{i:0;s:8:\"jss_main\";i:1;s:4:\"menu\";i:2;s:5:\"right\";i:3;s:5:\"user1\";i:4;s:5:\"user2\";i:5;s:5:\"user3\";i:6;s:5:\"user4\";i:7;s:6:\"footer\";}\";s:20:\"socialites2_cachtime\";i:1328757459;}'
      WHERE session_id='509d2cea0c0cc1224b49272f55e2caa1'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT id, parent_id, value, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  8. SELECT id, parent_id, value, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=21
  9. SELECT id, parent_id, value, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  10. SELECT id, parent_id, value, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=25
  11. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  12. SELECT `file`, `params`
      FROM `jos_sefexts`
  13. SELECT *
      FROM jos_sefurls
      WHERE ((`sefurl` = 'profile/profile.html') OR (`sefurl` = 'profile/profile.html/'))
      AND (`origurl` != '')
      ORDER BY `priority`
      LIMIT 1
  14. SELECT *
      FROM `jos_sefmoved`
      WHERE (`old` = 'profile/profile.html') OR (`old` = 'profile/profile.html/')
  15. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 42)
      ORDER BY menuid DESC
      LIMIT 0, 1
  16. SELECT *
      FROM jos_jcomments_settings
  17. SELECT *
      FROM jos_jss_hooks
      WHERE `published` = '1'
      ORDER BY `hook`, `ord`
  18. SELECT p.`folder_name`
                                   
      FROM jos_jss_plugins p
      WHERE p.`published` = '1'
  19. SELECT a.`folder_name`
                                           
      FROM jos_jss_apps a
      WHERE a.`published` = '1'
  20. SELECT *
      FROM jos_jss_config
  21. SELECT `page_title`
                                   
      FROM  jos_jss_users   
                                    
      WHERE `user_id` = 0
                                   
      LIMIT 1
  22. SELECT DISTINCT SQL_CALC_FOUND_ROWS u1.id, u1.name, u1.username, u1.email, u1.usertype, u1.block,
                                            u1.registerDate, u1.lastvisitDate, u2.sex, u2.dob, u2.descr, u2.show_email, u2.show_dob, u2.show_name,
                                            u2.views_count, u2.friends_count, u2.rating, u2.votes_count, u2.apps_count, u2.tmplid, u2.avatarid, u2.acceptedterms
                                   
      FROM jos_jss_users u2
                                    JOIN jos_users u1
      ON u1.`id` = u2.`user_id`
                                    JOIN jos_jss_user_friends f
      ON u2.`user_id` = f.`friend_id`
                                           
      AND f.`confirmed` = '1'
                                   
      WHERE f.`user_id` = 0
      LIMIT 0, 20
  23. SELECT m.*, am.params AS adv_params
      FROM jos_modules AS m
      LEFT JOIN jos_advancedmodules AS am
      ON am.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      ORDER BY m.ordering, m.id
  24. SELECT DISTINCT u.id, u.username, u.name, u.email, u.registerDate,   ju.avatarid, ju.rating, ju.friends_count, ju.descr, ju.show_name,  s.userid AS online 
      FROM  jos_users ASJOIN jos_jss_users AS ju
      ON ju.user_id = u.id 
      LEFT JOIN jos_session AS s
      ON s.userid = u.id 
      ORDER BY u.registerDate DESC 
      LIMIT 12
  25. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_jsocialsuite.xml'
      LIMIT 1
  26. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=96
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  27. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=95
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  28. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=94
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  29. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=93
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  30. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=92
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  31. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=91
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  32. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=90
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  33. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=89
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  34. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=88
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  35. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=87
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  36. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=86
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  37. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=85
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  38. SELECT DISTINCT u.id, u.username, u.name, u.email, u.registerDate,   ju.avatarid, ju.rating, ju.friends_count, ju.descr, ju.show_name,  s.userid AS online 
      FROM  jos_users ASJOIN jos_jss_users AS ju
      ON ju.user_id = u.id 
      LEFT JOIN jos_session AS s
      ON s.userid = u.id 
      ORDER BY ju.rating DESC 
      LIMIT 12
  39. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=66
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  40. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=72
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  41. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=62
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  42. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=63
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  43. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=64
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  44. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=65
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  45. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=85
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  46. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=78
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  47. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=73
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  48. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=74
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  49. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=75
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  50. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=76
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  51. SELECT DISTINCT u.id, u.username, u.name, u.email, u.registerDate,   ju.avatarid, ju.rating, ju.friends_count, ju.descr, ju.show_name,  s.userid AS online 
      FROM  jos_users ASJOIN jos_jss_users AS ju
      ON ju.user_id = u.id 
      LEFT JOIN jos_session AS s
      ON s.userid = u.id 
      ORDER BY ju.friends_count DESC 
      LIMIT 12
  52. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=62
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  53. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=72
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  54. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=66
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  55. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=63
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  56. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=64
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  57. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=73
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  58. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=80
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  59. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=65
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  60. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=85
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  61. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=78
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  62. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=74
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  63. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=75
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  64. SELECT DISTINCT u.id, u.username, u.name, u.email, u.registerDate,  ju.avatarid, ju.rating, ju.friends_count, ju.descr, ju.show_name,  s.userid AS online 
      FROM jos_session s, jos_users u  JOIN jos_jss_users AS ju
      ON ju.user_id = u.id 
      WHERE s.userid = u.id
      AND s.client_id = 0
      ORDER BY u.username 
      LIMIT 12
  65. SELECT DISTINCT u.id, u.username, u.name, u.email, u.registerDate,   ju.avatarid, ju.rating, ju.friends_count, ju.descr,  s.userid AS online 
      FROM  jos_users ASJOIN jos_jss_users AS ju
      ON ju.user_id = u.id 
      LEFT JOIN jos_session AS s
      ON s.userid = u.id 
      ORDER BY RAND() 
      LIMIT 12
  66. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=83
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  67. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=92
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  68. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=93
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  69. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=94
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  70. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=72
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  71. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=80
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  72. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=62
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  73. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=90
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  74. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=88
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  75. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=75
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  76. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=96
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  77. SELECT w1.`output`,  w1.`that_user`,  u.`name` AS that_name,  u.`username` AS that_username,  a.`name` AS appname,  p.`name` AS plgname,  ju1.`show_name` AS this_showname,  ju1.`sex` AS this_sex,  ju2.`show_name` AS that_showname,  ju2.`sex` AS that_sex  
      FROM jos_jss_thewall AS w1        JOIN jos_jss_thewall_users AS w2
      ON w1.`id` = w2.`wall_id`
                                                           
      AND w1.`this_user` = w2.`userid` JOIN jos_jss_users AS ju1
      ON ju1.`user_id` = w1.`this_user`   
      LEFT JOIN jos_jss_users AS ju2
      ON ju2.`user_id` = w1.`that_user` 
      LEFT JOIN jos_users AS u
      ON u.`id` = w1.`that_user` 
      LEFT JOIN jos_jss_apps AS a
      ON w1.`app_id` = a.`id`
      LEFT JOIN jos_jss_plugins AS p
      ON w1.`plg_id` = p.`id`
      WHERE w1.`this_user`=65
      ORDER BY w2.`tstamp` DESC 
      LIMIT 1
  78. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '32'
      AND m.`published` = '1'
      LIMIT 1
  79. SELECT *
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 1
      AND catid = 7
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  80. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 1
  81. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_banners.xml'
      LIMIT 1
  82. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_banners&bid=1&task=click'
  83. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '55'
      AND m.`published` = '1'
      LIMIT 1
  84. SELECT id
      FROM jos_menu
      WHERE link = 'index.php?option=com_jdownloads'
  85. SELECT cat_id
      FROM jos_jdownloads_cats
      WHERE published = 1
      AND cat_access <= 01
  86. SELECT *
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
      ORDER BY downloads DESC
      LIMIT 3
  87. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_jdownloads.xml'
      LIMIT 1
  88. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=17&cid=17&task=view.download'
  89. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '59'
      AND m.`published` = '1'
      LIMIT 1
  90. SELECT id
      FROM jos_menu
      WHERE link = 'index.php?option=com_jdownloads'
  91. SELECT cat_id
      FROM jos_jdownloads_cats
      WHERE published = 1
      AND cat_access <= 01
  92. SELECT *
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
      ORDER BY downloads DESC
      LIMIT 5
  93. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=17&cid=17&task=view.download'
  94. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=4&cid=47&task=view.download'
  95. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=4&cid=49&task=view.download'
  96. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '61'
      AND m.`published` = '1'
      LIMIT 1
  97. SELECT cat_id
      FROM jos_jdownloads_cats
      WHERE published = 1
      AND cat_access <= 01
  98. SELECT COUNT(*)
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
  99. SELECT SUM(downloads)
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
  100. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '34'
      AND m.`published` = '1'
      LIMIT 1
  101. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '101'
      AND m.`published` = '1'
      LIMIT 1
  102. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '97'
      AND m.`published` = '1'
      LIMIT 1
  103. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_agora.xml'
      LIMIT 1
  104. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_user.xml'
      LIMIT 1
  105. SELECT `value`
      FROM jos_jss_config
      WHERE `optname` = 'allow_user_registration'
  106. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '68'
      AND m.`published` = '1'
      LIMIT 1
  107. SELECT *
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 2
      AND catid = 52
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  108. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 2
  109. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_banners&bid=2&task=click'
  110. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '96'
      AND m.`published` = '1'
      LIMIT 1
  111. SELECT DISTINCT u.id, u.username, u.name, u.email, au.id AS `agora_user_id` 
      FROM jos_session s, jos_users u, jos_agora_users au 
      WHERE s.userid = u.id
      AND u.id = au.jos_id
      AND s.client_id = 0
      ORDER BY u.`username`
  112. SELECT DISTINCT `data`
      FROM jos_session
      WHERE guest <> 0
      AND client_id = 0 
      AND `data` NOT LIKE '%bot%'
      AND `data` NOT LIKE '%igdeSpyder%'
      AND `data` NOT LIKE '%Mail.Ru%'
      AND `data` NOT LIKE '%StackRambler%'
      AND `data` NOT LIKE '%Yandex%'
      AND `data` NOT LIKE '%Yanga%'
      AND `data` NOT LIKE '%Yahoo%'
      AND `data` NOT LIKE '%Snoopy%'
  113. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '89'
      AND m.`published` = '1'
      LIMIT 1
  114. SELECT w.tstamp, w.this_user, w.that_user, w.output, w.app_id, w.plg_id, w.icon, w.STATUS, u1.name AS this_name, u1.username AS this_username, u2.name AS that_name, u2.username AS that_username, a.name AS appname, p.name AS plgname, ju1.show_name AS this_showname, ju1.avatarid AS this_avatarid, ju1.sex AS this_sex, ju2.show_name AS that_showname, ju2.avatarid AS that_avatarid, ju2.sex AS that_sex 
      FROM (
                                                    SELECT DISTINCT w1.*, w2.userid, w2.tstamp
                                                   
      FROM jos_jss_thewall w1
                                                    JOIN jos_jss_thewall_users w2
      ON w1.id = w2.wall_id
                                                           
      AND w1.this_user = w2.userid
                                                   
                                            ) w JOIN `jos_jss_users` AS ju1
      ON ju1.user_id = w.this_user  JOIN `jos_users` AS u1
      ON u1.id = w.this_user 
      LEFT JOIN `jos_users` AS u2
      ON u2.id = w.that_user 
      LEFT JOIN `jos_jss_users` AS ju2
      ON ju2.user_id = w.that_user 
      LEFT JOIN `jos_jss_apps` AS a
      ON w.`app_id` = a.`id`
      LEFT JOIN `jos_jss_plugins` AS p
      ON w.`plg_id` = p.`id`
      GROUP BY w.tstamp
      ORDER BY w.tstamp DESC 
      LIMIT 10
  115. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '60'
      AND m.`published` = '1'
      LIMIT 1
  116. SELECT id
      FROM jos_menu
      WHERE link = 'index.php?option=com_jdownloads'
  117. SELECT cat_id
      FROM jos_jdownloads_cats
      WHERE published = 1
      AND cat_access <= 01
  118. SELECT *
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
      ORDER BY date_added DESC
      LIMIT 5
  119. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=7&cid=96&task=view.download'
  120. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=7&cid=95&task=view.download'
  121. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=12&cid=94&task=view.download'
  122. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=16&cid=93&task=view.download'
  123. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=14&cid=92&task=view.download'
  124. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '71'
      AND m.`published` = '1'
      LIMIT 1
  125. SELECT cc.id, cc.userid, cc.comment, cc.name, cc.username, cc.email, cc.date, cc.object_id, cc.object_group, '' AS avatar
     
      FROM jos_jcomments AS cc
     
      LEFT JOIN jos_content AS c
      ON c.id = cc.object_id
     
      WHERE cc.published = 1
       
      AND c.access <= '0'
       
      AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= NOW())
       
      AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= NOW())
       
      AND cc.object_group = 'com_content'
       
      AND (c.sectionid IN (5) )
     
      ORDER BY cc.date DESC
     
      LIMIT 5
  126. SELECT a.id, a.sectionid, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      WHERE a.id = 19
  127. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_content.xml'
      LIMIT 1
  128. SELECT title
      FROM jos_content
      WHERE id = 19
  129. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '69'
      AND m.`published` = '1'
      LIMIT 1
  130. SELECT m.*
      FROM `jos_modules` AS m
      WHERE m.`id` = '1'
      AND m.`published` = '1'
      LIMIT 1
  131. SELECT `catid`
      FROM `jos_content`
      WHERE `id` = '4'
  132. SELECT `catid`
      FROM `jos_content`
      WHERE `id` = '2'
  133. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_content&catid=1&id=2&view=article'
  134. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_aikadmin.xml'
      LIMIT 1
  135. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_weblinks.xml'
      LIMIT 1
  136. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_chronocontact.xml'
      LIMIT 1
  137. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads'
  138. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_lyftenbloggie.xml'
      LIMIT 1
  139. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_quickfaq.xml'
      LIMIT 1
  140. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_phocadocumentation.xml'
      LIMIT 1
  141. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_content&layout=form&view=article'

•Language Files Loaded•

•Untranslated Strings Diagnostic•

AUTHOR	::LyftenBloggieBuildRoute()	[/home/goopedg1/public_html/components/com_sef/joomsef.php:215]
AUTHOR	::LyftenBloggieBuildRoute()	[/home/goopedg1/public_html/components/com_sef/joomsef.php:215]
AUTHOR	::LyftenBloggieBuildRoute()	[/home/goopedg1/public_html/components/com_sef/joomsef.php:215]
MYDETAILS	::LyftenBloggieBuildRoute()	[/home/goopedg1/public_html/components/com_sef/joomsef.php:215]
MYENTRIES	::LyftenBloggieBuildRoute()	[/home/goopedg1/public_html/components/com_sef/joomsef.php:215]

•Untranslated Strings Designer•


# /home/goopedg1/public_html/components/com_sef/joomsef.php

AUTHOR=AUTHOR
MYDETAILS=MYDETAILS
MYENTRIES=MYENTRIES
Joomla SEF URLs by Artio