select h.* , (select group_concat(s2.adi_az SEPARATOR ' , ') from hekim_sube_ata s1 inner join sube s2 on (s1.sube_id=s2.sube_id) where s1.hekim_id=a.hekim_id) as hekim_sube_adi, (select group_concat(s2.adi_az SEPARATOR ' , ') from hekim_gun_ata s1 inner join gun s2 on (s1.gun_id=s2.gun_id) where s1.hekim_id=a.hekim_id) as hekim_gun_adi, (select filename from dosya where hekim_id=h.hekim_id and ana_dosya='1' limit 1) as resim from hekim_bolum_ata a inner join hekim h on (a.hekim_id=h.hekim_id and h.aktif='1' and h.durum='1') where a.bolum_id='45' and h.hekim_id in (select hekim_id from hekim_sube_ata where sube_id='1') order by a.sirano asc
Tarih : 2021-09-27 12:04:18 Script Name : www.bmp.az/az/clinic/45-bariatrik-va-metabolik-carrahiyya/1 MySQL Error : Can't create/write to file '/tmp/#sql_24c_1.MAI' (Errcode: 28 "No space left on device") MySQL Error No : 1select h.* , (select group_concat(s2.adi_az SEPARATOR ' , ') from hekim_sube_ata s1 inner join sube s2 on (s1.sube_id=s2.sube_id) where s1.hekim_id=a.hekim_id) as hekim_sube_adi, (select group_concat(s2.adi_az SEPARATOR ' , ') from hekim_gun_ata s1 inner join gun s2 on (s1.gun_id=s2.gun_id) where s1.hekim_id=a.hekim_id) as hekim_gun_adi, (select filename from dosya where hekim_id=h.hekim_id and ana_dosya='1' limit 1) as resim from hekim_bolum_ata a inner join hekim h on (a.hekim_id=h.hekim_id and h.aktif='1' and h.durum='1') where a.bolum_id='45' and h.hekim_id in (select hekim_id from hekim_sube_ata where sube_id='1') order by a.sirano asc
Tarih : 2021-09-27 12:04:18 Script Name : www.bmp.az/az/clinic/45-bariatrik-va-metabolik-carrahiyya/1 MySQL Error : Can't create/write to file '/tmp/#sql_24c_1.MAI' (Errcode: 28 "No space left on device") MySQL Error No : 1