Accommodation Self-catering Domaine Coutelier

Domaine Coutelier

0.0 (0)

0 15 0 0

Location

Western Cape

Stellenbosch

45 Blumberg Drive

Entry info

Check availability | Book online

Price range - complete one of the options

Rates/unit

R800 - R1500

About the establishment

General facilities

Activities offered

Swimming pool

Getting there

Farm-stays

Languages spoken

French

Domaine Coutelier is situated on the old 17th Century Devon Vale farm, set on a plateau between Devon Valley and Devon Vale, which was split in the 1950’s into smaller portions. The Domaine consists of a four hectare plot. Grapes have been grown on this land for decades.

Visible to the East are the mountains of Simonsberg, Groot Drakenstein, Jonkershook, Stellenbosch, Helderberg with the Hottentots –Holland to the South, Paarl Rock and surrounding mountains to the North East, Durbanville Hills and Cape Town Suburbs to the North West.

Domaine Coutelier is within the Bottelary Road ward of Stellenbosch, although Wine of Origin Stellenbosch is indicated on the labels (and Coastal region for the Durbanville Hills wines).

What to do in the area

The Domaine offers great walks through vineyards directly from the property.

For Wine enthusiasts, all guests are offered a free wine tasting of the Domaines award winning wines.

For keen mountain bikers, the Domaine is in the heart of the Bottelary Hills MTB Trails where there are dedicated, well-marked routes. The rolling hillsides feature vineyards, farmland, conservation areas and trails comprised of farm roads, jeep tracks and numerous single tracks. While never too technical there are challenging climbs and a variety of distances on offer for riders of all fitness levels.

For Golfers, the property is a mere 2 kilometres from Devon Vale Golf Course.

The Domaine is 15-minutes from the heart of the historical town of Stellebosch with great bars and restaurants.

A 35-minute drive to Cape Town gives makes our Domaine an ideal location for traveller’s, pleasure seekers and explorers alike.

The apartments

Domaine Coutelier offers two full equipped independent self-catering apartments set in the vineyards of the Domaine. Each apartment, as described below, offers modern comforts, privacy and spectacular views.

Sunset Apartment

Named for its stunning Sunset Vista and nestled among the vines of the Domaine Coutelier Wine Estate, offering spectacular views, this independent 1-bedroomed flatlet with a kitchenette and lounge area with a small private garden offers self-catering accommodation for 2 persons , or accompanied by a small child.

The flatlet comprises a bedroom with a queen size bed. A small foldaway bed or cot for young child or baby can also be made available upon request. There is a kitchen, with full cooking facilities and a fridge, with dining table, a living room area with settee and armchair. To add to this great unit is a private patio with loungers and a table, chairs and braai facilities. There is a private garden with small lawn.

Guests will have access to the main house pool and loungers.

Sunrise Apartment

Named for its stunning Sunrise Vista and nestled among the vines of the Domaine Coutelier Wine Estate, offering spectacular views, this independent 1-bedroomed open planned flatlet with a kitchenette and lounge area with a small private garden offers self-catering accommodation for 2 persons , or accompanied by a small child.

The flatlet comprises a bedroom with a queen size bed. A small foldaway bed or cot for young child or baby can also be made available upon request. There is also a kitchen, living room area with full cooking facilities and a fridge, table, settee and armchair. To add to this great unit is a private patio with loungers and a table, chairs and braai facilities. There is a private garden with small Olive Orchard.

Guests will have access to the main house pool and loungers.

Map

Move Map

Swap Start/End Start Address

End

User reviews

There are no user reviews for this listing.

S2Framework Debug Console

Database Queries (54)

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 count(*) FROM sdxbv_jreviews_categories AS JreviewCategory WHERE JreviewCategory.id = 164 AND JreviewCategory.option = 'com_content' AND JreviewCategory.criteriaid > 0

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`, Field.jr_latitude AS `Geomaps.lat`, Field.jr_longitude AS `Geomaps.lon`, JreviewsCategory.marker_icon AS `Geomaps.marker_icon` 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 = 6865 )

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 groupid FROM sdxbv_jreviews_groups WHERE groupid IN (5,10,3,1,4,15,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`, 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 = 'content' AND Field.groupid IN ( 1,3,4,5,10)

