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
02-03-2011 PHYSICIAN SPECIALIST CLINICAL INFORMATICS - Medina Job Cleveland Clinic Cleveland, OH N/A
PHYSICIAN SPECIALIST CLINICAL INFORMATICSCCHS Employees OnlyReference TitleHR Use Only: PHYSICIAN SPECIALIST CLINICAL INFORMATICS - MedinaHospital: Cleveland Clinic Main Campus & Family Health Centers
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
01-07-2011 Family Practice Physician, MD/DO Bay Mills Health Center Brimley, MI Full-Time
Normal 0 false false false MicrosoftInternetExplorer4 Family Practice Physician, MD/DO Need in Michigan Bay Mills Health Center seeks

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-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 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-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.

09-25-2009 General Surgeon Air National Guard Nationwide Full-Time
POSITIONS THROUGHOUT THE COUNTRYANG HP Job Postings – General Surgeon 4March 11, 2010 Be a General Surgeon in the Air Guard Job SummaryAs a General Surgeon in the Air Guard, you’ll adapt t
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
07-08-2011 TEST 2 Ralph's Test Account Norfolk, VA Part-Time
THIS IS A TEST POSTING!!!!!!! PLEASE DON'T RESPOND!!!!!
06-03-2011 Intent Test 2 Ralph's Test Account Norfolk, VA Full-Time
Test posting - DO NOT APPLY!!Test PostingTest PostingTest PostingTest PostingTest PostingTest Posting - DO NOT APPLY!!
06-03-2011 offsite posting - sub recruiter Todd's Test Company Virginia Beach, VA Part-Time
offsite posting - sub recruiter
02-05-2011 Physician Assistant (Breast Center Main Campus) Job Cleveland Clinic Cleveland, OH N/A
Physician Assistant (T31170)Reference TitleHR Use Only: Physician Assistant (Breast Center Main Campus)Hospital: Cleveland Clinic Main Campus & Family Health CentersFacility: CLEVELAND CLINIC FOUNDATI

Page 1 of 5

12 3 4 5 Next >

Spotlight Employers

Sign Up For Job Alerts

$_SESSION

Progname:

Line:

Array ( [Config] => Array ( [userAgent] => [time] => 31329949669 [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 1302 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES	127	127	27
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	11
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	9
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	9
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	13
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	12
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	13
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	10
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	13
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	12
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	32
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	19
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	10
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	12
17	EXEC [webuser].[usp_browse_get_state] @profession_name = 'Physician/Surgeon'	-1	17	46
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	758
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	37
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	57
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 = '2', @nationwide='1', @reverse= '0'	-1	1	47
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	10
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	10
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 1302 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

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

-1

758

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 = '2', @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