Events Music Music - jazz & popular Picnic concert with Emo Adams

Picnic concert with Emo Adams New

0 1 0 0

Location

Western Cape

Paarl

Gabbema Doordrift Street , Paarl , 7646

Event dates

March 05, 2016

Events

Info phone

021 863 0543

Info email

Info website

http://www.taalmuseum.co.za

Bookings website

http://online.computicket.com/web/event/emo_adams_piekniekkonsert/962635382/0/68270097

Prices

Adults R130, Students R120, Children R60

Picnic concert with Emo Adams at the Taalmonument Garden Theatre

Popular singer Emo Adams and his band are to perform as part of the Garden Theatre Picnic Series at the Afrikaanse Taalmonument in Paarl on Saturday 5 March 2016. The picnic series is held in aid of the “Laat ons lees!” reading project for children.

The popular actor, singer and producer first became known for his roles in District 6: The Musical and Kat & the Kings. His reality programme, JOU SHOW met Emo, is one of the most popular shows on KykNET.

Picnic concert with Emo Adams at the Taalmonument Garden Theatre

Popular singer Emo Adams and his band are to perform as part of the Garden Theatre Picnic Series at the Afrikaanse Taalmonument in Paarl on Saturday 5 March 2016. The picnic series is held in aid of the “Laat ons lees!” reading project for children.

The popular actor, singer and producer first became known for his roles in District 6: The Musical and Kat & the Kings. His reality programme, JOU SHOW met Emo, is one of the most popular shows on KykNET.

The show begins at 19:30 in the Garden Theatre, located on the lawn right at the foot of the monument. Visitors are welcome to bring their own drinks (no glass) and picnic basket or they can order one from Volksmond Coffee Shop (tel. 021 863 2800). Coffee, beer, wine and light refreshments will be for sale.

Tickets are pre-sold through Computicket as well as at the Taalmonument, at R130 for adults, R120 for students and R60 for children under 13 year. A limited number of tickets will be available at the gate. Remember to bring a blanket or cushion and warm clothes. Safe parking is available and access is controlled. No dogs or fires are allowed.

For more information, call 021 863 0543/4809 or visit www.taalmonument.co.za and www.facebook.com/afrikaansetaalmonument.

What are you looking for today?

For advanced searches (price, amenities, etc) please click here.

Special offers

Fabulous February Accommodation Special Offer

Discount %

Town: Hazyview

You have earned a break! And with a 25% discount of accommodation at Nabana Lodge this week only, it puts...

Hippoview Guesthouse 25% midweek discount for the month of February

Discount %

Town: Bela Bela

Hippoview Guesthouse 25% midweek discount for the month of February

Latest directory entries

McClean sunset - by Anthony Koeslag - 2012 03 12-1.jpg

Astronomy talk titled "Are we living in a simulation?"

Category: Workshops & Lectures

Town: Cape Town

Are we living in a simulation

Fabulous February Accommodation Special Offer

Discount %

Category: Special offers

Town: Hazyview

You have earned a break! And with a 25% discount...

Beauclair Guest Cottage

Category: Self-catering

Town: Stellenbosch

The stately Beauclair manor is situated on the banks...

Mogalakwena Beach Music

Category: Self-catering

Town: Hermanus

The Beach House is located on the popular whale coast...

The Carraighs

Category: Self-catering

Town: Plettenberg Bay

Charming modern but rustic cottage overlooking the indigenous forest in...

Far Horizon Eco Lodge

Category: Lodges & Country Houses

Town: Port Edward

Far Horizon Eco Lodge offers spacious 1 to 3...

Bed and Breakfast on Melrose

Category: Guest houses & B&Bs

Town: Johannesburg

Arrive to a warm friendly hospitality at this gracious privately...

Butterfly Dreams

Category: Theatre

Town: Cape Town

Jungle Theatre Company will perform Butterfly Dreams aka Metamorphosis with...

Stargazing Picnic

Category: Adventures & Outings

Town: Paarl

Stargazing Picnic at the Taalmonument Stargazing enthusiasts should...

Picnic concert with Emo Adams

Category: Music - jazz & popular

