SEOClerks

What current website features would you like enhanced or improved?



Write the reason you're deleting this FAQ

What current website features would you like enhanced or improved?

Have you ever wanted a certain feature to act a certain way? Do you have suggestions and feedback that you would like to voice your opinions on? In this FAQ we will discuss current features the site already has that we as users would like to see improved or enhanced. This FAQ is not an official suggestion and feedback requester, this is just to voice your opinions and ideas.

Please do not ask the staff to make a certain feature here, or even post an agreement such as "Yes, this would be nice" with a certain feature or improvement, if you agree with it, just simply "like" or "thumbs up" the post. If you don't agree, thumbs down the post.

Replies such as "yes, this would be good to add", or "no i dont agree with this improvement" without stating why you don't agree or why you agree without explanation will be removed.

All posts on this FAQ would need to be suggestions and/or feedback. If you think a suggestion would enhance the site, you need to say why it would enhance the site, provide an example, and your arguments. If you don't agree with a suggestion, voice your concerns!

Comments

Please login or sign up to leave a comment

Join
Everett
Notification System Improvement

How it currently works:
  • Once you get an alert, you will see Alerts (1)
  • You have to click on the alert button to see the alert you have, a popup will appear
  • The alerts are not posted in real time, but received in real time.
  • The alert page has no pagination and only displays a certain number of alerts


How it can be improved:
  • Make the alert realtime, display a window in the upper right corner or bottom right corner with a small box containing the alert details, give option to close the alert, or automatically close alert within 3 to 5 seconds.
  • Show who views your services, profile, FAQ, etc, we only get alerts via action based such as liking a service, or leaving a comment, give user option to turn off views of services, or profile
  • Either paginate alert page or give user ability to clear all alerts
  • Give user ability to go 'incognito' so other users dont know they view their pages, services, etc..

What current website features would you like enhanced or improved?

This is an example of how realtime alerts would look and function.



Are you sure you want to delete this post?

anwebservices
Some time ago on old forum were some suggestion about "sound" signal on receiving new alert and i guess it would be nice to have as well What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

Everett
I hope if there is a system implemented, and if it has a sound this sound would have a feature to turn it off. Because sometimes, sounds can get pretty stressful. Especially if you have about 10 active orders and trying to get things done with the marketplace tab open and all you keep hearing is "Bing Bing!" for new alerts. I would like to be able to mute that little sound, but overall a sound notification can be quite nice too.



Are you sure you want to delete this post?

Beverly
Would that be similar to the Facebook alerts/notifications, such as when someone likes or comments? Those are actually useful



Are you sure you want to delete this post?

Everett
Yes, it would be similar. I'm not trying to say yes, clone facebook's alert system but somehow its function would be the same of course.



Are you sure you want to delete this post?

EliteWriter
Yes I think it would be great as I find it bothersome to have to click on Alerts every time and since I am here practically all the time I would be able to increase my efficiency if I had to see alerts in real time instead of having to click each and every time out of curiosity. As you said it is quite similar to Facebook notifications. Moreover it would be great to be able to clear alerts as I must get at least 20 every day.



Are you sure you want to delete this post?

Everett
Yes, this is another hindrance, that pesky alert page that doesn't allow you to clear your alerts. I know that it only displays the latest alerts but it is still too bulky for my liking. We need a clear button now! 8-)
since I am here practically all the time I would be able to increase my efficiency if I had to see alerts in real time


You have no life like me, just kidding! Yes, I am in total agreement with you there as well. I too spend a lot of time here and notification system that I posted would be so beneficial for users like us who love to be as responsive to our clients or even users as much as possible.

Do you have anything to add to the system?



Are you sure you want to delete this post?

EliteWriter
Apart from that, I would love to have the possibility to see orders sorted out by their deadline - you know, seeing the one with the most recent deadline first, and others follow, as at the moment they are sorted out by the day they were ordered.

I would also like to have some sort of Notes feature, a place where you can make notes for personal use and reference. It would be helpful for me to keep track of which orders I will handle every day for example, rather than write it on a piece of paper as I do now.



