SELECT *, r.name as last_record_name, SUM(n.comments) as total_comments, SUM(n.records) as total_records, SUM(n.reports) as total_reports FROM numbers AS n LEFT JOIN records AS r ON r.id = n.last_record_id WHERE 1 AND n.`area` = '972' AND n.`prefix` = '862' AND (n.comments > 0 OR n.records > 0) GROUP BY n.area, n.prefix, n.block;
MySQL server has gone away
SELECT *, r.name as last_record_name, SUM(n.comments) as total_comments, SUM(n.records) as total_records, SUM(n.reports) as total_reports FROM numbers AS n LEFT JOIN records AS r ON r.id = n.last_record_id WHERE 1 AND n.`area` = '972' AND n.`prefix` = '862' AND (n.comments > 0 OR n.records > 0) GROUP BY n.area, n.prefix, n.range;
MySQL server has gone away
SELECT p.* FROM prefix AS p WHERE 1 AND p.prefix != 862 AND p.`company` = '3262' AND p.`rate_center` = '287' AND p.`active` = '1' AND p.`area` = '972';
MySQL server has gone away
Enter the last 4 digits to start the phone owner's name and address search:
Federal Data
State Data
County Data
City Data
Phone numbers, along with owner names and location information, found in U.S. open datasets:
Prefix 972-862 is operated by FRONTIER SOUTHWEST INC DBA FRONTIER COMM OF TEXAS. Its rate center is CARROLLTON.
| Company | FRONTIER SOUTHWEST INC DBA FRONTIER COMM OF TEXAS |
| Rate Center | CARROLLTON |