SELECT *
FROM jos_session
WHERE session_id = '0a177c92fd56ae9b541ca5d7c31a2d8d'
DELETE
FROM jos_session
WHERE ( TIME < '1524261727' )
SELECT *
FROM jos_session
WHERE session_id = '0a177c92fd56ae9b541ca5d7c31a2d8d'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '0a177c92fd56ae9b541ca5d7c31a2d8d','1524268927','','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 = 1)
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 = 1659
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-21 00:02:07' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-21 00:02:07' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='1659'
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 = 1659
SELECT
COUNT(*)
FROM
jos_jreviews_categories AS Category
WHERE
Category.OPTION = 'com_content'
AND
Category.id = 96
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', '1524268929')
ON DUPLICATE KEY UPDATE
VALUE = '1524268929'
SELECT id, VALUE
FROM jos_jreviews_config
DELETE
FROM jos_jreviews_registration
WHERE
session_time < 1524265332
SELECT
COUNT(*)
FROM
jos_jreviews_categories AS JreviewCategory
WHERE
JreviewCategory.id = 96
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 = 1659
)
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 (3)
)
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 (1659)
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 (3)
)
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 = 96
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 = 1659
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 (3)
)
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 (14079,12137)
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 (3)
)
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 (3)
)
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 = 1659
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= 1659
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 (3)
)
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 (14433,14136,14130,14042,13755)
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 (3)
)
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 (3)
)
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 (3)
)
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 (3)
)
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 (3)
)
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= 1659
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 (3)
)
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 = 1 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT j_user_id
FROM jos_jfbconnect_user_map
WHERE fb_user_id=''
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND menuid = 0