Are you sure you want to delete this post?

Everett
You could always keep notes on your computers notepad program?



Are you sure you want to delete this post?

EliteWriter
No I meant a sort of sticky note feature for each order. Or in the Manage Orders screen. The thing is I get several orders. For example at the moment I have 13 different orders with different deadlines and buyers sometimes send a message to my inbox rather than a reply in the order response page. So there are bits and pieces here and there sometimes. With such a feature I could see everything noteworthy in the same page and it would make it much easier for me.



Are you sure you want to delete this post?

Everett
oh yes, now I know what you're getting at. I think that would be beneficial as well.. a note section per order for the seller. I can see how this would help sellers, and provide notes so you don't forget..

It could get very chaotic if you have about 20 active orders a day, and clients changing their mind, etc. So I can really see how this would be great.



Are you sure you want to delete this post?

EliteWriter
Yes it certainly would help me a great deal! I really hope it could be taken into consideration. I end up making notes and every time I do this I have to write the order number because that is the only significant difference from one order to another as I get most orders from a couple of popular services, and generally I have more than one order placed by the same buyer. So such a feature could indeed save me time and a lot of possible mistakes and confusion between orders.



Are you sure you want to delete this post?

Cybertron
I also like that, it will be nice to add notes in each order for our reference without the buyer seeing it. The notes just need to be saved as a message in order page but only seen by the seller. We can save urls, keywords, id etc.. in the order page itself without disturbing the buyer.



Are you sure you want to delete this post?

ajlancer
Hi Anweb I agree with you. Though this featured not much necessary but, our execration always high and we expect always something special for SEOclerks and sound for alert may such great one for notification system. And we know, everything has both side good or bad. Alert with sound may has a bad side. For example, if you get notification very often by sound alert, it may annoying for your freelancing work and I am sure, I will mute when I will do very serious work. And you can use this featured facility by other way, which I am using for my email and I got notification for all email by sound.

Regards by Ajlancer



Are you sure you want to delete this post?

anwebservices
Well since i like the sound notifications i made it my own way for some alerts. I actually switch ON to receive them on my email and i am receiving my emails on my mobile phone application which is refreshing frequently and it also make sound on all received emails, so i can react as soon as possible if it's about providing service for my buyer or something else. It's true that i also receive some other spam too, but at list i clean it up more frequently now so my email inbox is always clean too. Not the best option out there but at the moment working good for me ;)



Are you sure you want to delete this post?

Beverly
Currently, a buyer or seller has to go to a third party site to file a support ticket. And, some buyers won't think to do that. My ideas would be for some kind of easier way for buyer to make contact with support staff to resolve issues sooner, rather than having to go to third party site, create a ticket, wait for response. While that system is used by many, a more instant way to communicate with support staff within the SEOClerks site would also be ideal.
  • Support based live chat feature that opens chat with support member who can immediately handle issue. It would be like a live chat feature on SEOClerks.com and many sites have live tech support on site. I realize this live chat feature is available on Zendesk but it depends on the buyer (or seller, if he has a problem) going to a third party site.
  • Support button that you click to get help (much like when you click the report button to report spam) and you describe your problem on the support form and all relevant information is tagged in the ticket created. Thereafter, that creates a ticket on the current support desk and a support member can respond, without the buyer/seller ever having to leave SEOClerk.com to create ticket. Possibly this could be integrated with the current Zendesk software used now for report but it would originate inside SEOClerks, the actual order itself. And, I know there could be issues such as ensuring the person who created this ticket could obtain follow ups. And, maybe they could show directly within a 'support dashboard' in each person's account.



Are you sure you want to delete this post?

TommyCarey
I don't know if live chat support would be the best thing for this type of website. Sure it works for many different websites out there, but with live chat on here you'd get questions like "How can I increase my rankings in Google?" and that's not really a support question.

Having live chat would also reduce the amount of posts on the community discussion where people can ask questions like that What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

procoder
Agree with you Raz.But would be great to have a live chat feature enabled only on order page, not on the main site. I'm talking about that page where we deliver orders, having that feature enabled only in that page , i think will eliminate all possibilities to abuse with live chat support.



