SEOClerks



Write the reason you're deleting this FAQ

More moderators!!

This is great forum, but i guess we need more moderators from different time zones. Obviously we getting attacked more and more by spammers...

I am willing to help if need.

Comments

Please login or sign up to leave a comment

Join
seoguru24x7
Yes the spamming has been increased, need more security



Are you sure you want to delete this post?

webnesia
Simple get rid of unwanted categories here.. people tend to advertise and spam more on such categories..



Are you sure you want to delete this post?

topclassseo
Yes lots of people are spam here in this forum.



Are you sure you want to delete this post?

Asmodeus
Simple get rid of unwanted categories here.. people tend to advertise and spam more on such categories..

Removing categories won't stop spam, as the spammers will just post in another category. There was a bad spammer yesterday who posted crap in several categories. I reported it and @NaturalWriter got rid of it.

They probably should have at least 1 more active mod though, as there is rarely ever a mod online when I look around here.



Are you sure you want to delete this post?

NaturalWriter
We do the best we can. It wouldn't hurt to have one or two more, but that has to be done by admin. I also notice there are members who comment on the spam without reporting it. This shouldn't be happening. If you are commenting on spam, the you can obviously report it! We don't get reports, then it may not get noticed.

I have been busy lately, and I come in and out quickly. If there is nothing reported, then I assume all is OK for the moment. We all have to work together and learn how to click the report button.



Are you sure you want to delete this post?

taffy
I just do not understand why someone would not report spam? It is the least someone could do!



Are you sure you want to delete this post?

anwebservices
Yeah, current moderators doing very good job! We know that you guys can't be here 24/7, that's why i mention someone from different time zone... But yes, reporting helps anyway.



Are you sure you want to delete this post?

Beverly
Thank you for your concern.

@farahkhan has joined our staff as moderator and she is doing a very good job with moderating duties.

We are currently cleaning up many of the threads which had been over run with one and two word spam posts. This will take time. And, we thank you for your patience as we get this matter resolved.

Some forum discussions/responses may be deleted, moved, merged or locked, depending upon the situation. For instance, where a discussion has gone off topic or the OP is found to be a copy/paste from another site or if the post or discussion in some way violates forum rules.

Please report any spam in any form that you see as it helps us do our jobs better.



Are you sure you want to delete this post?

farahkhan
Staff members are now working very efficiently on forum clean-up and in past 72 hours we have gone through 5000-6000 posts and more than 600 active profiles and deleted spam over 400 and cleaned up many profiles containing spam links & many useless threads are moved to trash. Many resolved FAQs has been locked now and moved to resolved/archived to avoid spamming and promoting all member to post on newer threads where useful instead of old ones where discussions and problems are already solved . We are moving very fast on this and we assure you guys you will see our forum cleaned up very soon.
We are trying our best to give as much time as possible so that every member will get staff support round the clock More moderators!!
Thank you so much to all of you who have reported to spam , I really appreciate all of you who are contributing in this clean up mission ,As we are all here this is our home forum and we have to keep this in a good shape . We all are a part of this great forum.
You can contact us if you are having any trouble in this forum,We are here to help you, We will be more than happy to assist all of you More moderators!!

Regards
Farah khan



Are you sure you want to delete this post?

WinnersPBN
Removing categories won't stop spam, as the spammers will just post in another category. There was a bad spammer yesterday who posted crap in several categories. I reported it and @NaturalWriter got rid of it.

They probably should have at least 1 more active mod though, as there is rarely ever a mod online when I look around here.


Agree. Removing categories is not the solution. And it will also spoil this wonderful forum.



Are you sure you want to delete this post?

Beverly
We are currently going through the Service Review section to delete threads that don't have a seller link. Older reviews are being locked as they don't require any further comment.

Agree. Removing categories is not the solution. And it will also spoil this wonderful forum.


Some less active subforums are being merged or deleted as they never or rarely receive posts.



Are you sure you want to delete this post?

WinnersPBN
We are currently going through the Service Review section to delete threads that don't have a seller link. Older reviews are being locked as they don't require any further comment.



Some less active subforums are being merged or deleted as they never or rarely receive posts.


I think a poll should be conducted in this regard. If more buyers and sellers think that these less active subforums should be deleted or merged then only the admins should go for this decision.



Are you sure you want to delete this post?

jabed92
I think a poll should be conducted in this regard. If more buyers and sellers think that these less active subforums should be deleted or merged then only the admins should go for this decision.

I think they took the right decision and staff here is smart enough to judge what is good for this forum .They have done a tremendous work in past few days , I have seen a very great change in forum in these few days I appreciate all the moderators and and admins of staff that they are making this place so nice for us .



Are you sure you want to delete this post?

Beverly
I think a poll should be conducted in this regard. If more buyers and sellers think that these less active subforums should be deleted or merged then only the admins should go for this decision.


In a way, the SEOClerks community has already voted on this decision.

Hopefully, this will help you understand our thinking on this situation.

https://www.seoclerks.com/forum/th...m-updates.10584/



Are you sure you want to delete this post?

webexpert1313
Hello, "anwebservices". I am agree with your thoughts, here more and more spammers coming and sending more unuseful articles and comments.

If seoclerks allowed me, i am agree to do works as a Moderator, BUT i need extra benefits from seoclerks..

Hope Seoclerks agree !! Then i will start !!



Are you sure you want to delete this post?

NaturalWriter
Hello, "anwebservices". I am agree with your thoughts, here more and more spammers coming and sending more unuseful articles and comments.

If seoclerks allowed me, i am agree to do works as a Moderator, BUT i need extra benefits from seoclerks..

Hope Seoclerks agree !! Then i will start !!

There are no extra benefits to being a mod. They do it because they want to help clean up the community for everyone.



Are you sure you want to delete this post?

chetaseo
i can see that the spam has reduced as the mods are now doing great job here. but we may need more moderators to help the existing more to monitor this site.



Are you sure you want to delete this post?

viewss
mod mast be smarter than Spammer!



Are you sure you want to delete this post?

chetaseo
I am sure seoclerks moderators, Admins are so good. they always try to help their community. I am so appreciated to seoclerks Moderators & Admin.

you are very right but we may still need more moderators but it all depends on the admins to decide on that.



Are you sure you want to delete this post?

Order Now
Process Time: 0.5326828956604

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

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

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

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

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12289' 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='12289' 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=58101 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=58101 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=58102 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=58102 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=58103 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=58103 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=58104 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=58104 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=58105 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=58105 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=58106 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=58106 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=58107 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=58107 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=58108 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=58108 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=58109 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=58109 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=58110 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=58110 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=58111 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=58111 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=58112 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=58112 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=58113 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=58113 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=58114 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=58114 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=58115 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=58115 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=58116 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=58116 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=58117 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=58117 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=58118 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=58118 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=58120 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=58120 LIMIT 5

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12289%' 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=12289%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

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

SELECT * FROM categories1SELECT * FROM categories

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

select * from categories_software order by name asc1select * from categories_software order by name asc

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

select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

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

select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

select * from 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.1375181SELECT 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 '%trafiic%' OR A.skills LIKE '%trafiic%')0.1375180.137518