3 - Error writing file 'C:\WINDOWS\TEMP\MY4E74.tmp' (Errcode: 28)

SELECT t_persos.persos_id,i_familles.familles_id,i_familles.familles_publiee,( if ( (select events_date from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '1') where l_persos_events.persos_id = t_persos.persos_id) is not null, if ( (select events_date from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '1') where l_persos_events.persos_id = t_persos.persos_id) = '', '?', if ( (select events_aaaa from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '1') where l_persos_events.persos_id = t_persos.persos_id) <>'' and (select events_mm from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '1') where l_persos_events.persos_id = t_persos.persos_id) ='', CONCAT('v. ', (select events_aaaa from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '1') where l_persos_events.persos_id = t_persos.persos_id) ), DATE_FORMAT((select events_date from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '1') where l_persos_events.persos_id = t_persos.persos_id) , '%d/%m/%Y') ) ) , '?')) AS naissance,( if ( (select events_date from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '2') where l_persos_events.persos_id = t_persos.persos_id) is not null, if ( (select events_date from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '2') where l_persos_events.persos_id = t_persos.persos_id) = '', '?', if ( (select events_aaaa from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '2') where l_persos_events.persos_id = t_persos.persos_id) <>'' and (select events_mm from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '2') where l_persos_events.persos_id = t_persos.persos_id) ='', CONCAT('v. ', (select events_aaaa from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '2') where l_persos_events.persos_id = t_persos.persos_id) ), DATE_FORMAT((select events_date from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '2') where l_persos_events.persos_id = t_persos.persos_id) , '%d/%m/%Y') ) ) , '?')) AS mort,concat(t_persos.persos_prenom,' ', t_persos.persos_nom, if ((persos_surnom)<>'', concat(' - ', t_persos.persos_surnom, ''), '')) AS nom,i_familles.familles_libelle FROM t_persos LEFT JOIN l_persos_familles pf ON t_persos.persos_id = pf.persos_id LEFT JOIN i_familles ON pf.familles_id = i_familles.familles_id WHERE t_persos.persos_publie='1' ORDER BY (select events_aaaa from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '1') where l_persos_events.persos_id = t_persos.persos_id) ASC, (select events_aaaa from t_events left join l_persos_events on (t_events.events_id = l_persos_events.events_id and t_events.events_types_events_id = '2') where l_persos_events.persos_id = t_persos.persos_id) ASC limit 0, 30

[TEP STOP]