SEOClerks

Happy Thanksgiving! Buy 3 get 10% back promotion plus free $5 coupon!



Write the reason you're deleting this FAQ

Happy Thanksgiving! Buy 3 get 10% back promotion plus free $5 coupon!

Happy Thanksgiving! Buy 3 get 10% back promotion plus free $5 coupon!



Happy Thanksgiving!

Give thanks for all the bounty and blessings of the fall season with our latest Thanksgiving promotion.

In appreciation of our amazing Ionicware community members, we've enabled the buy three (3) get 10% back promotion starting now through Cyber Monday.

Purchase any three services and get 10% of the total for all three instantly added back into your account.

All you have to do is order any three services or products and the funds will automatically be added to your account every three orders. The funds can be used to purchase more services and get more money back (via the three order promo).

This offer is valid starting on 11/23/2017 ending 11/28/2017 so claim your 10% refund now!

This promotion is valid on all of our marketplaces: SEOClerks, CodeClerks, PixelClerks, WordClerks, ListingDock.

Your funds are now shared across all five sites which means you can buy three services on any of those sites and receive the 10% bonus which can be used on all five sites.


Rules
  • Buy three services or products, get 10% back at the order order URL
  • You'll see an alert appear in the bottom-right with the amount refunded to your account
  • You can stack this, meaning every 3 purchases will return 10% to your account balance until it ends


Don't miss out! Cash in on this holiday spectacular today, because like leftover Turkey, it's gone all too soon.

P.S. If you don't have text deals turned on, do it it now! Free $5 coupons are being sent out now

Comments

Please login or sign up to leave a comment

Join
DarthHazard
Oh wow, this is actually quite nice. I've been a bit reluctant to purchase some services from here and the other Ionicware sites, to be honest, but this offer makes the idea quite attractive. Will have a look later to see if any services meet my needs.



Are you sure you want to delete this post?

socialshare
Great Thank you , how i can get free $5 coupon



Are you sure you want to delete this post?

augusta
Happy Thanksgiving,it nice of ionic ware to appreciate it esteemed customers and would be customers this way.Checking out the marketplaces and see how I can cash in on this.I hope more people will take advantage of this nice offer.



Are you sure you want to delete this post?

keen2write
Thanks, Bev and happy and happy thanksgiving Happy Thanksgiving! Buy 3 get 10% back promotion plus free $5 coupon! I got text notifications on but didn't receive any code.



Are you sure you want to delete this post?

kgord
Wow, that is great. I really only participate here, but I will keep it in mind in case I decide to start an account elsewhere on this site. Every little bit helps as they say, and who is going to turn down money? It is too dear to most of us.



Are you sure you want to delete this post?

SeoFriend2305
It was a great offer for any Buyer and seller. Thanks to Beverly and seoclerks community family for the being.



Are you sure you want to delete this post?

onlinephp
Great offer no doubt about that. thanks to the seoclerks community.



Are you sure you want to delete this post?

TheoSEO
Same issue here... i only get messages from services on sale. Happy Thanksgiving! Buy 3 get 10% back promotion plus free $5 coupon!



Are you sure you want to delete this post?

Order Now
Process Time: 0.68595600128174

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=1471SELECT googleplus_profile FROM seoclerks.members WHERE USERID=147

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='24845' 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='24845' 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=142458 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=142458 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=142181 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=142181 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=142184 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=142184 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=142361 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=142361 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=142449 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=142449 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=152153 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=152153 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=153316 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=153316 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=142408 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=142408 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='24845' AND status='1' AND (question like '%Happy Thanksgiving! Buy 3 10% promotion free $5 coupon!%' OR question like '%Happy%' OR question like '%Thanksgiving!%' OR question like '%promotion%' OR question like '%free%' OR question like '%coupon!%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='24845' AND status='1' AND (question like '%Happy Thanksgiving! Buy 3 10% promotion free $5 coupon!%' OR question like '%Happy%' OR question like '%Thanksgiving!%' OR question like '%promotion%' OR question like '%free%' OR question like '%coupon!%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='13175' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='13175' 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=24845%' 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=24845%' 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='599711.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='599711.jpg'

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='19146.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='19146.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.1173301SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 71207 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Youtube Youtubeseoskil Youtubeservice Youtubeviews Seo Seoexpert Traffic Websitetraffic%' ) LIMIT 40.1173300.117330
0.1139411SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 61154 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Programming Promotion Data Download Instagramservi Facebook%' ) LIMIT 40.1139410.113941