One big article every week - 2018 personal blog challenge

Cristian Level X³

January 6, 2018, 11:20 am

15

Write the reason you're deleting this FAQ

One big article every week - 2018 personal blog challenge

Giving the fact that brand new year just started a few days ago, I want to start a personal challenge in 2018, and I'm gladly advising you to set similar goals.

My goal is to write one big article per week on my personal SEO blog. I started my blog back in March 2017, and I haven't written as much as I wanted over there.

I did fix up all the design, user experience and programming problems and errors, everything is up to date and looks nice, I just need to create content.

Why do I need a personal blog for you may ask?
Well if you are working on anything related to the online industry, I believe you should have a personal website. It is just like having a business card or a social media profile, but you have the opportunity to control everything and show off your skills and knowledge.

I'm not doing it out of pure pleasure. I just need it. Sometimes, such a website can be a CV on steroids and may open a lot of doors for you. Not to mention the opportunities it provides for you to connect with other people in your industry.

We all need to evolve and reach an entirely another level in 2018.
What is your goal? Share your "challenge" in the comments below!

Comments

Please login or sign up to leave a comment

Join

TommyCarey

NEW YEAR NEW ME!!!!!

I've actually set up a few challenges for me, one of them being to get some whales on board for content writing

One big article every week - 2018 personal blog challenge

I've already gotten one, but I was working on them since October of 2017 and they signed on the first of January 2018. I assume that after I get some content rolling out for them I will get more whales on my radar, since I can use them as an example of what I can do for big corporations

One big article every week - 2018 personal blog challenge

Another goal of mine is to hit $100,000 profit in a year as quick as possible. If you do the math, that's $273.97 per day, which isn't entirely unobtainable. That's 3 SEO clients at $3,000 a month or 10 at $840 a month, which I can easily get on board if I do the right marketing and build up my company the best way I know of

One big article every week - 2018 personal blog challenge

Now, that's just with SEO, that doesn't factor in my affiliate sales, content writing profits, consulting, my niche websites selling a service, or my future physical product that I hope to start pushing this year

One big article every week - 2018 personal blog challenge

My goal is $100,000 in a year, but I'm going to do whatever I can in order to hit that mark as soon as possible, and if there's enough time in the year I might even increase it to 125k or 150k

One big article every week - 2018 personal blog challenge

It's a long shot since it's only the 7th and I'm technically behind the $273.97 per day, but I can still keep pushing to boost my profits and get as many clients on board as possible

One big article every week - 2018 personal blog challenge

I hope everyone else has similar goals and isn't going to just waste their entire year on pointless things like partying in the city or going out to bars with friends to get drunk

One big article every week - 2018 personal blog challenge

- Razzy

8 years ago

Are you sure you want to delete this post?

JoeMilford

This is a really cool idea--I do something similar, but only for a month, for National Poetry Month, where you have to write an original poem a day for the entire month. I think that anyone serious about his or her blog should do at least one entry per week, and this is a great challenge to keep all of us on point. I know that i could use a bit of a push in this department, and this is a challenge I would gladly accept. This might end up creating more disciplined practices, in terms of blogging, for some of us who do need a bit more motivation at times.

8 years ago

Are you sure you want to delete this post?

Corzhens

A blogger should be writing at least 2 blogs in a week so that the regular readers have something to look forward to in a matter of days. If you post only once a week on your blog then there is a tendency to lose some of your readers. However this challenge is still a good way of nudging the bloggers to at least write. I know that some bloggers lose time and interest particularly when the blog gets just a few readers.

7 years ago

Are you sure you want to delete this post?

augusta

This is a great one for you,I believe it always a good one to always specifically state our goals if possible just one big one that can be achievable.it still early in the year and making great goals or a big one should be on one's mind, so as to be successful, I think for me is to make more money online.Complete tasks on time and beat deadlines.This has always been a problem but I have decided to do away with it.My set goal to achieve.

8 years ago

Are you sure you want to delete this post?

mildredtabitha

Nice goal and I wish you good luck. I haven't set goals yet but I will in March or April. I just want to be done with the postponed exams solve some minor things in school then focus on other things and make goals. So in short words, I want to remove some pending issues from my mind and be open minded to other things. So I will need two to three months to do so. I suppose it is already a short term goal even if I don't want to call it a goal.

8 years ago

Are you sure you want to delete this post?

Barida

My challenge this year is to start off a blog and try as much as I can to make it popular around the niche that I plan to run it on. The thing with doing so is that it is going to assist me write my contents and post it there and see how the visitors will rate it at the end.

8 years ago

Are you sure you want to delete this post?

overcast

I think one big article can bring a lot of traffic over a period of time. You can see that there are plenty of people making use of the social media. And if you write 1000 word article every single day. You can reach more people in due time. That's something we have to consider in case of the blogs and the writing challenge. I'd say this can be a good challenge of making 52 posts in entire year. Surely it is a good project.

8 years ago

