SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (57774,57936,57447,46125,45809,57934,45753,57321,46017) 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

Spitalul Orășenesc Rupea

Spital Orasenesc

• Spital Orasenesc
• Adresa: Str. Republicii nr. 128, Rupea, Brașov

Doctori în alte secții

Dr. Victor Mihai Craciun

Dr. Otniela Adina Lariu

Dr. Viorica Prescuri

Dr. Liviu Victor Craciunel

Dr. Victoria Felea

Dr. Ioan Coriolan Giurgiu

Dr. Adrian Radu Muntean

Dr. Vicentiu Munteanu

Dr. Cornelia Muresan