SEOClerks

Questions from user Topseoservice

Showing page: 1 of 1

I have some suggestion regarding WTB category. There has to be some quality control in this section also. I have noticed many 'newbie' place their bid in this section. For example the client is requiring something speci...

17 9 years ago

Recently the SEOClerks marketplace has been redesigned and now it looks great. I was thinking if Buy Tweets section of the marketplace can also be redesined, so that buyers can sort tweet according to the number of follo...

4 10 years ago

Today I tried browse the SEOClerks forum and to my surprise I could not find it. So has it been stopped permanently or temporarily? I could not find any official announcement regarding this issue as well.

10 10 years ago

While creating a new service at SEOClerks, I noticed now you can set your own affiliate commission which was earlier fixed at 10%. That means now you can even offer 70% affiliate commission if you want. What is the benef...

7 10 years ago

It is true that using affiliate system of SEOClerks anyone can make decent money. It is also proved that creating affiliate store is the best way to get new affiliate members. However I am not sure what are the best plac...

8 10 years ago

I know some members here who are actively promoting via twitter. However when I search twitter using hashtags related with SeoClerks, I don't see much activities. There can be some reasons behind that - Users are promot...

4 10 years ago

Suppose you have a website which is earning decent money for you every month. The revenue from the website is constant despite you spend very little time in promotion/SEO. You know very well that if you spend some time w...

10 10 years ago

I have noticed if you have decent followers, around 10K or more, you tend to get decent traffic when you tweet. However I am not quite sure if these traffic that you get from twitter is 100% real or not. I have sent traf...

5 10 years ago

Since past few years progress of social media has been really impressive. As a result webmasters are also getting traffic from social media to their website. So which has more percentage when it comes to driving traffic ...

9 11 years ago

I would like to know if you have some kind of website or blog which makes you money. Do you have more alternatives to make money online?

9 11 years ago

As the title suggest, how many followers you have on your SEOClerks profile? I have 39 followers.

4 11 years ago

I just noticed I don't get any promotional services link in emails coming from SEOClerks. Has the email feature option has been stopped by the SEOClerks or its only me who is facing this issue? Can someone throw some lig...

9 11 years ago

There was lot of of buzz about the 21st Google update. This will affect websites which are not mobile device friendly. As a webmasters have you noticed any difference so far?

3 11 years ago

I hope you are doing good with your freelancing career. Most of the freelancers usually have more than one income sources. However would you like to inform your primary income source as freelancer?

9 11 years ago

This question is for the people who work really long hours in front of computers. As there is less physical activities, health is a major issue. How you maintain good health?

15 11 years ago

From tomorrow the knock out stage of world cup is starting. Which team do you think will win this time? My bet is on Germany.

5 12 years ago

In no time I am a level 3 member now on SeoClerks. I have worked in most of the freelance platform earlier, but SeoClerks seems to be the best for me. Not to mention the customer support which is awesome!

13 12 years ago

I have been experimenting with 'Bump' feature ever since I joined here. What I have found is that bumping your service will definitely help you to get sales. Anyway I am trying to figure out the best time to bump my serv...

8 12 years ago

I have this serious problem. There is one buyer who have bought some service from me. He told me that he would buy my service regularly. Anyway the buyer is not at all friendly and I am having problem working with him. H...

9 12 years ago
Order Now
Process Time: 0.11825513839722

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT 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='Topseoservice' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='Topseoservice' 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=8029 LIMIT 11SELECT 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=8029 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=8029 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 401SELECT 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=8029 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' 1SELECT 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' 1SELECT 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 1SELECT 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 categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='8029'1SELECT profilepicture FROM seoclerks.members WHERE USERID='8029'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

select * from categories_faq order by name asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin