Amy Heavin Featured Hot
Written by The Nominations Committee
About NomineeName of Nominee: Nominees' website: Nominee's Organization Ryan Park Elementary School Nominators affiliation to nominee: Colleague Tell us how he/she is making a difference: Amy has been a school administrator for 5 years. Previously, she taught middle school for 8 years. As a school leader, Amy is passionate about curriculum and instruction, pursuing learning opportunities to blend 21st-century instruction in essential skills with best practices. She leads through collaboration and coaching efforts. Editor reviews
About the NomineeBriefly explain what makes this person a noteworthy collaborator, contributor or role model Amy co-moderates the #INeLearn Twitter chat and is a monthly writer for Fractus Learning. Through both, she promotes the integration of strong pedagogy with technology in the classroom. But Amy also shares her philosophy about kids and learning with her thoughtful blog, Leading Inspired. She does all of this in addition to being a principal, wife, and mom. User reviews View all user reviewsAverage user rating from: 7 user(s)
About the NomineeBriefly explain what makes this person a noteworthy collaborator, contributor or role model Amy is an inspirational leader and serves as a model for others. Her positive message and focus on constant improvement helps all she comes into contact with.
About the NomineeBriefly explain what makes this person a noteworthy collaborator, contributor or role model Amy is reflective, collaborative and leads by example in her building and on social media!
About the NomineeBriefly explain what makes this person a noteworthy collaborator, contributor or role model Amy is an AMAZING administrator who leads by example every day! Not only does she model technology integration, She thoughtfully embraces curriculum and how the two should naturally fit together. Amy devotes herself to digitally telling the stories of why her school is a great place to be! I am proud to work with Amy, and look forward to seeing her career blossom as she continues moderating our state Twitter chats, blogging, and modeling what it takes to be a fantastic educational leader!!!!
About the NomineeBriefly explain what makes this person a noteworthy collaborator, contributor or role model When I think of Amy, I think of someone who has every reason to say, there isn't time for that. I am too busy to invest in being a connected educator. Fortunately, Amy does not operate like that. She models what she expects from her faculty and pulls her administrator peers up too. We are very fortunate to have her as an active member in a number of our online communities particularly the #INeLearn chat where she moderates our Digital Leadership strand! And she's a mean Voxer participant too!
About the NomineeBriefly explain what makes this person a noteworthy collaborator, contributor or role model Amy is an innovative and collaborative leader and learner. She centers everything around the students. As a principal, she ecourages teachers to give their best all the time. She is an excellent source of knowledge.
Powered by JReviews
|
#BammyAwards
Break the Code of Silence
Search Nominees
Login Form
Profile Information
Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.020 seconds, 6.48 MB
Application afterRoute: 0.025 seconds, 8.17 MB
Application afterDispatch: 1.448 seconds, 26.22 MB
Application afterRender: 1.464 seconds, 27.52 MB
Memory Usage
2890368061 queries logged
- SELECT *
FROM jos_session
WHERE session_id = '113c09d0526d8b9c9a8d5553cc820db3' - DELETE
FROM jos_session
WHERE ( TIME < '1524617741' ) - SELECT *
FROM jos_session
WHERE session_id = '113c09d0526d8b9c9a8d5553cc820db3' - INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '113c09d0526d8b9c9a8d5553cc820db3','1524624941','','0','1','0' ) - SELECT *
FROM jos_components
WHERE parent = 0 - SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering - SELECT setting,VALUE
FROM jos_jfbconnect_config - 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 - SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1 - SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.SECTION
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 1647
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-25 02:55:41' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-25 02:55:41' ) ) OR ( a.state = -1 ) ) - UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='1647' - SELECT
published, params
FROM
jos_plugins
WHERE
element = 'jreviews'
AND folder = 'content'
LIMIT 1 - SELECT VALUE
FROM jos_jreviews_config
WHERE id = 'debug_overrides_disable' - SELECT catid
FROM jos_content
WHERE id = 1647 - SELECT
COUNT(*)
FROM
jos_jreviews_categories AS Category
WHERE
Category.OPTION = 'com_content'
AND
Category.id = 55 - 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
SET SQL_BIG_SELECTS=1- INSERT INTO
jos_jreviews_config (id, VALUE)
VALUES
('last_cache_clean', '1524624941')
ON DUPLICATE KEY UPDATE
VALUE = '1524624941' - SELECT id, VALUE
FROM jos_jreviews_config - DELETE
FROM jos_jreviews_registration
WHERE
session_time < 1524621342 - SELECT
COUNT(*)
FROM
jos_jreviews_categories AS JreviewCategory
WHERE
JreviewCategory.id = 55
AND
JreviewCategory.OPTION = 'com_content'
AND
JreviewCategory.criteriaid > 0 - 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 = 1647
) - 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 - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - 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 - 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 (1647) - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'content' - 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 = 55 - 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 = 1647
AND Review.author = 1
AND Review.published = 1
)
ORDER BY `Review.created` DESC
LIMIT 5 - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'review' - 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 - SELECT Review.reviewid AS element_id,jr_accomplishments
FROM jos_jreviews_review_fields AS Review
WHERE Review.reviewid IN (12087) - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'review' - SELECT COUNT(*)
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 = 1647
AND Review.author = 1
AND Review.published = 1
) - 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`,
Review.owner_reply_approved AS `Review.owner_reply_approved`,
Review.owner_reply_text AS `Review.owner_reply_text`,
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= 1647
AND Review.author = 0
AND Review.published = 1
AND Review.mode = 'com_content'
AND JreviewsCategory.`option` = 'com_content'
)
ORDER BY `Review.created` DESC
LIMIT 5 - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'review' - 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 - SELECT Review.reviewid AS element_id,jr_accomplishments
FROM jos_jreviews_review_fields AS Review
WHERE Review.reviewid IN (15223,15124,14404,13921,12695) - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'review' - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'review' - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'review' - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'review' - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'review' - SELECT COUNT(*)
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= 1647
AND Review.author = 0
AND Review.published = 1
AND Review.mode = 'com_content'
AND JreviewsCategory.`option` = 'com_content'
) - 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 (12)
) - SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19)
AND TYPE = 'review' - 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 - 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 - SELECT j_user_id
FROM jos_jfbconnect_user_map
WHERE fb_user_id='' - SELECT *
FROM jos_menu
WHERE menutype='topmenu'
AND published=1
ORDER BY sublevel DESC,ordering
; - SELECT *
FROM jos_modules
WHERE published=1
ORDER BY id
;
Language Files Loaded
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.plg_system_jqueryeasy.ini
- /home/bammy54/public_html/nominations/administrator/language/en-GB/en-GB.plg_system_easycalccheckplus.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.plg_system_debug.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.com_content.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.plg_content_pagebreak.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.tpl_theme513.ini
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_jcomments_most_commented.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_search.ini 1
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_socialauth.ini
- /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_maximenu_CK.ini 1
Untranslated Strings Diagnostic
None
Untranslated Strings Designer
None