Are you sure you want to delete this post?

anwebservices
This option is not bad actually. But i still hope it won't be misused because there is many inpatient customers. We notice that most of people don't want to search FAQ either, but asking same question again and again, most of them want dedicated answer, without searching, like it's hard to input word or two and click search... While in other hand this support chat on order page could be effective too



Are you sure you want to delete this post?

Everett
In these great times, people want mostly everything done for them. They are too impatient and want things NOW. That is a whole other issue! But if you can filter out those wanting quick responses to questions that have been answered time and time again, then those specific users wouldn't be an issue. Perhaps if you ask a question or fill out the form, it will have a dropdown with questions already asked via our FAQ section. This would assist the user about to make a ticket with their previously asked question such as "how to increase user level". Unsure if the form already does that now, haven't checked Support in a long time.



Are you sure you want to delete this post?

TommyCarey
That could work, but we would only know how much it would be used by testing it What current website features would you like enhanced or improved?

When someone hits the order page I'm not sure if they really want to talk to people because they just want their service done now. But I could be wrong ;)



Are you sure you want to delete this post?

Lynne
Oh that would be great to be able to have live chat with my seller about my order or just to ask questions about services offered. This would really provide value for buyers and sellers.



Are you sure you want to delete this post?

Beverly
You have some really valid points there. :/

We were talking also about having a sales related chat, not related to tech help. And, I would support the sales chat feature, such as where a buyer could click to get support for finding a good buyer. The chat person would not be able to answer generic questions though and would likely just give a macro/canned response for those. What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

Everett
If the chat was targeted to an active order that was not yet delivered or canceled, if they had X amount of time to make a support request this can limit the amount of redundant support inquiries. For instance, active order support, instead of just onsite realtime support. Where the buyer or seller would create a ticket regarding an order, but only have a limited of options, and make a phase stating something like: "If your topic is not listed here, please view the FAQ or send in a site support ticket". Maybe something like that? But this would probably branch off the support into 2 support systems.



Are you sure you want to delete this post?

MasterA
I agree that needing to go to a third party website for support can sometimes be a hassle. Therefore, I think having a support ticket system integrated with SEO Clerks like the Community Discussions would be a good idea so everything can be done on here instead of a separate website. Also, I know there is a short FAQ on the support desk but I think it will be a good idea to move that over to the SEO Clerks website as it is easier for members to see it here. Also, I think more common questions should be put there like “Where can I find my affiliate link?” just so it can be easily found.



Are you sure you want to delete this post?

ajlancer
Hi Bev I agree with you like some buyer and seller does not like to get support ticket by third party and I personally do not like. But, it is not big problem too. And I agree with your second Idea like live chat support. It should be awesome. And I saw it some big website like payoneer.com and user can fix their problem within moment by live chat. So, I very much prefer your this point. And I do not agree your second point like support system by click on button. Because, such type of very easy and convenient system may be abused.

Regards by Ajlancer



Are you sure you want to delete this post?

hitmeasap
I've read all the points stated by everyone regarding this but I still believe a live chat function could be something outstanding. For any "how do I level my account" questions, one could simply refer them to the proper Community Section topic. Basically just a copy & paste reply. In my opinion, a live chat, for anyone who's in need of support, would actually be a great feature to bring even further professionalism into SEOClerks. It looks good to have one. It is good to offer people instant support. I honestly can't see any major downsides, even though I still understand all the stated points above.



Are you sure you want to delete this post?

TommyCarey
Campaign Builder Option:
Basically you could pay $1, or whatever the price woule be, to have an SeoClerks staff member to pick out what they think you would need in order to hit the top in Google, Yahoo! and Bing. Basically the staff member would be putting together a basic plan of attack to increase in the rankings on the search engines. The buyer could put in their budget of $10, $25, $50, $5,000,000, etc. and the staff member will try to stay under that budget, but put together the best bang for the buck What current website features would you like enhanced or improved?

