Search Thousands of Health Care Jobs

Physician/Surgeon Jobs

Browse Jobs

by Specialty

Physician/Surgeon

83 Job(s)

Page 1 of 5

12 3 4 5 Next >

Date Title Company Location Type
01-28-2011 Reservist Medical MD Navy Recruiting District/PA Baltimore, MD Full-Time
Normal 0 false false false MicrosoftInternetExplorer4 PHYSICIANS Distinguish yourself as a Navy Reserve Medical Officer and extend your
01-28-2011 Reserve MSC Navy Recruiting District/PA Baltimore, MD Full-Time
Normal 0 false false false MicrosoftInternetExplorer4 Reserve MSC If you’re a seasoned medical professional, just starting out or sti

01-28-2011 Dentist Navy Recruiting District/PA Philadelphia, PA Full-Time
Normal 0 false false false MicrosoftInternetExplorer4 Your passion for perfecting smiles, your appreciation for dentistry as an art and sc
04-21-2009 Doctor / Physician required for Internal Medicine practice Univision Group Nationwide Full-Time
Well established Internal Medicine partnership with several clinic sites seeks a Board Certified Internal Medicine Doctor / Physician to join its expanding practice in New Jersey. This is a partnershi
01-31-2011 Reservist Medical MD Navy Recruiting District/PA Philadelphia, PA Full-Time
Normal 0 false false false MicrosoftInternetExplorer4 PHYSICIANS Distinguish yourself as a Navy Reserve Medical Officer and extend your
02-05-2011 Physician Billing Liaison Advocate Health Care Oak Lawn, IL N/A
To facilitate timely charge entry of all patient encounter forms and review for accuracy and completeness. To reconcile all entered encounters to number of patients seen on an inpatient and outpatien
01-17-2011 Physician Assistant (Surgical Services Euclid PRN) Job Cleveland Clinic Euclid, OH N/A
PA HOSP MIDLEVEL PROVIDERReference TitleHR Use Only: Physician Assistant (Surgical Services Euclid PRN)Hospital: Euclid HospitalFacility: EUCLID HOSPITALDepartment: PHYSICIAN/SURG/MED STAFF ASSTJob Co
03-22-2010 Dental Specialist Los Angeles County Sheriff's Dept. Medical Services Bureau Los Angeles, CA Full-Time
JOB TITLE DENTAL SPECIALISTEXAM NUMBER J4767AFILING DATES September 25, 2006 until needs are metMONTHLY SALARY $7,892.64 - $9,287.00 POSITION INFORMATION Positions allocable to this class provides pr
03-22-2010 Chief Physician III Los Angeles County Sheriff's Dept. Medical Services Bureau Los Angeles, CA Full-Time
JOB TITLE CHIEF PHYSICIAN III (VARIOUS SPECIALTIES)EXAM NUMBER J5459AFILING DATES October 23, 2009 until needs are metMONTHLY SALARY $10,755.00 - $28,331.00 Persons employed in this position shall be

03-22-2010 Chief Physician II Los Angeles County Sheriff's Dept. Medical Services Bureau Los Angeles, CA Full-Time
JOB TITLE CHIEF PHYSICIAN II (VARIOUS SPECIALTIES)EXAM NUMBER J5458AFILING DATES October 29, 2009 until needs are metMONTHLY SALARY $10,467.00 - $27,573.00 Persons employed in this position shall be c
04-21-2009 Doctor / Physician required for Internal Medicine practice Univision Group Nationwide Full-Time
Well established Internal Medicine partnership with several clinic sites seeks a Board Certified Internal Medicine Doctor / Physician to join its expanding practice in New Jersey. This is a partnershi
03-22-2010 Physician Specialist Los Angeles County Sheriff's Dept. Medical Services Bureau Los Angeles, CA Full-Time
JOB TITLE PHYSICIAN SPECIALIST (NON-MEGAFLEX)EXAM NUMBER J5476AFILING DATES May 26, 2009 until needs are metMONTHLY SALARY $8,851.00 - $30,581.00 Persons employed in this position shall be compensate
03-22-2010 Pharmacist Los Angeles County Sheriff's Dept. Medical Services Bureau Los Angeles, CA Full-Time
PHARMACIST/PERMANENTEXAM NUMBER J5512IFILING DATES August 06, 2007 until needs are metSALARY $8,393.82 - $9,356.00 MONTHLY$8,645.91 - $9,636.45 (Effective January 1, 2009) POSITION INFORMATION Positio
04-03-2009 Obstetrics and gynecology TruStaff Travel Nurses Battle Creek, MI
Board-Certified, experienced, femaile OBGYN needs to add a colleague due to the rapid growth of her practice. New OBGYN must share paatient-centered, compassionate attitude. Part time status can be ar
04-03-2009 Cardiology TruStaff Travel Nurses Ashtabula, OH
Great Opportunity for invasive cardiologist to join multi specialty clinic; Hospital has bult a brand new cath lab; Cardiologist can perform peripheral/vascular procedures; Excellent salary guaranteed
04-03-2009 General surgery TruStaff Travel Nurses Ashtabula, OH
General Surgeon; Currently multi-specialty clinic has two general surgeons; Heavy volume requires three surgeons; Will consider HIB Visa; *WAITING ON PAY DETAILS*

