SELECT *
FROM jos_session
WHERE session_id = '04e1ecfc169ea18a85b3d07beae07b35'
DELETE
FROM jos_session
WHERE ( TIME < '1524616405' )
SELECT *
FROM jos_session
WHERE session_id = '04e1ecfc169ea18a85b3d07beae07b35'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '04e1ecfc169ea18a85b3d07beae07b35','1524623605','','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 VALUE
FROM jos_jreviews_config
WHERE id = 'debug_overrides_disable'
SELECT *
FROM jos_menu
WHERE id = 69
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', '1524623605')
ON DUPLICATE KEY UPDATE
VALUE = '1524623605'
SELECT id, VALUE
FROM jos_jreviews_config
DELETE
FROM jos_jreviews_registration
WHERE
session_time < 1524620005
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`
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
WHERE 1 = 1
AND (
Review.userid= 10305
AND Review.published = 1
)
ORDER BY Review.created DESC
LIMIT 15
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 IN (1686,1593,1602,1761,1653,1559,1736,1659,1860,1859,1858,1832,1830,1668,1610)
)
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 (25,5,44,28,33,3,41,12,13)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (20,26,25,27,19,20,26,25,27,19,20,26,25,27,19,20,26,25,27,19,20,26,25,27,19,20,26,25,27,19,20,26,25,27,19,20,26,25,27,19,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 (15346,14981,14897,14728,14531,14310,14308,14130,13866,13864,13863,13688,13679,13567,13443)
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 (41)
)
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 (13)
)
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 (41)
)
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 (41)
)
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 (33)
)
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 (33)
)
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 (28)
)
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 (44)
)
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 (25)
)
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 (5)
)
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 (25)
)
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
WHERE 1 = 1
AND (
Review.userid= 10305
AND Review.published = 1
)
SELECT USER.name AS `User.name`
FROM jos_users AS `User`
WHERE 1 = 1
AND (
USER.id = 10305
)
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 OR menuid = 69)
ORDER BY menuid DESC
LIMIT 0, 1
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 = 69 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT name
FROM jos_rquotes_categories
WHERE id='1'
SELECT *
FROM jos_rquotes
WHERE published = '1'
AND category='Academy Member Quotes'
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
;