SEOClerks

Answers from user experttr Page 2

Showing page: 2 of 2

I just saw a member of SEOClerks with 7 positive ratings but had level 2 . But according to SEOClerks TOS we need to complete 10+ orders ? How is it possible ? I just saw a member of SEOClerks with 7 positive ratings ...

  • crazygeek
    crazygeek Level 1
  • 2 13 years ago

    Hello, i need to sell a service for 3$ URGENT but i am only a level 1, and it will take a while for me to get to level 2! I need someone to tell me if there is any possible way for me to sell a sevice for 3$, and not t...

  • YamanAbu
    YamanAbu Level 1
  • 8 13 years ago

    in this situation i need to contact to support and submit a ticket to seoclerks. but i dont know ? how to contact seoclerks! This is very Urgent,? if ? somebody knows how to, please answer this question! Thank you! ...

  • YamanAbu
    YamanAbu Level 1
  • 14 13 years ago

    Hai, What is the adsense account? and how it works in seo services? PLease explain any one about adsense account. how can we earn with google adsense account in seo services in online market. how to open the verifi...

    5 13 years ago

    So, I ordered twice from a seller, that I'm used to buying from him. I probably ordered more than twice from him. But one day he suddenly dissapers, I tried many attempts to contact him but I've received no answer. Is it...

  • YamanAbu
    YamanAbu Level 1
  • 8 13 years ago

    The excuse that buyer ordered by mistake and asks the cancellation of the order after 90% completion of job. If the cancellation is due to buyers problem, wheter rating will be effected or not? If cancel the order ...

    3 13 years ago

    I uploaded a contacts file at my Facebook account and send a invitation to like my page or come at my page so how could i track them. Like 1000 contacts in my upload profile so what my neat step to track my contacts. i...

  • ankurrajput
    ankurrajput Level 1
  • 1 13 years ago

    what is paypal process to withdrawl tell me in clear ok.. i need in right way....how much time paypal take to withdraw?,tell me that how many days paypal take for withdrawl? when money is reach to my bank account .... t...

    2 13 years ago

    I am curious to know if user levels increase your sales or views on your service. When I joined here, I didn't know what they were, and disregarded them until I did some research. I want to know if services will get more...

  • Sackfist
    Sackfist Level 1
  • 7 13 years ago

    What happens if I don't complete a job on time? That is if I have clicked deliver work and the buyer rejects it, what is the effect if the deadline is reached. Never happened just curious. I know I can suspend my want...

  • Sackfist
    Sackfist Level 1
  • 5 13 years ago

    I need to know that is mutual cancelation is harmful for my own profile/ i have ordered one of sellers for my need and he can`t complete my wanted works and can`t complete within deadline of his gig.and also not respons...

  • sunbeam
    sunbeam Level 1
  • 7 13 years ago

    I am a level 1 seller now i need to move .so, i need to get more sales .So, i want to know is it most important should have more gigs to get more orders!I need to get a clear information about this!so, Can anyone describ...

  • sunbeam
    sunbeam Level 1
  • 4 13 years ago

    hey please help me till now i use paypal but i need to know about payza and payoneer card what are these and tell me the benefits of using them are they better than paypal please tell me about it. . would be gratef...

  • shubhujn
    shubhujn Level 1
  • 9 13 years ago
    Order Now
    Process Time: 0.074033975601196

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM seoclerks.members WHERE username='experttr' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='experttr' AND status='1'

    /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()

    SELECT * FROM answers WHERE userid=494421SELECT distinct quesid FROM answers WHERE userid=49442

    /opt/clerks-staging/docroot/faq.php 258 () ()

    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.quesid IN (5933,5929,5906,5909,5904,5949,5950,5951,5958,5956,5980,5977,5975,5954,5979,6005,5971,5969,5968,6029,6123,6124,6122,6121,6118,6114,6146,6139,6315,6313,6392,6390,6388,6384,6383,6377,6376,6374,6375,6393,6369,6366,6356,6401,6402,6403,6399,6398,6210,6211,6205,6209,6202,6304,6309,6404,6406,6305,6250,6418,6417,6442,6438,6635,6630,10495,11941,11942,11943,12032,12117) 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.quesid IN (5933,5929,5906,5909,5904,5949,5950,5951,5958,5956,5980,5977,5975,5954,5979,6005,5971,5969,5968,6029,6123,6124,6122,6121,6118,6114,6146,6139,6315,6313,6392,6390,6388,6384,6383,6377,6376,6374,6375,6393,6369,6366,6356,6401,6402,6403,6399,6398,6210,6211,6205,6209,6202,6304,6309,6404,6406,6305,6250,6418,6417,6442,6438,6635,6630,10495,11941,11942,11943,12032,12117) 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.quesid IN (5933,5929,5906,5909,5904,5949,5950,5951,5958,5956,5980,5977,5975,5954,5979,6005,5971,5969,5968,6029,6123,6124,6122,6121,6118,6114,6146,6139,6315,6313,6392,6390,6388,6384,6383,6377,6376,6374,6375,6393,6369,6366,6356,6401,6402,6403,6399,6398,6210,6211,6205,6209,6202,6304,6309,6404,6406,6305,6250,6418,6417,6442,6438,6635,6630,10495,11941,11942,11943,12032,12117) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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.quesid IN (5933,5929,5906,5909,5904,5949,5950,5951,5958,5956,5980,5977,5975,5954,5979,6005,5971,5969,5968,6029,6123,6124,6122,6121,6118,6114,6146,6139,6315,6313,6392,6390,6388,6384,6383,6377,6376,6374,6375,6393,6369,6366,6356,6401,6402,6403,6399,6398,6210,6211,6205,6209,6202,6304,6309,6404,6406,6305,6250,6418,6417,6442,6438,6635,6630,10495,11941,11942,11943,12032,12117) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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='62528'1SELECT profilepicture FROM seoclerks.members WHERE USERID='62528'

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

    SELECT * FROM seoclerks.members WHERE USERID='54589'1SELECT profilepicture FROM seoclerks.members WHERE USERID='54589'

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

    SELECT * FROM seoclerks.members WHERE USERID='49596'1SELECT profilepicture FROM seoclerks.members WHERE USERID='49596'

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

    SELECT * FROM seoclerks.members WHERE USERID='64493'1SELECT profilepicture FROM seoclerks.members WHERE USERID='64493'

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

    SELECT * FROM seoclerks.members WHERE USERID='64082'1SELECT profilepicture FROM seoclerks.members WHERE USERID='64082'

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

    SELECT * FROM seoclerks.members WHERE USERID='39772'1SELECT profilepicture FROM seoclerks.members WHERE USERID='39772'

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

    SELECT * FROM seoclerks.members WHERE USERID='26667'1SELECT profilepicture FROM seoclerks.members WHERE USERID='26667'

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

    SELECT * FROM seoclerks.members WHERE USERID='33664'1SELECT profilepicture FROM seoclerks.members WHERE USERID='33664'

    /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.4094991SELECT 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 (84) AND gtags like'%highdapbns%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4094990.409499
    0.3158141SELECT 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,400.3158140.315814
    0.1917581SELECT 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.1917580.191758
    0.1725421SELECT 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 AND (A.tags LIKE '%codeigniter%' OR A.skills LIKE '%codeigniter%') ORDER BY A.lastgigedit desc LIMIT 0,400.1725420.172542
    0.1246641SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9848 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Microsoft Word Microsoftword Documents Formatting%' ) LIMIT 40.1246640.124664
    0.1228801SELECT 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 AND (A.tags LIKE '%codeigniter%' OR A.skills LIKE '%codeigniter%')0.1228800.122880
    0.1185661SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 60547 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Scripts%' ) LIMIT 40.1185660.118566