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

Loreli Stochaj Featured Hot

Written by cheryl    
 
5.0
 
5.0 (75)
0   0   0   0  
75 results - showing 1 - 15
1 2 3 4 5  
Ordering 
 
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by MaryEliza McEachen May 14, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Ms. Stochaj is a kind and attentive librarian. She connects with all of the kids on a personal level and helps them discover the exciting and rewarding world of reading.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by pat May 14, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Loreli is not just a librarian, she is a positive force for learning in the school and also in the community. Loreli has proactively developed a robotics course for 4 and 5th graders. It started as an after school enrichment course, but she continued with the children for 30 minutes before school started, the latter on a purely volunteer basis. She actively teaches technology during the library classes, having the children slowly build up their skills by using google docs, powerpoint and also digital cameras to illustrate their chosen topics. Loreli also has a passion for reading and instills this in her students by helping them choose books according to their ability and interest. Loreli also runs a program called "Books and Woofs" at the local library. In this program elementary school children sign up to read to the local Seeing Eye dogs. The dogs gain socialization experience and the children develop a love of reading whilst conquering their fear of dogs. My own daughter started going to this program when she was in 2nd grade, she would sit 2-3ft away from the dogs, at the end of the year it was a joy to see her reading to a dog while it balanced its head on her leg. It has been a privilege to know Loreli and I hope she wins this award she deserves it.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Eleanor Wang May 14, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Loreli is innovative, creative and dedicated. She is always on the look out to enrich the students' experience at Franklin. She helps the staff in so many ways. It is really wonderful the way students love going to our school library. They learn so much from Ms. Stochaj and love their time with her.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Deb McCann May 13, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Loreli is an amazing member of the Franklin School and Summit community. I have 2 children at Franklin School and it is amazing to watch her work with the kids. She instills a love of reading within all Franklin School students by helping each student find books that will get him/her excited about reading and learning. Each child feels as if Mrs. Stochaj is their personal librarian because she very quickly learns what makes them tick and makes each one of them feel special as she helps them find the perfect book just for them. Isn't that really what education is about? In addition to inspiring the kids to read, she has quickly become a media and technology specialist so that she can teach the kids how they can most effectively utilize technology to learn and grow. Outside of the school I have the honor of working with Loreli on the Summit Public Library Foundation where she is dedicated to improving the children's programs at the public library in order to further improve the reading opportunities for children in Summit. She is truly amazing and works so hard not only during her workday but after work as a volunteer, all for the benefit of Summit's kids. I can't imagine anybody more deserving of this amazing award dedicated to honoring our finest educators.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Kathryn B May 12, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Loreli does so many wonderful things for Franklin School and our community. She is a wonderful Librarian but also teaches extracurricular classes before and after school, helps kids with special projects including charity work and has completely transformed our school library. She always goes the extra mile to help the kids and it shows because both my children love her!
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Donna Gangi May 12, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Loreli goes above and beyond in so many ways. Not only did she transform our library into a true 21st century learning and information center (and encourage technical skills in the Tech Club and Robotics club she formed), but she teaches the students how to think like 21st Century thinkers and how to use the resources effectively rather than just use them. During my many volunteer shifts in the Franklin Library Information Center (FLIC), I witness how she gets the students to think critically about research topics, etc. It is quite amazing how she gets them to figure out the questions and the answers and then find them and they do so with eagerness and enthusiasm. She teaches them how to organize their information which helps how they think about it. In addition, not only do I see Loreli collaborate with teachers who look to her for her expert advice and guidance, but Loreli also teaches the students to collaborate!! That's a true 21st Century Role Model! But what is also truly inspiring is when Loreli reads to the students. They don't even realize that she is teaching them important skills because they are having a ball! She reads with such precise yet entertaining expression, connects themes with her own personal stories, encourages discussion and self reflection. In fact, during this reading time, she even teaches them manners such as being considerate and taking turns. I find that as I'm shelving books, she gets me thinking and even laughing about the books! Loreli also makes time to get to know the students and really talk to them. She keeps FLIC very organized and has her lessons planned out and prepared ahead of time and that leaves her time to take the extra and very meaningful moments with students. When my daughter was in 5th grade, Loreli sensed that she would benefit from some extra conversation about the books she was reading. They ended up having lively and interesting conversations. Loreli would set aside books for her based on their conversations. My daughter really benefitted from those intellectually stimulating conversations and it sparked a true love for books that she still has in high school. So even though Loreli has led our school and our library into the 21st Century as well as teach the students important 21st Century skills, she also models and instills a love of books, critical thinking and character.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Donna StAmant May 12, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Loreli is always looking for new and creative programs to bring to the children and our school. She is so much more than our school librarian. She is a wonderful role model and always goes the extra mile.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Jennifer Geoghegan May 11, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Lorelei partners with teachers and others to engage the children. She partnered with our Brownie Troop to support the Seeing Eye program. She also helped me personally when my son had a concussion and was unable to read. She kept us stocked up on audio books to keep him relaxed and learning.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Christine Murray May 11, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Loreli is a passionate, dedicated and caring librarian and educator. When I volunteer at the library I watch as she gets the children excited about a research project, a book or a new club she is starting. Her reach at the school goes far beyond the library. She has started technology, robotics and coding clubs which meet before or after school and are heavily attended. Loreli is also dedicated to outside causes like the Seeing Eye and Susan Koman Walk for the Cure, which inspires the students. Loreli has been a positive role model not just for my four kids, but for the school and the community as well. We are lucky to have her!
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Kate Polles May 11, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Ms. Stochaj has turned the library into a place of learning and fun. She helps turn every idea turn into a reality, and her enthusiasm for teaching is evident each day. Ms. Stochaj encourages teachers and students alike to learn more about whatever it is that interests them, and she finds innovative ways to cultivate their learning through electronic and print sources. She supports teachers in becoming more comfortable using technology in their classrooms in ways that are extremely engaging and motivating for the students. Ms. Stochaj is a role model and inspiration to all who meet her.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Liz Buryk May 11, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Loreli is an innovative and passionate educator who knows how to reach kids of all ages and interests. She collaborates with teachers and isn't afraid to pilot any new project! She is a role model to all.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Bethann Harvey May 11, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Ms Stochaj is an amazing librarian and teacher for all of our children. She works collaboratively with all of the teachers at our school and helps work the library learnings into the curriculum. My children are enthusiastic readers, and they love to go to library to get an enrichment to their classroom learnings. The technology education that Ms Stochaj brings to my children is always amazing for them. She shows them something new every time they are there. Her passion and enthusiasm for the students and the school is contagious.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by myung shin May 08, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
She gets kids interested in learning and she tries to collaborate with classroom teachers to further enhance kids learning.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Courtney Alberta May 08, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
A wonderful example and a leader who gets the kids excited to read!
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Organized  
 