SELECT Listing.contentid AS element_id,jr_country,jr_province,jr_region,jr_town,jr_suburb,jr_postalcode,jr_streetaddress,jr_latitude,jr_longitude,jr_venue,jr_nightsbridgebbid,jr_tgcsagrading,jr_telephone,jr_mobile,jr_fax,jr_contact,jr_email,jr_website,jr_facebook,jr_twitter,jr_rates,jr_ratesunit,jr_generalfacilities,jr_activitiesoffered,jr_gettingthere,jr_languagesspoken FROM sdxbv_jreviews_content AS Listing WHERE Listing.contentid IN (6865)

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4','92','69','70','71','72') AND value IN ( 'south-africa','western-cape','winelands','stellenbosch','upper','braai','childfriendly','credit-cards-accepted','gayfriendly','laundry-facilities','petfriendly','secure-parking','selfcatering-facilities','wireless-internet','swimming-pool','farmstays','french') ORDER BY ordering ASC ,optionid ASC

SELECT rating_range, count(*) AS count FROM (SELECT CASE WHEN ROUND(rating,1) > 0 AND rating < 1.5 THEN 1 WHEN ROUND(rating,1) >= 1.5 AND ROUND(rating,1) < 2.5 THEN 2 WHEN ROUND(rating,1) >= 2.5 AND ROUND(rating,1) < 3.5 THEN 3 WHEN ROUND(rating,1) >= 3.5 AND ROUND(rating,1) < 4.5 THEN 4 WHEN ROUND(rating,1) >= 4.5 THEN 5 END as rating_range FROM sdxbv_jreviews_comments WHERE pid = 6865 AND published = 1 AND mode = 'com_content' AND rating > 0 AND author = 0 ) AS ReviewRange GROUP BY rating_range

SELECT content_id AS listing_id, count(*) AS favored FROM sdxbv_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (6865) GROUP BY listing_id

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (17314) )

SELECT tmp.media_id, tmp.listing_id, tmp.review_id, tmp.media_type, tmp.media_function, tmp.likes_rank, tmp.main_media, media.likes_up, media.likes_total, media.created, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.duration, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM ( SELECT media_id, listing_id, review_id, media_type, media_function, main_media, views, likes_rank, created, ordering, CASE WHEN @id != listing_id AND media_type = 'photo' THEN @photo := 1 ELSE IF(media_type = 'photo' ,@photo := @photo + 1,NULL) END AS photo_rank, CASE WHEN @id != listing_id AND media_type = 'video' THEN @video := 1 ELSE IF(media_type = 'video' ,@video := @video + 1,NULL) END AS video_rank, CASE WHEN @id != listing_id AND media_type = 'attachment' THEN @attachment := 1 ELSE IF(media_type = 'attachment',@attachment := @attachment + 1,NULL) END AS attachment_rank, CASE WHEN @id != listing_id AND media_type = 'audio' THEN @audio := 1 ELSE IF(media_type = 'audio',@audio := @audio + 1,NULL) END AS audio_rank, @id := listing_id FROM ( SELECT media_id, review_id, listing_id, user_id, media_type, media_function, likes_rank, likes_up, likes_total, created, main_media, ordering, views FROM sdxbv_jreviews_media WHERE listing_id IN (6865) AND published = 1 AND approved = 1 AND access IN (1) AND extension = 'com_content' ) mtmp JOIN (SELECT @id := NULL, @photo := 0, @video := 0, @attachment := 0, @audio := 0) r ORDER BY main_media DESC, listing_id, media_type, ordering ) tmp JOIN sdxbv_jreviews_media AS media ON media.media_id = tmp.media_id WHERE (tmp.photo_rank >= 0) OR (tmp.video_rank BETWEEN 1 AND 7) OR (tmp.attachment_rank > 0) OR (tmp.audio_rank > 0) ORDER BY tmp.main_media DESC, tmp.listing_id, tmp.media_type, tmp.ordering

