doc nearby
  • Home
  • Contact us
  • Join now
  • Sign In
    Forgot Password?
Search for
in city or suburb
 

Optometrist in and around Fish Hoek

Stephenson & Hodgkinson Optometrist

8th Avenue, Fish Hoek, Cape Town

021 7826092

Allan Wise Optometrist

Westlake Drive, Southern Suburbs, Cape Town

021 7024856

Vision Works Blue Route

16, Tokai Rd, Tokai

021 7124717

D R G Optical

Vans Road, Dreyersdal, Southern Suburbs

082 4625003

Colin Rodd Optometrists

Fish Hoek, Cape Town

021 7826313

Spec Savers Longbeach Mall

7975, WC, ZA

021 7852181

Torga Optical Tokai

Tokai, Southern Suburbs, Cape Town

021 7156238

Spec Savers Tokai

Tokai, Southern Suburbs, Cape Town

021 7158204

Eyelink-Stephen Pulford Optometrist Tokai

Tokai, Southern Suburbs, Cape Town

021 7158555

Hodgkinson & van Niekerk Optometrists

Muizenberg, Cape Town

021 7887281

Spec Savers Blue Route

Tokai, Southern Suburbs, Cape Town

021 7126725

Eyelink Stephen Pulford Optometrists Retreat

7945, WC, ZA

021 7126411