SC wouldn't really profit off of this because of the time it would take to research the buyers website, put together a campaign and then find the right services for the buyer. I think it would increase conversions a lot since people wouldn't really have to search for what they need and a lot of buyers may be wary of purchasing because they don't know exactly what to get.



Are you sure you want to delete this post?

Beverly
The buyer could put in their budget of $10, $25, $50, $5,000,000, etc. and the staff member will try to stay under that budget, but put together the best bang for the buck


A lot of times, when a buyer cancels one order, such as for Twitter followers, the next question out of their mouth (or fingers, considering they are typing it) is "Who provides really high quality Twitter followers?" and then I have to go find a seller who does just that. And, usually it will result in another sale! So the idea of having a live chat for pre-sales is a good idea. This campaign builder option would satisfy that requirement too, for many buyers.

The site would benefit in the long run as there would be more purchases if a person could find the perfect seller/service match, as you said. They would not have to do all that research on their own. Though I don't really know if there should be a charge for this.



Are you sure you want to delete this post?

TommyCarey
yeah, I don't know if there should be a charge, that's why I just said $1 because I didn't know what to put it at lol What current website features would you like enhanced or improved?

The only real downside to this is that it would reduce the time on site and the bounce rate wouldn't be as good. That's mainly because people wouldn't be browsing as many pages since we'd be doing it for them What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

Beverly
I can definitely see where any service that would save the buyer some time/headache in locating a useful service would make the site more profitable though, even with the downsides.



Are you sure you want to delete this post?

idealmike
Some truly excellent suggestions here guys! Some real thinking "outside the box". Some of these features would be very welcome and very cool features but only worth adding it there is a demand for it and it will solve another problem perhaps. Or if they simply just promote site usage itself and make using it easier and promote sales and things then I'm all for having them yes! What current website features would you like enhanced or improved?

I would like to suggest a preview option for the FAQ so we could preview our things first. It's not essential, it's just one of those things that could sometimes come in handy and also better handling of images and image placement as well so that I can upload images used in FAQs like guides etc to SEOClerks rather than hosting them elsewhere and also ability to float them into the left or right hand side of a paragraph like how you can when editing a WordPress post for example. But again, not essential and I can live without it just would be nice.

But the other suggestions made here so far are much more worth implementing for sure! Maybe. What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

Everett
Well, there is actually a way to upload images (you don't have to host elsewhere), and then place them somewhere in the paragraph. What I do is upload the image, and copy the image's link or the image itself and post the image where I want it. Just click the image button, send to server and place in the paragraph.

What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

idealmike
Yeah nice! I see Jordan just readded it nice one boss! Yeah that works but you can't float the image into the top right hand or left hand corner of a paragraph though. That's the catch! ;)

Still this will come in very handy thanks mate.



Are you sure you want to delete this post?

anwebservices
Yes you can align it to left, right , center, same as you do for text. Most of time i align it to center.
[right]YOUR IMAGE HERE[/right]



Are you sure you want to delete this post?

idealmike
Hmm I will try that! But that looks like it only places it either left or right not actually floating it in the text. I'm talking about actually floating it in the text. Example like this..
What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

Beverly
I would like to suggest a preview option for the FAQ so we could preview our things first


I didn't see a response to this part of your comment so I'll be the first to say that I really want this feature too.

I'm constantly going back after the fact and editing because a comma is out of place or there were two and not one space after a word. Just picky little things about my post, turn it from a quick one minute thought to a half hour endeavor and by then ten other people have responded to what the original poster. So yeah, preview mode would be good, just like on the old forum.



Are you sure you want to delete this post?

idealmike
Yes preview option would be awesome! Virtually every time I have submitted a guide or something quite lengthy to the FAQ, I am always going into it and editing it after. I always spell check as I go or after but sometimes they still slip through or perhaps there is too much white space or whatever. With a preview option it would save having to do that and thus, save time as well. It's like you say, it's only sometimes small things but small things can go a long way and make all the difference if you're trying to remain professional. What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