SELECT PaidOrder.*, User.id AS `User.user_id`, User. name AS `User.name` FROM sdxbv_jreviews_paid_orders AS `PaidOrder` LEFT JOIN sdxbv_users AS User ON PaidOrder.user_id = User.id WHERE 1 = 1 AND ( `PaidOrder`.listing_id IN (6865) AND `PaidOrder`.order_status IN ('Complete') AND `PaidOrder`.order_active = 1 ) ORDER BY `PaidOrder`.order_created ASC

SELECT PaidCountry.id, PaidCountry.country_code, PaidCountry.country_name FROM sdxbv_jreviews_paid_countries AS `PaidCountry` ORDER BY PaidCountry.country_name ASC

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 (6865) )

SELECT images FROM sdxbv_content WHERE id = 6865

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`, Review.owner_reply_approved As `Review.owner_reply_approved`, Review.owner_reply_text As `Review.owner_reply_text` 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' LEFT JOIN sdxbv_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' WHERE 1 = 1 AND ( Review.pid = 6865 AND Review.mode = 'com_content' AND Review.published = 1 AND Review.author = 0 AND JreviewsCategory.option = 'com_content' ) ORDER BY `Review.created` DESC LIMIT 5

SELECT FieldValue.optionid, FieldValue.fieldid, FieldValue.text, FieldValue.value, FieldValue.image, FieldValue.ordering FROM sdxbv_jreviews_fieldoptions AS FieldValue WHERE FieldValue.fieldid IN (87) ORDER BY FieldValue.text ASC

SELECT COUNT(*) FROM sdxbv_jreviews_comments AS Review WHERE 1 = 1 AND ( Review.pid = 6865 AND Review.mode = 'com_content' AND Review.published >= 0 AND Review.author = 0 AND Review.ipaddress = '204.236.226.210' )

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 = 244

SELECT id FROM sdxbv_jreviews_categories WHERE `option` = "com_content"

SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.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`, 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`, 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`, JreviewsCategory.marker_icon AS `Geomaps.marker_icon`, Field.jr_latitude AS `Geomaps.lat`, Field.jr_longitude AS `Geomaps.lon` FROM sdxbv_content AS Listing USE KEY (jr_created) 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.catid IN (244) AND Listing.state = 1 AND Listing.access IN ( 1) AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2016-11-04 22:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2016-11-03 22:00:00" ) ) ORDER BY Listing.created DESC LIMIT 100

SELECT groupid FROM sdxbv_jreviews_groups WHERE groupid IN (9,1,16) AND type = 'content'

SELECT Listing.contentid AS element_id,jr_country,jr_province,jr_region,jr_town,jr_suburb,jr_postalcode,jr_streetaddress,jr_latitude,jr_longitude,jr_venue,jr_startdate,jr_enddate,jr_discount FROM sdxbv_jreviews_content AS Listing WHERE Listing.contentid IN (7027,7022,6919,6821,6820,6587)

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4') AND value IN ( 'south-africa','western-cape','west-coast','velddrif','winelands','stellenbosch','garden-route','george','eastern-cape','grahamstown') ORDER BY ordering ASC ,optionid ASC

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 (2662,6819,6400,6361,6360) )

SELECT content_id AS listing_id, count(*) AS favored FROM sdxbv_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (7027,7022,6919,6821,6820,6587) GROUP BY listing_id

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (16919,16948,17284,3264) )

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 (7027,7022,6919,6821,6820,6587) AND published = 1 AND approved = 1 AND access IN (1) AND main_media = 1

SELECT PaidOrder.*, User.id AS `User.user_id`, User. name AS `User.name` FROM sdxbv_jreviews_paid_orders AS `PaidOrder` LEFT JOIN sdxbv_users AS User ON PaidOrder.user_id = User.id WHERE 1 = 1 AND ( `PaidOrder`.listing_id IN (7027,7022,6919,6821,6820,6587) AND `PaidOrder`.order_status IN ('Complete') AND `PaidOrder`.order_active = 1 ) ORDER BY `PaidOrder`.order_created ASC

