SEOClerks

Clear
Sign In Join

Answers from user kashifrasheed

Date Hot Date (old to new)
Unanswered Votes
Showing page: 1 of 1
Start a discussion

How New Sellers Can Get Started on SEOClerks and Ways to Increase Sales and Success Answered

Every now and then on the Community FAQ we get a post by someone asking for help as a new seller. Asking for tips and ways they can increase sales of their services and see more success. And every time we just about tell...

  • idealmike
    idealmike Level X3
    • 8 9 years ago

    Error message as spam Answered

    When i try to answer to the offers i have this message : << This message was detected as spam. You could be using a URL or a Word which has been flagged as spam previously. If you were recently sending mass messa...

  • omelhor
    omelhor Level 1
    • 5 9 years ago

    Why I can't create a service??? Answered

    Hi, I am in a big trouble. I can't add any services. Early this day, I have created a service and deleted it after a few minutes later as it was wrong information. After that, I tried to create another service, but I can...

  • Ivans
    Ivans Level 1
    • 11 12 years ago

    This message was detected as spam. Answered

    This message once again appear every time I reply to a man interested to buy my service. This message was detected as spam. You could be using a URL or a Word which has been flagged as spam previously. If you were recen...

  • seoguy
    seoguy Level 1
    • 6 12 years ago

    Order Now
    Process Time: 0.050564050674438

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

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

    SELECT * FROM answers WHERE userid=8091441SELECT distinct quesid FROM answers WHERE userid=809144

    		/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 (12581,22148,12435,22216) 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 (12581,22148,12435,22216) 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 (12581,22148,12435,22216) 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.quesid IN (12581,22148,12435,22216) 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='272'1SELECT profilepicture FROM seoclerks.members WHERE USERID='272'

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='318'1SELECT 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 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.4242981SELECT 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 (62) AND gtags like'%Socialmedia%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4242980.424298
    0.2931301SELECT 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.2931300.293130
    0.2831541SELECT 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.viewcount desc LIMIT 0,400.2831540.283154
    0.1798311SELECT 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.1798310.179831