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

Optometrist in and around Mbekweni

D Mnisi Optometrist

Mphakalasi Street, Mbekweni, Paarl

021 8681390

Van der Spuy Oogkundiges

319, Main St, Paarl

021 8720701

Marelise Bester Optometrists

304, Main St, Lemoenkloof

021 8723530

Henk Moolman Optometrist

23, Church St, Wellington

021 8730074

Liebenberg Optometrists

20, Bo-Lady Grey, Lemoenkloof

021 8721910

Optika Paarl

5, Verster St, Lemoenkloof

021 8711470

Weck & Danner (Pty) ltd

36, Lady Grey St, Lemoenkloof

021 8722438

Spec Savers Paarl

58, Lady Grey St, Lemoenkloof

021 8726317

A G Gilliland Optometrist Wellington

7654, Breede River DC, WC

021 8642990

Andre Gilliland Optometrist

7655, WC, ZA

021 8642120

Torga Optical Paarl Mall

7646, WC, ZA

021 8634297/6

Spec Savers Paarl Mall

7646, WC, ZA

021 8634318

© DocNearby 2013
Contact us Privacy Policy Terms of Use
(default) 8 queries took 32 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 1110
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` = 'mbekweni' AND `Lookup`.`deleted` = '' LIMIT 1110
4SELECT *, round( sqrt( (POW( Practice.lat -"-33.6788112", 2)* 68.1 * 68.1) + (POW(Practice.lng -"18.9888537", 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 12121229
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 (6729, 6758, 6757, 6847, 6751, 6752, 6756, 6753, 6848, 6846, 6755, 6754) AND `UserPractice`.`role_id` = 1 AND `UserPractice`.`is_bookable` = '1' AND `UserPractice`.`is_active` = 1 AND `UserPractice`.`deleted` = ''003
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