| Match | Count | SQL | Script |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='4337' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='4337'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='9' | 1 | SELECT * FROM seoclerks.members WHERE USERID='9'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM categories_faq WHERE CATID='36' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='36'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
|
| SELECT * FROM categories_faq WHERE CATID='30' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='30'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
|
| SELECT * FROM seoclerks.members WHERE USERID=9 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=9
| /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()
|
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=4337 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=4337
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='4337' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='4337' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc
| /opt/clerks-staging/docroot/viewfaq.php 1245 () ()
|
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=20139 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=20139
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='4337' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='4337'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='4337' AND status='1' AND (question like '% "Google Slump"?%' OR question like '%"Google%' OR question like '%Slump"?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='4337' AND status='1'
AND (question like '% "Google Slump"?%' OR question like '%"Google%' OR question like '%Slump"?%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=4337%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=4337%'
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='16706.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='16706.jpg'
| /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()
|
bormanbg
Of course, the world of SEO hasn’t quite caught on yet, but it’s getting very close. Even so, there are still some sites who have gotten penalized by Google recently. And let me tell you, this is one of the worst things that can happen to an online business – especially if your business relies on Google (which it shouldn’t!).
A penalty literally means a loss of targeted traffic overnight. If you were generating $100/day on a page ranking well on Google, you could be penalized and earn $0/day on that page… THE VERY NEXT DAY.
So obviously, we’d like to avoid that from happening. However, in some cases, it’s inevitable. And in this case, the question is, how do you get out of a Google penalty slump and get your rankings back?
In today’s article, we’re aiming to answer that question.
Start With HIGH-QUALITY Content
This is the first place to start. What is your content strategy like? How is the content on your website? Does it provide value to the people who read it? Does it give your visitors exactly what they’re looking for if they land on your page through Google?
Additionally, how often do you publish new content? How long are your articles? How consistent are you?
All these factors play a big role in how Google will rank your website. In general, the best content is:
Unique
Published regularly (at least once a week)
LONG (1k+ articles rank better, increase conversions, etc)
Insightful
Entertaining
It’s a tall order for sure. But then again, why should Google put your website above other pages if your content doesn’t do anything just discussed? The more high-quality, consistent, long and insightful content you can publish, the better you’ll do in Google.
And that’s just looking at things from a content-only angle. Through writing this content, you’ll get heaps of natural backlinks and social shares, which all add up to your rankings as well!
Look for “Bad Links”
If you’ve done any SEO within the past 3-4 years, you’ve probably built some poor-quality links at some point. Now, these links may be coming back to bite you, and cause penalties in Google.
Although getting rid of bad links is tricky, it’s absolutely essential if you want to recover from a Google penalty.
If you built links yourself—through a forum, for example—go through and manually remove these links. Manually remove any spam link you can. If you have spam links on other websites, email the webmasters and ask them to remove your links.
Lastly, if all else fails, use the “disavow links” tool in Google Webmasters. This isn’t as good as getting a link completely removed, but is a huge leg up from having the link pointing at your site.
Do Solid “New SEO” From Now On
new seo is key to ranking and recovering from penalties
Lastly, once you’ve created a new content strategy and removed poor-quality links, your best bet is to do clean, “New SEO” from now on. This means you should be focusing on content and, should you decide to build links, build only “natural” links. That is, links with non-optimized anchor text (such as ‘click here’ and ‘learn more’, as well as your site url ‘siteexample.com’).
Also, look to build SUPER high-quality links through guest posting. With guest posting, you can target top-quality blogs and deliver value to them through unique, valuable content. Then, they’ll link back to your site, giving you a great boost in the rankings.
All this New SEO has an additional benefit. That is, the more good SEO you do, the more it overwrites any poor SEO you may have done in the past. If you continually publish top-quality content that attracts natural links and social shares, and you remove as many bad links as you can, over time, your SEO rankings will improve. Old SEO tactics no longer work. New SEO is the only way to go. Of course, the world of SEO hasn’t quite caught on yet, but it’s getting very close. Even so, there are still some sites who have gotten penalized by Google recently. And let me tell you, this is one of the worst things that can happen to an online business – especially if your business relies on Google (which it shouldn’t!). A penalty literally means a loss of targeted traffic overnight. If you were generating $100/day on a page ranking well on Google, you could be penalized and earn $0/day on that page… THE VERY NEXT DAY. So obviously, we’d like to avoid that from happening. However, in some cases, it’s inevitable. And in this case, the question is, how do you get out of a Google penalty slump and get your rankings back? In today’s article, we’re aiming to answer that question. Start With HIGH-QUALITY Content This is the first place to start. What is your content strategy like? How is the content on your website? Does it provide value to the people who read it? Does it give your visitors exactly what they’re looking for if they land on your page through Google? Additionally, how often do you publish new content? How long are your articles? How consistent are you? All these factors play a big role in how Google will rank your website. In general, the best content is: Unique Published regularly (at least once a week) LONG (1k+ articles rank better, increase conversions, etc) Insightful Entertaining It’s a tall order for sure. But then again, why should Google put your website above other pages if your content doesn’t do anything just discussed? The more high-quality, consistent, long and insightful content you can publish, the better you’ll do in Google. And that’s just looking at things from a content-only angle. Through writing this content, you’ll get heaps of natural backlinks and social shares, which all add up to your rankings as well! Look for “Bad Links” If you’ve done any SEO within the past 3-4 years, you’ve probably built some poor-quality links at some point. Now, these links may be coming back to bite you, and cause penalties in Google. Although getting rid of bad links is tricky, it’s absolutely essential if you want to recover from a Google penalty. If you built links yourself—through a forum, for example—go through and manually remove these links. Manually remove any spam link you can. If you have spam links on other websites, email the webmasters and ask them to remove your links. Lastly, if all else fails, use the “disavow links” tool in Google Webmasters. This isn’t as good as getting a link completely removed, but is a huge leg up from having the link pointing at your site. Do Solid “New SEO” From Now On new seo is key to ranking and recovering from penalties Lastly, once you’ve created a new content strategy and removed poor-quality links, your best bet is to do clean, “New SEO” from now on. This means you should be focusing on content and, should you decide to build links, build only “natural” links. That is, links with non-optimized anchor text (such as ‘click here’ and ‘learn more’, as well as your site url ‘siteexample.com’). Also, look to build SUPER high-quality links through guest posting. With guest posting, you can target top-quality blogs and deliver value to them through unique, valuable content. Then, they’ll link back to your site, giving you a great boost in the rankings. All this New SEO has an additional benefit. That is, the more good SEO you do, the more it overwrites any poor SEO you may have done in the past. If you continually publish top-quality content that attracts natural links and social shares, and you remove as many bad links as you can, over time, your SEO rankings will improve.
Are you sure you want to delete this post?