SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (30231) 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 (77154,48421,77065,48423,77649,48424,77260,77160,48413,48427,48432,77450,48416,77358,77366,48429,48419,48418,48431,48425,77321,77277,48420,77602,77498,48415,77137,77100,48411,48422,48430,77369,77514,81013,48412,77518,77455,48428,76992,77048,77648,77265,48414,77661,77148,48426,48417,77352) 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 (77154,48421,77065,48423,77649,48424,77260,77160,48413,48427,48432,77450,48416,77358,77366,48429,48419,48418,48431,48425,77321,77277,48420,77602,77498,48415,77137,77100,48411,48422,48430,77369,77514,81013,48412,77518,77455,48428,76992,77048,77648,77265,48414,77661,77148,48426,48417,77352) 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

Spitalul Municipal Mediaș

Spital Municipal

Spital Municipal
Adresa: str. Closca, nr. 2, Medias, jud. Sibiu, Mediaș, Sibiu
Boli Infecțioase
Chirurgie generală
Medicină internă
Neonatologie
Obstetrică - ginecologie
Pediatrie
Radiologie - imagistică medicală

Ultima actualizare a datelor: 18.12.2015

Spitalul Municipal Mediaș

Spital Municipal

Secția M.G

Doctori în alte secții