#BammyAwards
Break the Code of Silence
Search Nominees
Login Form
Profile Information
Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.021 seconds, 6.48 MB
Application afterRoute: 0.027 seconds, 8.53 MB
Application afterDispatch: 0.093 seconds, 23.65 MB
Application afterRender: 0.109 seconds, 25.08 MB
Memory Usage
2634134447 queries logged
- SELECT *
FROM jos_session
WHERE session_id = 'dd497830594814d3def52fe1388261f5' - DELETE
FROM jos_session
WHERE ( TIME < '1524152646' ) - SELECT *
FROM jos_session
WHERE session_id = 'dd497830594814d3def52fe1388261f5' - INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'dd497830594814d3def52fe1388261f5','1524159846','','0','1','0' ) - SELECT *
FROM jos_components
WHERE parent = 0 - SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering - SELECT setting,VALUE
FROM jos_jfbconnect_config - 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 - SELECT VALUE
FROM jos_jreviews_config
WHERE id = 'debug_overrides_disable' - SELECT
id,
name,
alias AS alias,
link AS menu_type,
link,
componentid,
params,
access,
published,
'*' AS LANGUAGE
FROM jos_menu
WHERE published = 1
ORDER BY link DESC
SET SQL_BIG_SELECTS=1- INSERT INTO
jos_jreviews_config (id, VALUE)
VALUES
('last_cache_clean', '1524159846')
ON DUPLICATE KEY UPDATE
VALUE = '1524159846' - SELECT id, VALUE
FROM jos_jreviews_config - DELETE
FROM jos_jreviews_registration
WHERE
session_time < 1524156246 - SELECT Category.id AS `Category.cat_id`,
Category.SECTION AS `Category.section_id`,
Category.title AS `Category.title`,
Category.alias AS `Category.slug`,
Category.image AS `Category.image`,
Category.image_position AS `Category.image_position`,
Category.description AS `Category.description`,
Category.access AS `Category.access`,
Category.published AS `Category.published`,
Directory.id AS `Category.dir_id`,
JreviewsCategory.criteriaid AS `Category.criteria_id`,
JreviewsCategory.tmpl AS `Category.tmpl`,
JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
Directory.id AS `Directory.dir_id`,
Directory.DESC AS `Directory.title`,
Directory.title AS `Directory.slug`,
ListingType.config AS `ListingType.config`
FROM jos_categories AS Category
INNER JOIN jos_jreviews_categories AS JreviewsCategory
ON Category.id = JreviewsCategory.id
AND JreviewsCategory.OPTION = "com_content"
LEFT JOIN jos_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN jos_jreviews_criteria AS ListingType
ON JreviewsCategory.criteriaid = ListingType.id
WHERE 1 = 1
AND (
Category.id = 70
) - SELECT
id,
name,
alias AS alias,
link AS menu_type,
link,
componentid,
params,
access,
published,
'*' AS LANGUAGE
FROM jos_menu
WHERE published = 1
ORDER BY link DESC - SELECT Category.id AS `Category.cat_id`,
Category.SECTION AS `Category.section_id`,
Category.title AS `Category.title`,
Category.alias AS `Category.slug`,
Category.image AS `Category.image`,
Category.image_position AS `Category.image_position`,
Category.description AS `Category.description`,
Category.access AS `Category.access`,
Category.published AS `Category.published`,
Directory.id AS `Category.dir_id`,
JreviewsCategory.criteriaid AS `Category.criteria_id`,
JreviewsCategory.tmpl AS `Category.tmpl`,
JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
Directory.id AS `Directory.dir_id`,
Directory.DESC AS `Directory.title`,
Directory.title AS `Directory.slug`,
ListingType.config AS `ListingType.config`,
(SELECT
COUNT(*)
FROM jos_content AS Listing
INNER JOIN jos_jreviews_categories AS JreviewsCategory
ON JreviewsCategory.id = Listing.catid
AND JreviewsCategory.`option` = "com_content"
WHERE
Listing.sectionid = 5
AND Listing.catid = Category.id
AND Listing.state = 1
AND Listing.access <= 0
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2018-04-19 23:59:59" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2018-04-19" )
) AS `Category.listing_count`
FROM jos_categories AS Category
INNER JOIN jos_jreviews_categories AS JreviewsCategory
ON Category.id = JreviewsCategory.id
AND JreviewsCategory.OPTION = "com_content"
LEFT JOIN jos_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN jos_jreviews_criteria AS ListingType
ON JreviewsCategory.criteriaid = ListingType.id
WHERE 1 = 1
AND (
Category.SECTION = 5
AND Category.published = 1
)
ORDER BY Category.title ASC - SELECT SECTION.id AS `Section.section_id`,
SECTION.title AS `Section.title`,
SECTION.alias AS `Section.slug`,
SECTION.image AS `Section.image`,
SECTION.image_position AS `Section.image_position`,
SECTION.description AS `Section.description`,
SECTION.access AS `Section.access`,
SECTION.published AS `Section.published`,
JreviewsSection.tmpl AS `Section.tmpl`,
JreviewsSection.tmpl_suffix AS `Section.tmpl_suffix`,
1 AS `Section.dir_id`
FROM jos_sections AS `Section`
LEFT JOIN jos_jreviews_sections AS JreviewsSection
ON SECTION.id = JreviewsSection.sectionid
WHERE 1 = 1
AND (
SECTION.id = 5
) - SELECT Listing.id AS `Listing.listing_id`,
Listing.alias AS `Listing.slug`,
Category.alias AS `Category.slug`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.modified AS `Listing.modified`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.publish_down AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Directory.id AS `Directory.dir_id`,
Directory.DESC AS `Directory.title`,
Directory.title AS `Directory.slug`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.weights AS `Criteria.weights`,
Criteria.required AS `Criteria.required`,
Criteria.state AS `Criteria.state`,
Criteria.config AS `ListingType.config`,
`Field`.featured AS `Listing.featured`,
USER.id AS `User.user_id`,
USER.name AS `User.name`,
USER.username AS `User.username`,
USER.email AS `User.email`,
Claim.approved AS `Claim.approved`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.user_criteria_rating AS `Review.user_criteria_rating`,
Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
Totals.user_comment_count AS `Review.review_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
Totals.editor_comment_count AS `Review.editor_review_count`,
Totals.media_count AS `Listing.media_count`,
Totals.video_count AS `Listing.video_count`,
Totals.photo_count AS `Listing.photo_count`,
Totals.audio_count AS `Listing.audio_count`,
Totals.attachment_count AS `Listing.attachment_count`,
(Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
(Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
(Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
(Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
(Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
Totals.media_count_user AS `Listing.media_count_user`,
Totals.video_count_user AS `Listing.video_count_user`,
Totals.photo_count_user AS `Listing.photo_count_user`,
Totals.audio_count_user AS `Listing.audio_count_user`,
Totals.attachment_count_user AS `Listing.attachment_count_user`,
Listing.sectionid AS `Listing.section_id`,
SECTION.id AS `Section.section_id`,
SECTION.title AS `Section.title`,
SECTION.alias AS `Section.slug`,
Category.image AS `Listing.category_image`
FROM jos_content AS Listing
INNER JOIN jos_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jos_categories AS Category
ON JreviewsCategory.id = Category.id
LEFT JOIN jos_sections AS SECTION
ON Category.SECTION = SECTION.id
LEFT JOIN jos_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN jos_jreviews_content AS FIELD
ON FIELD.contentid = Listing.id
LEFT JOIN jos_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN jos_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN jos_users AS USER
ON USER.id = Listing.created_by
LEFT JOIN jos_jreviews_claims AS Claim
ON Claim.listing_id = Listing.id
AND Claim.user_id = Listing.created_by
AND Claim.approved = 1
WHERE 1 = 1
AND (
Category.id IN (70)
AND Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2018-04-19 23:59:59" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2018-04-19" )
AND Category.access <= 0
AND Listing.access <= 0
)
ORDER BY `Listing.featured` DESC, Listing.created DESC
LIMIT 15 - SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.SEARCH AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (26)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`,
FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`,
FIELD.TYPE AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`,
FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`,
FIELD.SEARCH AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`,
FIELD.published AS `Field.published`,
`Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`
FROM jos_jreviews_fields AS FIELD
INNER JOIN jos_jreviews_groups AS `Group`
ON (`Group`.groupid = FIELD.groupid
AND
`Group`.groupid IN (25,20,26,27)
AND `Group`.TYPE = 'content' )
WHERE FIELD.location = 'content'
AND FIELD.published = 1
ORDER BY
GROUP.ordering, FIELD.ordering - SELECT Listing.contentid AS element_id,jr_nameofentry,jr_nomineesemailaddress,jr_nomineeswebsiteaddress,jr_nomineescompany,jr_youraffiliationtonominee,jr_imnominatingbecause
FROM jos_jreviews_content AS Listing
WHERE Listing.contentid IN (1864,1824,1766,1735,1677,1594) - SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.SEARCH AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (26)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.SEARCH AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (26)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.SEARCH AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (26)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.SEARCH AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (26)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.SEARCH AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (26)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.SEARCH AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (26)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - SELECT COUNT(*)
FROM jos_content AS Listing
INNER JOIN jos_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jos_categories AS Category
ON JreviewsCategory.id = Category.id
LEFT JOIN jos_jreviews_listing_totals AS Totals
ON Totals.listing_id = Listing.id
AND Totals.extension = 'com_content'
LEFT JOIN jos_jreviews_content AS FIELD
ON FIELD.contentid = Listing.id
LEFT JOIN jos_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
WHERE 1 = 1
AND (
Category.id IN (70)
AND Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2018-04-19 23:59:59" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2018-04-19" )
AND Category.access <= 0
AND Listing.access <= 0
) - SELECT Directory.id AS `Directory.dir_id`,
Directory.DESC AS `Directory.title`,
Directory.title AS `Directory.name`,
Directory.tmpl_suffix AS `Directory.tmpl_suffix`,
Directory.title AS `Directory.slug`
FROM jos_jreviews_directories AS Directory
WHERE 1 = 1
AND (
Directory.id = 1
) - SELECT COUNT(DISTINCT groupid)
FROM jos_jreviews_criteria
WHERE groupid != '' - SELECT criteriaid
FROM jos_jreviews_categories
WHERE `option` = 'com_content'
AND id IN (70) - SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.required AS `Criteria.required`,
Criteria.weights AS `Criteria.weights`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.qty AS `Criteria.quantity`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.SEARCH AS `Criteria.search`,
Criteria.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (26)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - SELECT FIELD.fieldid, FIELD.title AS text, FIELD.name AS VALUE, FIELD.access_view AS access
FROM jos_jreviews_fields AS FIELD
WHERE FIELD.location = 'content'
AND FIELD.listsort = 1
AND FIELD.groupid IN (25,20,26,27) - SELECT j_user_id
FROM jos_jfbconnect_user_map
WHERE fb_user_id='' - SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1 - 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 = 0 OR mm.menuid = 0 )
ORDER BY POSITION, ordering - SELECT *
FROM jos_menu
WHERE menutype='topmenu'
AND published=1
ORDER BY sublevel DESC,ordering
; - SELECT *
FROM jos_modules
WHERE published=1
ORDER BY id
;
Language Files Loaded
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.plg_system_jqueryeasy.ini
- /home/bammy54/public_html/nominations/administrator/language/en-GB/en-GB.plg_system_easycalccheckplus.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.plg_system_debug.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.com_jreviews.ini
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.tpl_theme513.ini
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_jcomments_most_commented.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_search.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_socialauth.ini
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_maximenu_CK.ini 1
Untranslated Strings Diagnostic
None
Untranslated Strings Designer
None
Bammy Award Categories Education Policy/Research
Education Policy/Research
6 results - showing 1 - 6
Ordering
6 results - showing 1 - 6
Powered by JReviews