SEOClerks

Clear
Sign In Join

If you could change one thing about SEOClerks

  • Ashlyn Level 1
    • 18

    Write the reason you're deleting this FAQ

    If you could change one thing about SEOClerks

    If you could change one thing about SEOClerks (for sellers) or SEOClerks Marketplace (for buyers), what would it be? What would you add? What changes would you make?

    # SEOClerks
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    seoguru24x7

    seoguru24x7

    I would love to add a chat option for buyers , so sellers can easily interact with buyers .
    11 years ago

    Are you sure you want to delete this post?

    viewss

    viewss

    Must Change On featured services, Only 4 Featured. but @jordan give over featured services, this is not helpfull
    11 years ago

    Are you sure you want to delete this post?

    Lillian

    Lillian

    I would love to add a chat option for buyers , so sellers can easily interact with buyers .

    This would be a very good feature to have on SEOClerks as it would allow for instantaneous interaction with clients. Though it would be annoying if someone was constantly messaging you while you were trying to work, angry that you are not responding to their messages.
    11 years ago

    Are you sure you want to delete this post?

    forever love

    forever love

    This would be a very good feature to have on SEOClerks as it would allow for instantaneous interaction with clients. Though it would be annoying if someone was constantly messaging you while you were trying to work, angry that you are not responding to their messages.


    I'm sure they would include a 'chat off' feature to switch chat to off for times when you wanted to show your status as offline or not available to talk.
    11 years ago

    Are you sure you want to delete this post?

    seoguru24x7

    seoguru24x7

    Yeah we can follow facebook chat system If you could change one thing about SEOClerks

    And a report option as well, if someone try to spam or break seoclerks term and conditions .
    11 years ago

    Are you sure you want to delete this post?

    seoguru24x7

    seoguru24x7

    #2
    Optional subscription button on service page for buyers would be great .
    11 years ago

    Are you sure you want to delete this post?

    Beverly

    Beverly

    If buyers could be automatically subscribed to your profile on SEOClerks for future updates.

    Not everyone of my buyers subscribes to my services and for this reason I lose contact.
    11 years ago

    Are you sure you want to delete this post?

    mgmshihan

    mgmshihan

    if any feature to get quality services on seoclark its more better by adding such gig manual approval
    11 years ago

    Are you sure you want to delete this post?

    seoguru24x7

    seoguru24x7

    If buyers could be automatically subscribed to your profile on SEOClerks for future updates.

    Not everyone of my buyers subscribes to my services and for this reason I lose contact.

    optional subscription means on order page a buyer can order a service for 1 time or he can order monthly subscription also .
    11 years ago

    Are you sure you want to delete this post?

    Beverly

    Beverly

    optional subscription means on order page a buyer can order a service for 1 time or he can order monthly subscription also .


    Yes I understand what a subscription is, in terms of what you are saying and like your idea of optional subscription for that. And, I support your idea.

    When I use the word 'subscribe', I'm not talking about subscribe in that way though. I'm referring to 'subscribe' as you might if you were to subscribe to an update.

    I would like it so that my customers/buyers would automatically follow me when buying my services. That's what I mean in reference to the word 'subscribe' as in 'subscribe (or follow) for updates'. We should have this option as there is no option for using email to have 'subscribers' which is a typical practice in any other freelance scenario. The customer who has made a purchase from a seller would be notified on their dashboard when that seller has news.

    If someone buys from me then I want them to receive a notification in the future for any service that I create or any service that goes on sale. And, this should be automatic too, without the customer having to 'follow' my profile. Simply asking a buyer to follow is not always successful. They have purchased my services previously, so presumably would be interested in seeing more. I would think this type of feature would benefit most of the SEOClerks sellers.

    This could potentially lead to repeat sales as a customer who has used your services before is more likely to use your services again if they are simply reminded.

    So just think of this as a 'reminder service' where the buyer is automatically opted into rather than 'asked' to opt in.
    11 years ago

    Are you sure you want to delete this post?

    seoguru24x7

    seoguru24x7

    Yes I understand what a subscription is, in terms of what you are saying and like your idea of optional subscription for that. And, I support your idea.

    When I use the word 'subscribe', I'm not talking about subscribe in that way though. I'm referring to 'subscribe' as you might if you were to subscribe to an update.

    I would like it so that my customers/buyers would automatically follow me when buying my services. That's what I mean in reference to the word 'subscribe' as in 'subscribe (or follow) for updates'. We should have this option as there is no option for using email to have 'subscribers' which is a typical practice in any other freelance scenario. The customer who has made a purchase from a seller would be notified on their dashboard when that seller has news.

    If someone buys from me then I want them to receive a notification in the future for any service that I create or any service that goes on sale. And, this should be automatic too, without the customer having to 'follow' my profile. Simply asking a buyer to follow is not always successful. They have purchased my services previously, so presumably would be interested in seeing more. I would think this type of feature would benefit most of the SEOClerks sellers.

    This could potentially lead to repeat sales as a customer who has used your services before is more likely to use your services again if they are simply reminded.

    So just think of this as a 'reminder service' where the buyer is automatically opted into rather than 'asked' to opt in.

    Yes that is a great idea too, we can offer discounts and other promotional stuffs to our buyers (subscribers) directly :cool: .
    11 years ago

    Are you sure you want to delete this post?

    seoguru24x7

    seoguru24x7

    To stop spamming - Sellers can send 1 update every week to their subscribers/buyers or something like that .
    11 years ago

    Are you sure you want to delete this post?

    chetaseo

    chetaseo

    i want the feature fee to reduce drastically so that i can feature my services also on the front page. i will be very happy for this should it be reduced.
    11 years ago

    Are you sure you want to delete this post?

    farahkhan

    farahkhan

    I would really love to change the automatic order completion thing to be done early 5 days is a bit too long . I think 2 days should be enough because buyer still got a chance to review it even after its complete . It will help the seller to get his funds quickly. As for level 1 seller clearance time is already very long so it would really help them as well . And i think 48 hour is enough time for buyer to review the order .
    11 years ago

    Are you sure you want to delete this post?

    Anisha

    Anisha

    Maybe it's a small thing, but I would like to be able to customize the look of SEOClerks dashboard. Maybe it could be more like a real home page where you can add modules.
    11 years ago

    Are you sure you want to delete this post?

    Asmodeus

    Asmodeus

    It should be harder for a seller to lose their level status. As it is now I've seen plenty of sellers drop from level 3+ right down to level 1 just because of ONE factor of the many requirements had changed. Usually its just the feedback percentage drops a percent because of one sale gone sour and suddenly the seller is back to level 1 again after months of hard work.

    It's not fair and needs to be addressed. Sellers have already complained about that on various forum threads when it happens to them and I'd like to suggest they re-evaluate the currently flawed levelling system.

    Related to that, the number of affiliate sales needed to reach level 4 is too high at 50. I reached the number of personal sales needed for level 4 (100+) awhile ago, but I'm still only level 3 because of that barrier.
    11 years ago

    Are you sure you want to delete this post?

    SMMEXPRESS

    SMMEXPRESS

    If the features price will down from $350 to $100 than it would be great for lots of seller to do a good business here in this market place.
    11 years ago

    Are you sure you want to delete this post?

    Asmodeus

    Asmodeus

    If the features price will down from $350 to $100 than it would be great for lots of seller to do a good business here in this market place.


    For some, maybe, but as much as I think the featured spots are overpriced and can only be afforded by a few sellers, if they lowered the price so that more sellers could afford them, then there would be even more featured (ie. static) listings on the front page and normal sellers would never get a chance to be on the homepage at all using their normal bumps.

    A balance needs to be found to be fair to everyone.
    11 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.34511709213257

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    		/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

    SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='11741'1SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='11741'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='59007'1SELECT * FROM seoclerks.members WHERE USERID='59007'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM seoclerks.members WHERE USERID=590071SELECT googleplus_profile FROM seoclerks.members WHERE USERID=59007

    		/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()

    SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=11741 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=11741 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='11741' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='11741' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc

    		/opt/clerks-staging/docroot/viewfaq.php 1245 () ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53515 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53515 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53516 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53516 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53517 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53517 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53518 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53518 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53519 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53519 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53520 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53520 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53521 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53521 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53522 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53522 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53523 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53523 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53524 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53524 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53525 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53525 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53526 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53526 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53527 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53527 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53528 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53528 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53529 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53529 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53530 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53530 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53531 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53531 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53532 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53532 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='11741'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='11741'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='11741' AND status='1' AND (question like '%If change SEOClerks%' OR question like '%change%' OR question like '%SEOClerks%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='11741' AND status='1' AND (question like '%If change SEOClerks%' OR question like '%change%' OR question like '%SEOClerks%') -- ORDER BY RAND() LIMIT 15

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

    SELECT * FROM seoclerks.members WHERE USERID='1364' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1364' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='957' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='957' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='750' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='750' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='1643' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1643' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='9' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1

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

    SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=11741%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=11741%' 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='134284.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='134284.jpg'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    		/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.4759531SELECT 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 (64) AND gtags like'%emb%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4759530.475953
    0.4273011SELECT 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'%alt%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4273010.427301
    0.1656881SELECT 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 '%Pa%' OR A.skills LIKE '%Pa%') ORDER BY A.lastgigedit desc LIMIT 0,400.1656880.165688
    0.1211631SELECT 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 '%Pa%' OR A.skills LIKE '%Pa%')0.1211630.121163