SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (77883,77895,77692,78236,78148,78120,49931,77955,78237,78332,78121,77712,78238,77996,78430,77971) 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 Gura Humorului

  • Adresa: Pavilion Central: Piata Republicii, nr.1, Compartiment Pediatrie si Ambulator Intregrat Cabinet Pediatrie: str.Lt.Viorel Marceanu, nr.24; Sediul Administrativ, Dispensar TBC, Magazie Spital: b-dul Bucovinei nr.17., Gura Humorului, Suceava

Doctori în alte secții