2018 brought new challenges that surely taught us a lot of things. What are some of the most important lessons you've learned about freelancing this year, either through firsthand experience or as an advice? Share away!
About six months ago Google increased the meta description length to most websites. From an average of 130-150 to an average of 280 with some meta description even going past 300 characters. At first, I thought to m...
Google recently announced that website speed would be an official ranking factor for mobile searches starting in July 2018 when a Speed Update will take place. This is probably the biggest news coming from Google this ye...
The online arena is always evolving and changing. As far as SEO goes, I always try to keep up with everything that's developing. I keep myself informed by reading popular SEO specialists I trust, I'm being careful to wha...
Giving the fact that brand new year just started a few days ago, I want to start a personal challenge in 2018, and I'm gladly advising you to set similar goals. My goal is to write one big article per week on my pers...
Over the years I always had a moment when I had doubts about the industry I'm currently activating, Search Engine Optimization. It changed so much over the years it is barely responsible compared with the SEO I was doing...
Few weeks left before saying goodbye to 2017. We had different experiences, with highs and lows, success and failures, death for some while others welcomed a new baby in the family, a number of lucky ones won the lottery...
SEO is constantly changing and although some ranking remains more or less unchanged over the years (like the need for quality backlinks) other constantly change and evolve and what was a positive SEO implementation today...
In that last 20 years, we have seen a total change in the marketing world as far as trends go, constantly changing and evolving. Predicting those trends and getting prepared for them can make all the difference between a...
| Match | Count | SQL | Script |
| SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% 2018 %' OR A.tags LIKE '2018 %' OR A.tags LIKE '% 2018' OR A.tags='2018') LIMIT 1 | 1 | SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C
where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% 2018 %' OR A.tags LIKE '2018 %' OR A.tags LIKE '% 2018' OR A.tags='2018') LIMIT 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% 2018 %' OR A.tags LIKE '2018 %' OR A.tags LIKE '% 2018' OR A.tags='2018') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40 | 1 | SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C
where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% 2018 %' OR A.tags LIKE '2018 %' OR A.tags LIKE '% 2018' OR A.tags='2018')
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * from questions as A where A.status='1' | 1 | SELECT count(A.quesid) as total from questions as A
where A.status='1' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM answers as A where A.status='1' | 1 | SELECT count(A.ansid) as total
FROM answers as A where A.status='1' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE (script='/opt/clerks-staging/docroot/faq.php'
OR script='/opt/clerks-staging/docroot/viewfaq.php')
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='741460' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='741460' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='134' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='134' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='632507' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632507' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
