<![CDATA[Hotels - capeinfo.com]]>
/
<![CDATA[Tzaneen Country Lodge, Convention Centre & Spa: Sheer professionalism]]>
/hotels/discussions/review?id=25
/hotels/discussions/review?id=25Fri, 17 Jul 2015 14:53:19 +0200<![CDATA[Montagu Country Hotel: It's a destination in its own right]]>
/hotels/discussions/review?id=4
/hotels/discussions/review?id=4Tue, 27 Nov 2012 16:35:49 +0200
S2Framework Debug Console
Database Queries (17)
SELECT
id, language
FROM
sdxbv_menu
WHERE
link LIKE "%com_comprofiler&view=userprofile" AND published = 1 AND type = "component"
SELECT
id, language
FROM
sdxbv_menu
WHERE
link LIKE "%com_comprofiler&view=registers" AND published = 1 AND type = "component"
SELECT
Category.id
FROM
sdxbv_categories AS Category,
sdxbv_categories AS ParentCategory
WHERE
Category.published = 1
AND Category.extension = "com_content"
AND Category.access IN ( 1)
AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt
AND ParentCategory.id = 162
SELECT id FROM sdxbv_jreviews_categories WHERE `option` = "com_content"
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`,
User.id 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`,
Review.listing_type_id AS `Review.listing_type_id`,
IF(Review.rating=0,"na",Review.rating) 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 sdxbv_jreviews_comments AS Review
LEFT JOIN sdxbv_users AS User ON Review.userid = User.id
LEFT JOIN sdxbv_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id
LEFT JOIN sdxbv_content AS Listing ON Listing.id = Review.pid
LEFT JOIN sdxbv_jreviews_listing_totals AS Totals ON Totals.listing_id = Review.pid AND Totals.extension = 'com_content'
WHERE 1 = 1 AND (
Review.published = 1
AND Review.mode = 'com_content'
AND Listing.catid IN (162)
AND Listing.state = 1
AND Listing.access IN ( 1)
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2016-08-27 22:00:00" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2016-08-26 22:00:00" )
)
ORDER BY Review.created DESC
LIMIT 10
SELECT Listing.id AS `Listing.listing_id`,
Listing.alias AS `Listing.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`,
Field.featured AS `Listing.featured`,
JreviewsCategory.criteriaid AS `Listing.listing_type_id`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.alias AS `Category.slug`,
Category.params AS `Category.params`,
Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.slug`,
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`
FROM sdxbv_content AS Listing
LEFT JOIN sdxbv_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content'
LEFT JOIN sdxbv_jreviews_content AS Field ON Field.contentid = Listing.id
LEFT JOIN sdxbv_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN sdxbv_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content'
LEFT JOIN sdxbv_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid
LEFT JOIN sdxbv_users AS User ON User.id = Listing.created_by
LEFT JOIN sdxbv_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 (3352,3144)
)
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`
FROM sdxbv_jreviews_criteria AS Criteria
WHERE 1 = 1 AND (
Criteria.id IN ('8')
)
SELECT CriteriaRating.criteria_id AS `CriteriaRating.criteria_id`,
CriteriaRating.title AS `CriteriaRating.title`,
CriteriaRating.required AS `CriteriaRating.required`,
CriteriaRating.weight AS `CriteriaRating.weight`,
CriteriaRating.description AS `CriteriaRating.description`,
CriteriaRating.listing_type_id AS `CriteriaRating.listing_type_id`,
CriteriaRating.ordering AS `CriteriaRating.ordering`,
ListingType.state AS `CriteriaRating.listing_type_state`
FROM sdxbv_jreviews_criteria_ratings AS CriteriaRating
LEFT JOIN sdxbv_jreviews_criteria AS ListingType ON ListingType.id = CriteriaRating.listing_type_id
WHERE 1 = 1 AND (
CriteriaRating.listing_type_id IN (8)
)
ORDER BY CriteriaRating.ordering
SELECT *
FROM sdxbv_comprofiler AS Community
WHERE 1 = 1 AND (
user_id IN (5073,5783)
)
SELECT
media.media_id,
media.media_type,
media.media_function,
media.likes_rank,
media.likes_up,
media.likes_total,
media.created,
media.main_media,
media.listing_id,
media.review_id,
media.user_id,
media.filename,
media.file_extension,
media.rel_path,
media.title,
media.description,
media.media_info,
media.metadata,
media.embed,
media.published,
media.approved,
media.access,
media.views,
media.filesize,
media.extension
FROM
sdxbv_jreviews_media AS media
WHERE
listing_id IN (3144,3352)
AND published = 1 AND approved = 1
AND access IN (1)
AND main_media = 1
SELECT *
FROM sdxbv_comprofiler AS Community
WHERE 1 = 1 AND (
user_id IN (5817,62)
)
SELECT
review_id, criteria_id, IF(rating=0,'na',rating) AS rating
FROM
sdxbv_jreviews_review_ratings
WHERE
review_id IN (25,4)
SELECT Criteria.id AS `Criteria.criteria_id`,
Criteria.title AS `Criteria.title`,
Criteria.groupid AS `Criteria.group_id`,
Criteria.state AS `Criteria.state`,
Criteria.search AS `Criteria.search`,
Criteria.config AS `ListingType.config`
FROM sdxbv_jreviews_criteria AS Criteria
WHERE 1 = 1 AND (
Criteria.id IN (8)
)
SELECT
groupid
FROM sdxbv_jreviews_groups
WHERE
groupid IN (5,10,3,1,4,15,13)
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`, Field.ordering AS `Field.ordering`,
`Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering`
FROM
sdxbv_jreviews_fields AS Field
LEFT JOIN
sdxbv_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid
WHERE
Field.published = 1
AND Field.location = 'review'
AND Field.groupid IN ( 13,15)
SELECT
Review.reviewid AS element_id,jr_lastvisitmonth,jr_lastvisityear,jr_travelledwith,jr_goodpoints,jr_badpoints,jr_doyourecommendthisestablishment
FROM
sdxbv_jreviews_review_fields AS Review
WHERE
Review.reviewid IN (25,4)
SELECT
*
FROM
sdxbv_jreviews_fieldoptions
WHERE
fieldid IN ( '82','83','84','87')
AND
value IN ( 'november','2012','alone','yes','march','2010','solo')
ORDER
BY ordering ASC ,optionid ASC