Discussions about Gig Seoclerks

How can I improve my service description? Answered

How to improve my gig description? Please help me, so I can make more sales.

rock22star Level 1

9 9 years ago

What is the meaning of service or services ??? Answered

I am not able to find the actual meaning of Gig or Gigs in seoclerk.com ??? please reply. try to find it but couldn't do. My second question is: what is the best way to withdraw money from SEOClerks account? Bank transfe...

svsorg Level 1

2 12 years ago

What are the best ways to get traffic to a Seoclerks Gig? Answered

What are the best ways to get traffic to a Seoclerks Gig?

Topviews Level 1

7 13 years ago

what will be the cost for get my service featured? Answered

please any one tell me what will be the cost for get my gig featured?? i want to improve my sales..

speedworker Level 1

1 13 years ago

How do I know when people order my services on here? Answered

am i notified or do i have to check my messages/account

abetti17 Level 3

6 13 years ago

i got about $45 but received only $36? why? Answered

I got about $45 from a gig but received only $36? why?

seoguy Level 1

15 14 years ago

Order Now

Process Time: 0.14737892150879

Possible Duplicate queries found!

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time	Count	SQL	Max	Min
0.294101	1	SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.bdays desc LIMIT 0,40	0.294101	0.294101
0.194795	1	SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID	0.194795	0.194795

Match	Count	SQL	Script
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.tags LIKE '% Gig Seoclerks %' OR A.tags LIKE 'Gig Seoclerks %' OR A.tags LIKE '% Gig Seoclerks' OR A.tags='Gig Seoclerks') 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.tags LIKE '% Gig Seoclerks %' OR A.tags LIKE 'Gig Seoclerks %' OR A.tags LIKE '% Gig Seoclerks' OR A.tags='Gig Seoclerks') 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.tags LIKE '% Gig Seoclerks %' OR A.tags LIKE 'Gig Seoclerks %' OR A.tags LIKE '% Gig Seoclerks' OR A.tags='Gig Seoclerks') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 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.tags LIKE '% Gig Seoclerks %' OR A.tags LIKE 'Gig Seoclerks %' OR A.tags LIKE '% Gig Seoclerks' OR A.tags='Gig Seoclerks') 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'	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='124329'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='124329'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='149263'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='149263'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='17297'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17297'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='29425'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='29425'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='39184'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='39184'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='318'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='318'	/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()