Town: Paarl

Picnic concert with Emo Adams at the Taalmonument Garden Theatre...

S2Framework Debug Console

PHP Errors

[8] Undefined variable: public_menu_id on line 93 in file /usr/www/users/capeixwyks/templates/jreviews_overrides/views/themes/capeinfo/modules/advanced_search.thtml

Database Queries (58)

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 = 190 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 = 6454 )

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 ('2') )

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 (2) ) ORDER BY CriteriaRating.ordering

SELECT groupid FROM sdxbv_jreviews_groups WHERE groupid IN (9,2,1) 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,2,9)

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_infophone,jr_infoemail,jr_infowebsite,jr_bookingswebsite,jr_pricerange FROM sdxbv_jreviews_content AS Listing WHERE Listing.contentid IN (6454)

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4') AND value IN ( 'south-africa','western-cape','winelands','paarl') 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 = 6454 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 (6454) GROUP BY listing_id

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

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 (6454) 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 (6454) 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 images FROM sdxbv_content WHERE id = 6454

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 = 6454 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 groupid FROM sdxbv_jreviews_groups WHERE groupid IN (9,2,1) AND type = 'review'

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

SELECT Listing.catid FROM sdxbv_content AS Listing RIGHT JOIN sdxbv_jreviews_categories AS Category ON Listing.catid = Category.id AND Category.option = 'com_content' WHERE Listing.id = 6454

SELECT Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid,CONCAT(REPEAT('- ', IF(Category.level>0,Category.level - 1,1)), Category.title) AS text FROM sdxbv_categories AS Category RIGHT JOIN sdxbv_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Category.id AND JreviewsCategory.`option` = 'com_content' WHERE Category.published = 1 AND Category.access IN ( 1 ) AND Category.level > 0 AND Category.extension = 'com_content' AND (Category.id IN ( SELECT id FROM sdxbv_jreviews_categories WHERE `option` = "com_content" AND dirid IN (1) )) ORDER BY Category.lft

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-02-23 22:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2016-02-22 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 * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4') AND value IN ( 'south-africa','limpopo','waterberg','bela-bela','mpumalanga','panorama','hazyview') 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 (6332,5783) )

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

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (5254,16898) )

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 (6463,6402) 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 (6463,6402) 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) AND Listing.state = 1 AND Listing.access IN ( 1) AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2016-02-23 22:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2016-02-22 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,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_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,jr_discount FROM sdxbv_jreviews_content AS Listing WHERE Listing.contentid IN (6464,6463,6462,6461,6459,6458,6457,6456,6455,6454)

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4','68','92','69','70','71','21','5') AND value IN ( 'south-africa','western-cape','winelands','paarl','cape-town-metro','cape-town','gauteng','johannesburg-metro','johannesburg','upper','airconditioning','childfriendly','disabilityfriendly','gayfriendly','laundry-facilities','secure-parking','tv-in-rooms','wireless-internet','swimming-pool','public-transport-nearby','shopping-nearby','kwazulu-natal','south-coast','port-edward','1-star','budget','midrange','braai','conference-facilities','credit-cards-accepted','petfriendly','restaurantbar','selfcatering-facilities','fishing','farmstays','garden-route','plettenberg-bay','beach-nearby','wilderness-environment','overberg','hermanus','luxury','stellenbosch','top','mpumalanga','panorama','hazyview','observatory') 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 (5783) )

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

SELECT content_id AS listing_id, count(*) AS favored FROM sdxbv_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (6464,6463,6462,6461,6459,6458,6457,6456,6455,6454) GROUP BY listing_id

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (15544,5254,16996,6616,16995,16964,16994,5820,6993) )

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 (6464,6463,6462,6461,6459,6458,6456,6455,6454) 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 (6464,6463,6462,6461,6459,6458,6457,6456,6455,6454) 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 (6457,6458,6459,6461,6462) )

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (16994,16964,16995,6616,16996) )

Picnic concert with Emo Adams New

Location

Event dates

Events

Special offers

Latest directory entries

National Guide

S2Framework Debug Console

PHP Errors

Database Queries (58)