select news.*, attacheFiles.filename as listfilename, attacheFiles.filename_org as listfilename_org,(select name from hospital where hospital.no = news.hospital_fk) as hospital_name,(select count(*) from comment where comment.parent_fk = news.no and comment.tablename = 'news') as comment_count,(select name from clinic where clinic.no = news.clinic_fk) as clinic_name from news left outer join attacheFiles on news.no = attacheFiles.common_fk and attacheFiles.tablename = 'news'and attacheFiles.fileobject = 'imagename' WHERE 1=1 group by no ORDER BY top desc ,registdate desc LIMIT 0, 10 안산21세기병원
21세기뉴스

    ANSAN 21 CENTURY HOSPITAL

    병원소식

    진료안내

    전화번호 1577-6660

    평일 _오전 9시 ~ 오후 5시 30분

    토요일 _오전 9시 ~ 오후 12시 30분

    ※일요일 및 공휴일 휴진

    간편상담신청

    치료과목

    이름

    전화번호

    - -
    상담
    신청
    간편상담신청