SEOClerks

Clear
Sign In Join

Answers from user Sylvester Page 3

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

What Happend???? Answered

What Happened To Code Clerks???? Not Many Memberso_O No Deals

  • Haider
    Haider Level 1
    • 2 13 years ago

    Biggest forum failures Answered

    What's the worst mistake you have made on your own forum; whether deleting the wrong reply to accidentally banning yourself. Talk about how you recovered. As for myself, i seriously messed up my forum theme about two ...

  • Beverly
    Beverly Level X3
    • 9 13 years ago

    Do flash or video ads work better than static banners? Answered

    When using Google Adwords or paid advertisements online, does it help to use video or flash banners? Or, do static banners work better for catching consumer attention?

  • Beverly
    Beverly Level X3
    • 2 13 years ago

    What does Bing think about being the #2 search engine? Answered

    Here's a fun video with top executive from Bing on what it's like being the second best search engine (compared to Google Search). [media=youtube]AUdAM0p18BU[/media]

  • Jolie
    Jolie Level 1
    • 20 13 years ago

    When did you start blogging? Answered

    I started blogging about three years ago just to have something to do with my spare time. Now I blog for income. When did you start blogging? And, what's your main reason for blogging now?

  • WilderRose
    WilderRose Level 1
    • 7 13 years ago

    Should be less awaiting delay after order delivery Answered

    hey guys, first of all i want to thank Admin and Mods here who always gave me good response when i ever need help from them . i am really enjoying working on this website and enjoying pretty money coming to my account ;)...

  • moneygoddy
    moneygoddy Level 1
    • 6 13 years ago

    Do you get your friends to advertise for you? Answered

    My best friend advertises my forum on her blog sometimes and I do the same for her on my own forum when she makes new posts. And, it really helps us both out, exchanging ads like this. If i had T-shirts with my forum l...

  • Beverly
    Beverly Level X3
    • 5 14 years ago

    Local radio advertising Answered

    Is radio ads an option for forums? What about if you have a local forum or site related to local tourism?

  • Beverly
    Beverly Level X3
    • 7 14 years ago

    Do you use a fake name on Facebook? Answered

    Facebook lets you change your name several times. But, many times i see fake names from users such as Kitty LuvsU (as the username) or some other made up name. And, you know that's not a real name. But these accounts ...

  • Beverly
    Beverly Level X3
    • 82 14 years ago

    Order Now
    Process Time: 0.052021980285645

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

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

    SELECT * FROM answers WHERE userid=605321SELECT distinct quesid FROM answers WHERE userid=60532

    		/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 (10629,10635,10637,10672,10720,10721,10722,10856,10858,10880,10936,10987,10997,11098,11138,11217,11372,11384,11389,11552,11553,11570,11729,11750,11758,11772,12495,12496,12557,12576,12819,12826,12871,12873,12922,12924,12928,12944,12959,13031,13065,13271,13276,13285,13287,13463,13464,13707,14062,14063,14064,14066,14067,14071,14080,14093,14286,14553,14557,14579,14584,14585,15332,15333,15646,16038,16039,16044,16053,16054,16083,16097,16109,16124,16171,16454,16474,16484,16886,17012,17188,17196,17207,17288,17326,17338,17394,17401,17407,17431) 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 (10629,10635,10637,10672,10720,10721,10722,10856,10858,10880,10936,10987,10997,11098,11138,11217,11372,11384,11389,11552,11553,11570,11729,11750,11758,11772,12495,12496,12557,12576,12819,12826,12871,12873,12922,12924,12928,12944,12959,13031,13065,13271,13276,13285,13287,13463,13464,13707,14062,14063,14064,14066,14067,14071,14080,14093,14286,14553,14557,14579,14584,14585,15332,15333,15646,16038,16039,16044,16053,16054,16083,16097,16109,16124,16171,16454,16474,16484,16886,17012,17188,17196,17207,17288,17326,17338,17394,17401,17407,17431) 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 (10629,10635,10637,10672,10720,10721,10722,10856,10858,10880,10936,10987,10997,11098,11138,11217,11372,11384,11389,11552,11553,11570,11729,11750,11758,11772,12495,12496,12557,12576,12819,12826,12871,12873,12922,12924,12928,12944,12959,13031,13065,13271,13276,13285,13287,13463,13464,13707,14062,14063,14064,14066,14067,14071,14080,14093,14286,14553,14557,14579,14584,14585,15332,15333,15646,16038,16039,16044,16053,16054,16083,16097,16109,16124,16171,16454,16474,16484,16886,17012,17188,17196,17207,17288,17326,17338,17394,17401,17407,17431) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 80, 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 (10629,10635,10637,10672,10720,10721,10722,10856,10858,10880,10936,10987,10997,11098,11138,11217,11372,11384,11389,11552,11553,11570,11729,11750,11758,11772,12495,12496,12557,12576,12819,12826,12871,12873,12922,12924,12928,12944,12959,13031,13065,13271,13276,13285,13287,13463,13464,13707,14062,14063,14064,14066,14067,14071,14080,14093,14286,14553,14557,14579,14584,14585,15332,15333,15646,16038,16039,16044,16053,16054,16083,16097,16109,16124,16171,16454,16474,16484,16886,17012,17188,17196,17207,17288,17326,17338,17394,17401,17407,17431) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 80, 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='19352'1SELECT profilepicture FROM seoclerks.members WHERE USERID='19352'

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

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

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

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

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

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

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

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

    		/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
    5.5297601SELECT 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 (17,18,22,30,33,47,49,50,72,84) AND gtags like'%BAcklink%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 405.5297605.529760