Everett
I would also like to mention other alerts, improvements, or statistical information for enhanced improvements and little upgrades to already amazing functions the website has:
  • Show who actually liked posts, not just the number of thumbs
  • Show who actually bookmarked your service, on the service page, possibly a little popup window containing the profile image of the user who liked your service
  • Show who is currently responding to your messages, via inbox, FAQ responses, and possibly orders
  • Show the real statistics of your services by including page view graphs (refer to basic image statistical graph below)

What current website features would you like enhanced or improved?

Now i couldn't really replicate javascript in the image, but there should be javascript indicating views, and orders so when you hover above an "order" or "view" label it will display that graph and info.



Are you sure you want to delete this post?

idealmike
Yes that was my other suggestion to have profile tracking so we can see how many views our profiles have had and where the views came from (country, search term maybe etc) and went to, visited etc on your profile.

This would let me know what other language I should most convert my services to and the history of views of our services so you can see what the daily, weekly, monthly or yearly traffic is/was too.

That would be a very welcome feature I'm sure! What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

Everett
Any feature or improvement that promotes sales is perfectly fine in my book. It would be beneficial to indicate where exactly the sale originated from, search engine, or the website link and the country. I haven't actually translated any of my services into different languages, which probably would be beneficial but I'm just either too busy or too lazy to even want to do it!



Are you sure you want to delete this post?

anwebservices
I guess it's implemented as per this discussion here: https://www.seoclerks.com/faq/1038...-and-sales-pages



Are you sure you want to delete this post?

Everett
Yes, but this sort of tracking uses a third party, it would be nice to log into SEOclerks or whatever ionicware, inc. marketplace you are on to track your analytics without going to another third party website. I believe the marketplace should have a feature like the Google Analytics tracking platform but specifically for us sellers, and/or buyers.



Are you sure you want to delete this post?

idealmike
That is true. That said, I think I will still like to implement this in the mean time. It could be very interesting to see how many daily/weekly or monthly views my profile got. Any organic keywords that were used to find it or what their activity and paths traveled too were too. Deffo!! I am sure that later down the line, they would be able to implement something like this without having to use a 3rd party tracking script but for now I'm definitely going to give this a go! What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

tamourk
Thanks for asking us, I am expecting a Tips Feature which will helps sellers to earn extra money, Such as Seller has no option to get bonus from buyers, I think if it be implemented ours and the community revenue will be increased, Thank You so much for reading my Comments,



Are you sure you want to delete this post?

seogurudev
Logout have bugs
after click LOGOUT -
https://www.seoclerk.com/logout?_ss=(some random alpha numerical codes)

in Firefox showing white blank page
in Chrome its showing
The www.seoclerk.com page isn’t working

www.seoclerk.com is currently unable to handle this request.HTTP ERROR 500



Are you sure you want to delete this post?

ezrank
A TOTALLY re-designing of UI of the website.

It's been long time that this website looks like this.

IT'S OLD, IT'S UGLY !!

Compare the look with some of famous competitors.



Are you sure you want to delete this post?

TommyCarey
Sorting services based on country:
I can't take full credit for this because it was talked about the other day and I actually think it's a pretty good feature. This will allow you to find people in certain countries if you need a specific language or you want to pay a certain rate. If I needed something written in Spanish I could look for people from Mexico or Spain (different Spanish, I know). If I wanted to pay a low rate for something of high quality I could search for people from India or other countries where the currency conversion is high on my end but low on theirs. I'd basically be getting a discount by hiring someone over seas because $1 to me would be $5 to $6 to them.



Are you sure you want to delete this post?

Everett
This is a commonly requested, or asked question "How to sort services by seller's country". I agree with this feature, and more search filters because we need to be able to search with more filters attached to our search queries to find that perfect seller.

What other features would be good?

I'm thinking, last active, user level, orders completed, positive ratings, response time all grouped into one search.

For instance: I'm looking for a Canadian seller who is an artist, and can draw me an elk for a game. I want the seller to be last active within 7 days, at least 5 positive ratings, and a response time under 2 days. I do not care about user level so I will just leave that blank.

It would be much easier to find that perfect seller, don't you agree?



Are you sure you want to delete this post?

