SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (31584) 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 (59635,12489) 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 (59635,12489) 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

CENTRUL MEDICAL SENARIUS

Centru Medical

• Centru Medical
• Adresa: Str. Clinicilor, 36, Cluj-Napoca, Cluj Napoca, Cluj

Descriere

CENTRUL MEDICAL SENARIUS VA OFERA O GAMA LARGA DE SERVICII MEDICALE DE CALITATE:CONSULTATII DE SPECIALITATE (cardiologie,ginecologie,medicina de famili,medicina muncii,orl,pneumologie,rematologie,pediatrie,psihiatrie,urologie,nefrologie),ECOGRAFIE(abdominala,cardiaca,tiroidiana,endovaginala,de sarcina,articulara,san,testiculara,tesuturi moi),KINETOTERAPIE CU INSTRUCTOR PERSONAL,LOGOPEDIE,PSIHOTERAPIE

Ultima actualizare a datelor: 20.07.2016

Secția gastroenterologie

Dr. Romeo Chira

Doctori în alte secții

Prof.Dr. Silviu Albu

Dr. Ligia Diana Mihalca