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

Gary Abud Featured Hot

Written by The Nominations Committee    
 
5.0 (2)
 
5.0 (33)
0   0   0   0  
33 results - showing 1 - 15
1 2 3  
Ordering 
 
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Andrew Steinman May 15, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
As 2014 Michigan Teacher of the Year, Gary Abud quickly became a role model for many educators, including myself. He is a true leader and one of the best educators. His knowledge and expertise has influenced classrooms and teachers across the nation.

One of the first words I think of to describe Gary Abud is collaborator. He understands the task of educating children cannot happen in isolation. Teachers must work together as a team in order to provide students with the education they need and deserve. As a high school science teacher, Gary Abud shared his instructional practices and lessons with other teachers, both in and out of his district. As an instructional coach, he has been able to further share best practice instructional practices and provide additional support through coaching and consultation.

Gary Abud has dedicated his life to the education of others. He has contributed to several events that promote the development of Michigan educators. Most recently, Gary Abud helped organize the Michigan New Teacher Conference. This event was dedicated to serving the learning needs of early career and aspiring educators. It also focused on networking and helped build a collaborative community of support for these young educators.

It is with no hesitation that I vote for Gary Abud to be the Bammy Award winning High School Teacher of the Year. I do not know anyone more deserving of this award than him.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Alex Teska May 15, 2015
Last updated: May 15, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
My path has crossed with Gary due to his gift of sight through corneal transplantation. The way that Gary uses his gift of sight, to give back and teach the future generation, makes his job even more special.

Recently our organization, Eversight Michigan, which coordinates corneal transplants for the state of Michigan, partnered with Gary and the Grosse Pointe School system to do something truly amazing. For the second year, Gary organized GPNnspire talks (similar to a TED talk format) and all of the money raised from tickets sales benefited our organization. Not only did Gary bring the Grosse Pointe community together around this event, but he promoted the gift of sight - allowing the children of a Metro Detroit cornea recipient to keynote the event. Constituents from our organization were amazed at the uplifting and inspiring event - you could tell that every student who spoke that night is on the path to do something truly outstanding in life.

I could not think of a more deserving candidate for the Bammy Awards, we are so inspired to see the work that Gary does on a daily basis.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Danny Schrage May 15, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Looking back three years after graduating, there are a handful of people that stick out as having played a significant role in shaping the person I am. Not only is Gary Abud one of them, he continues to challenge me intellectually because he understands one thing: the classroom can extend far beyond the doors of the high school.

I've heard buzz words like 'utilizing 21st century technology in the classroom' float around before. However, few educators are able to successfully apply their methods in a way that they not only engage their students by offering something cutting edge, but they then go one step further and use them effectively.

Gary had the respect of my peers and I because he did not rely on a static textbook, he was dynamic with the latest software and apps, and omnipresent (to this day!) with relevant events on Twitter. All of this contributed to a learning environment closer to any sort of academic Utopia than I thought could exist in a high school science classroom.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Christopher Profeta May 14, 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
Mr. Abud has been a strong advocate for moving our schools into the 21st century. We have much work to do, but we would not be as far along as we are without the hard work of Mr. Abud.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Michelle Okroy May 13, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Gary Abud is an extraordinary teacher whose educational philosophy focuses on collaboration with all stakeholders involved in education. He is involved in various types of professional development whether it is incorporating new technology into the classroom, developing new teachers, or improving STEM education in science classes, Gary does it all and does it well!

Gary has the incredible skill of being a dynamic leader while still providing members of a school community with opportunities to collaborate and provide input. This has been evident in our work together through Modeling Instruction workshops over the last three years. During this time I have had the pleasure to work with Gary as both a participant and co-facilitator and in each situation Gary has gone out of his way to incorporate my thoughts and expectations into the workshops. He is always working on improving STEM education in the state of Michigan and welcomes the input of other science educators when it comes to improving the Modeling Instruction curriculum. In addition to our work with Modeling Instruction, Gary has been a valuable asset in developing a physics cardboard boat regatta in my school district. With Gary's mentorship I was able to develop this project, while integrating state and national science standards, into a successful hands-on learning experience.