© DocNearby 2013
Contact us Privacy Policy Terms of Use
(default) 8 queries took 31 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `PracticeType`.`id`, `PracticeType`.`name`, `PracticeType`.`slug`, `PracticeType`.`is_general`, `PracticeType`.`ordering`, `PracticeType`.`is_active`, `PracticeType`.`created`, `PracticeType`.`modified`, `PracticeType`.`deleted`, `PracticeType`.`deleted_date` FROM `docnecpr_southafrica_live1`.`practice_types` AS `PracticeType` WHERE `PracticeType`.`slug` = 'optometrist' AND `PracticeType`.`deleted` = '' LIMIT 1111
2SELECT `PracticeType`.`id`, `PracticeType`.`slug` FROM `docnecpr_southafrica_live1`.`practice_types` AS `PracticeType` WHERE `PracticeType`.`slug` = 'optometrist' AND `PracticeType`.`deleted` = ''110
3SELECT `Lookup`.`id`, `Lookup`.`lookup`, `Lookup`.`lat`, `Lookup`.`lng`, `Lookup`.`geo`, `Lookup`.`created`, `Lookup`.`modified`, `Lookup`.`deleted`, `Lookup`.`deleted_date` FROM `docnecpr_southafrica_live1`.`lookups` AS `Lookup` WHERE `Lookup`.`lookup` = 'fish-hoek' AND `Lookup`.`deleted` = '' LIMIT 1110
4SELECT *, round( sqrt( (POW( Practice.lat -"-34.134171", 2)* 68.1 * 68.1) + (POW(Practice.lng -"18.4238", 2) * 53.1 * 53.1) )) AS distance FROM `docnecpr_southafrica_live1`.`practices` AS `Practice` LEFT JOIN `docnecpr_southafrica_live1`.`practice_types` AS `PracticeType` ON (`Practice`.`practice_type_id` = `PracticeType`.`id`) LEFT JOIN `docnecpr_southafrica_live1`.`cities` AS `City` ON (`Practice`.`city_id` = `City`.`id`) WHERE NOT (`Practice`.`accuracy` IS NULL) AND `Practice`.`practice_type_id` = (33) AND `Practice`.`deleted` = '' ORDER BY `distance` asc, `Practice`.`accuracy` desc LIMIT 12121228
5SELECT `Role`.`id` FROM `docnecpr_southafrica_live1`.`roles` AS `Role` WHERE `Role`.`deleted` = '' LIMIT 1110
6SELECT `UserPractice`.`id`, `UserPractice`.`user_id`, `UserPractice`.`practice_id`, `UserPractice`.`role_id`, `UserPractice`.`is_bookable`, `UserPractice`.`consultation_duration_minutes`, `UserPractice`.`is_verified`, `UserPractice`.`is_active`, `UserPractice`.`created`, `UserPractice`.`modified`, `UserPractice`.`deleted`, `UserPractice`.`deleted_date`, `User`.`id`, `User`.`email`, `User`.`password`, `User`.`timezone`, `User`.`group_id`, `User`.`is_verified`, `User`.`verification_code`, `User`.`remember_me`, `User`.`primary_practice_id`, `User`.`activated`, `User`.`created`, `User`.`modified`, `User`.`deleted`, `User`.`deleted_date`, `Practice`.`id`, `Practice`.`city_id`, `Practice`.`name`, `Practice`.`picture_url`, `Practice`.`practice_type_id`, `Practice`.`practice_number`, `Practice`.`utc_open_time_hh_mm_ss`, `Practice`.`utc_close_time_hh_mm_ss`, `Practice`.`consultation_duration_minutes`, `Practice`.`address_1`, `Practice`.`address_2`, `Practice`.`address_3`, `Practice`.`city`, `Practice`.`suburb`, `Practice`.`province`, `Practice`.`postal_address_1`, `Practice`.`postal_address_2`, `Practice`.`postal_address_3`, `Practice`.`postal_postal_code`, `Practice`.`postal_city`, `Practice`.`postal_province`, `Practice`.`postal_code`, `Practice`.`tel`, `Practice`.`fax`, `Practice`.`email`, `Practice`.`lat`, `Practice`.`lng`, `Practice`.`timezone`, `Practice`.`geo`, `Practice`.`accuracy`, `Practice`.`created`, `Practice`.`modified`, `Practice`.`source`, `Practice`.`is_verified`, `Practice`.`is_active`, `Practice`.`deleted`, `Practice`.`deleted_date`, `Role`.`id`, `Role`.`name`, `Role`.`label`, `Role`.`display_order`, `Role`.`created`, `Role`.`modified`, `Role`.`deleted`, `Role`.`deleted_date` FROM `docnecpr_southafrica_live1`.`user_practices` AS `UserPractice` LEFT JOIN `docnecpr_southafrica_live1`.`users` AS `User` ON (`UserPractice`.`user_id` = `User`.`id`) LEFT JOIN `docnecpr_southafrica_live1`.`practices` AS `Practice` ON (`UserPractice`.`practice_id` = `Practice`.`id`) LEFT JOIN `docnecpr_southafrica_live1`.`roles` AS `Role` ON (`UserPractice`.`role_id` = `Role`.`id`) WHERE `Practice`.`id` IN (6684, 6828, 6831, 6832, 6683, 6868, 6830, 6834, 6829, 6747, 6833, 6781) AND `UserPractice`.`role_id` = 1 AND `UserPractice`.`is_bookable` = '1' AND `UserPractice`.`is_active` = 1 AND `UserPractice`.`deleted` = ''002
7SELECT `PracticeType`.`slug`, `PracticeType`.`name` FROM `docnecpr_southafrica_live1`.`practice_types` AS `PracticeType` WHERE `PracticeType`.`is_active` = 1 AND `PracticeType`.`is_general` = 1 AND `PracticeType`.`deleted` = '' ORDER BY `PracticeType`.`is_general` DESC, `PracticeType`.`ordering` ASC, `PracticeType`.`name` ASC330
8SELECT `PracticeType`.`slug`, `PracticeType`.`name` FROM `docnecpr_southafrica_live1`.`practice_types` AS `PracticeType` WHERE `PracticeType`.`is_active` = 1 AND `PracticeType`.`is_general` = 0 AND `PracticeType`.`deleted` = '' ORDER BY `PracticeType`.`is_general` DESC, `PracticeType`.`ordering` ASC, `PracticeType`.`name` ASC26260