TommyCarey
An advanced search feature would be pretty great What current website features would you like enhanced or improved? This would weed out a lot of sellers and only leave the exact ones you're looking for. I have, and I think others have, searched for a while trying to find the right seller for what we need done. I've spent 30 minutes searching, reading service descriptions and sometimes not even finding what I need. If we had an advanced search feature that hit all the metrics, I think we'd see a lot of buyers and sellers more happy than they already are because there will be less confusion about the service.



Are you sure you want to delete this post?

Everett
I actually read a post, well a review awhile ago stating that the reviewer didn't stay because they couldn't find the exact service they wanted, or couldn't locate a specific seller. This would increase buyer activity, and I'm sure buyers would order more services if they can actually find the perfect service they want. It just takes too long to go through pages, and pages of services, and the end result being that you couldn't find the service, or just simply gave up. This is very bad in terms of business!



Are you sure you want to delete this post?

Lynne
I would like to be able to get notifications of any activity on a thread if I want to, not just in reply to my threads or my comments. There have been some posts that I have nothing of value to add to, or I don't know much about but I find it interesting and would like to know more.

So yes, the ability to follow a discussion thread and get notifications. I think that would be lovely.



Are you sure you want to delete this post?

idealmike
You can do that already Lynn. Just click the "Subscribe" link on the OP's post. What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

Lynne
Oh cool! Thanks Mike, silly me not knowing about that.



Are you sure you want to delete this post?

idealmike
Yes silly you!! OJ Don't worry! I only accidently found out about it the other day when I accidently clicked on it. I was like oops what have I done. Oh, I've subscribed. Sweet. What current website features would you like enhanced or improved?



Are you sure you want to delete this post?

Lynne
Well I'm glad you made the oopsie so you could make me aware of it. I am already finding it coming in handy. It is so much easier than keeping checking in on a post to see if anything new has been added!



Are you sure you want to delete this post?

ajlancer
Hi Everett thanks for raising a excellent point. I read all comments and I saw many arguments here, what looking more live concerning this post. Overall, as a micro job site SEOclerks really awesome. And hope we are very satisfied. And all existing featured are working very good. And Jordan done everything very well. As a nature of human our expectation always high or it may happening be loving SEOclerks. I mostly insist on service status option. At this moment you cannot push your service by any current status, what is now going on with you either show up sold out. And, I really expect such featured will come soon, we can push service by any message like vacation going on, sickness etc. Buyer will see on service this message on Order now button. And I think another featured may need to enhance like order deliver section still slow. If you going to deliver order by click on deliver now, it will be hanging for few moment. It should be instant. And large file still not possible to attach in deliver section properly. If you attach large file by zip, it will make error for other hand like for buyer. So, this section should be more update.

Regards by Ajlancer



Are you sure you want to delete this post?

Everett
Yes, you are correct this is a "micro job" website, but what you failed to mention is that, this site is the BEST micro job website on the internet.
At this moment you cannot push your service by any current status


