Hata
  • Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM u32r1_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM u32r1_content AS a LEFT JOIN u32r1_categories AS c ON c.id = a.catid LEFT JOIN u32r1_users AS ua ON ua.id = a.created_by LEFT JOIN u32r1_users AS uam ON uam.id = a.modified_by LEFT JOIN u32r1_categories as parent ON parent.id = c.parent_id LEFT JOIN u32r1_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM u32r1_categories AS cat JOIN u32r1_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN u32r1_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-28 03:53:50') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-28 03:53:50') ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC LIMIT 0, 4 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM u32r1_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM u32r1_content AS a LEFT JOIN u32r1_categories AS c ON c.id = a.catid LEFT JOIN u32r1_users AS ua ON ua.id = a.created_by LEFT JOIN u32r1_users AS uam ON uam.id = a.modified_by LEFT JOIN u32r1_categories as parent ON parent.id = c.parent_id LEFT JOIN u32r1_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM u32r1_categories AS cat JOIN u32r1_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN u32r1_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-28 03:53:50') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-28 03:53:50') ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC

MHRS Online Randevu

 
 
 

Telefon Rehberi

 
 

Bebek Dostu Hastane

 

Organ Bağışı

 

Hastanemizden Duyurular

example1

Hastanemizde Diyet Polikliniği hizmet vermeye başlamıştır.


example1

Hastanemizde Sigara Bırakma Polikliniği hizmet vermeye başlamıştır.


example1

Kadın Hastalıkları ve Doğum Uzmanı Uzman Doktor göreve başlamıştır.


example1

Anestezi Uzmanı Uzman Doktor Berna DEMİR göreve başlamıştır.

 

example1Hastanemizde Kardiyoloji Uzmanı Uzm. Dr.Okan ÖZTÜRK Göreve Başlamıştir

example1

Genel Cerrahi Uzmanı Opr. Dr. Onur PEKER Göreve Başlamıştır

example1

Ortopedi Uzmanı Opr. Dr. Mehmet KEZER Göreve Başlamıştır

 
example1

Hastanemize Psikiyatri Uzmanı Uzm.Dr.İbrahim Karakaya Göreve Başlamıştır.


example1

Hastanemiz Personellerine Uzm.Dr. Yalçın Kaya Tarafından Ebola Eğitimi Verilmiştir.


example1

Hastanemiz Kardiyoloji Polikliğinde Efor Testi İle Hizmet Vermekteyiz


example1

Hastanemizde 03-09 Kasım Organ Bağışı Haftası Nedeniyle Organ Bağışı Standı Açılmıştır

example1

Hastanemize Radyoloji Uzmanı Uzm.Dr. Hasan Araz Görevine Başlamıştır.

 

İletişim
Tel : 0 346 512 1477
Fax : 0 346 512 5100
Mail : yonetim@sarkisladh.gov.tr
Adres : Yıldırım Mah. Ülkü Sk. No: 27 Şarkışla/Sivas Pk.58400