S2Framework Debug Console

SET SQL_BIG_SELECTS=1
SHOW TABLES LIKE '%_jreviews_config'
SELECT value FROM tan_jreviews_config WHERE id = 'cms_secret'
SELECT name FROM tan_jreviews_addons WHERE state = 1 ORDER BY ordering
SELECT DISTINCTROW criteriaid FROM tan_jreviews_categories WHERE `option`='com_content'
SELECT id AS value, title AS text FROM tan_jreviews_criteria WHERE 1 = 1 AND id IN (1) AND search = 1 ORDER BY title ASC
SELECT Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,IF(JreviewsCategory.criteriaid = 0,1,0) AS disabled,CONCAT(REPEAT('─', IF(Category.level>0,Category.level - 1,1)), ' ',Category.title) AS text FROM tan_categories AS Category RIGHT JOIN tan_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Category.id AND JreviewsCategory.`option` = 'com_content' WHERE Category.published = 1 AND Category.access IN ( 1,5 ) AND Category.level > 0 AND Category.extension = 'com_content' AND (Category.id IN ( SELECT id FROM tan_jreviews_categories WHERE `option` = "com_content" AND criteriaid IN (1) )) ORDER BY Category.lft