SELECT appel.debut AS date_debut_appel, appelant.numero AS numero_appelant, appele.numero AS numero_appele
FROM appel, ligne appelant, ligne appele
WHERE appel.id_ligne_appelant = appelant.id AND appel.id_ligne_appele = appele.id AND appel.debut BETWEEN '2015-03-06 00:00:00' AND '2015-03-06 23:59:59'
ORDER BY appel.debut ;
