SEOClerks

Now you can Email your Seoclerks Follower's



Write the reason you're deleting this FAQ

Now you can Email your Seoclerks Follower's

Since Jordan (Seoclerks) have the tendency to code the best features for our beloved Seoclerks and forget to make a little announcement thread so all of us know right away, i took the liberty of making a thread to announce the latest Seoclerks feature.

Now you can email your Seoclerks follower's, which in my opinion is a great feature, you can now advertise your new gigs to your followers which will help you gain more sales, keep in mind that if you spam your follower's they will un-follow you.

Thank you Jordan (Seoclerks) for the great features and sorry Jorden for the first part of my thread if i offended you in anyway.

Now you can Email your Seoclerks Follower

Comments

Please login or sign up to leave a comment

Join
oksalieva
How dare you jump ahead of Jordan?!!! ;) Thank you for sharing it with us, SeoExpertts!



Are you sure you want to delete this post?

robertman11
Awesome! Will be good for sending out coupons.



Are you sure you want to delete this post?

SeoExpertts
@robertman11
Nice idea



Are you sure you want to delete this post?

ionicware
More to come, this is work in progress.

Thanks for making the announcement though! Now you can Email your Seoclerks Follower



Are you sure you want to delete this post?

SeoExpertts
More to come, this is work in progress.

Thanks for making the announcement though! Now you can Email your Seoclerks Follower


Thank you Jordan for the great features and your outstanding support, i have to say that in my humble opinion this site is the best micro job site i have seen and i have seen many, with your features and your support to the site and us (seller's and buyer's) you are the #1 micro job site in my list.



Are you sure you want to delete this post?

exjordanary
Nice!! Thanks!!
Now it's time to implement a "Search" Function for our Active, Delivered, & Completed Sales/Orders.

I still spend a good 10-15 hours per week sifting through hundreds of Orders.
If I could just enter a Keyword to find Someone's Order, it would give me more time to spend on better Serving Customers.

Also, it would really help when someone inquires about a Gig, to include whichever Gig it is that they're referring to in the Message. I would say that out of about 50% of all messages sent to me, I reply with a "Please tell me which Gig you are Referring to" - before even answering their question.
When you trying to reel in a New Customer who's in "Buy Now Mode", every minute Counts and many times, I will lose them by the time we've gone back and forth 3 times just to answer 1 question.

-Jordan

Now you can Email your Seoclerks Follower

Now you can Email your Seoclerks Follower



Are you sure you want to delete this post?

exjordanary
Gee, what do ya know. Speak of the Devil :

Now you can Email your Seoclerks Follower



Are you sure you want to delete this post?

ionicware
What would you search for regarding a keyword? The only thing separating the data would be the buyer username.

Regarding your screenshot, if you use https://www.seoclerks.com/manage_orders you can see the buyer's name beside each order which should allow you to find his order quickly. I can add it to https://www.seoclerks.com/balance?tab=sales if needed.



Are you sure you want to delete this post?

exjordanary
Sometimes if A Buyer messages me regarding an Order they placed for a Video that is missing Comments, and they have ordered many Videos from me in the past (I have many regular Customers who will order multiple Videos per Order via Gig "extras"), they won't know whether its "Active", "Delivered", or "Completed", and most of the time they wont have an Order number.
With the amount of Orders I have in all 3 Tabs, it could take some time to find. Sometimes I never find the Video they're talking about.

Then there are time when i don't know the Buyer's username. One of my workers will refer to a Video that needs this, or that, and I'll have no way of connecting it with a buyer.



Are you sure you want to delete this post?

Order Now
Process Time: 1.9529559612274

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=122601SELECT googleplus_profile FROM seoclerks.members WHERE USERID=12260

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10413' 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='10413' 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=43350 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=43350 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=43351 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=43351 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=43352 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=43352 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=43353 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=43353 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=43354 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=43354 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=43355 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=43355 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=43356 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=43356 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=43357 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=43357 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=43358 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=43358 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='10413' AND status='1' AND (question like '%Now Email Seoclerks Follower\'s%' OR question like '%Email%' OR question like '%Seoclerks%' OR question like '%Follower\'s%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='10413' AND status='1' AND (question like '%Now Email Seoclerks Follower\'s%' OR question like '%Email%' OR question like '%Seoclerks%' OR question like '%Follower\'s%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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='3446' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3446' 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=10413%' 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=10413%' 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='3891.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='3891.jpg'

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

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