Yes, technically you can only suspended a service, and this will prevent buyers from buying the service. You can add a little message within the service indicating why the service is suspended, but I agree with your suggestion too. What other types of status do you think would be beneficial other than the current ones you already mentioned? Also, I forgot to add it would be nice to automatically pause your service and have them automatically activated again (like if you're going on holiday/vocation)



Are you sure you want to delete this post?

Beverly
What would happen to all your open orders if you shut your shop/services down temporarily? Would a custom message be automatically posted to each order to let buyers know that you will be away on vacation, sickness, etc? That would be useful for sellers have have hundreds of open orders as updating each one would be very time consuming. Possibly that's what you were indicating too.



Are you sure you want to delete this post?

idealmike
Yeah that's a good point/question. I guess there would have to be some kind of message that was shown globally across all your services or perhaps some small popup message that showed on them or even showed in the sidebar under the order details perhaps.



Are you sure you want to delete this post?

Everett
What happens if a seller passes away, that has many active orders? What if no one knows they sell their services on SEOclerks? I've always wondered what will happen in this regard.

I think that if there is active orders and someone is in the hospital, or just sick and can't complete orders they should cancel each and every order. However if the system was programmed not to cancel orders but to send a message to their buyers couldn't this result in more further scams? Say Billy Bob signed up, posted amazing services, and got a lot of sales and then decided to post that message. What happens when they mark the order as delivered and then asks buyers to review the service with the assurance that they will complete the order.

However you could always put in safety guards such as, not being to deliver order until X date?



Are you sure you want to delete this post?

aditya
One feature some of us already discussed about Live Chat when I posted in previous forum.
I think it is necessary feature in todays environment so staff should thing about it to get more sales by convincing our potential customers.
Thanks



Are you sure you want to delete this post?

EliteWriter
Yes I was one of those who created such a discussion a couple of weeks ago. I know that many buyers would love to have this as it irritates them that they cannot chat real time with us sellers. There are time differences of course, but chat could help to overcome them, and avoid the waiting between getting a message, replying to it, and waiting for another message in the inbox. The live chat should be restricted to orders and solely to facilitate communication between a buyer and a seller. In such a way it would not be abused.



Are you sure you want to delete this post?

anwebservices
From some point of view it would be nice feature to have for some reasons. I just don't see how exactly it would improve number of sales at our marketplace. Can you explain how it will bring more customers or sales?



Are you sure you want to delete this post?

aditya
With Live Chat feature we can have conversation at the same time rather than waiting for reply each time.
This frustrates buyers mostly that they want to order right now but they have to wait for reply for discussion.
This way we can increase sales & conversion rate.



Are you sure you want to delete this post?

rockerzzz82
i just want to say that i have been waiting for 4 months to get my gig featured but its always sold out,you can do a thing that not to make a gig featured which were already featured before



Are you sure you want to delete this post?

hitmeasap
Hello rockerzzz82,
I do understand how you feel in this matter. The featured slots are extremely hard to get and it's always hundreds of people trying to claim their spot as soon as one featured slot is free. However, you can't just take away a sellers chance to get a featured slot, no matter if they had one for 1 month or 48 months.. That's just wrong and unethical.


Best Regards,
hitmeasap



Are you sure you want to delete this post?

EliteWriter
I was not aware that one would have to wait as slots are limited. Couldn't you consider other options to make your service more visible and prominent maybe, such as the paid bumps that offer a highlighting feature?



Are you sure you want to delete this post?

Everett
I don't know why people wait for slots to open, it's shocking to me. You are paying $375 for a slot, for your service to be featured. Do these sellers know that they can potentially advertise their service on a third parties website? Why target just marketplace traffic? Sellers should branch out, away from the marketplace, as it will increase orders.

So if you have say $375, why not create an advertising campaign? You'll most likely get the same amount of views, and orders if done correctly. I believe that if you are waiting for a slot you should advertise elsewhere. Don't put all your eggs in one basket.



Are you sure you want to delete this post?

anwebservices
This is actually true and good idea, while waiting for available slot to feature service on front page, for this amount of money you can advertise your services on multiple, yet popular websites and possibly use even affiliate link to your service to bring i more customers and sell your service for 100% price



Are you sure you want to delete this post?

rockerzzz82
@elitewriter i dont think so paid bumps or highlightings helps a lot



Are you sure you want to delete this post?

Lynne
Hi Everett

Something I have noticed is that some sellers are not happy with the 5 day waiting period before an order is automatically approved. I am not too worried about that time frame because there has been a discussion about that and I have added my thoughts there.

But something that has also come up now is how many buyers don't bother with approving an order at all or with writing feedback and they just leave it for the 5 days and then the system automatically approves the order.

I don't think any of that should be changed... but what about offering some sort of incentive to buyers to approve orders as soon as possible, simply because it is nice for the sellers to get their orders approved quickly. But more importantly also offer an incentive for the buyer to give honest feedback on the orders whether it be good or bad.

I think that if more buyers approved orders quickly and most importantly gave honest feedback it would benefit the entire community of buyers and sellers.

When I am looking for sellers I always look at the feedback and go through what everyone has said. It gives me good insight into how people feel about the quality of the services given.

I have often been tempted to purchase a service and didn't simply because I would have wanted to know more about the seller... and not from the seller, from others that have purchased before.

I don't know what sort of incentive would work but I know it would make me happy if I got some sort of benefit. I always check and approve orders immediately when I receive the email saying it is completed and I always give feedback. If the work is outstanding I leave a recommendation.



Are you sure you want to delete this post?

Everett
I'm kinda confused when you mention "approve" the order. What some sellers do is offer bonuses, or extra work for buyers that rate the order, this could potentially give the buyer an incentive to rate the order. I think there is already a discussion mentioning above so we can continue it there if you wish.



Are you sure you want to delete this post?

TwitterFollwerz
An IOS App would be pretty cool to see dont know if this was already answered though.



Are you sure you want to delete this post?

Everett
An iOS app would be quite nifty! However, it would take forever to program due to all the functions. And then you have to recode functions to fit other languages, and it's a big hassle. But hopefully one day we will have this app!



Are you sure you want to delete this post?

Order Now
Process Time: 9.8441479206085

Possible Duplicate queries found!
MatchCountSQLScript
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='17608'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='17608'

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

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

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

SELECT * FROM categories_faq WHERE CATID='39'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='39'

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

SELECT * FROM seoclerks.members WHERE USERID=29511SELECT googleplus_profile FROM seoclerks.members WHERE USERID=2951

/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=17608 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=17608 LIMIT 5

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='17608' 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='17608' 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=95995 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=95995 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=96009 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=96009 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=96015 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=96015 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=96016 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=96016 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=96020 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=96020 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=96128 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=96128 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=96221 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=96221 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=96274 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=96274 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=96290 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=96290 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=96358 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=96358 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=96804 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=96804 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=96840 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=96840 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=99774 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=99774 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=96185 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=96185 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=97380 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=97380 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=95987 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=95987 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=95996 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=95996 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=96001 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=96001 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=96007 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=96007 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=96012 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=96012 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=96004 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=96004 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=96069 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=96069 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=95998 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=95998 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=96000 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=96000 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=96003 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=96003 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=96179 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=96179 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=96779 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=96779 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=96002 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=96002 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=96014 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=96014 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=96018 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=96018 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=96025 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=96025 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=96017 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=96017 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=96023 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=96023 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=96031 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=96031 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=96150 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=96150 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=96366 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=96366 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=96050 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=96050 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=96367 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=96367 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=96026 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=96026 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=96034 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=96034 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=96039 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=96039 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=96152 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=96152 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=96223 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=96223 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=96368 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=96368 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=97427 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=97427 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=97500 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=97500 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=98596 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=98596 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=95993 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=95993 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=95997 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=95997 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=95999 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=95999 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=96005 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=96005 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=96066 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=96066 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=96159 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=96159 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=96194 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=96194 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=96369 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=96369 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=96405 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=96405 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=96175 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=96175 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=96224 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=96224 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=96325 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=96325 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=96370 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=96370 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=96372 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=96372 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=96487 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=96487 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=96841 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=96841 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=96653 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=96653 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=96972 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=96972 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=96710 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=96710 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=96778 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=96778 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=96842 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=96842 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=96873 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=96873 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=97483 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=97483 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=97067 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=97067 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=96918 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=96918 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=96952 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=96952 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=97377 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=97377 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=97662 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=97662 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='17608' AND status='1' AND (question like '% current website features enhanced improved?%' OR question like '%current%' OR question like '%website%' OR question like '%features%' OR question like '%enhanced%' OR question like '%improved?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='17608' AND status='1' AND (question like '% current website features enhanced improved?%' OR question like '%current%' OR question like '%website%' OR question like '%features%' OR question like '%enhanced%' OR question like '%improved?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='1628' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1628' 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=17608%' 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=17608%' 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='2951.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.jpg'

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

SELECT * FROM seoclerks.members WHERE USERID='254580.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.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='212316.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='212316.jpg'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='196749.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='196749.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.2205291SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (90) AND gtags like'%ming%' AND type !=99 0.2205290.220529