SEOClerks

Questions from user dynamicjoseph

Showing page: 1 of 1

Hi Admin, Can free Boost time frame be reduced from 12hrs to maybe 3 hours to enable members boost their service more. Also, can the amount of boost be increased from 6 to 20 or to cover for all available services ...

4 5 years ago

Hi Admin, i have been a member of SEOCLERK for some years now and I observed that each time I am away on holiday for some weeks my level on SEOclerk suddenly drops to level one. This has happened about 3 times now, ...

5 5 years ago

Hi, I created a custom order to show my customer what he should do, but he ended up accepting the custom order and making me having a request to pay him for the service which I am supposed to do for him. I have tried ...

2 6 years ago

I want to use this medium to wish everyone on seoclerk the best of this season. Season Greetings, wish you all more success stories in year 2020 and beyond. Happy boxing day and New year in advance. Check out my services...

1 6 years ago

Recently, I made some payment for paid bumps and yes, i started bumping my services, but I realized that the paid bumps were not really increasing my views to my service. I had the views to a particular service at 68 vie...

2 6 years ago

SEOclerk Community is a unique university on its own. You have a whole lot to learn for free and grow yourself step by step all the way to the top in your freelancing career. I don't think there is anywhere else you can ...

12 7 years ago

So far so good, SEOCLERK is still the best place for a freelancer to work and collaborate and the admin support is awesome. I just thought of sharing this to help someone understand better. If you are new here, please...

2 7 years ago

My names are Jospeh.O.Bankole and I am proud to be a SEOCLERKER and I have worked for many clients here on SEOCLERK. To start with, nobody introduced me to SEOCLERK, I just stumbled on it myself through google search. ...

8 7 years ago

Hi Admin, Please how can I delete a job I once created. I have been looking for delete button to delete the job but I can't find a way through it. Please help.

2 7 years ago

My name is Joseph Bankole and I want to quickly share my success story here on SEO CLERK. Many years back, precisely August 2014, I stumbled on SEO CLERK and I registered. I have no clue what SEO CLERK was meant for, so,...

7 7 years ago

I want to withdraw my earnings via papal and I got a message that i should verify my papal via email. How do i do that please?

1 11 years ago
Order Now
Process Time: 0.11298108100891

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM seoclerks.members WHERE username='dynamicjoseph' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='dynamicjoseph' 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=221341 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=221341 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=221341 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=221341 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='221341'1SELECT profilepicture FROM seoclerks.members WHERE USERID='221341'

/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
0.3931811SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (36) AND gtags like'%forumposts%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.3931810.393181
0.1077371SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Fanpge%') ORDER BY total_recommendations desc LIMIT 0,400.1077370.107737