In summary my experience working with Gary has made me a better educator. It is apparent that improving education is his top priority and he wants everyone to be a part of the collaborative process. He embodies what it means to be distinguished educator.




Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Jen Evans May 13, 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
Mr. Abud is an excellent teacher, both for students and for his fellow educators. He is passionate about making technology accessible to everyone and works with groups and one-on-one to make sure people have the tools they need to use it. He is an inspiration!
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Geoffrey Fong May 12, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Mr. Abud always has a way to motivate students to learn. The use of technology in his classroom is a great way to help students understand a specific material. When I first arrived in his classroom, I didn't know what to expect. When I heard that we get to use mobile devices in his class, that got me feeling like I want to learn how to use new things with apps like Google Drive and how it's used. He always brings a positive attitude to the classroom and to Grosse Pointe North. The way he collaborates with students in his class is amazing and with new technology he teaches gets the students motivated. His passion for being a role model and as a collaborator can be felt throughout GPN and to the entire Grosse Pointe community.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Allison Baker May 12, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
As a parent from the rival high school, all I can say is that I wish we could clone Gary and spread him around the district. An educator who is truly interested in finding solutions for kids, and helping other teachers do the same.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Jed Scott May 12, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
I I became aware of Gary when he was nominated for (and eventually won) Michigan Teacher of the Year. He has become a wonderful resource for teaching ideas, both through his active Twitter feed and through personal interactions. He is a willing sharer of his insights an his insights are plentiful and highly worthwhile.

Gary is an excellent model of a twenty-first century teacher, and despite our working in vastly different subject matters (physics vs vocal music), his work his significantly impacted my own. His students and colleagues are lucky to have him, and his willingness to be open about his teaching process means that his impact can reach far beyond his own school district.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Judy Gafa May 08, 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
Gary is a great role model for the students at GP North high school, where he was a student just a few short years ago. His collaboration and positivity and respect for the students is unparalleled. Gary always is looking for teachable moments and student input and creativity.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Steve Perkins May 07, 2015
Top 1000 Reviewer  -   View all my reviews (2)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
I have taught for 24 years and can honestly say that I have enjoyed collaborating with Gary on projects more than I have with any other colleague. He shares his ideas while giving space for others to do the same. He is incredibly connected in the education community and models very well how to lead in the 21st century.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Andrew Taylor May 07, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Gary's work is grounded in instructional practice. Whether using technology, project-based learning, or standards-based grading, the question always comes back to how to foster student learning through enhanced instruction and feedback. Using a tool or a project for the spotlight or novelty is never considered.

As a presenter, coach and a leader, his professionalism is peerless. Great leaders make their team feel comfortable, and with Gary that is quickly apparent, whether he's meeting a cold audience or long-time colleagues.

Most of all, he's a positive force for finding solutions. You'll never hear "We tried that," or "That won't work," as the end of a conversation. Rather, he'll re-focus the question on finding new solutions to explore, enabling learning to grow for adults and students alike.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Katie Buda May 05, 2015
Last updated: May 05, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Gary taught me a more valuable lesson than the principles of physics- he taught me that I can learn and excel at even my weakest subjects. Although I don't still remember all of the things I learned in his class, I will never forget the experience of learning that I can actually learn. Every day I looked forward to Gary's class because he approached teaching in a way that was open minded, positive and engaging. I never felt like I would be made to feel "dumb" like I often felt in math and science classes throughout my entire academic career. I always felt capable and accomplished, even though physics was never something I thought I could be "good" at. Gary left a lasting impression on me that I will never forget. As I continue my education at the University of Utah and take classes that leave me feeling overwhelmed, I recall Gary's high school physics class and remind myself again that I can achieve anything.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Melissa White May 04, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Gary is very passionate about his work whether it is teaching children or adults. He is an innovator and a wonderful presenter. He packs the house when he is at MACUL! His newest project to provide quality PD to educators is being well received in its infancy. His work especially with pre-service teachers is needed so our new teachers are better prepared when they begin working with students.
Overall rating 
 
