SEOClerks

Clear
Sign In Join

Why is the Want to Buy so full of spam?

  • Topseoservice Level 3
    • 17

    Write the reason you're deleting this FAQ

    Why is the Want to Buy so full of spam?

    I have some suggestion regarding WTB category. There has to be some quality control in this section also.
    I have noticed many 'newbie' place their bid in this section. For example the client is requiring something specific, but the bids are completely out of context (specially from new sellers). I am quite sure potential clients will get 'irritated' by these out of context bids which is not a good sign for growth of SeoClerks. For instance, if a buyer wants an article written but a seller is bidding for Youtube likes? How can we stop this?

    #Suggestions #Feedback Suggestions & Feedback
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    aqibarif74

    aqibarif74

    Hello,

    Thanks for your question.
    I would suggest Ionicware make 10 sales requirement to bid in WTB section.
    When sellers reach 10 sales. They will be able to bid in WTB. If they still do.
    They will be punished. To make 10 sale requirement. It will stop newbie to bid in WTB.

    All the best,
    9 years ago

    Are you sure you want to delete this post?

    lvlrgreen

    lvlrgreen

    I agree with this statement whole heartedly. I am a power buyer and when i create the WTB the spam of other services is bad. I mainly deal in the YouTube side, I could only imagine what the rest of you are going through.
    9 years ago

    Are you sure you want to delete this post?

    aqibarif74

    aqibarif74

    Thanks for agreeing with me.

    I look forward Ionicware to make it happen.


    All the best,
    9 years ago

    Are you sure you want to delete this post?

    robertman11

    robertman11

    This seems like a good idea. We have plans to allow buyers to restrict who can bid by level. For example, you could select an option that allowed only Level 2+ or Level 3+ users to bid. Thoughts?
    9 years ago

    Are you sure you want to delete this post?

    TheoSEO

    TheoSEO

    Great suggestion Robertman11! Restriction by Level would be the best and the easiest to implement. As the person mentioned, i also got irritated a lot of times and simply stopped using the WTB section. Finally, if we get rid of this type of SPAM, it can actually start working properly.

    Level 2+ should be enough though... Why is the Want to Buy so full of spam?
    9 years ago

    Are you sure you want to delete this post?

    idealmike

    idealmike

    Yeah those out of context bids really get my goat too. Especially when I'm the one making the WTB for something, and I even state not to bid for anything other than I'm asking for. Yet people just blindly go and post something else that's not even related. I sometimes get annoyed by this and end up messaging them and in blunt words asking them if they can read and asking why they felt the need to bid on my WTB for something that I wasn't even asking for. Most times I just get the same response of "sorry sir" lol. But it's frustrating because it just dilutes the WTB and then you have all these bids on it that aren't even related to what it is you're asking for like what!

    I got so annoyed with it that I ended up creating a post about it.

    See How to Bid on People's WTB's and WTT's Be Hired and Get Work as a Freelancer. I wish more people would read that! Why is the Want to Buy so full of spam?
    9 years ago

    Are you sure you want to delete this post?

    Everett

    Everett

    That's the thing, people just don't read. They just care about placing the bid, and hoping to be selected. I think it's countries where they can live in pennies a day because usually the quality, and the price of the bid is so low you think to yourself, wow, are they actually going that low? I don't often purchase things, but if I did I wouldn't purchase PHP programming work for say, $1. LOL.
    9 years ago

    Are you sure you want to delete this post?

    idealmike

    idealmike

    I know peanuts is what they are and peanuts is what they work for lol ;)
    9 years ago

    Are you sure you want to delete this post?

    Everett

    Everett

    Why is the Want to Buy so full of spam?
    *spits coffee on laptop screen*

    Thanks! Have to hope to the tech gods i wont fry my screen out.

    But it's honestly sad really, that they are so desperate they are willing to do things for that much. :/
    9 years ago

    Are you sure you want to delete this post?

    Artois52

    Artois52

    I agree totally. I am often put off making a proper bid, just because of all the spam
    bids that have already been made.

    I really can’t see someone new to SEOClerks being very impressed with lots of spam
    offers, and I know that if I were a buyer, I would give up after the first few irrelevant
    offers, and just not bother with SEOClerks again.

    I like the idea of having to have completed 10 orders before you can bid. How about going
    a bit further and making it 10 completed orders in the category relevant to the WTB?

    At least then a bidder would have to have some kind of relevant track record before they can make a bid.
    9 years ago

    Are you sure you want to delete this post?

    Everett

    Everett

    I do not frequent the Want to Buy section that much so I am a bit out of the loop as to what goes on there. A previous user had mentioned that a new user must have 10 sales to be able to bid, however why not just make it to where they have to be level 2?

    The thing about the Want to Buy section is that many new users use that feature to upgrade their user level quickly by bidding on Want to Buy ads and hoping the buyer chooses their bid. Every site that has a level/rank system gets spammed by users that want to quickly upgrade their account so it's fairly common practice.

    However, if there were to be restrictions this would result in buyers having to wait additional time for more established sellers to bid on their ad. As a buyer, especially on this marketplace, you want to find a seller as quickly as you can. I suggest a feature to report certain want to buy bids, like the option to report a want to buy ad itself. I do not think the marketplace should limit users from bidding on ads placed by buyers that want a service.

    I also haven't placed a want to buy ad in so long I forgot what features the WTB creator has.. lol
    9 years ago

    Are you sure you want to delete this post?

    keen2write

    keen2write

    I totally agree as well, As in the past I have placed stuff into the WTB section and get a lot of it filling up with non related items for bids. If ok to mention as well spam needs to be sorted through inbox meaning if there will be a way in the future to block that would be handy. As some sellers see you buying and leaving feedback from services and then all of a sudden a lot of newbies send inbox's telling me to buy backlinks... It gets annoying as if I need backlinks I would look for this service I don't need inbox's telling me to do anything.

    Does anyone else get random inbox spammy messages. ??
    9 years ago

    Are you sure you want to delete this post?

    Everett

    Everett

    I get spammy inbox messages on occassion. I never reply to them, and simply archive the message. If they contact me again I'll most likely report it, or archive their message again. They don't pester me too much, and hopefully I am not pestered in the future. *knocks on wood* This is where a block feature could in handy as well, but the marketplace doesn't have this option.
    9 years ago

    Are you sure you want to delete this post?

    keen2write

    keen2write

    Well maybe in the future we will see this feature on seoclerks. Here's hoping.
    9 years ago

    Are you sure you want to delete this post?

    keen2write

    keen2write

    Also I have noticed I always thought with the WTT is to actually trade services you always get members trying to sell you stuff on there as well. A while ago I was going to trade twitter retweets for something can't remember as it was a while ago. But I wanted to trade and had members saying " Buy subscribers from me " I didn't want to buy anything let alone subscribers .
    9 years ago

    Are you sure you want to delete this post?

    robertman11

    robertman11

    Thanks for the suggestion and reporting. I posted this above in response to aqibarif74 but will post again here:

    We have plans to allow buyers to restrict who can bid by level. For example, you could select an option that allowed only Level 2+ or Level 3+ users to bid. Thoughts?
    9 years ago

    Are you sure you want to delete this post?

    Corzhens

    Corzhens

    My take on those suspected spam on the want-to-buy posts is the lack of English knowledge or maybe there is a language barrier. Most of the newcomers to this site think that this marketplace is a mine of gold since there are far too many buyers that they can sell their product or service. Unfortunately some of those newbies have no product or service to sell but just fence sitting, so to speak.
    7 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.60543203353882

    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='22118'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='22118'

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

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

    		/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=80291SELECT googleplus_profile FROM seoclerks.members WHERE USERID=8029

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22118' 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='22118' 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=115908 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=115908 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=115909 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=115909 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=115910 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=115910 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=115999 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=115999 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=116009 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=116009 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=115936 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=115936 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=115938 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=115938 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=115941 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=115941 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=115945 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=115945 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=115914 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=115914 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=115920 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=115920 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=115939 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=115939 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=115940 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=115940 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=115942 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=115942 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=115946 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=115946 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=116001 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=116001 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=170051 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=170051 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='22118' AND status='1' AND (question like '%Why Buy full spam?%' OR question like '%full%' OR question like '%spam?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='22118' AND status='1' AND (question like '%Why Buy full spam?%' OR question like '%full%' OR question like '%spam?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    		/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='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='296516.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='296516.png'

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.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.4736991SELECT 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'%booklogo%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4736990.473699
    0.0945461SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 6842 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Need to post advertising on big FB pages%' ) LIMIT 40.0945460.094546