SELECT JreviewsCategory.id FROM sdxbv_jreviews_categories AS JreviewsCategory LEFT JOIN sdxbv_categories AS Category On JreviewsCategory.id = Category.id WHERE JreviewsCategory.dirid IN (1,2) AND JreviewsCategory.`option`= "com_content" AND Category.published = 1 AND Category.access IN ( 1)

SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.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`, 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`, 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`, JreviewsCategory.marker_icon AS `Geomaps.marker_icon`, Field.jr_latitude AS `Geomaps.lat`, Field.jr_longitude AS `Geomaps.lon` FROM sdxbv_content AS Listing USE KEY (jr_created) 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.catid IN (161,162,163,164,165,166,177,180,178,179,188,181,182,184,183,185,186,202,189,191,190,193,195,196,197,167,168,170,200,201,171,198,172,203,173,175,207,208,213,214,244,169,204,199,264,265,267,266,269,268,270,271,272,298) AND Listing.state = 1 AND Listing.access IN ( 1) AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2016-11-04 22:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2016-11-03 22:00:00" ) ) ORDER BY Listing.created DESC LIMIT 10

SELECT groupid FROM sdxbv_jreviews_groups WHERE groupid IN (9,2,1,5,10,3,1,4,15,13) AND type = 'content'

SELECT Listing.contentid AS element_id,jr_country,jr_province,jr_region,jr_town,jr_suburb,jr_postalcode,jr_streetaddress,jr_latitude,jr_longitude,jr_venue,jr_nightsbridgebbid,jr_tgcsagrading,jr_startdate,jr_enddate,jr_telephone,jr_mobile,jr_fax,jr_contact,jr_email,jr_website,jr_facebook,jr_twitter,jr_infophone,jr_infoemail,jr_infowebsite,jr_bookingswebsite,jr_pricerange,jr_rates,jr_ratesunit,jr_generalfacilities,jr_activitiesoffered,jr_gettingthere,jr_languagesspoken FROM sdxbv_jreviews_content AS Listing WHERE Listing.contentid IN (7064,7063,7062,7061,7060,7058,7057,7056,7055,7054)

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4','68','69','71','92','70','5','21','72') AND value IN ( 'south-africa','western-cape','winelands','tulbagh','upper','airconditioning','credit-cards-accepted','fireplace','restaurantbar','secure-parking','wireless-internet','airport-transfers','franschhoek','superlative','braai','childfriendly','gayfriendly','laundry-facilities','selfcatering-facilities','tv-in-rooms','swimming-pool','public-transport-nearby','shopping-nearby','heritage-environment','stellenbosch','banhoek','rawsonville','3-stars','conference-facilities','disabilityfriendly','petfriendly','wedding-specialists','birdwatching','fishing','hiking','stargazing','northern-cape','kimberley','mpumalanga','wild-frontier','marloth-park','top','game-watchinghunting','golf','wilderness-environment','cape-town-metro','cape-town','observatory','overberg','hermanus','beach-nearby','kwazulu-natal','south-coast','port-shepstone','simon-s-town','4-stars','german') ORDER BY ordering ASC ,optionid ASC

SELECT groupid FROM sdxbv_jreviews_groups WHERE groupid IN (9,2,1) AND type = 'content'

SELECT content_id AS listing_id, count(*) AS favored FROM sdxbv_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (7064,7063,7062,7061,7060,7058,7057,7056,7055,7054) GROUP BY listing_id

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (17480,17479,17478,15544,17477,17456,17474,17276,17473,17446) )

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 (7063,7062,7061,7060,7058,7057,7056,7055,7054) AND published = 1 AND approved = 1 AND access IN (1) AND main_media = 1

SELECT PaidOrder.*, User.id AS `User.user_id`, User. name AS `User.name` FROM sdxbv_jreviews_paid_orders AS `PaidOrder` LEFT JOIN sdxbv_users AS User ON PaidOrder.user_id = User.id WHERE 1 = 1 AND ( `PaidOrder`.listing_id IN (7064,7063,7062,7061,7060,7058,7057,7056,7055,7054) AND `PaidOrder`.order_status IN ('Complete') AND `PaidOrder`.order_active = 1 ) ORDER BY `PaidOrder`.order_created ASC

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 (7054,7055,7057,7058,7060,7062,7063,7064) )