Are you sure you want to delete this post?

vhinz

Having your own blog can really help you attract more opportunities online. I actually just started my blog two months ago. It is my goal to write more content in this year and of course, I'm hoping that my blog could help me generate passive income.

8 years ago

Are you sure you want to delete this post?

peachpurple

that is a One good goal for you. I am planning to continue writing Hubpages for my recipes, I had stopped writing for 1.5 years, need to write one recipe per month

8 years ago

Are you sure you want to delete this post?

Baburra

I think this is a good idea and it's just the right amount for a challenge for a whole year. I myself have a blog and put out articles twice a week, but I wouldn't consider them big articles and I think if I were new at this and would just make a personal blog, this might be how I would go about it as well. I think it's a great idea and the reasons you have behind it are very sound so I wish you luck and hope to see your site when it has a lot of content on it already.

8 years ago

Are you sure you want to delete this post?

Corzhens

Wow, that big article every week is a big challenge if you are not a professional blogger. What I mean is if you have other things to do regularly like an office job then that big article is a daunting task. But I like your positive outlook to start the new year with a bang in terms of work. And it looks like you are determined to reach your goal and I’d say good luck to you. Please post an update of the development and I want to see your blogs.

8 years ago

Are you sure you want to delete this post?

kgord

I think this is a great idea, but I am wondering what you mean by a big article? How long will it be? What sorts of things do you need to do to make it happen? Are you talking about 2,000 words or what? What makes a long article? I wish you luck with this.

8 years ago

Are you sure you want to delete this post?

vinaya

Last year I created a couple of websites in order to flip and make quick money. sadly, I was unable to sell my website. This year I have made a goal "not to sell" my websites instead work on these websites and earn me revenue. One of my websites that I intended to sell is an affiliate website, I am thinking to change it to ecommerce website. I think I will do dropshipping, which I have never done. My another big goal for 2018 is to launch a front store for my online store.

8 years ago

Are you sure you want to delete this post?

DenisP

I'm actually working on a similar goal myself. Long story short, I would definitely like to get into blogging. If not to make a profit from it, then to at least have a website that exhibits my writing skills so I can potentially attract more clients in my freelancing endeavors. I haven't gotten started on the blog itself, but what I have been doing is motivating myself to write at least 1,000-2,000 words a day, as a means of stretching my creative muscles and accustoming myself to writing effectively about different topics. So far, that goal has been going well for me. I hope you succeed in all the goals you've set for yourself!

8 years ago

Are you sure you want to delete this post?

jaymish2

I'm writing this at nearly the end of 2018. I like this goal, it's big ambitious but very achievable. I’ve already started working on my 2019 goals. I like the idea of writing one big article per week however. I don't plan to put it on my blog but an article site where I can sell and hopefully make some money eventually from it. In 2019 i plan to make some serious money from affiliate marketing. The years 2018 was my chance to learn and sort of put my feet in the water now I plan to get very serious about it. I have made a bit of money not a lot. The point is that I know I can do it.

7 years ago

Are you sure you want to delete this post?

Process Time: 1.2905049324036

Possible Duplicate queries found!

Match	Count	SQL	Script
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='25273'	1	SELECT 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='25273'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='134'	1	SELECT * FROM seoclerks.members WHERE USERID='134'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM categories_faq WHERE CATID='55'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='55'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM seoclerks.members WHERE USERID=134	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=134	/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=25273 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=25273 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='25273' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT 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='25273' 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=147110 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147110 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=147049 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147049 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=177477 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=177477 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=147064 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147064 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=147069 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147069 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=147082 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147082 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=147091 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147091 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=147094 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147094 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=147103 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147103 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=147152 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147152 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=147156 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147156 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=147179 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147179 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=147260 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147260 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=149572 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=149572 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=171030 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=171030 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='25273'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='25273'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='25273' AND status='1' AND (question like '%One big article week - 2018 personal blog challenge%' OR question like '%article%' OR question like '%week%' OR question like '%2018%' OR question like '%personal%' OR question like '%blog%' OR question like '%challenge%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='25273' AND status='1' AND (question like '%One big article week - 2018 personal blog challenge%' OR question like '%article%' OR question like '%week%' OR question like '%2018%' OR question like '%personal%' OR question like '%blog%' OR question like '%challenge%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='147' limit 1	1	SELECT 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='1220' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1220' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='184' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='184' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1364' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1364' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='7' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='7' 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=25273%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=25273%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * 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 asc	1	select * 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 asc	1	select * 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='19821.png'	1	SELECT 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='603739.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='603739.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='634003.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='634003.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='617077.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='617077.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='589438.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='624598.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='624598.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='598910.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='598910.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='615678.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='615678.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='585810.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='601667.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='601667.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time	Count	SQL	Max	Min
0.203134	1	SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID	0.203134	0.203134
0.126693	1	SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Advanced%' OR A.skills LIKE '%Advanced%')	0.126693	0.126693