3 ms·
I chose not to list any page without at least 1 reported phonecall or comment. Competitors instead listed empty pages, and that is why they beat whocalled.us to
by whocalledus 12y ago
I chose not to list any page without at least 1 reported phonecall or comment. Competitors instead listed empty pages, and that is why they beat whocalled.us to the top results in Google, and gained much more traffic.
I thought it was spammy to list empty pages, and could not bring myself to do it. But the sites that do that are still indexed, and whocalled.us is not.
mysql whocalled -e 'select count(*) as empty
from sitemap s
left join comment c using(phonenumber)
left join phonecall p using(phonenumber)
where c.id is null and p.id is null'
+-------+
| empty |
+-------+
| 0 |
+-------+