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` = '369' 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 != 369 AND p.`company` = '146' AND p.`rate_center` = '10498' 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-369 is operated by SOUTHWESTERN BELL. Its rate center is MCKINNEY.
Company | SOUTHWESTERN BELL |
Rate Center | MCKINNEY |