All pastes #482111 Raw Edit

Miscellany

public sql v1 · immutable
·published 2007-05-11 04:13 UTC
rendered paste body
select count(*) 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 asterisk_tf_map.toll_free='NUMBER BEING CALLED';