peezypoofy
Level 1
Write the reason you're deleting this FAQ
New to seoclerks and need advice on how to make money fast , heard about this browsing & wanted to give it a shot myself so can someone reach out it would be nice
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT 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='29249' | 1 | SELECT 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='29249' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='858048' | 1 | SELECT * FROM seoclerks.members WHERE USERID='858048' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='42' | 1 | SELECT 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=858048 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=858048 | /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=29249 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=29249
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29249' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT 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='29249' 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=188582 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=188582
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=188539 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=188539
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=188542 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=188542
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=188573 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=188573
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29249' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29249' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29249' AND status='1' AND (question like '%New & advice %' OR question like '%&%' OR question like '%advice%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29249' AND status='1'
AND (question like '%New & advice %' OR question like '%&%' OR question like '%advice%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='9874' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9874' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='10950' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='10950' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='7247' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='7247' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='7564' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='7564' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='28851' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='28851' 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=29249%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=29249%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * 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 asc | 1 | select * 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 asc | 1 | select * 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='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='844576.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='844576.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='805244.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='805244.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
TommyCarey
Welcome to the marketplace and I hope you will enjoy your time here
As for making money here, there are a few ways to do that, but they all revolve around selling something. You'll need the skills in order to start a service so start writing down what a website owner would love to purchase from you. Think of how you would pitch it to them, what the price points should be, ponder on what add-ons you could use as upsells, and be sure to do a rough draft of everything before you submit it as a service.
After you get an idea for a few services, start submitting them for approval, if there is no reason to review them then they'll get auto-approved and you should be able to sell right away.
Now you'll need to go back, look over your services, and be sure they look great. You can have something amazing to sell but if it looks like it was written by a 3-year-old, people will think you don't know what you're doing, and they will avoid your services entirely. You'll want to format everything so it looks like certain sections stand out, especially the titles and sub-titles of each new section. Use Bold, Italics, and Underlines when needed and be sure to throw in a quote or review from a previous client you've had. Since you don't have any sales yet, you can't screenshot a positive review and add it to your service, but that's something to think about later on when you start getting consistent work here
Now that you have your services set up, you'll want to think about how you can get them in front of the most people in the shortest amount of time. This usually comes in the form of advertising, or you can boost your services like other members have said, so be sure to try out the cheaper versions of this and see how it goes. You can buy boosts and apply them from your services page, or you can earn them for free by doing various tasks like completing an order on time or submitting a discussion here on the site. You can also purchase boosts and use them every 12 hours if you'd like and this will push your service to the top of its category but it won't stick there. You can use one boost on each of your services every 12 hours. This means if you have 10 services and 10 boosts, you can bump them all up to the top of their category pages one time, and then you're out of boosts.
Paid advertising will help you get on top of the category for 31 days or get you on the homepage for the most exposure possible. After you've worked with the paid bump method of bringing in sales I would recommend trying out the category feature paid advertising option before the homepage feature option because the category option is much cheaper and will still bring in a positive ROI if you have a quality service to offer buyers here. After a month or two of the category feature, you could probably put in a bid on the homepage feature, and you'll notice your sales shoot up dramatically if you win the bid. Your service will be in front of hundreds of thousands of people every month and they will be browsing through all of your services if you structured them right and interlinked them, then you'll really notice success starting to creep into your freelancing career
I hope that helps you out a bit
- Tommy Hey PeezyPoofy, Welcome to the marketplace and I hope you will enjoy your time here :) As for making money here, there are a few ways to do that, but they all revolve around selling something. You'll need the skills in order to start a service so start writing down what a website owner would love to purchase from you. Think of how you would pitch it to them, what the price points should be, ponder on what add-ons you could use as upsells, and be sure to do a rough draft of everything before you submit it as a service. After you get an idea for a few services, start submitting them for approval, if there is no reason to review them then they'll get auto-approved and you should be able to sell right away. Now you'll need to go back, look over your services, and be sure they look great. You can have something amazing to sell but if it looks like it was written by a 3-year-old, people will think you don't know what you're doing, and they will avoid your services entirely. You'll want to format everything so it looks like certain sections stand out, especially the titles and sub-titles of each new section. Use Bold, Italics, and Underlines when needed and be sure to throw in a quote or review from a previous client you've had. Since you don't have any sales yet, you can't screenshot a positive review and add it to your service, but that's something to think about later on when you start getting consistent work here :) Now that you have your services set up, you'll want to think about how you can get them in front of the most people in the shortest amount of time. This usually comes in the form of advertising, or you can boost your services like other members have said, so be sure to try out the cheaper versions of this and see how it goes. You can buy boosts and apply them from your services page, or you can earn them for free by doing various tasks like completing an order on time or submitting a discussion here on the site. You can also purchase boosts and use them every 12 hours if you'd like and this will push your service to the top of its category but it won't stick there. You can use one boost on each of your services every 12 hours. This means if you have 10 services and 10 boosts, you can bump them all up to the top of their category pages one time, and then you're out of boosts. Paid advertising will help you get on top of the category for 31 days or get you on the homepage for the most exposure possible. After you've worked with the paid bump method of bringing in sales I would recommend trying out the category feature paid advertising option before the homepage feature option because the category option is much cheaper and will still bring in a positive ROI if you have a quality service to offer buyers here. After a month or two of the category feature, you could probably put in a bid on the homepage feature, and you'll notice your sales shoot up dramatically if you win the bid. Your service will be in front of hundreds of thousands of people every month and they will be browsing through all of your services if you structured them right and interlinked them, then you'll really notice success starting to creep into your freelancing career :D I hope that helps you out a bit :) - Tommy
Are you sure you want to delete this post?