04-21-2009 Doctor / Physician required for Internal Medicine practice Univision Group Nationwide Full-Time
Well established Internal Medicine partnership with several clinic sites seeks a Board Certified Internal Medicine Doctor / Physician to join its expanding practice in New Jersey. This is a partnershi
04-03-2009 Obstetrics and gynecology TruStaff Travel Nurses Dallas, TX
Austin - Suburb; This is a brand new full-service hospital located less than 20 minutes north of Austin seeking an Obstetrician/Gynecologist to meet the needs of this fast-growing and highly desirable
04-03-2009 Orthopedic surgery TruStaff Travel Nurses Battle Creek, MI
Three board-certified partners need to recruit two colleagues to replace a recently-retired partner and a partner who is relocating to be near family in California. The practice is largely general ort
04-03-2009 Otolaryngology TruStaff Travel Nurses Battle Creek, MI
Experienced otolaryngologist needs to replace young colleague who relocated. Doctor recruited will be interested in general ENT practice and capturing sinus surgery and cancer cases now referred out.
04-03-2009 Pain Management TruStaff Travel Nurses Battle Creek, MI
Experienced pain specialist with PM&R (preferred) or Anesthesia residency and ACGME-accredited, university-based interventional pain fellowship is needed to start a practice expected to support two ph
04-03-2009 Otolaryngology TruStaff Travel Nurses Ashtabula, OH
Otolaryngoloist; Tremendous growth potential for otolaryngologist to join our multi specialty clinic; Fourteen Primary Care Physicians Referring to the OTO; Will Accept HIB Visa; ***WAITING ON PAY DET
04-03-2009 Pediatrics TruStaff Travel Nurses Battle Creek, MI
Two board-certified pediatricians need to recruit another to facilitate the senior partner’s reduction in hours in anticipation of retirement. Salary $135,000 to $145,000. Bonus is not based on prod

Page 1 of 5

12 3 4 5 Next >

Spotlight Employers

Sign Up For Job Alerts

$_SESSION

Progname:

Line:

Array ( [Config] => Array ( [userAgent] => [time] => 31329950138 [timeout] => 10 ) [oldParams] => Array ( [pass] => Array ( ) [named] => Array ( ) [controller] => profession [action] => getActive [plugin] => [form] => Array ( ) [url] => Array ( [url] => /profession/getActive/ ) [autoRender] => 0 [return] => 1 [bare] => 1 [requested] => 1 ) )

$this->params

Progname:

Line:

Array ( [pass] => Array ( [0] => Physician_Surgeon ) [named] => Array ( ) [plugin] => [controller] => jobs [action] => browseProfession [form] => Array ( ) [url] => Array ( [url] => browse-by-profession/Physician_Surgeon ) [models] => Array ( [0] => Job [1] => State [2] => City [3] => Profession [4] => GsaLocation [5] => Company [6] => SavedJob [7] => Specialty [8] => Application [9] => Availability [10] => UploadFile [11] => User [12] => JacJob [13] => Recruiter ) )

