Untitled

select top 50 asterisk_tf_map.*,isp_active_track.date  from asterisk_tf_map inner join dialup_info on asterisk_tf_map.user_id = dialup_info.user_id inner join isp_active_track on dialup_info.email = isp_active_track.email inner join asterisk_tf_routing_latest_status on asterisk_tf_map.tf_id = asterisk_tf_routing_latest_status.tf_id where dialup_info.active=-3 and asterisk_tf_routing_latest_status.num_type = 2 and asterisk_tf_routing_latest_status.status_id = 1 and isp_active_track.date !> '2007-02-10' and dialup_info.domain like 'tollfreemax.com' order by isp_active_track.date;