New User Register
Sign Up
As a member, you get access to more features.
Sign Up
Login to your account

Login

S2Framework Debug Console

Database Queries (12)

  1. SET SQL_BIG_SELECTS=1
  2. SHOW TABLES LIKE '%_jreviews_config'
  3. SELECT value FROM tan_jreviews_config WHERE id = 'cms_secret'
  4. SELECT name FROM tan_jreviews_addons WHERE state = 1 ORDER BY ordering
  5. INSERT INTO tan_jreviews_config ( id, value ) VALUES ('ranks_rebuild_last','1792707210') ON DUPLICATE KEY UPDATE value = VALUES(value)
  6. SELECT * FROM tan_jreviews_config AS `Config`
  7. UPDATE tan_jreviews_comments SET vote_helpful = 0, vote_total = 0;
  8. UPDATE tan_jreviews_comments as Review INNER JOIN ( SELECT review_id AS review_id, SUM(vote_yes + vote_no) AS vote_total, SUM(vote_yes) AS vote_helpful FROM tan_jreviews_votes AS Review GROUP BY review_id ORDER BY NULL ) AS VoteAggregate ON Review.id = VoteAggregate.review_id SET Review.vote_helpful = VoteAggregate.vote_helpful, Review.vote_total = VoteAggregate.vote_total
  9. SELECT Review.id FROM tan_jreviews_comments as Review WHERE Review.mode = "com_content" AND Review.pid NOT IN ( SELECT id from tan_content )
  10. DELETE FROM tan_jreviews_reviewer_ranks WHERE user_id = 0 OR user_id NOT IN ( SELECT userid FROM tan_jreviews_comments WHERE published = 1 ) OR user_id NOT IN ( SELECT id FROM tan_users WHERE block = 0 )
  11. INSERT INTO tan_jreviews_reviewer_ranks (user_id, reviews, votes_percent_helpful, votes_total) ( SELECT userid AS user_id, COUNT(*) AS reviews, (IF(SUM(vote_total)>0,SUM(vote_helpful)/SUM(vote_total),0)) AS votes_percent_helpful, SUM(vote_total) AS votes_total FROM tan_jreviews_comments AS Review RIGHT JOIN tan_users AS User ON User.id = Review.userid AND User.block = 0 WHERE userid > 0 AND published = 1 AND author = 0 GROUP BY userid ORDER BY NULL ) ON DUPLICATE KEY UPDATE reviews = VALUES(reviews), votes_percent_helpful = VALUES(votes_percent_helpful), votes_total = VALUES(votes_total);
  12. INSERT INTO tan_jreviews_reviewer_ranks (user_id, `rank`) ( SELECT user_id, @curRank := @curRank + 1 AS `rank` FROM tan_jreviews_reviewer_ranks, (SELECT @curRank := 0) r ORDER BY reviews DESC, votes_percent_helpful DESC ) ON DUPLICATE KEY UPDATE `rank` = VALUES(`rank`);