SEOClerks



Write the reason you're deleting this FAQ

Suggestion for WTB

Dont allow sellers to offer services through it.

For example I just got an email for this:
Title: I will Post unlimited Free Ads as im Electronics Telecom Engineer
Skills Required: HTML,Designing, blog, in, CMS,SEO,PHP,Javascripts,making, , , website, blog,wordpress,Marketing
Short Description: I will Post unlimited Free Ads as im Electronics Telecom Engineer...

Am I missing something or is that WTS and not WTB?

And add a report button so wtb's can be reported when they are just soliciting for purchases.

Comments

Please login or sign up to leave a comment

Join
seogawd
wow,

the thought of someone actually opening and reading a seo sales email and posting questions about here is about a sad as me thinking there was something to read here and posting this reply.



Are you sure you want to delete this post?

expertwebreview
Seoclerks sell space in emails. If those emails are spam then more people will opt out of them meaning Seoclerks are going to lose money.

Also feel free to not post, if this doesn't float your boat ;)



Are you sure you want to delete this post?

seogawd
well ok then mr. no sense of humor! why you so jumpy? you know we all got your back here.. dang... relax a bit and put the gun away, lol

that's interesting though - had no idear they did that - but no I normally do not open un-solicited sales mails if that's what you were taking about.

Im jeff by the way, nice to meet you webreview, you got another name you go by?



Are you sure you want to delete this post?

expertwebreview
Hi Jeff, I'm James. Sorry if I come across as an ass, but the emails are from Seoclerks WTB service, which of course, I dont mind. Its when I check the email and its not a WTB, but a WTS. Just turns me off (and I'm sure others feel the same) + I'm sure Seoclerks dont wanna lose money (who does right?)



Are you sure you want to delete this post?

ionicware
We don't allow users to do this. This particular user is nothing more than a spammer. Sorry for the inconvenience it caused - will add the report button as well.



Are you sure you want to delete this post?

seogawd
ahhh... allllrighty James, I think Im starting to get the picture here; now this thread makes sense to me

so just to catch up (been gone a while) seo-c is selling ad space in shotgun emails that are supposed to be directed at sellers here - the adspace is supposed to be reserved for "want to buy" ads - so the sellers can respond in a timely fashion etc etc.

but - the problem is, these emails which are directed at the sellers are actually containing "want to sell" ads from other sellers... right on right on, gotcha!

lemme take a sec to digest this here...

ok, I need a little more clarification without having to try and find this system on the site so help out if u dont mind..

who exactly is spending money on this ad system? the people getting the mail or the people who's ads are in the mail? or both?



Are you sure you want to delete this post?

seogawd
sup J, thanks for dropping in on this -

you replied as I was fishing around looking for this ad system for email ads--- couldnt find it.

im guessing by Jordans' reply that the problem here is someone who has circumvented the rules of the system and slipped through the cracks.

ok James, looks like Jman is on the case so I will bow out - but thanks for bringing the issue up all the same.



Are you sure you want to delete this post?

expertwebreview
Thanks Jordan and No worries Seogawd Suggestion for WTB



Are you sure you want to delete this post?

ionicware

im guessing by Jordans' reply that the problem here is someone who has circumvented the rules of the system and slipped through the cracks.


The user in this case created a bunch of WTBs as a service. When he entered a set of skills, it emailed everyone that claims they obtain these skills (in order to find likely candidates). Whether this was intentional or not, I couldn't tell as it wasn't spam for another website (they appeared to be valid services which were meant for the marketplace area).



Are you sure you want to delete this post?

Order Now
Process Time: 0.25659704208374

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

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

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

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

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12360' 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='12360' 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=58705 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=58705 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=58706 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=58706 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=58707 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=58707 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=58708 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=58708 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=58709 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=58709 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=58710 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=58710 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=58711 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=58711 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=58712 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=58712 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=58713 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=58713 LIMIT 5

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='20911' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='20911' 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 seoclerks.members WHERE USERID='17031' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' 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=12360%' 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=12360%' 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='46.gif'1SELECT profilepicture FROM seoclerks.members WHERE USERID='46.gif'

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

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

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

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

/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