Notice: Undefined variable: user in /home/bammy54/public_html/nominations/templates/theme513/index.php on line 67

Notice: Trying to get property of non-object in /home/bammy54/public_html/nominations/templates/theme513/index.php on line 67

Bammy awards

Dennis Schug Featured Hot

Written by Donald Gately    
 
5.0
 
5.0 (10)
0   0   0   0  
10 results - showing 1 - 10
 
Ordering 
 
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Dan McCabe May 16, 2015
Last updated: May 16, 2015
Top 100 Reviewer  -   View all my reviews (9)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
From the very beginning of my journey as a connected educator I have met few people more upbeat and supportive than Dennis. I feel very lucky to have crossed paths with him and now call him a friend. Dennis is a smart, considerate leader who excels at developing relationships by honoring the voice of the people he surrounds himself with. Dennis and I had the privilege of traveling to San Diego together this year for NASSP. I value the time we spent learning together. What became very obvious to me was the way Dennis attracts people into his sphere due to his interpersonal skills and genuine care for the others. He is part of the educational vanguard leading the way for principals online and offline. His dedication to the advancement of education is remarkable and I am thrilled to support his Bammy nomination!
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Craig Vroom May 15, 2015
Top 100 Reviewer  -   View all my reviews (9)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Dennis is a leader among leaders! Whether working with kids, his staff or community he is invested 110% with all that he comes into contact with. Best practice and what is best for kids are two ways I would describe his leadership. A presence with social media and sharing of his work has been inspiring and motivating. Understanding the middle level is in his "wheel-house". It takes a talented educator to work with this age of students, Dennis is amazing in his role!
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by LaVonna Roth May 15, 2015
Top 50 Reviewer  -   View all my reviews (25)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Every so often I have the privilege of crossing paths with Dennis on Twitter and each time it is a pleasure! He offers insights and shares tidbits that make you think and nod in agreement. It is obvious he cares for every student, teacher and parent. His blog is another example of his own personal and professional insights, as well as growth. He's a shining example to middle school students who are often lost with who they are, yet their Principal, Dennis, models always learning and growing.
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Jeff Zoul May 10, 2015
Top 50 Reviewer  -   View all my reviews (23)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Dennis is one of my educational heroes. He is an amazing school leader who is always trying to get better and support those around him so they can get better as well. Dennis is always willing to lend a hand to support a fellow educator; he has helped me on several occasions. I learn a great deal from Dennis's Tweets, his blogs, his work at edcamps, and simply by the way he carries himself on a daily basis as a person. He is one of our nation's finest principals.
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Lisa Meade May 10, 2015
Top 500 Reviewer  -   View all my reviews (8)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Dennis lives and breathes middle school leadership. He is positive influence on all of us lucky enough to be in his PLN. He is articulate and driven to do what is best for kids at all times. I learn so much from Dennis. He makes me a better leader.
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Scott May 07, 2015
Top 1000 Reviewer  -   View all my reviews (2)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Dennis is a committed leader whose passion is evident in all he does. He empowers his staff to take risks in the classroom, embraces progressive ideas, and is always focused on what's best for students. As a mentor, he has shown me how passion, collaboration, drive, and stepping out of your comfort zone can lead to amazing things. He is well deserving of this nomination.
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Jon Harper May 02, 2015
Top 50 Reviewer  -   View all my reviews (18)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Dennis is the type of leader that I one day strive to be. He is without a doubt, one of the most reflective and positive leaders that I know. I recall a day earlier this year when he had to serve lunch to his entire school on the day his school would be dismissing early due to snow. Dennis saw this as a challenge and along with his staff was able to serve his whole student body in a little more than an hour. While we have never met face to face, I feel as if I know him well through the communication we have via Voxer. I truly consider Dennis to be a long distance mentor of mine and feel fortunate to have connected with him.
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Starr Sackstein May 02, 2015
Top 10 Reviewer  -   View all my reviews (67)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Although I don't work with Dennis directly at school, he is a huge part of my PLN. Completely dedicated to education with great energy. He is always contributing to making education better. Very deserving
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Audra Beberman May 01, 2015
Top 500 Reviewer  -   View all my reviews (8)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Dennis is a committed and capable educator. It was my good fortune to meet him when we co-founded and organized the first Long Island EdCamp. Dennis understands that the key to educating children in the 21st century is to first educate their teachers to be 21st century teachers! His peers, his subordinates and his students all know him as an effective leader who uses innovative ideas and technology to keep his building up-to-date and "of the moment." His skills as a collaborator are apparent on Twitter, in meetings and in his workshops as edcamp and other professional development gatherings. He is very deserving of this recognition.
Overall rating 
 
5.0
Visionary 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
Innovative 
 
