SELECT *
FROM jos_session
WHERE session_id = '0ehnn0f5sgle61buehslsjmpa4'
DELETE
FROM jos_session
WHERE ( time < '1231320902' )
SELECT *
FROM jos_session
WHERE session_id = '0ehnn0f5sgle61buehslsjmpa4'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '0ehnn0f5sgle61buehslsjmpa4','1231332902','','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 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 = 98)
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 = 87
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-01-07 12:55:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-07 12:55:02' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='87'
SELECT published,params
FROM jos_plugins
WHERE element = 'jreviews'
AND folder = 'content'
LIMIT 1
SELECT id,name,link AS menu_type,link,componentid,params
FROM jos_menu
WHERE published = 1
ORDER BY link DESC
SELECT id, value
FROM jos_jreviews_config
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 = 39
SELECT jr_category.criteriaid,jr_category.tmpl_suffix AS cat_suffix,criteria.state,category.image,
jr_section.tmpl_suffix AS sec_suffix, jr_category.dirid
FROM jos_jreviews_categories AS jr_category
LEFT JOIN jos_categories AS category
ON category.id = jr_category.id
LEFT JOIN jos_jreviews_sections AS jr_section
ON category.section = jr_section.sectionid
LEFT JOIN jos_jreviews_criteria AS criteria
ON jr_category.criteriaid = criteria.id
WHERE jr_category.OPTION = 'com_content'
AND jr_category.id = 39
SELECT id,created
FROM `jos_jreviews_votes_tmp`
ORDER BY reviewid
SELECT Listing.id AS `Listing.listing_id`,
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.sectionid AS `Listing.section_id`,
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.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.state AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Section.id AS `Section.section_id`,
Section.title AS `Section.title`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.image AS `Listing.category_image`,
Directory.id AS `Directory.dir_id`,
Directory.title AS `Directory.title`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.state AS `Criteria.state`,
`Field`.featured AS `Listing.featured`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty)) AS `Review.editor_rating`,
IF(sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty))>0,1,0) AS `Review.editor_rating_exists`,
(sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty)) AS `Review.user_rating`,
IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
(count(Review.id)-sum(Review.author)) AS `Review.review_count`,
IF ((count(Review.id)-sum(Review.author))>0,1,0) AS `Review.review_count_exists`,
Listing.alias AS `Listing.slug`,
Category.alias AS `Category.slug`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.weights AS `Criteria.weights`
FROM jos_content AS Listing
LEFT JOIN jos_jreviews_comments AS Review
ON Listing.id = Review.pid
AND Review.published = 1
AND Review.mode = 'com_content'
LEFT JOIN jos_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
LEFT JOIN jos_jreviews_content AS FIELD
ON FIELD.contentid = Listing.id
LEFT JOIN jos_sections AS Section
ON Listing.sectionid = Section.id
LEFT JOIN jos_categories AS Category
ON Listing.catid = Category.id
INNER JOIN jos_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
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
WHERE 1 = 1
AND (
Listing.id = 87
)
GROUP BY Listing.id
SELECT id,name,link AS menu_type,link,componentid,params
FROM jos_menu
WHERE published = 1
ORDER BY link DESC
SELECT *
FROM jos_comprofiler AS CommunityBuilder
WHERE 1 = 1
AND (
user_id IN (63)
)
SELECT id
FROM jos_menu
WHERE link LIKE "%com_comprofiler%"
AND published = 1
SELECT content_id AS listing_id, count(Favorite.favorite_id) AS favored
FROM jos_jreviews_favorites AS Favorite
WHERE Favorite.content_id IN (87)
GROUP BY listing_id
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
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.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (1,4,2)
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.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`.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 (1,4)
AND `Group`.type = 'content' )
WHERE FIELD.location = 'content'
AND FIELD.published = 1
ORDER BY
GROUP.ordering, FIELD.ordering
SELECT *
FROM jos_jreviews_fieldoptions
WHERE fieldid = 4
ORDER BY ordering ASC ,optionid ASC
SELECT *
FROM jos_jreviews_fieldoptions
WHERE fieldid = 18
ORDER BY ordering ASC ,optionid ASC
SELECT *
FROM jos_jreviews_fieldoptions
WHERE fieldid = 20
ORDER BY ordering ASC ,optionid ASC
SELECT Listing.contentid AS element_id,jr_usplayers,jr_website,jr_established,jr_country,jr_email,jr_telephone,jr_startingchips,jr_blindlevel,jr_microstakes,jr_multi
FROM jos_jreviews_content AS Listing
WHERE Listing.contentid IN (87)
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 `User.user_id`,
Review.name AS `User.name`,
Review.username AS `User.username`,
Review.email AS `User.email`,
Review.location AS `User.location`,
Review.ipaddress AS `User.ipaddress`,
Review.title AS `Review.title`,
Review.comments AS `Review.comments`,
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`,
Vote.yes AS `Vote.yes`,
Vote.no AS `Vote.no`,
(Vote.yes/(Vote.yes+Vote.no))*100 AS `Vote.helpful`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.criteria AS `Criteria.criteria`,
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_jreviews_votes AS Vote
ON Review.id = Vote.reviewid
LEFT JOIN jos_content AS Listing
ON Review.pid = Listing.id
LEFT JOIN jos_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option`='com_content'
LEFT JOIN jos_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
WHERE 1 = 1
AND (
Review.pid = 87
AND Review.author = 1
AND Review.published = 1
)
GROUP BY Review.id
SELECT *
FROM jos_comprofiler AS CommunityBuilder
WHERE 1 = 1
AND (
user_id IN (63)
)
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.criteria AS `Criteria.criteria`,
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.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (1)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (1,4,2)
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.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`.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 (2)
AND `Group`.type = 'review' )
WHERE FIELD.location = 'review'
AND FIELD.published = 1
ORDER BY
GROUP.ordering, FIELD.ordering
SELECT Review.userid, count(Review.userid) AS review_count,
sum(Vote.yes)/(sum(Vote.yes)+sum(Vote.no)) AS helpful,
(count(Review.id)*(sum(Vote.yes)/(sum(Vote.yes)+sum(Vote.no)))) IS NULL AS vote_null
FROM jos_jreviews_comments AS Review
LEFT JOIN jos_jreviews_votes AS Vote
ON Review.id = Vote.reviewid
WHERE Review.published = 1
AND Review.userid > 0
GROUP BY Review.userid
ORDER BY review_count DESC, helpful DESC, vote_null ASC
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 `User.user_id`,
Review.name AS `User.name`,
Review.username AS `User.username`,
Review.email AS `User.email`,
Review.location AS `User.location`,
Review.ipaddress AS `User.ipaddress`,
Review.title AS `Review.title`,
Review.comments AS `Review.comments`,
Review.author
in Bubble Play by 