5.0
Collaborative 
 
5.0
Proactive 
 
5.0
Effective 
 
5.0
21st Century Role Model 
 
5.0
Reviewed by Amber May 03, 2015
  -   View all my reviews (1)

About the Nominee

Briefly explain what makes this person a noteworthy collaborator, contributor or role model
Gary is wonderfully enthusiastic and passionate about making a difference in education. Not only does he want to impact his students, he cares deeply for impacting all those in the education world including pre-service teachers, teachers, and educators in any sense of the word. He works tirelessly to build networks that allow him to share his knowledge and experiences with those around him while still learning all that he can. Gary Abud is a teacher, a leader, and a life long learner making a positive mark in the educational community!
33 results - showing 1 - 15
1 2 3  
Ordering 
 
 
Powered by JReviews

Profile Information

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.021 seconds, 6.48 MB
Application afterRoute: 0.027 seconds, 8.53 MB
Application afterDispatch: 0.111 seconds, 23.31 MB
Application afterRender: 0.127 seconds, 24.65 MB

Memory Usage

25890672

77 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '6c01ec65222e0f8d373e6d7aa9b2dbff'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1516204874' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '6c01ec65222e0f8d373e6d7aa9b2dbff'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '6c01ec65222e0f8d373e6d7aa9b2dbff','1516212074','','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 = 1748
  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 = 63
  14. INSERT INTO
                                                    jos_jreviews_config (id, VALUE)
                                           
      VALUES
                                                    ('last_cache_clean', '1516212074')
                                           
      ON DUPLICATE KEY UPDATE
                                                    VALUE = '1516212074'
  15. SELECT id, VALUE
      FROM jos_jreviews_config
  16. DELETE
                                   
      FROM jos_jreviews_registration
                           
      WHERE
                                    session_time < 1516208474
  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 = 1748
     )
  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 (19)
     )
  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 (1748)
  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 (19)
     )
  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 = 1748
       
      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 (19)
     )
  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 (12725,14229)
  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 (19)
     )
  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 (19)
     )
  33. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  34. 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= 1748
       
      AND Review.author = 0
       
      AND Review.published = 1
       
      AND Review.mode = "com_content"
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 15
  35. 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 (19)
     )
  36. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  37. 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
  38. SELECT Review.reviewid AS element_id,jr_accomplishments
     
      FROM jos_jreviews_review_fields AS Review
     
      WHERE Review.reviewid IN (15180,15074,14917,14777,14678,14532,14475,14445,14443,13948,13758,13584,13403,13369,13333)
  39. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.qty AS `Criteria.quantity`,
    Criteria.groupid AS `Criteria.group_id`,
    Criteria.state AS `Criteria.state`,
    Criteria.SEARCH AS `Criteria.search`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (19)
     )
  40. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  41. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.qty AS `Criteria.quantity`,
    Criteria.groupid AS `Criteria.group_id`,
    Criteria.state AS `Criteria.state`,
    Criteria.SEARCH AS `Criteria.search`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  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 (19)
     )
  68. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  69. SELECT COUNT(*)
     
      FROM jos_jreviews_comments AS Review
     
      WHERE 1 = 1
      AND (
       Review.pid= 1748
       
      AND Review.author = 0
       
      AND Review.published = 1
       
      AND Review.mode = "com_content"
     )
  70. 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 (19)
     )
  71. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
  72. 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
  73. 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
  74. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  75. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
  76. SELECT *
                           
      FROM jos_menu
                           
      WHERE menutype='topmenu'
      AND published=1
                           
      ORDER BY sublevel DESC,ordering
                            ;
  77. SELECT *
                           
      FROM jos_modules
                           
      WHERE published=1
                           
      ORDER BY id
                            ;

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None