select gallery.*, attacheFiles.filename as listfilename, attacheFiles.filename_org as listfilename_org,(select name from hospital where hospital.no = gallery.hospital_fk) as hospital_name,(select count(*) from comment where comment.parent_fk = gallery.no and comment.tablename = 'gallery') as comment_count,(select name from clinic where clinic.no = gallery.clinic_fk) as clinic_name from gallery left outer join attacheFiles on gallery.no = attacheFiles.common_fk and attacheFiles.tablename = 'gallery'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분

    ※일요일 및 공휴일 휴진

    간편상담신청

    치료과목

    이름

    전화번호

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