Doc Nearby - Doctors near Zamdela

Search for
in city or suburb doctors that I have used before practices that I have used before

Doctors in and around Zamdela

LOEST H C INC

5, N J Van Der Merwe Cres, Sasolburg

016-9760940

FRITZ J T

5, N J Van Der Merwe Cres, Sasolburg

016-9760940

DIPPENAAR Y

17, Schumann St, Vanderbijlpark S. W. 5

016-9322552

CRAEMER C L A

Piet Retief Boulevard, Vanderbijlpark S. E. 7, Vanderbijlpark

016-9823123

VENTER D F

326, Playfair Blvd, Vanderbijlpark C. E. 5

016-9331497

DOOREWAARD G H

23, Livingstone Blvd, Vanderbijlpark C. E. 1

016-9334012

BESTER M R N

23, Livingstone Blvd, Vanderbijlpark C. E. 1

016-9334012

KLOPPERS B

6, Jan Van Riebeeck Blvd, Vanderbijlpark C. E. 1

016-9508047

COETZER G J

6, Jan Van Riebeeck Blvd, Vanderbijlpark C. E. 1

016-9508079

DU TOIT A G

6, Jan Van Riebeeck Blvd, Vanderbijlpark C. E. 1

016-9508087

GILLILAND D G

6, Jan Van Riebeeck Blvd, Vanderbijlpark C. E. 1

016-9322925

ENGELBRECHT F J

6, Jan Van Riebeeck Blvd, Vanderbijlpark C. E. 1

016-9508068

© DocNearby 2013

Contact us Privacy Policy Terms of Use

(default) 8 queries took 36 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `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 1		1	1	0
2	SELECT `PracticeType`.`id`, `PracticeType`.`slug` FROM `docnecpr_southafrica_live1`.`practice_types` AS `PracticeType` WHERE `PracticeType`.`slug` = 'doctors' AND `PracticeType`.`deleted` = ''		2	2	0
3	SELECT `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` = 'zamdela' AND `Lookup`.`deleted` = '' LIMIT 1		1	1	0
4	SELECT , round( sqrt( (POW( Practice.lat -"-26.8662267", 2) 68.1 * 68.1) + (POW(Practice.lng -"27.8692376", 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 12		12	12	34
5	SELECT `Role`.`id` FROM `docnecpr_southafrica_live1`.`roles` AS `Role` WHERE `Role`.`deleted` = '' LIMIT 1		1	1	0
6	SELECT `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 (302, 259, 562, 532, 1334, 568, 456, 732, 530, 580, 614, 587) AND `UserPractice`.`role_id` = 1 AND `UserPractice`.`is_bookable` = '1' AND `UserPractice`.`is_active` = 1 AND `UserPractice`.`deleted` = ''		0	0	2
7	SELECT `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` ASC		3	3	0
8	SELECT `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` ASC		26	26	0