Bammy awards

BAM TV
bammy1820 » 6am - Oct 8, 2014
Tony Sinanis & Joe Sanfelippo give 3iTalk at the 2014 Bammy Award
Rating: 2.0 (251 Votes)

Profile Information

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.021 seconds, 6.48 MB
Application afterRoute: 0.029 seconds, 8.76 MB
Application afterDispatch: 0.096 seconds, 16.46 MB
Application afterRender: 0.115 seconds, 17.68 MB

Memory Usage

18657816

109 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '20df4e0abcae1c666b6f59e735ae1378'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1490547184' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '20df4e0abcae1c666b6f59e735ae1378'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '20df4e0abcae1c666b6f59e735ae1378','1490554384','','0','1','0' )
  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 setting,VALUE
      FROM jos_jfbconnect_config
  8. 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
  9. SELECT COUNT(*)
      FROM jos_menu
      WHERE id = 172
      AND link = "index.php?option=com_hwdvideoshare&task=viewvideo"
      AND published = 1
  10. SELECT id
      FROM jos_menu
      WHERE link = "index.php?option=com_hwdvideoshare&task=viewvideo"
      AND published = 1
      LIMIT 0, 1
  11. SELECT id
      FROM jos_menu
      WHERE link = "index.php?option=com_hwdvideoshare&task=frontpage"
      AND published = 1
  12. SELECT id
      FROM jos_menu
      WHERE id = 172
      AND link LIKE "%com_hwdvideoshare%"
      AND published = 1
  13. SELECT id ,parent,category_name, access_u, access_lev_u, access_u_r
      FROM jos_hwdvidscategories

      WHERE published = 1

      ORDER BY category_name
  14. SELECT g1.id AS group_id, g1.name
     
      FROM jos_core_acl_aro_groups g1
     
      LEFT JOIN jos_core_acl_aro_groups g2
      ON g2.lft <= g1.lft
     
      WHERE g2.id =24
     
      ORDER BY g1.name
  15. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  16. SELECT g1.id AS group_id, g1.name
     
      FROM jos_core_acl_aro_groups g1
     
      LEFT JOIN jos_core_acl_aro_groups g2
      ON g2.lft <= g1.lft
     
      WHERE g2.id =25
     
      ORDER BY g1.name
  17. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  18. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  19. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  20. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  21. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  22. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  23. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  24. SELECT video.*, u.name, u.username
      FROM jos_hwdvidsvideos AS video
      LEFT JOIN jos_users AS u
      ON u.id = video.user_id
      WHERE video.id = 102
      ORDER BY video.date_uploaded DESC
  25. INSERT INTO `jos_hwdvidslogs_views` ( `videoid`,`userid`,`date` )
      VALUES ( '102','0','2017-03-26 12:53:04' )
  26. SELECT COUNT(*)
      FROM jos_hwdvidslogs_views
      WHERE videoid = 102
  27. SELECT views
      FROM jos_hwdvidslogs_archive
      WHERE videoid = 102
  28. UPDATE jos_hwdvidsvideos
      SET number_of_views = 4460
      WHERE id = 102
  29. UPDATE jos_hwdvidsvideos
      SET number_of_views = 4460
      WHERE id = 102
  30. SELECT video.*, u.name, u.username
      FROM jos_hwdvidsvideos AS video
      LEFT JOIN jos_users AS u
      ON u.id = video.user_id
      WHERE video.user_id = 62
      AND video.published = 1
      AND video.approved = "yes"
      AND video.id <> 102
      ORDER BY video.date_uploaded DESC
      LIMIT 0, 10
  31. SELECT video.*, u.name, u.username
      FROM jos_hwdvidsvideos AS video
      LEFT JOIN jos_users AS u
      ON u.id = video.user_id
      WHERE MATCH (title,description,tags) AGAINST ('3iTalk: Tony Sinanis & Joe Sanfelippo <p>Tony Sinanis & Joe Sanfelippo give 3iTalk at the 2014 Bammy Award</p> Joe Sanfelippo  Bammy Awards  3italks  TED  Tedtalks  Keynotes  Speaker  Education')
      AND video.published = 1
      AND video.approved = 'yes'
      AND video.published = 1
      AND video.approved = "yes"
      AND video.id <> 102
      LIMIT 0, 10
  32. SELECT video.*, u.name, u.username
      FROM jos_hwdvidsvideos AS video
      LEFT JOIN jos_users AS u
      ON u.id = video.user_id
      LEFT JOIN jos_hwdvidsvideo_category AS cmap
      ON cmap.videoid = video.id
      WHERE cmap.categoryid = 102
      AND video.published = 1
      AND video.approved = "yes"
      AND video.id <> 102
      ORDER BY video.ordering ASC
      LIMIT 0, 10
  33. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 102
  34. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 102
  35. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 102
  36. SELECT COUNT(*)
      FROM jos_hwdvidsfavorites AS a
      WHERE a.userid = 0
      AND a.videoid = 102
  37. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 102
  38. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 102
  39. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  40. SELECT id, category_name
      FROM jos_hwdvidscategories
  41. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 102
  42. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 172)
      ORDER BY menuid DESC
      LIMIT 0, 1
  43. SELECT COUNT(*)
      FROM jos_hwdvidsfavorites AS a
      WHERE a.userid = 0
      AND a.videoid = 102
  44. SELECT COUNT(*)
      FROM jos_hwdvidsplaylists
      WHERE user_id = 0
  45. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 40
  46. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 40
  47. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 16
  48. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 40
  49. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 95
  50. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 95
  51. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  52. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 95
  53. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 107
  54. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 107
  55. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  56. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 107
  57. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 112
  58. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 112
  59. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  60. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 112
  61. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 100
  62. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 100
  63. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  64. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 100
  65. SELECT g1.id AS group_id, g1.name
     
      FROM jos_core_acl_aro_groups g1
     
      LEFT JOIN jos_core_acl_aro_groups g2
      ON g2.lft <= g1.lft
     
      WHERE g2.id =21
     
      ORDER BY g1.name
  66. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 127
  67. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 127
  68. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  69. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 127
  70. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 126
  71. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 126
  72. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  73. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 126
  74. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 125
  75. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 125
  76. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  77. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 125
  78. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 123
  79. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 123
  80. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  81. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 123
  82. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 122
  83. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 122
  84. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  85. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 122
  86. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 121
  87. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 121
  88. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  89. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 121
  90. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 120
  91. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 120
  92. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  93. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 120
  94. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 119
  95. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 119
  96. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  97. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 119
  98. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 118
  99. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 118
  100. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  101. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 118
  102. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 117
  103. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 117
  104. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  105. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 117
  106. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  107. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 172 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  108. SELECT *
                           
      FROM jos_menu
                           
      WHERE menutype='topmenu'
      AND published=1
                           
      ORDER BY sublevel DESC,ordering
                            ;
  109. SELECT *
                           
      FROM jos_modules
                           
      WHERE published=1
                           
      ORDER BY id
                            ;

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None