SEOClerks

Clear
Sign In Join

Highlight and category featured posts?

  • Lynne Level 1
    • 16

    Write the reason you're deleting this FAQ

    Highlight and category featured posts?

    I have seen that there are options to have my services highlighted and also to have them as category featured posts.

    I am interested to know whether you think this would make a huge difference to my sales for the services I have added.

    What is personal experience with paying to promote your services here?

    Has it been worthwhile and have you had a huge jump in sales?

    I don't mind spending the money at all to do this but I just wonder if I would make sales and how quickly they would come in if I did it?

    Share your thoughts please.

    #Highlight #Category #Featured #Posts Freelance
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    hitmeasap

    hitmeasap

    The highlight feature will do exactly what it says. It will highlight your service listing and that will automatically attract people as it stands out. It's easier to see it and as it's something different, people will often take a look out of curiosity. - That being said though, it all comes down to your service. No matter if you use the highlight feature, the monthly feature or a category feature.

    If you can attract clients without any of these features, then it might be a good option to use the features to attract even more potential clients. You should also have the competitors in mind. If they highlight an identical service, you might end up with less results. If any of your competitors are using the category feature, then you might get less results.. - Well, common sense actually.

    I've been here long enough to see that even the monthly feature have ended up with poor results for some sellers.. But that's not the features fault. It all comes down to the service.. And the potential clients. - That being said, most of the times, any promotion like this will boost your results. Even if it's just a little bit.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thans Andre, yes I know what you mean. Just because you advertise does not mean you will get any ROI or any sales even for that matter.

    I think I will wait a bit and do some of my own marketing first.
    10 years ago

    Are you sure you want to delete this post?

    TommyCarey

    TommyCarey

    Well, as you may know, I don't sell any of my services here. Mainly because I charge way too much compared to everyone here lol Highlight and category featured posts?

    But I have paid for ad spots on popular forums in the past and they offered a featured highlighted section which I sprung for. By doing this I saw a lot more sales per day just because my service was shown a lot more compared to a basic listing.

    Here on SeoClerks I can see how the feature positions would be a huge boost in sales because people usually type in SeoClerks.com to their address bar and come right to the homepage. This is where you'll get the boost in traffic to your service because it will be one of the top few that are shown before the basic listings. If your service is top notch and you have a few good reviews already, I would see you getting 10x the amount of sales than if you had a basic listing.

    Just think about it, you're posting your service that goes next to, above, below, etc. to a bunch of other services that are similar. Now these other services may not be as good as yours is, but you could get lost in the sea of similar service providers. By purchasing the featured listing for your service you will stand out and funnel sales Highlight and category featured posts?

    Another trick you can do is buy one featured listing for one of your services and increase your sales across all your services. To do this all you have to do is link all your other services within your service description. Sort of like a "Check out my other services below" and link to them. You can also add all your services to your order page where people have to submit their info for the current job. This will show them they can purchase other services from you and in turn it will increase your sales Highlight and category featured posts? Oh! Another thing you can do is to link to all your services in your completed project page. You know when you submit the work to be accepted for completion? Yup, there Highlight and category featured posts?
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Hi Razzy

    Thanks for all these tips! Yes I think that is what I am going to start with, letting people know about my other services in each service. They are all similar, just different social networks so if someone is interested in one of my services then very likely they will be interested in all of the,.

    Ok so that is the first thing I will be doing and then I will be thinking about paid advertising. I first want to see what effect it has making that small change first.

    Nice one!
    10 years ago

    Are you sure you want to delete this post?

    EliteWriter

    EliteWriter

    I never tried them out to be honest as I got orders simply with the help of free bumps and through regular orders from some clients. They might help as they make your service stand out a bit, but ultimately it is all about if there are people who might be interested in your service, if the pricing is right, and your reputation / if you can offer a really good service, that effects how successful you are and how many orders you get. At least that is what I believe. However there is obviously nothing wrong to try them out to try to boost sales.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thanks EliteWriter. Yes I think I already have a regular client for my services, she has ordered 2 out of the 3 already which is really awesome. I am still needing to add some more services and then I will do promotion of these via my own website and social media first for a bit.

    I got some really great tips from Razzy now which I think will be really helpful to implement first.
    10 years ago

    Are you sure you want to delete this post?

    procoder

    procoder

    I've never used them, I've used only free and paid bumps so far. However, I think that depends on your service and the category where you have added it, if it's a big category that people visit it too often then definitely it will give good results.

    Now that I read your CD I'm thinking to do the same thing for my services.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thanks for your thoughts Procoder Highlight and category featured posts? I will wait a bit and see how my services fare with free bumps for a bit.
    10 years ago

    Are you sure you want to delete this post?

    MusicMoguls

    MusicMoguls

    I Absolutely think it helps a new seller or a vet the same way. Like CDRocks mentioned above you get more visibility and you are put at the top when you category feature. I know some shoppers personally will check categories and pick whoever is at the top. Competition plays a small role but not big i am currently offering a unique service and far less plays than the competition at almost triple the price yet i manage to scrape up a few sales a day. I think its because more people can see my listing above all it shows that your a dedicated seller. highlighting a service is good but only if you bump n a regular basis because unlike category feature this does not put your service at the top of the list only makes it stand out. I Also think that bumping your services wisely is key to success. If your competition is bumped wait until they fall a bit to bump your service this creates more of a market if you bump at the same time its more of a waste of a bump.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Yes I've been watching how it all works and I am taking note of everything. It really is an interesting experience being a buyer here now!
    10 years ago

    Are you sure you want to delete this post?

    Cristian

    Cristian

    Think very careful about purchasing any feature services of highlight features. You need to make some calculation, like how many orders would you need to break thing even and how more order would you need to turn a profit around?
    This is the kind of things you would need to think about.

    If you are getting more than 20 order per month on a service that you only bump once in a while, that service may have huge potential if made featured, so think about it, be ready to deliver a lot of order if you get them and learn that your goal is actual ROI.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thanks Cristian, yeah I think I do need to think about that. I have had a few orders but I am so short on time that it may turn problematic for me if I get too many orders LOL. I wouldn't want to get so many orders that I have a problem delivering them!
    10 years ago

    Are you sure you want to delete this post?

    cdrocks

    cdrocks

    It really depends on what your competition is doing I find the more I stand out the more sales I get! If I were you I would pay to just highlight your most popular service and then keep bumping it up in it's category. The highlight is only a $19 gamble that is good for a month lol. Don't be afraid to experiment Highlight and category featured posts?
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Yeah I think it would be well worth giving it a shot, even if it doesn't even give me my money back in sales it will be worth it, maybe I will be raking in the sales?
    10 years ago

    Are you sure you want to delete this post?

    ourseo

    ourseo

    hello..i want use highlight.....can it work for me ? any help
    8 years ago

    Are you sure you want to delete this post?

    Corzhens

    Corzhens

    This reminds me of a site that is an e-commerce which is like Amazon. I have noticed that some of the products are always on the home page and they also appear on the side bar like an advertisement. One friend said that it gets a lot of “hits” when your product is advertised like that so it is worth the cost that you pay to have your product featured in the homepage.
    7 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 1.1574339866638

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=3066321SELECT googleplus_profile FROM seoclerks.members WHERE USERID=306632

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19820' 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='19820' 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=108204 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=108204 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=108222 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=108222 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=108205 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=108205 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=108221 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=108221 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=108211 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=108211 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=108223 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=108223 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=108265 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=108265 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=108277 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=108277 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=108267 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=108267 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=108278 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=108278 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=108350 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=108350 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=108373 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=108373 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=108241 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=108241 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=108260 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=108260 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=149883 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=149883 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=167897 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=167897 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='19820' AND status='1' AND (question like '%Highlight category featured posts? %' OR question like '%Highlight%' OR question like '%category%' OR question like '%featured%' OR question like '%posts?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='19820' AND status='1' AND (question like '%Highlight category featured posts? %' OR question like '%Highlight%' OR question like '%category%' OR question like '%featured%' OR question like '%posts?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='17457' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='17457' 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=19820%' 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=19820%' 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='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='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='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='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='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='139192.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='139192.png'

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='375186.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='375186.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.2539781SELECT 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 (16) AND gtags like'%O%' AND type !=99 order by A.lastgigedit desc limit 120, 400.2539780.253978
    0.1041891SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 53897 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Traffic Youtube Seo Adsense Views Organic%' ) LIMIT 40.1041890.104189