SELECT *
FROM jos_session
WHERE session_id = 'b8a2a8549ec9ffa914c1e6e24e18f985'
DELETE
FROM jos_session
WHERE ( TIME < '1371529866' )
SELECT *
FROM jos_session
WHERE session_id = 'b8a2a8549ec9ffa914c1e6e24e18f985'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'b8a2a8549ec9ffa914c1e6e24e18f985','1371533466','','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 id
FROM jos_menu
WHERE link = 'index.php?option=com_community&view=frontpage'
AND published = 1
SELECT newurl
FROM jos_sh404sef_aliases
WHERE alias = ''
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 id, parent_id, VALUE, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=23
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.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-06-18 05:31:06' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-06-18 05:31:06' )
ORDER BY a.created DESC
LIMIT 0, 9
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-06-18 05:31:06' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-06-18 05:31:06' )
ORDER BY a.created DESC
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=1&format=feed&lang=en&type=rss&view=frontpage'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=1&format=feed&lang=en&type=atom&view=frontpage'
SELECT
published, params
FROM
jos_plugins
WHERE
element = 'jreviews'
AND folder = 'content'
LIMIT 1
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.VALUE='62'
ORDER BY g.id
SELECT *
FROM jos_community_config
WHERE name = 'config'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`events` AS _events, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='0'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=62&view=profile'
SELECT *
FROM jos_content
WHERE id = '93497'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&catid=&id=93497&lang=en&view=article'
SELECT alias,id
FROM jos_content
WHERE id=93497
SELECT a.alias AS title,a.id AS id
FROM jos_content AS a
LEFT JOIN jos_sections AS s
ON a.sectionid=s.id
LEFT JOIN jos_categories AS c
ON a.catid=c.id
WHERE a.id=93497
SELECT oldurl
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&id=93497&lang=en&view=article'
SELECT `pageid`
FROM jos_sh404sef_pageids
WHERE `newurl`='index.php?option=com_content&Itemid=1&view=frontpage';
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 oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=27&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=81&lang=en&view=events'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=37&groupid=1&lang=en&task=viewgroup&view=groups'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=41&groupid=2&lang=en&task=viewgroup&view=groups'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=50&groupid=3&lang=en&task=viewgroup&view=groups'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_easyblog&Itemid=331&lang=en&view=latest'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&view=frontpage'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=28&id=42657&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=247&id=42658&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_flexicontact&Itemid=29&lang=en&view=contact'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=30&id=93275&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=248&id=42659&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=137&id=93276&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=18&id=42661&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_flexicontact&Itemid=135&lang=en&view=contact'
SET SQL_BIG_SELECTS=1
SELECT
id
FROM
jos_menu
WHERE
link LIKE "%com_community&view=frontpage%"
AND published = 1
AND TYPE = "component"
UPDATE
jos_jreviews_config
SET
VALUE= '1371533466'
WHERE
id = 'last_cache_clean'
SELECT
COUNT(*)
FROM
jos_jreviews_config
WHERE
id = 'last_cache_clean'
SELECT id, VALUE
FROM jos_jreviews_config
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
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.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`,
'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`,
Frontpage.content_id AS `Listing.frontpage`,
USER.id AS `User.user_id`,
USER.name AS `User.name`,
USER.username AS `User.username`,
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`,
Claim.approved AS `Claim.approved`,
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`,
PaidPlanCategory.cat_id AS `PaidPlanCategory.cat_id`
FROM jos_content AS Listing USE KEY (jr_hits)
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.approved = 1
LEFT JOIN jos_content_frontpage AS Frontpage
ON Frontpage.content_id = Listing.id
LEFT JOIN tmpPlanCategories AS PaidPlanCategory
ON Category.id = PaidPlanCategory.cat_id
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2013-06-18 05:31") )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2013-06-18 05:31") )
AND Category.access <= 0
AND Listing.access <= 0
)
ORDER BY Listing.hits DESC
LIMIT 3
SELECT
id
FROM
jos_menu
WHERE
link LIKE "%com_community&view=frontpage%"
AND published = 1
AND TYPE = "component"
SELECT params
FROM jos_community_config
WHERE name = 'config'
SELECT Community.userid AS `Community.user_id`,
Community.thumb AS `Community.avatar`
FROM jos_community_users AS Community
WHERE 1 = 1
AND (
userid IN (62)
)
SELECT
content_id AS listing_id, COUNT(*) AS favored
FROM jos_jreviews_favorites AS Favorite
WHERE
Favorite.content_id IN (93458,26688,93485)
GROUP BY
listing_id
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.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (10)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (1,13)
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 (1,13)
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_musicplayed,jr_paymentsaccepted,jr_dresscode,jr_cover,jr_food,jr_smokingarea,jr_noiselevel,jr_dj,jr_djnights,jr_location,jr_city,jr_state,jr_zip,jr_latitude,jr_longitude,jr_phone,jr_email,jr_website,jr_specials,jr_parkingarea,jr_hours
FROM jos_jreviews_content AS Listing
WHERE Listing.contentid IN (93458,26688,93485)
SELECT PaidOrder.*
FROM jos_jreviews_paid_orders AS `PaidOrder`
WHERE 1 = 1
AND (
`PaidOrder`.listing_id IN (93458,26688,93485)
AND `PaidOrder`.order_status = "Complete"
AND `PaidOrder`.order_active = 1
)
ORDER BY `PaidOrder`.order_created ASC
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=251&catid=66&id=26688&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=251&catid=66&id=26688&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=261&catid=62&id=93485&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=261&catid=62&id=93485&lang=en&view=article'
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
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
SET SQL_BIG_SELECTS=1
SELECT
id
FROM
jos_menu
WHERE
link LIKE "%com_community&view=frontpage%"
AND published = 1
AND TYPE = "component"
UPDATE
jos_jreviews_config
SET
VALUE= '1371533467'
WHERE
id = 'last_cache_clean'
SELECT
COUNT(*)
FROM
jos_jreviews_config
WHERE
id = 'last_cache_clean'
SELECT id, VALUE
FROM jos_jreviews_config
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
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.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`,
'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`,
Frontpage.content_id AS `Listing.frontpage`,
USER.id AS `User.user_id`,
USER.name AS `User.name`,
USER.username AS `User.username`,
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`,
Claim.approved AS `Claim.approved`,
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`,
PaidPlanCategory.cat_id AS `PaidPlanCategory.cat_id`
FROM jos_content AS Listing USE KEY (jr_created)
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.approved = 1
LEFT JOIN jos_content_frontpage AS Frontpage
ON Frontpage.content_id = Listing.id
LEFT JOIN tmpPlanCategories AS PaidPlanCategory
ON Category.id = PaidPlanCategory.cat_id
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2013-06-18 05:31") )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2013-06-18 05:31") )
AND Category.access <= 0
AND Listing.access <= 0
AND Totals.user_rating_count >= 1
)
ORDER BY Listing.created DESC
LIMIT 50
SELECT Community.userid AS `Community.user_id`,
Community.thumb AS `Community.avatar`
FROM jos_community_users AS Community
WHERE 1 = 1
AND (
userid IN (62)
)
SELECT
content_id AS listing_id, COUNT(*) AS favored
FROM jos_jreviews_favorites AS Favorite
WHERE
Favorite.content_id IN (93458,93280)
GROUP BY
listing_id
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.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (10)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (1,13)
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 (1,13)
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_musicplayed,jr_paymentsaccepted,jr_dresscode,jr_cover,jr_food,jr_smokingarea,jr_noiselevel,jr_dj,jr_djnights,jr_location,jr_city,jr_state,jr_zip,jr_latitude,jr_longitude,jr_phone,jr_email,jr_website,jr_specials,jr_parkingarea,jr_hours
FROM jos_jreviews_content AS Listing
WHERE Listing.contentid IN (93458,93280)
SELECT PaidOrder.*
FROM jos_jreviews_paid_orders AS `PaidOrder`
WHERE 1 = 1
AND (
`PaidOrder`.listing_id IN (93458,93280)
AND `PaidOrder`.order_status = "Complete"
AND `PaidOrder`.order_active = 1
)
ORDER BY `PaidOrder`.order_created ASC
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=281&catid=83&id=93280&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=281&catid=83&id=93280&lang=en&view=article'
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
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
SET SQL_BIG_SELECTS=1
SELECT
id
FROM
jos_menu
WHERE
link LIKE "%com_community&view=frontpage%"
AND published = 1
AND TYPE = "component"
SELECT params
FROM jos_community_config
WHERE name = 'config'
UPDATE
jos_jreviews_config
SET
VALUE= '1371533468'
WHERE
id = 'last_cache_clean'
SELECT
COUNT(*)
FROM
jos_jreviews_config
WHERE
id = 'last_cache_clean'
SELECT id, VALUE
FROM jos_jreviews_config
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
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.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`,
'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`,
Frontpage.content_id AS `Listing.frontpage`,
USER.id AS `User.user_id`,
USER.name AS `User.name`,
USER.username AS `User.username`,
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`,
Claim.approved AS `Claim.approved`,
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`,
PaidPlanCategory.cat_id AS `PaidPlanCategory.cat_id`
FROM jos_content AS Listing USE KEY (jr_created)
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.approved = 1
LEFT JOIN jos_content_frontpage AS Frontpage
ON Frontpage.content_id = Listing.id
LEFT JOIN tmpPlanCategories AS PaidPlanCategory
ON Category.id = PaidPlanCategory.cat_id
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2013-06-18 05:31") )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2013-06-18 05:31") )
AND Category.access <= 0
AND Listing.access <= 0
AND Totals.user_rating >= 4
)
ORDER BY Listing.created DESC
LIMIT 12
SELECT Community.userid AS `Community.user_id`,
Community.thumb AS `Community.avatar`
FROM jos_community_users AS Community
WHERE 1 = 1
AND (
userid IN (62)
)
SELECT
content_id AS listing_id, COUNT(*) AS favored
FROM jos_jreviews_favorites AS Favorite
WHERE
Favorite.content_id IN (93458,93280)
GROUP BY
listing_id
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.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (10)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (1,13)
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 (1,13)
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_musicplayed,jr_paymentsaccepted,jr_dresscode,jr_cover,jr_food,jr_smokingarea,jr_noiselevel,jr_dj,jr_djnights,jr_location,jr_city,jr_state,jr_zip,jr_latitude,jr_longitude,jr_phone,jr_email,jr_website,jr_specials,jr_parkingarea,jr_hours
FROM jos_jreviews_content AS Listing
WHERE Listing.contentid IN (93458,93280)
SELECT PaidOrder.*
FROM jos_jreviews_paid_orders AS `PaidOrder`
WHERE 1 = 1
AND (
`PaidOrder`.listing_id IN (93458,93280)
AND `PaidOrder`.order_status = "Complete"
AND `PaidOrder`.order_active = 1
)
ORDER BY `PaidOrder`.order_created ASC
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=281&catid=83&id=93280&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=281&catid=83&id=93280&lang=en&view=article'
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 98
ORDER BY sticky DESC, ordering
LIMIT 0, 1000
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 13
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_banners&bid=13&lang=en&task=click'
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 97
ORDER BY sticky DESC, ordering
LIMIT 0, 1000
SELECT *
FROM `jos_users`
WHERE `gid`='25'
SELECT *
FROM `jos_users` AS a
INNER JOIN `jos_community_users` AS b
ON a.`id` = b.`userid`
WHERE a.`block` = '0'
AND `id` NOT IN('62')
ORDER BY a.`registerDate` DESC
LIMIT 24
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`friendcount` AS _friendcount, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session`s
ON s.`userid`=a.`userid`
WHERE a.`userid` IN (101,100,99,98,97,96,95,94,93,92,91,90,89,88,87,86,85,84,83,82,81,80,79,78)
SELECT *
FROM jos_community_storage_s3
WHERE storageid = 'images/avatar/thumb_c94fff511b36f3a9f4964a75.jpg'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=101&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=100&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=99&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=98&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=97&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=96&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=95&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=94&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=93&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=92&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=91&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=90&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=89&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=88&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=87&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=86&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=85&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=84&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=83&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=82&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=81&view=profile'
SELECT *
FROM jos_community_storage_s3
WHERE storageid = 'images/avatar/thumb_c94fff511b36f3a9f4964a75.jpg'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=80&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=79&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=78&view=profile'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=search%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&sort=latest&task=browse&view=search'
SELECT name, link,id
FROM jos_menu
WHERE id = 60
AND published='1'
SELECT oldurl
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&task=browse&view=search'
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
SELECT
id
FROM
jos_menu
WHERE
link LIKE "%com_community&view=frontpage%"
AND published = 1
AND TYPE = "component"
SELECT params
FROM jos_community_config
WHERE name = 'config'
UPDATE
jos_jreviews_config
SET
VALUE= '1371533469'
WHERE
id = 'last_cache_clean'
SELECT
COUNT(*)
FROM
jos_jreviews_config
WHERE
id = 'last_cache_clean'
SELECT id, VALUE
FROM jos_jreviews_config
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`,
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`
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.published > 0
)
ORDER BY `Review.created` DESC
LIMIT 3
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
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`,
Frontpage.content_id AS `Listing.frontpage`,
USER.id AS `User.user_id`,
USER.name AS `User.name`,
USER.username AS `User.username`,
USER.email AS `User.email`,
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`,
Claim.approved AS `Claim.approved`,
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`,
PaidPlanCategory.cat_id AS `PaidPlanCategory.cat_id`
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.approved = 1
LEFT JOIN jos_content_frontpage AS Frontpage
ON Frontpage.content_id = Listing.id
LEFT JOIN tmpPlanCategories AS PaidPlanCategory
ON Category.id = PaidPlanCategory.cat_id
WHERE 1 = 1
AND (
Listing.id IN (93458,93280)
)
SELECT Community.userid AS `Community.user_id`,
Community.thumb AS `Community.avatar`
FROM jos_community_users AS Community
WHERE 1 = 1
AND (
userid IN (62)
)
SELECT
content_id AS listing_id, COUNT(*) AS favored
FROM jos_jreviews_favorites AS Favorite
WHERE
Favorite.content_id IN (93280,93458)
GROUP BY
listing_id
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.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (10)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (1,13)
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 (1,13)
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_musicplayed,jr_paymentsaccepted,jr_dresscode,jr_cover,jr_food,jr_smokingarea,jr_noiselevel,jr_dj,jr_djnights,jr_location,jr_city,jr_state,jr_zip,jr_latitude,jr_longitude,jr_phone,jr_email,jr_website,jr_specials,jr_parkingarea,jr_hours
FROM jos_jreviews_content AS Listing
WHERE Listing.contentid IN (93280,93458)
SELECT PaidOrder.*
FROM jos_jreviews_paid_orders AS `PaidOrder`
WHERE 1 = 1
AND (
`PaidOrder`.listing_id IN (93280,93458)
AND `PaidOrder`.order_status = "Complete"
AND `PaidOrder`.order_active = 1
)
ORDER BY `PaidOrder`.order_created ASC
SELECT Community.userid AS `Community.user_id`,
Community.thumb AS `Community.avatar`
FROM jos_community_users AS Community
WHERE 1 = 1
AND (
userid IN (100,78)
)
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.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (10)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (1,13)
AND TYPE = 'review'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=100&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=100&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=281&catid=83&id=93280&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=281&catid=83&id=93280&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&userid=78&view=profile'
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
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
SET SQL_BIG_SELECTS=1
SELECT
id
FROM
jos_menu
WHERE
link LIKE "%com_community&view=frontpage%"
AND published = 1
AND TYPE = "component"
SELECT params
FROM jos_community_config
WHERE name = 'config'
UPDATE
jos_jreviews_config
SET
VALUE= '1371533469'
WHERE
id = 'last_cache_clean'
SELECT
COUNT(*)
FROM
jos_jreviews_config
WHERE
id = 'last_cache_clean'
SELECT id, VALUE
FROM jos_jreviews_config
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
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.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`,
'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`,
Frontpage.content_id AS `Listing.frontpage`,
USER.id AS `User.user_id`,
USER.name AS `User.name`,
USER.username AS `User.username`,
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`,
Claim.approved AS `Claim.approved`,
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`,
PaidPlanCategory.cat_id AS `PaidPlanCategory.cat_id`
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.approved = 1
LEFT JOIN jos_content_frontpage AS Frontpage
ON Frontpage.content_id = Listing.id
LEFT JOIN tmpPlanCategories AS PaidPlanCategory
ON Category.id = PaidPlanCategory.cat_id
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2013-06-18 05:31") )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2013-06-18 05:31") )
AND Category.access <= 0
AND Listing.access <= 0
AND FIELD.featured = 1
)
ORDER BY RAND(1672027540)
LIMIT 10
SELECT Community.userid AS `Community.user_id`,
Community.thumb AS `Community.avatar`
FROM jos_community_users AS Community
WHERE 1 = 1
AND (
userid IN (62)
)
SELECT
content_id AS listing_id, COUNT(*) AS favored
FROM jos_jreviews_favorites AS Favorite
WHERE
Favorite.content_id IN (93458)
GROUP BY
listing_id
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.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (10)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (1,13)
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 (1,13)
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_musicplayed,jr_paymentsaccepted,jr_dresscode,jr_cover,jr_food,jr_smokingarea,jr_noiselevel,jr_dj,jr_djnights,jr_location,jr_city,jr_state,jr_zip,jr_latitude,jr_longitude,jr_phone,jr_email,jr_website,jr_specials,jr_parkingarea,jr_hours
FROM jos_jreviews_content AS Listing
WHERE Listing.contentid IN (93458)
SELECT PaidOrder.*
FROM jos_jreviews_paid_orders AS `PaidOrder`
WHERE 1 = 1
AND (
`PaidOrder`.listing_id IN (93458)
AND `PaidOrder`.order_status = "Complete"
AND `PaidOrder`.order_active = 1
)
ORDER BY `PaidOrder`.order_created ASC
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=305&catid=54&id=93458&lang=en&view=article'
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 96
ORDER BY sticky DESC, ordering
LIMIT 0, 1000
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 9
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_banners&bid=9&lang=en&task=click'
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
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
SET SQL_BIG_SELECTS=1
SELECT
id
FROM
jos_menu
WHERE
link LIKE "%com_community&view=frontpage%"
AND published = 1
AND TYPE = "component"
SELECT params
FROM jos_community_config
WHERE name = 'config'
UPDATE
jos_jreviews_config
SET
VALUE= '1371533469'
WHERE
id = 'last_cache_clean'
SELECT
COUNT(*)
FROM
jos_jreviews_config
WHERE
id = 'last_cache_clean'
SELECT id, VALUE
FROM jos_jreviews_config
DROP TEMPORARY TABLE IF EXISTS tmpPlanCategories;
CREATE TEMPORARY TABLE tmpPlanCategories (cat_id INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE = MEMORY;
INSERT IGNORE INTO tmpPlanCategories
SELECT PaidPlanCategory.cat_id
FROM jos_jreviews_paid_plans_categories AS PaidPlanCategory
INNER JOIN jos_jreviews_paid_plans AS PaidPlan
ON PaidPlan.plan_id = PaidPlanCategory.plan_id
WHERE PaidPlan.plan_state = 1;
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.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`,
'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`,
Frontpage.content_id AS `Listing.frontpage`,
USER.id AS `User.user_id`,
USER.name AS `User.name`,
USER.username AS `User.username`,
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`,
Claim.approved AS `Claim.approved`,
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`,
PaidPlanCategory.cat_id AS `PaidPlanCategory.cat_id`
FROM jos_content AS Listing USE KEY (jr_created)
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.approved = 1
LEFT JOIN jos_content_frontpage AS Frontpage
ON Frontpage.content_id = Listing.id
LEFT JOIN tmpPlanCategories AS PaidPlanCategory
ON Category.id = PaidPlanCategory.cat_id
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2013-06-18 05:31") )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2013-06-18 05:31") )
AND Category.access <= 0
AND Listing.access <= 0
)
ORDER BY Listing.created DESC
LIMIT 15
SELECT Community.userid AS `Community.user_id`,
Community.thumb AS `Community.avatar`
FROM jos_community_users AS Community
WHERE 1 = 1
AND (
userid IN (62)
)
SELECT
content_id AS listing_id, COUNT(*) AS favored
FROM jos_jreviews_favorites AS Favorite
WHERE
Favorite.content_id IN (99029,99028,99027,99026,99025,99024,99023,99022,99021,99020,99019,99018,99017,99016,99015)
GROUP BY
listing_id
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.config AS `ListingType.config`,
Criteria.groupid
FROM jos_jreviews_criteria AS Criteria
WHERE 1 = 1
AND (
Criteria.id IN (13,10)
)
SELECT groupid
FROM jos_jreviews_groups
WHERE groupid IN (1,13,12,13)
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 (1,12,13)
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_musicplayed,jr_paymentsaccepted,jr_dresscode,jr_cover,jr_food,jr_smokingarea,jr_noiselevel,jr_dj,jr_djnights,jr_takeout,jr_delivery,jr_alcohol,jr_kidfriendly,jr_location,jr_city,jr_state,jr_zip,jr_latitude,jr_longitude,jr_phone,jr_email,jr_website,jr_specials,jr_parkingarea,jr_hours
FROM jos_jreviews_content AS Listing
WHERE Listing.contentid IN (99029,99028,99027,99026,99025,99024,99023,99022,99021,99020,99019,99018,99017,99016,99015)
SELECT PaidOrder.*
FROM jos_jreviews_paid_orders AS `PaidOrder`
WHERE 1 = 1
AND (
`PaidOrder`.listing_id IN (99029,99028,99027,99026,99025,99024,99023,99022,99021,99020,99019,99018,99017,99016,99015)
AND `PaidOrder`.order_status = "Complete"
AND `PaidOrder`.order_active = 1
)
ORDER BY `PaidOrder`.order_created ASC
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=327&catid=124&id=99029&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=327&catid=124&id=99029&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=258&catid=144&id=99028&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=258&catid=144&id=99028&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99027&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99027&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=327&catid=124&id=99026&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=327&catid=124&id=99026&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=261&catid=62&id=99025&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=261&catid=62&id=99025&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99024&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99024&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99023&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99023&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=323&catid=122&id=99022&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=323&catid=122&id=99022&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=326&catid=145&id=99021&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=326&catid=145&id=99021&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99020&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99020&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=327&catid=124&id=99019&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=327&catid=124&id=99019&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=261&catid=62&id=99018&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=261&catid=62&id=99018&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=254&catid=135&id=99017&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=254&catid=135&id=99017&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=292&catid=57&id=99016&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=292&catid=57&id=99016&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99015&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=316&catid=69&id=99015&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=98&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=99&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=100&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=101&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=102&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=125&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=103&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=104&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=105&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=106&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=107&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=127&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=113&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=114&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=115&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=116&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=117&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=128&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=108&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=109&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=110&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=111&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=112&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=126&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=93&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=94&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=95&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=96&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=97&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=124&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=118&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=119&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=120&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=121&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=122&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=123&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=87&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=89&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=90&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=91&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=92&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=129&lang=en'
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 88
ORDER BY sticky DESC, ordering
LIMIT 0, 1000
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 11
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_banners&bid=11&lang=en&task=click'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&view=frontpage'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=130&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=131&lang=en&view=events'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=60&lang=en&view=register'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=129&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=123&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=124&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=126&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=128&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=127&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=125&lang=en'
SELECT *
FROM jos_sh404SEF_meta
WHERE `newurl`='index.php?3de69ea13a27d1ead96ff5d7b47efae3';
