Robot | Path | Permission |
GoogleBot | / | ✔ |
BingBot | / | ✔ |
BaiduSpider | / | ✔ |
YandexBot | / | ✔ |
User-agent: * Crawl-delay: |
Title | Smith Talks Tech – Talking about webdev tools, tips and |
Description | Smith Talks Tech Talking about webdev tools, tips and projects Menu About Me Mission Statement Counting Posts per User per Month in WordPress December 1, |
Keywords | N/A |
WebSite | smithtalkstech.com |
Host IP | 198.46.81.152 |
Location | United States |
Site | Rank |
US$1,086,281
Last updated: 2023-05-07 15:21:49
smithtalkstech.com has Semrush global rank of 9,743,622. smithtalkstech.com has an estimated worth of US$ 1,086,281, based on its estimated Ads revenue. smithtalkstech.com receives approximately 125,341 unique visitors each day. Its web server is located in United States, with IP address 198.46.81.152. According to SiteAdvisor, smithtalkstech.com is safe to visit. |
Purchase/Sale Value | US$1,086,281 |
Daily Ads Revenue | US$1,003 |
Monthly Ads Revenue | US$30,082 |
Yearly Ads Revenue | US$360,980 |
Daily Unique Visitors | 8,357 |
Note: All traffic and earnings values are estimates. |
Host | Type | TTL | Data |
smithtalkstech.com. | A | 899 | IP: 198.46.81.152 |
smithtalkstech.com. | NS | 14400 | NS Record: ns1.inmotionhosting.com. |
smithtalkstech.com. | NS | 14400 | NS Record: ns2.inmotionhosting.com. |
smithtalkstech.com. | MX | 900 | MX Record: 0 smithtalkstech.com. |
Smith Talks Tech Talking about webdev tools, tips and projects Menu About Me Mission Statement Counting Posts per User per Month in WordPress December 1, 2022 ~ Pete Smith ~ Leave a comment Had an interesting problem land on my plate today. A corner-office type wanted to know how many posts per month each of our authors had written. Sounds like a round of layoffs are coming, eh? I hadn’t written any SQL in a LONG time but I managed to finally figure it out. Certainly it was faster than trying to add things up by hand (we have 17 brands we need this data for). Figured I’d save the queries in case I ever need them again. I am not saying this is the most efficient way to do this — I’m no DBA — but for a 1 time thing, it worked. SELECT t.year_month, users.user_nicename, users.user_email, count(post_author) FROM ( SELECT DISTINCT(EXTRACT(YEAR_MONTH FROM `post_date`)) as `year_month` FROM wp_posts WHERE post_date > "2021-01-01 00:00:01" ORDER BY `year_month` ASC ) as t, wp_users users, |
HTTP/1.1 406 Not Acceptable Date: Thu, 28 Oct 2021 07:03:59 GMT Server: Apache Content-Type: text/html; charset=iso-8859-1 |
Domain Name: SMITHTALKSTECH.COM Registry Domain ID: 2128010547_DOMAIN_COM-VRSN Registrar WHOIS Server: whois.godaddy.com Registrar URL: http://www.godaddy.com Updated Date: 2020-05-26T16:42:24Z Creation Date: 2017-05-26T01:16:39Z Registry Expiry Date: 2023-05-26T01:16:39Z Registrar: GoDaddy.com, LLC Registrar IANA ID: 146 Registrar Abuse Contact Email: abuse@godaddy.com Registrar Abuse Contact Phone: 480-624-2505 Domain Status: clientDeleteProhibited https://icann.org/epp#clientDeleteProhibited Domain Status: clientRenewProhibited https://icann.org/epp#clientRenewProhibited Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited Domain Status: clientUpdateProhibited https://icann.org/epp#clientUpdateProhibited Name Server: NS1.INMOTIONHOSTING.COM Name Server: NS2.INMOTIONHOSTING.COM DNSSEC: unsigned >>> Last update of whois database: 2021-09-16T00:16:35Z <<< |