SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
			 FROM wp_posts 
			 WHERE 1=1  AND wp_posts.ID IN (82587,55598,55409) 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

Centrul de oftalmologie Medsystem

Cabinet Medical de Oftalmologie

• Cabinet Medical de Oftalmologie
• Adresa: Str. Gen. Magheru, nr.1, Oradea, Bihor, Oradea, Bihor
• Oftalmologie
• Urologie

Descriere

CONSULTAÅ¢II ÅžI TRATAMENTE AMBULATORII
CHIRURGIE OFTALMOLOGICÄ‚ – OPERAÅ¢II MEDII ÅžI MARI
TRANSPLANT DE CORNEE
TRATAMENT CU LASER PENTRU îMBUNÄ‚TÄ‚Å¢IREA VEDERII

Ultima actualizare a datelor: 10.02.2015

Secția N/A

Dr. Norbert Czumbel

Dr. Elisabeta Gale

Dr. Alexis Tsorbatzoglou