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

Doctors in and around Kraaifontein

VOSLOO M

120, Shelley St, Windsor Park

021-9874282

BEKKER J B AND ASSOCIATES MEDICROSS

Brighton Road, Windsor Park Estate, Kraaifontein

021-98716907

DU PLESSIS N V

Okavango Road, Brackenfell, Cape Town

021-9817880

KRETSCHMER AND ASSOCIATES INCORPORATED

Brackenfell Boulevard, Sonstraal Heights, Durbanville

021-9826331

GOOSEN W N

4, Fontein Rd, Arauna

021-9819890

BAARD A

185, 3rd Ave, Belmont Park

021-9871616

VOS P J

Koopmans Avenue, Scottsdene, Kraaifontein

021-9884816

FERREIRA AND TRUTER INCORPORATED

23, Protea Rd, Protea Hoogte

021-9826152

TREDOUX A

20, Langenhoven St, Durbanville

021-9751683

MILES C A

4, Kruin St, Protea Hoogte

021-9819385

MULLER RIANA

Kraaifontein, Cape Town

021-9871995

VOS P J AND ASSOCIATES

Scottsdene, Kraaifontein, Cape Town

021-9884816

© DocNearby 2013
Contact us Privacy Policy Terms of Use
(default) 8 queries took 37 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` = 'doctors' AND `PracticeType`.`deleted` = '' LIMIT 1110
2SELECT `PracticeType`.`id`, `PracticeType`.`slug` FROM `docnecpr_southafrica_live1`.`practice_types` AS `PracticeType` WHERE `PracticeType`.`slug` = 'doctors' AND `PracticeType`.`deleted` = ''220
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` = 'kraaifontein' AND `Lookup`.`deleted` = '' LIMIT 1110
4SELECT *, round( sqrt( (POW( Practice.lat -"-33.8441667", 2)* 68.1 * 68.1) + (POW(Practice.lng -"18.6986111", 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` IN (1, 50) AND `Practice`.`deleted` = '' ORDER BY `distance` asc, `Practice`.`accuracy` desc LIMIT 12121235
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 (2969, 2559, 2621, 2726, 2653, 2549, 2967, 2635, 2923, 2773, 2799, 2968) 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