(default) 26 queries took 1060 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES	127	127	23
2	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('State', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('State'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'State'	8	8	10
3	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('city', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('city'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'city'	5	5	10
4	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Profession', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Profession'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Profession'	5	5	10
5	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Company', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Company'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Company'	31	31	14
6	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Saved_Job', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Saved_Job'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Saved_Job'	7	7	10
7	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Application', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Application'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Application'	27	27	12
8	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Availability', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Availability'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Availability'	5	5	9
9	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Recruiter_Profile', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Recruiter_Profile'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Recruiter_Profile'	19	19	11
10	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Recruiter', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Recruiter'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Recruiter'	25	25	12
11	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Login', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Login'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Login'	11	11	10
12	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Login_Type', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Login_Type'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Login_Type'	5	5	9
13	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Member', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Member'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Member'	9	9	10
14	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Files', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Files'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Files'	11	11	11
15	SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'jobs' AND action = 'browseProfession' AND status = 'A' ORDER BY [level] DESC,weight DESC	14	14	11
16	SELECT id, name FROM Profession (NOLOCK) where status = 'A' and id > 0 ORDER BY name	4	4	9
17	EXEC [webuser].[usp_browse_get_state] @profession_name = 'Physician/Surgeon'	-1	17	306
18	exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '20', @start = '1', @nationwide='0', @reverse= '0'	-1	20	323
19	exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '1', @start = '1', @nationwide='1', @reverse= '0'	-1	1	39
20	exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '1', @start = '1', @nationwide='1', @reverse= '0'	-1	1	39
21	exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '1', @start = '1', @nationwide='1', @reverse= '0'	-1	1	39
22	exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '1', @start = '1', @nationwide='1', @reverse= '0'	-1	1	39
23	SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'companies' AND action = 'getSpotlights' AND status = 'A' ORDER BY [level] DESC,weight DESC	0	0	11
24	SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'home' AND action = 'index' AND status = 'A' ORDER BY [level] DESC,weight DESC	1	1	9
25	EXEC webuser.usp_get_spotlight_employer_cron @top_count = 8	-1	8	64
26	SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'profession' AND action = 'getActive' AND status = 'A' ORDER BY [level] DESC,weight DESC	0	0	10

(default) 26 queries took 1060 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

127

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('State', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('State'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'State'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('city', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('city'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'city'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Profession', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Profession'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Profession'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Company', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Company'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Company'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Saved_Job', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Saved_Job'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Saved_Job'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Application', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Application'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Application'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Availability', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Availability'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Availability'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Recruiter_Profile', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Recruiter_Profile'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Recruiter_Profile'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Recruiter', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Recruiter'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Recruiter'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Login', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Login'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Login'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Login_Type', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Login_Type'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Login_Type'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Member', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Member'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Member'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Files', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Files'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Files'

SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'jobs' AND action = 'browseProfession' AND status = 'A' ORDER BY [level] DESC,weight DESC

SELECT id, name FROM Profession (NOLOCK) where status = 'A' and id > 0 ORDER BY name

EXEC [webuser].[usp_browse_get_state] @profession_name = 'Physician/Surgeon'

-1

306

exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '20', @start = '1', @nationwide='0', @reverse= '0'

-1

323

exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '1', @start = '1', @nationwide='1', @reverse= '0'

-1

exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '1', @start = '1', @nationwide='1', @reverse= '0'

-1

exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '1', @start = '1', @nationwide='1', @reverse= '0'

-1

exec [webuser].[usp_browse_profession] @profession_name = 'Physician/Surgeon', @sortby = '', @top_count = '100000', @result_count = '1', @start = '1', @nationwide='1', @reverse= '0'

-1

SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'companies' AND action = 'getSpotlights' AND status = 'A' ORDER BY [level] DESC,weight DESC

SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'home' AND action = 'index' AND status = 'A' ORDER BY [level] DESC,weight DESC

EXEC webuser.usp_get_spotlight_employer_cron @top_count = 8

-1

SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'profession' AND action = 'getActive' AND status = 'A' ORDER BY [level] DESC,weight DESC

Physician/Surgeon Jobs

Spotlight Employers

Sign Up For Job Alerts

Members

Employers

Site

$_SESSION

$this->params