I just got done talking to my friend about using iframes on his site and when too many is too many and how you should correctly use them. He had some questions about using iframes on his site which I tried to answer in s...
When I first begun doing Internet Marketing and SEO, I thought I know what it was all about and how it worked. I knew that SEO stood for Search Engine Optimization and that meant optimizing your site for the Search Engin...
If you're a freelancer and can do a service of some kind and want to find some work, the SEOClerks WTB and WTT section is where you can find people who want to hire you! But how to know who's hiring? This is where ...
Blog commenting (as a method to get traffic and increase rank to your site) is often overlooked or ignored by many webmasters who've heard horror stories about people who have received some penalty or perhaps they think ...
Everyone makes mistakes at some point when doing affiliate marketing. However mistakes aren't always a bad thing because you can learn from them and turn them into a positive. Many very successful affiliate marketers had...
Facebook Group Marketing Tips & Tricks Note: This will be a 3 part guide with this faq being the first part. Hello dear entrepreneur and business minded individual. My names Mike and I've been providing SMO and...
I know its a wide open question and there are many ways to earn money with affiliate marketing. Some ways are better than others, some pay more than others, some are easier than others. But in your experience, what's the...
If you could only use one way to promote some affiliate offer, either SEO, PPC or Social Media, which one would you choose and why? Obviously each have their own benefits, advantages, disadvantages, pros and cons. For...
Most successful affiliate marketers got into the affiliate game in some way or another. Some people accidently stumble into it from something else. Some people literally search in Google for "affiliate marketing" and the...
I know what you're thinking, but Mike, you're not a complete newbie to affiliate marketing. You've been doing it for the past 15 years. Surely you don't need to ask questions like that about affiliate marketing because y...
EPN (eBay Partner Network) is the affiliate system for eBay. Much like Amazon have an affiliate you can join, eBay have their own as well. I used to make some good money with them back in the day but have not used them i...
Schema Markup is one of the latest and most powerful evolutions in SEO right now. It's a very new optimization method that is also one of the least used methods, mainly because many people still don't know what it is, an...
Virtually every online or offline business has a social profile of some sort on one of the top social media sites. And no matter your type of business, there is a place on social media that is perfect for your business. ...
Some people say that when building Web 2.0's you shouldn't use the same IP for creating all of them because that is a footprint and can lead to the search engines penalizing that Web 2.0 or something. But as far as I hav...
What daily/weekly/monthly or even annual SEO activities are there that you do? Like what do you find yourself doing everyday or what things do you do only every once in a while. Obviously you can't do some thing every...
If you're a newbie webmaster who wants to get better Google rankings and more traffic to your site, it can seem a bit of a daunting task knowing what to do and how to do it properly. So here are 10+ link building methods...
There was some discussion about this in the group chat the other day and I was reading something about it on here earlier as well in another faq, plus it's something that's coming up more and more now as people are disco...
WeHeartIt!? In case you don't know about it already (and that would be rare if you've been doing SEO and IM for a while) but WeHeartIt is (and could be for you) an excellent site to do marketing and promotion on and for ...
Bounce with it! Your websites bounce rate is an obvious indicator of how interesting and appealing your website and its content is to its visitors. The higher your bounce rate, the less people are finding your site or it...
Hello there dear entrepreneur, webmaster and newbie SEO or Internet Marketer. Having a great idea is one thing, but taking that idea and making it go from zero to hero is another. In these tough times it can be hard goin...
What's a Good Talk to Text Software App for Windows for Writers? Hi all. Do you ever wish writing (tapping away on your keyboard) could be done much faster? I'm a fairly fast typer and can knock out 100 words in about...
Marketing or promoting or advertising with articles has been used by webmasters to get more traffic and better search engine rankings for their websites for as long as the Internet as been around pretty much. But it's no...
We all know how effective social media sites can be for getting the word "out there" about your new product, service or website. For drumming up visitors, clients and sales. For building brand awareness and building up y...
If you want to make money on SEOClerks, (and anyone can) that's one thing, but if you want to withdraw that money and cash out, that's another. To withdraw your earned money you will need to have an account on one of the...
If you've purchased and ordered a service here on SEOClerks and are pleased with the sellers work well then firstly, congrats! But you may want to leave them a positive recommendation for their work they've done for you ...
The security of your account is of the utmost importance to SEOClerks and yourself. For that reason, SEOClerks provide various methods in which to improve and tighten up the security of your account. This can prevent una...
In these tough times people would like to make good money from the comfort of their own home without having to work outside in the cold everyday! And is it possible to do that? Yes it is absolutely possible if you have s...
Would you like to get many thousands of thousands of referrals under your affiliate member account in SEOClerks, ListingDock or CodeClerks? Of course there are many ways to do that and promote your affiliate/referral lin...
How to Make Money With SEOClerks Up To $1000 Per Month or More! Do you know what SEOClerks is? SEOClerks started about 5+ years ago, right about around the time when Microgig sites started kicking off. These days of c...
Let’s face it and talk straight, every website needs SEO to survive let alone be successful! Whether its on-page SEO or off-page SEO. 9/10 its authority sites that rank high that got where they are through pure SEO don...
I know! The title is very confusing isn't it! But it's all about a new website that is proving to be very helpful for affiliate marketers and SEO's today. IFTTT.com (IF This Then That) is a site you can use to set up ...
If anyone does any kind of SEO / Internet Marketing / Social Media Marketing (SMM) online today then they would have probably come across a site called Flipboard (flipboard.com). According to Wiki Flipboard is a social-n...
When it comes to SEO, it's just a matter of building the right type and right amount of backlinks to your site in order to improve that sites ranking in the SERP's. Obviously it's not quite as simple and straight forward...
Recently, SEOClerks have updated their Responsible Listing Guidelines which sets guidelines for the types of things you can list and sell on SEOClerks. Some of these guidelines say that you cannot "include third party tr...
This category is completely empty! Which is surprising because as an SEO or a Webmaster, there's no escaping code! We all come across it at some point and are either forced to delegate the task to someone experienced or ...
SEO ain't what it used to be! Back 5+ years ago you could build a few links here, a few there and get listed on the first page quite easily. Those days are over now and that doesn't happen quite as easy in 2016 as it did...
It's funny but some people still don't know what "web 2.0 sites" are. Or what even makes a site a Web 2.0 site a Web 2.0 site in the first place. Let alone how they can help improve SERP ranking. Wikipedia says that; ...
Over the years, SEO has changed and evolved. What used to work last year, might not work this year or the next. What mattered last year, might not matter anymore. So as SEO is a constantly shifting thing, from one thi...
Hello all I am looking for an SEOClerks affiliate script, theme or plugin for my site. I am looking at some but it seems they have not sold any in about 3 years. Is it still worth doing an SEOClerks affiliate type site...
I see that some recent changes/updates are done to SEOClerks UI which has made it look nicer, but I also see that some categories have been removed as well such as the Lists category https://www.seoclerk.com/categories/...
| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.112' | 1 | SELECT count(id) as total FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.112' | /opt/clerks-staging/docroot/include/functions/includes/security.php 1090 IsIPBannedBot() include_once() |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| SELECT * FROM seoclerks.members WHERE username='idealmike' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='idealmike' AND status='1' | /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() () |
| 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.userid=272 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.userid=272 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.userid=272 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 440, 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.userid=272
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 440, 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='272' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272' | /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 |
| Avg Time | Count | SQL | Max | Min |
| 0.076915 | 1 | SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Elctronic_music%') | 0.076915 | 0.076915 |
