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

Jerry Blumengarten Featured Hot

Written by The Nominations Committee    
 
5.0 (3)
 
5.0 (18)
0   0   0   0  
18 results - showing 1 - 15
1 2  
Ordering 
 
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Leslie Pralle Keehn May 16, 2015
Top 500 Reviewer  -   View all my reviews (6)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
When I am delivering professional learning if there is ONE resource that I make sure I give out, that is relevant to EVERY scenario and topic, it's CybraryMan! Jerry is an incredible fixture in education, and I am proud to cast a vote for him.
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Kristin Harrington May 10, 2015
Top 500 Reviewer  -   View all my reviews (5)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Jerry is an amazing person who truly sets out to help other educators every day. He came to our EdCamp this weekend and arrived early to help set up...we didn't even ask. He was such a huge presence and supporter for our event. Jerry is also a wealth of knowledge about most any educational topic. Whenever I am in a Twitter chat with him, I know great conversations are sure to follow. Jerry will be an amazing representative for the Bammy award!
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Christina Luce May 10, 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
Jerry is amazing. If you are looking for information or resources related to education, look no further than Jerry's website! It is an absolute treasure trove! He is brilliant, kind and supportive, and he has dedicated himself to learning and sharing his learning with others. The best of the best!
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Sandy King May 10, 2015
Top 10 Reviewer  -   View all my reviews (62)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
I've never had the pleasure of meeting Jerry in person but I hope I have the chance someday so that I thank him for his selfless sharing. I have used and used and used his resources. He is the ONE person that I tell every new person to Twitter to follow. No one can match his contribution to education!
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Nikki D Robertson May 08, 2015
Top 50 Reviewer  -   View all my reviews (16)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Jerry's site is my "go to" site for everything education related..even more than Google! Jerry is a wonderful person who has dedicated his life to education! He is the BEST!
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Jared Wastler May 07, 2015
Top 50 Reviewer  -   View all my reviews (36)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Find a chat, any chat, and see if Jerry is there. I guarantee he is. Jerry tirelessly supports educators worldwide through his resources and commentary. He is truly the Twitterverse Librarian.
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Craig Kemp May 07, 2015
Top 50 Reviewer  -   View all my reviews (29)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
I don't know how else to describe Jerry than the man! He is EDUCATION. You need a resource? Jerry's blog has it - he jumps in to chats, shares his ideas freely and never sells a product. He is truly the most sensational education blogger I have come across - his resources blow me away!
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Fran Simon May 06, 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
Jerry is a thought leader who shares his knowledge at the highest level.
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by John Martin May 06, 2015
Top 50 Reviewer  -   View all my reviews (16)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
What is not to love about Jerry? The man must have a clone factory because there is no way a single human being can do the amount of work that he's done, and give the appearance of being everywhere at once! I can't count the number of times he has jumped into #NHed or #RuralEdChat or any number of other chats with a resource page on the topic being discussed! He is the ultimate sharer and the web world is made better as a result of his presence! Thank you Jerry for all that you've done and continue to do for education!
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Arlen Kimmelman May 04, 2015
Top 500 Reviewer  -   View all my reviews (4)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Jerry is the go-to guy. If librarian = resource, then resource = Jerry.
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Karen Foley May 04, 2015
Top 500 Reviewer  -   View all my reviews (3)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
As a newbie to Twitter Jerry answered my query's quickly. He was very helpful and kind.
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Diana Rendina April 29, 2015
Top 500 Reviewer  -   View all my reviews (6)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Jerry's site is an amazing resource for all educators. He is truly the librarian of the internet, gathering resources, links and information useful to all of us. I have had the honor of meeting Jerry several times, and he is warm, supportive, down-to-earth and welcoming. Even though he is officially retired, he is extremely active in education and always offering up help to others. His passion for education is amazing!
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Tammy Neil April 27, 2015
Top 500 Reviewer  -   View all my reviews (6)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
When I think of Jerry Blumengarten, I always smile. He has supported more educators than anyone else I know. His wealth of information and his willingness to share it is unequaled. I have had the pleasure of co-facilitating with him at various edcamps around the state of Florida. His desire to help educators connect to each other is contagious. Speak to him about any topic and he almost instantly comes up with an educator working in that field. Jerry is everyone's mentor. I am blessed to also call him friend.
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Dennis Dill April 27, 2015
Top 100 Reviewer  -   View all my reviews (10)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Jerry is a game changer. He was one of the first educators I found on Twitter and has proven to be a valuable source of information and support. He awesomeness is not just limited to the virtual world as he is even better in person. I have had the honor of Jerry visiting my classes at school and he even joined my kids on a field trip. His positive energy is contagious and when he dons the cape you better watch out because something great is going to happen.
Overall rating 
 
