SELECT a.id, COUNT(p.prefix) as prefixes FROM area AS a LEFT JOIN prefix AS p ON a.id = p.area AND p.active = 1 WHERE 1 AND a.id != AND a.`location` IS NULL AND a.`active` = '1' GROUP BY a.id;
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND a.`location` IS NULL AND a.`active` = '1' GROUP BY a.id' at line 1
Enter a phone number starting with
Notice: Undefined index: id in /home/thisnumber/public_html/templates/area.php on line 10
to complete a free reverse phone lookup.
Our database includes 0 area code
Notice: Undefined index: id in /home/thisnumber/public_html/templates/area.php on line 26
prefix with phone numbers:
| Prefix | Company | Rate Center |
|---|
Area code
Notice: Undefined index: id in /home/thisnumber/public_html/templates/area.php on line 59
belongs to
Notice: Undefined index: location_name in /home/thisnumber/public_html/templates/area.php on line 59
,
Notice: Undefined index: country_name in /home/thisnumber/public_html/templates/area.php on line 59
. It is a
Notice: Undefined index: type in /home/thisnumber/public_html/templates/area.php on line 59
which was placed in service on January 1, 1947.
| Type | Notice: Undefined index: type in /home/thisnumber/public_html/templates/area.php on line 64 |
| Use | Notice: Undefined index: use_ in /home/thisnumber/public_html/templates/area.php on line 68 |
| Location | Notice: Undefined index: location_name in /home/thisnumber/public_html/templates/area.php on line 72 ( Notice: Undefined index: location_short in /home/thisnumber/public_html/templates/area.php on line 72 ) |
| Country | Notice: Undefined index: country_name in /home/thisnumber/public_html/templates/area.php on line 76 |
| Service Date | Notice: Undefined index: service_date in /home/thisnumber/public_html/templates/area.php on line 80 31/12/1969 |
| Service | Notice: Undefined index: service in /home/thisnumber/public_html/templates/area.php on line 84 |