mccalljt.io valuation and analysis
Robots.txt Information
| Robot | Path | Permission |
| GoogleBot | / | ✔ |
| BingBot | / | ✔ |
| BaiduSpider | / | ✔ |
| YandexBot | / | ✔ |
Meta Tags
| Title | Jacks |
| Description | MCCALLJT.IO MCCALLJT.IO Jack McCallum’s Personal Site Home Blog Photos Generate a Date Series in MySQL using CTEs Dec 20 2018 Today I needed to run a query in MySQL t |
| Keywords | N/A |
Server Information
| WebSite | |
| Host IP | 104.21.1.2 |
| Location | United States |
Related Websites
| Site | Rank |
More to Explore
mccalljt.io Valuation
|
US$371,464
Last updated: 2022-08-28 16:54:06
mccalljt.io has Semrush global rank of 28,493,510. mccalljt.io has an estimated worth of US$ 371,464, based on its estimated Ads revenue. mccalljt.io receives approximately 42,862 unique visitors each day. Its web server is located in United States, with IP address 104.21.1.2. According to SiteAdvisor, mccalljt.io is safe to visit. |
Traffic & Worth Estimates
| Purchase/Sale Value | US$371,464 |
| Daily Ads Revenue | US$343 |
| Monthly Ads Revenue | US$10,287 |
| Yearly Ads Revenue | US$123,441 |
| Daily Unique Visitors | 2,858 |
| Note: All traffic and earnings values are estimates. | |
DNS Records
| Host | Type | TTL | Data |
| mccalljt.io. | A | 299 | IP: 104.21.1.2 |
| mccalljt.io. | A | 299 | IP: 172.67.151.160 |
| mccalljt.io. | AAAA | 299 | IPV6: 2606:4700:3031::6815:102 |
| mccalljt.io. | AAAA | 299 | IPV6: 2606:4700:3031::ac43:97a0 |
| mccalljt.io. | NS | 86400 | NS Record: albert.ns.cloudflare.com. |
| mccalljt.io. | NS | 86400 | NS Record: jule.ns.cloudflare.com. |
| mccalljt.io. | TXT | 300 | TXT Record: google-site-verification=o9uXQP-4gF4XRf98DAmHffsEXFRU3MfC63RkT_cnSu8 |
HtmlToTextCheckTime:2022-08-28 16:54:06
| MCCALLJT.IO Jack McCallum’s Personal Site Home Blog Photos Generate a Date Series in MySQL using CTEs Dec 20 2018 Today I needed to run a query in MySQL that needed a series of dates that was independent of any table data. Something like this: 2018-12-01 2018-12-02 2018-12-03 2018-12-04 2018-12-05 I’m used to Postgres so I naturally reached for generate_series . Unfortunately MySQL does not seem to have that function so I had to do some Googling and throw something together with Common Table Expressions . I figure someone else might need this type of thing so I’ll share my solution here. SET @start_date = ’2018-12-01’; SET @end_date = ’2018-12-15’; WITH digit AS ( SELECT 0 AS d UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9 ), num_seq AS ( SELECT a.d + (10 * b.d) + (100 * c.d) + (1000 * d.d) AS num FROM digit a CROSS JOIN digit b CROSS JOIN digit c CROSS JOIN |
HTTP Headers
HTTP/1.1 301 Moved Permanently
Date: Tue, 21 Dec 2021 17:16:18 GMT
Connection: keep-alive
Cache-Control: max-age=3600
Expires: Tue, 21 Dec 2021 18:16:18 GMT
Location: https://mccalljt.io/
Report-To: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=dIt3b8WssO8lPKTKKgsSJO%2Fd1VywkvI%2FSZkj39KZsupPPXYYAmIdRvFaGEVG54tuL3jNEyH7Z8JnmqfLNKiwlsZvgsZFTh5wK%2FPOXqHBQT7lp2qAgBMcy62FjMPHFg%3D%3D"}],"group":"cf-nel","max_age":604800}
NEL: {"success_fraction":0,"report_to":"cf-nel","max_age":604800}
Server: cloudflare
CF-RAY: 6c12c1e8e9cfe6dc-EWR
alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400, h3-28=":443"; ma=86400, h3-27=":443"; ma=86400
HTTP/2 200
date: Tue, 21 Dec 2021 17:16:18 GMT
content-type: text/html
x-guploader-uploadid: ADPycdstcT8GGpRAPYqTPt6MaW7UjD8vMbsOCagnlTGWP0a4Hv3dP2lIyWd3O9FHi5a1TH56_c-Ux4-woICuM1cmeuB-U9S58Q
expires: Tue, 21 Dec 2021 17:50:33 GMT
last-modified: Thu, 31 Dec 2020 16:11:22 GMT
x-goog-generation: 1609431082478549
x-goog-metageneration: 1
x-goog-stored-content-encoding: identity
x-goog-stored-content-length: 63040
x-goog-meta-goog-reserved-file-mtime: 1609430799
content-language: en
x-goog-hash: crc32c=wwO6UA==
x-goog-hash: md5=JYgiZfq+BjplYs4PeytNlg==
x-goog-storage-class: MULTI_REGIONAL
accept-ranges: bytes
age: 1545
cache-control: public, max-age=3600
cf-cache-status: DYNAMIC
expect-ct: max-age=604800, report-uri="https://report-uri.cloudflare.com/cdn-cgi/beacon/expect-ct"
report-to: {"endpoints":[{"url":"https:\/\/a.nel.cloudflare.com\/report\/v3?s=f64NOK38c%2FNm3z6YMJCE1fhh2nsfuVzEzcFZ7hNiZrjnwYfLUBweH2X4MoCzMhUG99rCrIRaiMSvdrrMiekefQw%2FWVDp0ERs0FTPB9TFyPRMq0E9N3y5AvxzXf6y8Q%3D%3D"}],"group":"cf-nel","max_age":604800}
nel: {"success_fraction":0,"report_to":"cf-nel","max_age":604800}
server: cloudflare
cf-ray: 6c12c1e94ed41875-EWR
alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400, h3-28=":443"; ma=86400, h3-27=":443"; ma=86400
|
mccalljt.io Whois Information
Domain Name: mccalljt.io Registry Domain ID: bb88c863c79141cc8ba5a410aa28502c-DONUTS Registrar WHOIS Server: whois.1api.net Registrar URL: http://www.1api.net Updated Date: 2021-11-19T11:44:04Z Creation Date: 2016-07-15T14:47:08Z Registry Expiry Date: 2022-07-15T14:47:08Z Registrar: 1API GmbH Registrar IANA ID: 1387 Registrar Abuse Contact Email: abuse@1api.net Registrar Abuse Contact Phone: +49.68949396850 Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited Registrant Organization: Daily Ask Registrant State/Province: Illinois Registrant Country: US Name Server: albert.ns.cloudflare.com Name Server: jule.ns.cloudflare.com DNSSEC: unsigned >>> Last update of WHOIS database: 2021-12-25T08:16:25Z <<< |