5.0
Thoughtful Commentary 
 
5.0
Reliable Source 
 
5.0
Consistently Relevant 
 
5.0
Insightful and Informative 
 
5.0
Reviewed by Nancy April 26, 2015
Top 500 Reviewer  -   View all my reviews (7)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Jerry not only provides great resources but great insights as well. He participates in several chats and is always ready to help out whenever he can. He keeps his websites up-to-date and is always making additions. His passion and dedication to education is unwavering!
18 results - showing 1 - 15
1 2  
Ordering 
 
 
Powered by JReviews

Profile Information

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.020 seconds, 6.48 MB
Application afterRoute: 0.026 seconds, 8.53 MB
Application afterDispatch: 0.129 seconds, 23.30 MB
Application afterRender: 0.144 seconds, 24.63 MB

Memory Usage

25869880

79 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'ab92562795d4e6e8a55e2198a04fc7c0'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1516239552' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'ab92562795d4e6e8a55e2198a04fc7c0'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'ab92562795d4e6e8a55e2198a04fc7c0','1516246752','','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 = 1692
  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 = 69
  14. INSERT INTO
                                                    jos_jreviews_config (id, VALUE)
                                           
      VALUES
                                                    ('last_cache_clean', '1516246752')
                                           
      ON DUPLICATE KEY UPDATE
                                                    VALUE = '1516246752'
  15. SELECT id, VALUE
      FROM jos_jreviews_config
  16. DELETE
                                   
      FROM jos_jreviews_registration
                           
      WHERE
                                    session_time < 1516243152
  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 = 1692
     )
  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 (25)
     )
  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 (1692)
  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 (25)
     )
  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 = 1692
       
      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 (25)
     )
  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 (12297,12859,14082)
  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 (25)
     )
  31. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  32. 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 (25)
     )
  33. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  34. 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 (25)
     )
  35. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  36. 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= 1692
       
      AND Review.author = 0
       
      AND Review.published = 1
       
      AND Review.mode = "com_content"
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 15
  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 (25)
     )
  38. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  39. 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
  40. SELECT Review.reviewid AS element_id,jr_accomplishments
     
      FROM jos_jreviews_review_fields AS Review
     
      WHERE Review.reviewid IN (15357,14164,14141,14087,13813,13702,13596,13549,13509,13362,13354,13147,12945,12899,12823)
  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 (25)
     )
  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 (25)
     )
  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 (25)
     )
  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 (25)
     )
  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 (25)
     )
  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 (25)
     )
  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 (25)
     )
  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 (25)
     )
  56. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  57. 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 (25)
     )
  58. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  59. 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 (25)
     )
  60. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  61. 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 (25)
     )
  62. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  63. 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 (25)
     )
  64. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  65. 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 (25)
     )
  66. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  67. 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 (25)
     )
  68. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  69. 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 (25)
     )
  70. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  71. SELECT COUNT(*)
     
      FROM jos_jreviews_comments AS Review
     
      WHERE 1 = 1
      AND (
       Review.pid= 1692
       
      AND Review.author = 0
       
      AND Review.published = 1
       
      AND Review.mode = "com_content"
     )
  72. 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 (25)
     )
  73. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  74. 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
  75. 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
  76. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  77. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  78. SELECT *
                           
      FROM jos_menu
                           
      WHERE menutype='topmenu'
      AND published=1
                           
      ORDER BY sublevel DESC,ordering
                            ;
  79. SELECT *
                           
      FROM jos_modules
                           
      WHERE published=1
                           
      ORDER BY id
                            ;

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None