Unknown column 'ycode' in 'where clause'
select c.fname as country, c.code as coucode, concat( left( d.descr, 300 - locate( " ", reverse( left( d.descr, 300 ) ) ) ) ) AS intro, a.suburb_code, count(a.suburb_code) as cnt, d.fname as suburb, d.code as suburbcode, r.fname as region, r.code as regioncode, e.fname as area, f.fname as city, f.code as cicode, g.fname as town, g.code as towncode, e.code as areacode from va_suburb d left join va_venue a on (a.suburb_code = d.code) left join va_country c on (c.code = d.country_code) left join va_region r on (r.code = d.region_code) left join va_area e on (e.code = d.area_code) left join va_city f on (f.code = d.city_code) left join va_town g on (g.code = d.town_code) where d.code = ycode and a.active = 1 group by d.code LIMIT 100 offset 0

Error Text:
Unknown column 'ycode' in 'where clause' ....
Query Text:
select c.fname as country, c.code as coucode, concat( left( d.descr, 300 - locate( " ", reverse( left( d.descr, 300 ) ) ) ) ) AS intro, a.suburb_code, count(a.suburb_code) as cnt, d.fname as suburb, d.code as suburbcode, r.fname as region, r.code as regioncode, e.fname as area, f.fname as city, f.code as cicode, g.fname as town, g.code as towncode, e.code as areacode from va_suburb d left join va_venue a on (a.suburb_code = d.code) left join va_country c on (c.code = d.country_code) left join va_region r on (r.code = d.region_code) left join va_area e on (e.code = d.area_code) left join va_city f on (f.code = d.city_code) left join va_town g on (g.code = d.town_code) where d.code = ycode and a.active = 1 group by d.code LIMIT 100 offset 0

ACCOMMODATION SEARCH
Enter first 3 letters of a location or venue name & wait for suggestions: or try our new
Accommodation Search LIVE AVAILABILITY SEARCH

Big Bay Car Hire

Car Hire</div>Car Hire

Big Bay Accommodation

Find the ideal Big Bay Accommodation at a guesthouse, self-catering establishment, a bed & breakfast or safari lodge.

Please contact us on +27 021 683 6444 or email us at for all your Big Bay Accommodation needs.

Book the perfect Big Bay vacation accommodation online with www.Venues4Africa.com




Kingshaven Cottage
Graded

Self Catering Accommodation in Big Bay
Kingshaven Cottage can comfortably accommodate 6 guests. A double sleeper couch can accommodate another two people at a nominal charge. This beautiful cottage is found within a security estate with 24-hour More about Kingshaven Cottage
Price Per Person Per Night from R1050 to R1400

Seaside Village NR B24
Graded

Self Catering Accommodation in Big Bay
Situated 20 minutes from the centre of Cape Town. The indigenous beauty of Big Bay with its stunning views of the ocean, Table Mountain and the historic Robben Island. As part of Bloubergstrand, Big Bay is a natural More about Seaside Village NR B24
Price Per Person Per Night from R500 to R1000

Silver Wind
Graded

Self Catering Accommodation in Big Bay
SilverWind is a brand new luxury apartment which is situated right on the beach in Bloubergstrand. It sleeps between One and Six People comfortably and has two bathrooms. Eight people can be accommodated if necessary More about Silver Wind
Price Per Person Per Night from R450 to R1100


PAGE: 1