5.0
Tech Savvy 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by jamie May 08, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Loreli has the unique gift of being able to embrace each and every child with enthusiasm, compassion and authority. Kids look forward to library time where they are encouraged to explore the book shelves, experiment with technology and have fun while doing so. Three of my children have thrived under Loreli's leadership--three very different personalities that Loreli was able to connect with on individual basis. My oldest child is about to graduate from high school, and Loreli took the time out of her demanding schedule to see her perform on stage and send her a personal note after the performance, a true testament to the fact that her love of teaching children does not end when they leave her library classroom. Loreli is there for her students not only during library time, but also as they grow and mature, setting a great example of who a true educator is.
75 results - showing 1 - 15
1 2 3 4 5  
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.027 seconds, 8.53 MB
Application afterDispatch: 0.130 seconds, 23.32 MB
Application afterRender: 0.146 seconds, 24.65 MB

Memory Usage

25894776

74 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'b5ee5fe35cf8228fc4adaa482407cccd'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1516380971' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'b5ee5fe35cf8228fc4adaa482407cccd'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'b5ee5fe35cf8228fc4adaa482407cccd','1516388171','','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.   SET SQL_BIG_SELECTS=1
  11. SELECT catid
      FROM jos_content
      WHERE id = 1697
  12. 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 = 91
  13. INSERT INTO
                                                    jos_jreviews_config (id, VALUE)
                                           
      VALUES
                                                    ('last_cache_clean', '1516388171')
                                           
      ON DUPLICATE KEY UPDATE
                                                    VALUE = '1516388171'
  14. SELECT id, VALUE
      FROM jos_jreviews_config
  15. DELETE
                                   
      FROM jos_jreviews_registration
                           
      WHERE
                                    session_time < 1516384571
  16. 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 = 1697
     )
  17. 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
  18. 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 (44)
     )
  19. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'content'
  20. 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
  21. 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 (1697)
  22. 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 (44)
     )
  23. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'content'
  24. 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 = 1697
       
      AND Review.author = 1
       
      AND Review.published = 1
     )
  25. 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 (44)
     )
  26. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  27. 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
  28. SELECT Review.reviewid AS element_id,jr_accomplishments
     
      FROM jos_jreviews_review_fields AS Review
     
      WHERE Review.reviewid IN (12333)
  29. 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 (44)
     )
  30. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  31. 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= 1697
       
      AND Review.author = 0
       
      AND Review.published = 1
       
      AND Review.mode = "com_content"
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 15
  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 (44)
     )
  33. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  34. 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
  35. SELECT Review.reviewid AS element_id,jr_accomplishments
     
      FROM jos_jreviews_review_fields AS Review
     
      WHERE Review.reviewid IN (14729,14704,14703,14597,14476,14450,14396,14258,14257,14214,14206,14204,13956,13861,13839)
  36. 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 (44)
     )
  37. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  38. 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 (44)
     )
  39. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  40. 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 (44)
     )
  41. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  42. 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 (44)
     )
  43. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  44. 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 (44)
     )
  45. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  46. 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 (44)
     )
  47. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  48. 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 (44)
     )
  49. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  50. 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 (44)
     )
  51. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  52. 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 (44)
     )
  53. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  54. 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 (44)
     )
  55. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  56. 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 (44)
     )
  57. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  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 (44)
     )
  59. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  60. 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 (44)
     )
  61. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  62. 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 (44)
     )
  63. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  64. 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 (44)
     )
  65. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  66. SELECT COUNT(*)
     
      FROM jos_jreviews_comments AS Review
     
      WHERE 1 = 1
      AND (
       Review.pid= 1697
       
      AND Review.author = 0
       
      AND Review.published = 1
       
      AND Review.mode = "com_content"
     )
  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 (44)
     )
  68. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  69. 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
  70. 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
  71. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  72. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  73. SELECT *
                           
      FROM jos_menu
                           
      WHERE menutype='topmenu'
      AND published=1
                           
      ORDER BY sublevel DESC,ordering
                            ;
  74. SELECT *
                           
      FROM jos_modules
                           
      WHERE published=1
                           
      ORDER BY id
                            ;

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None