5.0
Collaborative 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Donald Gately May 01, 2015
Top 500 Reviewer  -   View all my reviews (8)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Dennis Schug is a role model to every school leader because of his singular focus on the success and well-being of children and because of his sincere interest in collaborating and contributing to the field. Anyone who knows Dennis will attest to his expertise, intelligence, reflectiveness and vision for the success of middle level students. As a colleague and friend I can attest to his being a most worthy candidate for this recognition.
10 results - showing 1 - 10
 
Ordering 
 
 
Powered by JReviews

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.102 seconds, 23.17 MB
Application afterRender: 0.117 seconds, 24.48 MB

Memory Usage

25719648

65 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'ccb14780ab7e6d2c9fd243d48f5de3dd'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1516275572' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'ccb14780ab7e6d2c9fd243d48f5de3dd'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'ccb14780ab7e6d2c9fd243d48f5de3dd','1516282772','','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 VALUE
      FROM jos_jreviews_config
      WHERE id = 'debug_overrides_disable'
  10. 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

  11.   SET SQL_BIG_SELECTS=1
  12. SELECT catid
      FROM jos_content
      WHERE id = 1792
  13. SELECT JreviewsSection.tmpl AS `Section.tmpl_list`,JreviewsSection.tmpl_suffix AS    `Section.tmpl_suffix`,JreviewsCategory.tmpl AS `Category.tmpl_list`,JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`
     
      FROM jos_categories AS Category
     
      LEFT JOIN jos_jreviews_categories AS JreviewsCategory
      ON Category.id = JreviewsCategory.id
     
      LEFT JOIN jos_sections AS SECTION
      ON Category.SECTION = SECTION.id
     
      LEFT JOIN jos_jreviews_sections AS JreviewsSection
      ON SECTION.id = JreviewsSection.sectionid
     
      WHERE JreviewsCategory.OPTION = 'com_content'
      AND Category.id = 57
  14. INSERT INTO
                                                    jos_jreviews_config (id, VALUE)
                                           
      VALUES
                                                    ('last_cache_clean', '1516282773')
                                           
      ON DUPLICATE KEY UPDATE
                                                    VALUE = '1516282773'
  15. SELECT id, VALUE
      FROM jos_jreviews_config
  16. DELETE
                                   
      FROM jos_jreviews_registration
                           
      WHERE
                                    session_time < 1516279173
  17. 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.fulltext AS `Listing.description`,
    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 (
       Listing.id = 1792
     )
  18. 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
  19. 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 (13)
     )
  20. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'content'
  21. 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
  22. 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 (1792)
  23. 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 (13)
     )
  24. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'content'
  25. SELECT Review.id AS `Review.review_id`,
    Review.pid AS `Review.listing_id`,
    Review.mode AS `Review.extension`,
    Review.created AS `Review.created`,
    Review.modified AS `Review.modified`,
    Review.userid AS `Review.user_id`,
    Review.userid AS `User.user_id`,
    CASE WHEN CHAR_LENGTH(USER.name) THEN USER.name ELSE Review.name END AS `User.name`,
    CASE WHEN CHAR_LENGTH(USER.username) THEN USER.username ELSE Review.username END AS `User.username`,
    Review.email AS `User.email`,
    Review.ipaddress AS `User.ipaddress`,
    Rank.rank AS `User.review_rank`,
    Rank.reviews AS `User.review_count`,
    Review.title AS `Review.title`,
    Review.comments AS `Review.comments`,
    Review.posts AS `Review.posts`,
    Review.author AS `Review.editor`,
    Review.published AS `Review.published`,
    Rating.ratings AS `Rating.ratings`,
    (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`,
    Review.vote_helpful AS `Vote.yes`,
    (Review.vote_total - Review.vote_helpful) AS `Vote.no`,
    (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`,
    Review.owner_reply_text AS `Review.owner_reply_text`,
    Review.owner_reply_approved AS `Review.owner_reply_approved`,
    Review.owner_reply_created AS `Review.owner_reply_created`,
    Review.media_count AS `Review.media_count`,
    Review.video_count AS `Review.video_count`,
    Review.photo_count AS `Review.photo_count`,
    Review.audio_count AS `Review.audio_count`,
    Review.attachment_count AS `Review.attachment_count`,
    Criteria.id AS `Criteria.criteria_id`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.state AS `Criteria.state`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.weights AS `Criteria.weights`
     
      FROM jos_jreviews_comments AS Review

      LEFT JOIN jos_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid

      LEFT JOIN jos_users AS USER
      ON Review.userid = USER.id

      LEFT JOIN jos_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id

      LEFT JOIN jos_content AS Listing
      ON Review.pid = Listing.id

      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'

      LEFT JOIN jos_categories AS Category
      ON Category.id = JreviewsCategory.id

      LEFT JOIN jos_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
     
      WHERE 1 = 1
      AND (
       Review.pid = 1792
       
      AND Review.author = 1
       
      AND Review.published = 1
     )
  26. 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 (13)
     )
  27. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  28. 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 (19)
      AND `Group`.TYPE =  'review' )
     
      WHERE FIELD.location = 'review'
      AND FIELD.published = 1
     
      ORDER BY
      GROUP.ordering, FIELD.ordering
  29. SELECT Review.reviewid AS element_id,jr_accomplishments
     
      FROM jos_jreviews_review_fields AS Review
     
      WHERE Review.reviewid IN (14979)
  30. 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 (13)
     )
  31. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  32. SELECT Review.id AS `Review.review_id`,
    Review.pid AS `Review.listing_id`,
    Review.mode AS `Review.extension`,
    Review.created AS `Review.created`,
    Review.modified AS `Review.modified`,
    Review.userid AS `Review.user_id`,
    Review.userid AS `User.user_id`,
    CASE WHEN CHAR_LENGTH(USER.name) THEN USER.name ELSE Review.name END AS `User.name`,
    CASE WHEN CHAR_LENGTH(USER.username) THEN USER.username ELSE Review.username END AS `User.username`,
    Review.email AS `User.email`,
    Review.ipaddress AS `User.ipaddress`,
    Rank.rank AS `User.review_rank`,
    Rank.reviews AS `User.review_count`,
    Review.title AS `Review.title`,
    Review.comments AS `Review.comments`,
    Review.posts AS `Review.posts`,
    Review.author AS `Review.editor`,
    Review.published AS `Review.published`,
    Rating.ratings AS `Rating.ratings`,
    (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`,
    Review.vote_helpful AS `Vote.yes`,
    (Review.vote_total - Review.vote_helpful) AS `Vote.no`,
    (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`,
    Review.owner_reply_text AS `Review.owner_reply_text`,
    Review.owner_reply_approved AS `Review.owner_reply_approved`,
    Review.owner_reply_created AS `Review.owner_reply_created`,
    Review.media_count AS `Review.media_count`,
    Review.video_count AS `Review.video_count`,
    Review.photo_count AS `Review.photo_count`,
    Review.audio_count AS `Review.audio_count`,
    Review.attachment_count AS `Review.attachment_count`,
    Criteria.id AS `Criteria.criteria_id`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.state AS `Criteria.state`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.weights AS `Criteria.weights`
     
      FROM jos_jreviews_comments AS Review

      LEFT JOIN jos_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid

      LEFT JOIN jos_users AS USER
      ON Review.userid = USER.id

      LEFT JOIN jos_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id

      LEFT JOIN jos_content AS Listing
      ON Review.pid = Listing.id

      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'

      LEFT JOIN jos_categories AS Category
      ON Category.id = JreviewsCategory.id

      LEFT JOIN jos_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
     
      WHERE 1 = 1
      AND (
       Review.pid= 1792
       
      AND Review.author = 0
       
      AND Review.published = 1
       
      AND Review.mode = "com_content"
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 15
  33. 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 (13)
     )
  34. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  35. 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 (19)
      AND `Group`.TYPE =  'review' )
     
      WHERE FIELD.location = 'review'
      AND FIELD.published = 1
     
      ORDER BY
      GROUP.ordering, FIELD.ordering
  36. SELECT Review.reviewid AS element_id,jr_accomplishments
     
      FROM jos_jreviews_review_fields AS Review
     
      WHERE Review.reviewid IN (15285,15020,14975,14183,14175,13588,13310,13292,13282,13262)
  37. 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 (13)
     )
  38. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  39. 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 (13)
     )
  40. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  41. 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 (13)
     )
  42. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  43. 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 (13)
     )
  44. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  45. 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 (13)
     )
  46. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  47. 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 (13)
     )
  48. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  49. 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 (13)
     )
  50. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  51. 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 (13)
     )
  52. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  53. 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 (13)
     )
  54. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  55. 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 (13)
     )
  56. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  57. SELECT COUNT(*)
     
      FROM jos_jreviews_comments AS Review
     
      WHERE 1 = 1
      AND (
       Review.pid= 1792
       
      AND Review.author = 0
       
      AND Review.published = 1
       
      AND Review.mode = "com_content"
     )
  58. 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 (13)
     )
  59. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  60. SELECT
                        FIELD.fieldid AS `Field.id`, FIELD.groupid AS `Field.groupid`, 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.SEARCH AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`,
                        FIELD.published AS `Field.published`,FIELD.compareview AS `Field.compareView`,
                        `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 (19)
      AND `Group`.TYPE =  'review' )
                   
      WHERE
                        FIELD.published = 1
      AND FIELD.location = 'review'
                       
                   
      GROUP BY
                        FIELD.fieldid
                   
      ORDER
                        BY `Group`.ordering, FIELD.ordering
  61. 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
  62. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  63. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  64. SELECT *
                           
      FROM jos_menu
                           
      WHERE menutype='topmenu'
      AND published=1
                           
      ORDER BY sublevel DESC,ordering
                            ;
  65. SELECT *
                           
      FROM jos_modules
                           
      WHERE published=1
                           
      ORDER BY id
                            ;

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None