how to fetch DNC list ????

[abhasbajpai]

how to fetch dnc list from leads
which agents have desposed as dnc
with clints name address and phone nos and list id for that perticular date
if it could be done through mysql querry
then please tell me the querry which i should put in mysql prompt
help needed
thanks

[mflorell]

Select * from vicidial_list where status='DNC' and modify_date > "2006-05-05 00:00:00" and modify_date < "2006-05-05 23:59:59";

[abhasbajpai]

thanks you very much