SEOClerks

We should be Promoting Seoclerks even more



Write the reason you're deleting this FAQ

We should be Promoting Seoclerks even more

Right well to start off by saying I have started promoting seoclerks even more now I just made a animated video about seoclerks . Soon as its uploaded to YouTube going to work on promoting the video . We should all work harder on promoting seoclerks and get more people into this business . Let us become even more popular before 2018. Who is promoting anyway ? and do You think it is a good idea doing videos.

I do think facebook should allow us to use seoclerks links on there now that seoclerks doesn't do facebook services. Who agrees with me.

Comments

Please login or sign up to leave a comment

Join
idealmike
Oh nice! I admire your enthusiasm it's infectious! lol We should be Promoting Seoclerks even more Wow if just more people was like that and done that just think and imagine if everyone on here done that and promoted SEOClerks on YouTube more and more we could have almost as many users here as cough cough fivr do lol. Now that would be epic! And that would mean soo so many more sales for everyone too. More buyers, more sellers, more sales, more business more earnings for yourself, for everyone! Why SC doesn't have the same amount of users still is beyond me when SC is clearly a much better site which has so much more flexibility to stretch and grow on here for sellers and a wide diversity for buyers. Not to mention lots of features that they don't as well so it's either a mystery or a conspiracy but they are often both so greatly intertwined!

And yeah I think doing videos is a good thing! 2016 was dubbed "year of the video". And it's the leader when it comes to what people prefer these days as they are much more entertaining to watch and can be much more insightful and informative than just words on a page can.
I do think facebook should allow us to use seoclerks links on there now that seoclerks doesn't do facebook services. Who agrees with me.

You can now use SEOClerks links on Facebook again! Not many people know this. (I guess you haven't tried in ages). But you can now post seoclerk.com seoclerks.com links to Fb again including your SEOClerks affiliate links too! So get posting and promoting! But don't spam it or they might disable the links again and I wouldn't want to be the one that was found out to be the cause of that! We should be Promoting Seoclerks even more

They also restored the official SEOClerks Fb page and there is now an official SEOClerks Fb group too but it needs more members. Search for it on Fb and you'll find it. We should be Promoting Seoclerks even more



Are you sure you want to delete this post?

keen2write



Are you sure you want to delete this post?

robertman11
That is fantastic! If you upgraded powtoon, would it remove the "Created using Powtoon" logo in the bottom right?



Are you sure you want to delete this post?

Drake83
That is awesome, nice work!



Are you sure you want to delete this post?

ridhyChandro1
Very good idea, i also with you, if need you can knock me.



Are you sure you want to delete this post?

keen2write
Do you have the link to the group . I will post the video in it yeah i know what site your on about cough cough lol. Its well expensive on that site. Well my video pulls that site down and makes seoclerks look like a golden chalice lol Seoclerks is well better . Here is to 2018 soon lol and hopefully we will have more members on here .

I been making few videos am using trial version like but am enjoying it and may upgrade to it . I am making a cartoon promoting this site as it deserves the attention. This site as helped me in many ways then one so am helping seoclerks.About the facebook group tho is facebook allowing the links of seoclerks to be posted now if not ill message them my self and have a go at them as its not fair people say facebook helps businesses but they can't be if they blocking there links from been posted.



Are you sure you want to delete this post?

keen2write
Sorry just read again and didn't notice you put can use seoclerks link again lol It's me am not with it today lol



Are you sure you want to delete this post?

robertman11
That is fantastic and I agree 100%, as long as the promotion isn't spam. What is the link to the video that you made?



Are you sure you want to delete this post?

keen2write
I will share the link in a moment to the video as need to edit it as left a few things out We should be Promoting Seoclerks even more



Are you sure you want to delete this post?

keen2write
I am uploading to youtube right now so once its finished upload I will show the video link here . I used the free version of powtoon to create it . If you all like the video then am hoping when I have enough cash lol to upgrade with powtoon and create video cartoon services for other members on seoclerks.



Are you sure you want to delete this post?

keen2write
The video is at the top as anyone watched it yet what do you think. Yeah if I upgrade it removes the watermark feature .



Are you sure you want to delete this post?

robertman11
I love it! I'd buy some video services from you, if you intend on creating them here.

BTW, hit the "Reply" link/button in the top right of a message to reply directly to that person and put your response underneath and indented to theirs (like this one).



Are you sure you want to delete this post?

keen2write
Yes i will be making some video services soon as I upgrade . As am just messing at moment creating videos in trial version but its good software for creating videos. Also lets you do whiteboard and many other features . Just abit pricey but I will be upgrading soon real soon.



Are you sure you want to delete this post?

OptimismSEO
Hello,

I appreciate the initiative; a small step can lead towards a big one and at the end of the day we all benefits from this.

I am really impressed with your action, getting people into SEOclerks can be massive, especially in today’s time where the unemployment rate is rising day by day, more people are joining to earn a living and many still not getting any work, getting more people will not only benefit the service creators but also will increase seoclerks revenue. More buyer means more selling it’s a win win situation for everyone.

I think I would like to address this, you’re actually doing it for the future use, I don’t think anyone would have done it, everyone is busy doing their own things, including myself, but seeing the necessary step that you have taken to secure a place in the future really inspires me.

And not to mention I like the video as well like others, it clearly defines its objective, it’s short and simple, classy and professional. This type of video will keep the audience engaged



Are you sure you want to delete this post?

Order Now
Process Time: 0.80278182029724

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=3220731SELECT googleplus_profile FROM seoclerks.members WHERE USERID=322073

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='21699' 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='21699' 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=115076 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=115076 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=115093 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=115093 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=115096 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=115096 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=115188 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=115188 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=116136 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=116136 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=115080 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=115080 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=115081 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=115081 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=115090 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=115090 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=115091 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=115091 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=115092 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=115092 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=115097 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=115097 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=115100 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=115100 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=115103 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=115103 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=115177 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=115177 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='21699' AND status='1' AND (question like '%We Promoting Seoclerks more%' OR question like '%Promoting%' OR question like '%Seoclerks%' OR question like '%more%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='21699' AND status='1' AND (question like '%We Promoting Seoclerks more%' OR question like '%Promoting%' OR question like '%Seoclerks%' OR question like '%more%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='1159' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1159' 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 11SELECT 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 seoclerks.members WHERE USERID='498' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='498' 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=21699%' 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=21699%' 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='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='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='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='6289.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='6289.jpg'

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='541270.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='541270.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
0.3813392SELECT 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.1915340.189805

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.3294581SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.viewcount desc LIMIT 0,400.3294580.329458
0.1906702SELECT 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.1915340.189805