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

Dentists in and around Bloemfontein

BRITTAIN R

17, Charlotte Maxeke Street, Bloemfontein Central

051-4473408

ROOD E R INCORPORATED

Hanger Street, Bloemfontein Central, Bloemfontein

051-4480973

MARAIS J S

Aliwal Street, Bloemfontein Central, Bloemfontein

051-4470873

MAILE INCORPORATED

Oos Burger Street, Bloemfontein Central, Bloemfontein

051-4300316

CILLIERS EZRA J

30A, Reid St, Westdene

051-4304911

MOKOTJO MOKHOTHU A

73, Park Rd, Willows

051-4442694

PATRINOS P

0, Nelson Mandela Dr, Brandwag

051-4301444

MATJOA P E

Dr Belcher Road, Heidedal, Bloemfontein

051-4327272

VON GERICKE Y

1st Avenue, Westdene, Bloemfontein

051-4478206

MUDAU T

Dr Belcher Road, Heidedal, Bloemfontein

015-9625410

BARNARD L

83, Melville Dr, Brandwag

051-4442042

APPOLLIS K B

84, Sonneblom St, Ashbury

051-4324493

© DocNearby 2013
Contact us Privacy Policy Terms of Use
(default) 8 queries took 28 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` = 'dentists' AND `PracticeType`.`deleted` = '' LIMIT 1110
2SELECT `PracticeType`.`id`, `PracticeType`.`slug` FROM `docnecpr_southafrica_live1`.`practice_types` AS `PracticeType` WHERE `PracticeType`.`slug` = 'dentists' 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` = 'bloemfontein' AND `Lookup`.`deleted` = '' LIMIT 1110
4SELECT *, round( sqrt( (POW( Practice.lat -"-29.118349", 2)* 68.1 * 68.1) + (POW(Practice.lng -"26.22492", 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` = (31) AND `Practice`.`deleted` = '' ORDER BY `distance` asc, `Practice`.`accuracy` desc LIMIT 12121226
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 (3087, 3138, 3113, 3107, 3089, 3120, 3133, 3116, 3154, 3127, 3082, 3081) 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