SEOClerks

Happy New Year 2017 SEOClerks! Let's rock 2017!!



Write the reason you're deleting this FAQ

Happy New Year 2017 SEOClerks! Let's rock 2017!!

Hello and happy new year 2017 SEOClerks!

Happy New Year 2017 SEOClerks! Let
Apparently it's traditional to say that around this time of year. And you know whenever you hear it, it's always to wish you well for the new year ahead. Which is exactly what I wish for everyone on SEOClerks in 2017 and beyond! Happy New Year 2017 SEOClerks! Let

You know, it's been some kind of year hasn't it? For SEOClerks and the whole Ionicware Clerks nation of sites. And for the freelancing industry on a whole too!

A recap and highlight of 2016's most memorable moments!

2016 has been an interesting, productive and innovative year to say the least! We've seen some radical and innovative changes and great new features being added to both SEOClerks and all Ionicware sites. Some small, some large, all amazing!

We've seen quite a lot of things happening and new things coming about. From the old forum being merged into the Community Discussions. To features for all of the Ionicware sites. New features all round, to benefit all users. And we've seen through the Community Discussions here how they and along with the site has helped people to find success in their SEOClerks / Freelancing career.

One of the largest things to happen in 2016 was the user base merge. Where as before you had to rank and level up on each Ionicware site, now, all the sites are using the same level status as SEOClerks. So if you was a Level 3 SEOClerks user/buyer/seller but only a Level 1 ListingDock/PixelClerks/WordClerks user, your level status carries over into all Ionicware sites the same so you'll be Level 3 everywhere if that's your level now.

This is a great thing for sellers here and buyers alike who can benefit from their freelance services. With no need to meet certain requirements to level up on each site, sellers can take advantage of all their current SEOClerks user level offers across all sites which means you can sell more and earn more quicker and that in turn means more variety for buyers to choose from as well! Win win all round! Happy New Year 2017 SEOClerks! Let

And of course, we've seen several new security features being added to make peoples accounts on all the Ionicware sites more secure as well. From secondary passwords to security questions. From telephone and address verification to identity verification to device management. Just little things that can give you a little more peace of mind.

And we've seen that the SEO industry is still going from strength to strength and looks set to be even bigger in 2017 and beyond that with up to 1/3rd of the US workforce becoming freelancers, could that percentage by 1/2 by the end of 2017?

And that's just for the US! As more people get online and take to freelancing in other countries, as well as more people getting online and needing a freelance service. We can expect a growth in the SEO and freelance industry on a whole.

That is something I for one and proud to be a part of that and look forward to seeing come about into fruition! Happy New Year 2017 SEOClerks! Let

So keep promoting SEOClerks you affiliates! Keep selling your services freelancers! And keep needing freelance services you freelance buyers! May your 2017 be bigger and better and more enriched and fulfiling than 2016 was!

What about 2016 was memorable and your most successful moment?

Are you excited for and feeling positive about 2017?

Do you have any plans you'll hope to put into action?

Whatever is whatever, let's rock 2017!!

Cheers!

Mike.

Comments

Please login or sign up to leave a comment

Join
sumoncps
Happy New Year Mike. Have a great year ahead!



Are you sure you want to delete this post?

EliteWriter
Happy new year to you Mike, and to all Seoclerks users. Yes you are right, 2016 was a very good year on Seoclerks. I think it was one of my best years ever as a freelancer too. I am thus looking forward for a great 2017 Happy New Year 2017 SEOClerks! Let



Are you sure you want to delete this post?

hitmeasap
Happy New Year Mike. I wish you the best of luck in your freelancing career, and in life, during 2017. - I hope that many of your dreams will come true and that you'll share many new things in the community discussion this year. - For all the other people on SEOClerks. I wish you all the best too! - Good luck & happy new year!



Are you sure you want to delete this post?

keen2write
lol I know its a late message but happy late new year lol... I do hope so far 2017 as been a good year as it as for me. Wishing you all the best for the rest of 2017 and the years to come.



Are you sure you want to delete this post?

idealmike
Better late than never! Happy New Year 2017 SEOClerks! Let

Cheers!



Are you sure you want to delete this post?

Lyudmilka7
With the days flying so fast before you know it it's gonna be New Years again.



Are you sure you want to delete this post?

Order Now
Process Time: 1.1961271762848

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

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

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

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

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

SELECT * FROM categories_faq WHERE CATID='42'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='42'

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

SELECT * FROM seoclerks.members WHERE USERID=2721SELECT googleplus_profile FROM seoclerks.members WHERE USERID=272

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='21048' 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='21048' 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=114086 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=114086 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=114088 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=114088 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=114121 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=114121 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=115293 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=115293 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=115295 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=115295 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=119337 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=119337 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='21048' AND status='1' AND (question like '%Happy Year 2017 SEOClerks! rock 2017!!%' OR question like '%Happy%' OR question like '%Year%' OR question like '%2017%' OR question like '%SEOClerks!%' OR question like '%rock%' OR question like '%2017!!%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='21048' AND status='1' AND (question like '%Happy Year 2017 SEOClerks! rock 2017!!%' OR question like '%Happy%' OR question like '%Year%' OR question like '%2017%' OR question like '%SEOClerks!%' OR question like '%rock%' OR question like '%2017!!%') -- ORDER BY RAND() LIMIT 15

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

SELECT * FROM seoclerks.members WHERE USERID='147' limit 11SELECT 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='8812' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='8812' limit 1

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

SELECT * FROM seoclerks.members WHERE USERID='212316' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='212316' 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=21048%' 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=21048%' 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='312171.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='312171.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='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='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='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 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.3331901SELECT 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.bdays desc LIMIT 0,400.3331900.333190
0.2088861SELECT 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.2088860.208886