SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64980,64979) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (22295,46824,64987,46890,64983) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (22295,46824,64987,46890,64983) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64988) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64988) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64988) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64989,46611) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64989,46611) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64989,46611) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64989,46611) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64998,64997) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64998,64997) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64998,64997) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64998,64997) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64998,64997) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64999) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64999) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64999) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64999) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64999) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (64999) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (65001,65000) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (65001,65000) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (65001,65000) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (65001,65000) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (65001,65000) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (65001,65000) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (65001,65000) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 200

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

SELECT   wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (6425) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
			 
			 ORDER BY wp_posts.order_by_in_listing DESC
			 LIMIT 0, 1

Spitalul de Boli Infecțioase și Psihiatrie Baia Mare

Spital de Boli Infectioase

• Spital de Boli Infectioase
• Adresa: Str. Vasile Lucaciu nr. 72, Baia Mare, Maramureș
• Boli Infecțioase
• Dermatovenerologie
• Epidemiologie
• Psihiatrie
• Radiologie - imagistică medicală

Ultima actualizare a datelor: 28.12.2015

Secția Comitet Director

Dr. Viorica Chereches

Dr. Oana Daniela David

Secția Boli Infectioase

Dr. Alexandru Mercea

Dr. Doina Harlisca

Dr. Viorica Cherches

Dr. Zenovia Pop

Dr. Onoria Daraban

Secția Cabinet Nosocomiale

Dr. Gheorghe Timis

Secția Dermatovenerologie

Dr. Valentin Pop

Dr. Maria Pocol

Secția Psihiatrie

Dr. Iuliu Marius Cordea

Dr. Aurora Caulea

Secția Radiologie

Dr. Gratian Botis

Secția Centrul de Sanatate Mintala

Dr. Sorina Birle

Dr. Dorina Donca