Hello! There's tons of questions regarding the "bump your service" feature and if you actually benefit from this feature. I'm here to shed some light on this topic. If you are serious about using your bumps you should p...
Hello, Have I missed something or is it impossible to create new threads in that section? Whenever I try to create or preview the thread, it just loads for about 1 second and nothing happens. Cheers, hitmeasap
Hello SEOClerks users! 21 September... 30 Years old.. Wish me luck and let's celebrate a bit together! First of all, I've launched a new service. I know this is the wrong topic to advertise this, but I'll do it anyway ...
Hello, I'm sorry if this is mentioned already. I couldn't find anything similar too this topic. Here goes: I've been looking for ways to contact my affiliates. The people who signed up using my affiliate id. I can't say...
Hello everyone, I thought I'd share something quite "fun" with you today. It's no surprise that I'm a HUGE FAN of SEOClerks. I always speak well about SEOClerks in any topic I can find. Especially the ones where people a...
So.. Here goes.. I started out as a Reseller. (I bought services and sold them to my personal clients.) I actually didn't do anything at all besides signing up the first time I stumbled upon SEOClerks.. I signed up and ...
Clerks Nation, I've recently made up my mind. I'm about to start gaining more affiliates, however, before I do that (or during the time I do it) I want the affiliates I have today, to become more active. Some of them a...
I received a negative feedback.. The reason was "very slow". I understand that there's always a risk of getting negative feedbacks but the delivery time is set to 24 hours and I delivered the service in about 1 hour. (~...
Clerks Nation, I need some tips, ideas and thoughts.. I'd be happy to hear from any of you! This is the case. (I won't go into any exact details) Note: This is my whole business I'm talking about and NOT only SEOClerks ...
SEOClerks Nation, Thank you! 200 positive ratings passed and I celebrate this by giving you all a 10% discount! The coupon code is: Celebrate200 and you can use this on any of the services below: Note that this...
I don't know if someone already mentioned this or not. I just thought of this myself, so I just had to make a thread about it. Would it be possible to minimize the clearing time on affiliate sales? Perhaps clearing time...
My affiliates just reached $5,000. Since we get 10% from that, I've just got $500 in total. Thank you! Please do understand that I don't try to brag or anything. I'm well aware of several SEOClerks users who's got 2 ...
I don't know if anyone else is interested in this or not, but I'm one of the users who's trying to bump my services as often as I can. I try to do this regularly around the same time every 24 hours but it usually ends up...
I've been reading some cool ideas from people and I stumbled on something that sounded cool. So, instead of letting it hang on page 3 among several posts, I thought I should share it here instead. (can't say it's exactly...
Hey, I recently launched a couple of services. Deliver 500 Facebook Photo or Post Likes for $1. Deliver 5,000 Instagram Likes or Followers for $3. I'm looking for 10 people in total, who's willing to accept my gift. Th...
I won't go into any specific details but I've been working online for quite a while.. I usually/mainly sell things through contacts & email conversations since it benefits me more than anything else around.. A couple...
Hey, Recently (just a couple of minutes ago actually) I got my first comment on one of my services which was totally outrageous. (Negative & stupid to be honest.) The comment was: "FAKE FAKE FAKE FAKE DONT ORDER!!!...
Note: English isn't my native language.. When I first joined SEOClerks I got amazed.. Jordan gave us (the users) totally mind-blowing features. And still does.. The main reason I first signed up, was because of the un...
I've seen several people who's still a level 1 seller, even though they've sold more than 200 services.. Is there anyone who can provide me with an accurate answer on Why?
If you have a service where you allow Multiple Quantity Orders, would that count as only 1 sale or not? Let's say you have a service which someone orders 5 times. That will count as 5 sales, but if you have a service ...
Hey everyone, I thought that I should share some stuff here.. Yeah, I know.. I'm a level 1 seller and have 2 sales (at this time) so why should you even bother to read this?? Here's why: First of all, increased sales ...
Hey, I'm just wondering if anyone knows how to delete/remove backlinks? Let's say that I've put together a list with backlinks I want to remove/delete.. How should I proceed to make them go away swiftly? Regards, h...
I don't mean to pointing fingers in anyway, and that's why I've hidden both the sellers names and the services. The delivery dates are copy+pasted, since I wanted to share these dates. The only reason I created this thre...
Hey, I don't sell any services myself yet, my affiliates purchase services from which I generate a small income. When I look at "my balance" this shows: "Since you joined you made $XX.XX" but as soon as one service has ...
Hey everyone! I think I'm kind of new... or not, don't know and it doesn't matter.. The title says, "Second thoughts... or not.." and I thought that I'd share my personal experience in one specific matter. I've purc...
| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='hitmeasap' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='hitmeasap' 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=6160 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=6160 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=6160 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 320, 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=6160
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 320, 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='6160' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6160' | /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 |
