hafiz3143
Level 3
Write the reason you're deleting this FAQ
How To Get Everday Orders On Seoclerk? Kindly Guide Us How we can Improve Our Earning On Seoclerk.
Thanks.
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='29254' | 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='29254' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='805244' | 1 | SELECT * FROM seoclerks.members WHERE USERID='805244' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=805244 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=805244 | /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=29254 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=29254
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29254' 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='29254' 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=188583 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=188583
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=188587 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=188587
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=188572 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=188572
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29254' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29254' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29254' AND status='1' AND (question like '%Why day Orders Seoclerk%' OR question like '%Orders%' OR question like '%Seoclerk%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29254' AND status='1'
AND (question like '%Why day Orders Seoclerk%' OR question like '%Orders%' OR question like '%Seoclerk%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='318' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='318' 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 1 | 1 | SELECT 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 seoclerks.members WHERE USERID='750' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='750' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' 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 1 | 1 | SELECT 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=29254%' 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=29254%'
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='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 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 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 |
TommyCarey
There are a few ways to boost your sales in order to have people purchase from you every day. You can pay for advertising and use free boosts but all of that won't matter unless you've built up your services just right.
I've looked over a few of your services, and they look pretty decent, but they lack some images and seem to be short on content sometimes. One of your services was about guest posting and there wasn't much on the page except a short description. You'll want to go through, write compelling information as to why your service is the best and why people would be fools not to purchase from you, then format it in a way that pulls people's attention down the page. You don't want to add a wall of text because many people online will get what's called "readers fatigue" and the ones who are used to this will see the page and instantly close it because they know what is in store for them.
To avoid readers fatigue you will need to use captivating titles that draw people in, write short paragraphs that are not longer than 3 sentences, use Bold/Italics/Underline when necessary, use examples of previous work (if possible), and add reviews to your service descriptions from previous buyers here or from other platforms. You can use any positive review you want on your service, it just has to be yours, and you will want to remove any branding that might get you in trouble later on lol.
As for advertising and bumping, you can bump your services for free every 12 hours as long as you've been acquiring free bumps from completing a service on time, participating here in the community discussions area, and various other things around the marketplace. You can also purchase bumps, which aren't expensive, and use them every 12 hours the same as a free bump. When you bump your service it will go to the top of its category and gradually fall down as other services are created or bumped.
You can always pay for a category feature, and keep your service stuck to the top of its category for 31 days, but that's costs a little more than how much you'd be paying for bumps. You'll get a lot more views on your service, and if you interlinked your other services within the description of your advertised service, you will be able to share traffic between them and increase your sales even more.
You can purchase a homepage featured advertisement for your service, but this tends to cost a bit more since it's now on a bidding system, and the highest bidder will get the position. The homepage feature is much more expensive because it puts your service in front of hundreds of thousands of potential customers who will look at your headline, click through to view your service, and purchase from you if they think you're the best of the best and they can't live without your skills. The homepage feature option is a very competitive field because a lot of top sellers know it will bring in a massive amount of profit, so be sure to think of this option later on down the road when you're pulling in more sales. Hey Hafiz, There are a few ways to boost your sales in order to have people purchase from you every day. You can pay for advertising and use free boosts but all of that won't matter unless you've built up your services just right. I've looked over a few of your services, and they look pretty decent, but they lack some images and seem to be short on content sometimes. One of your services was about guest posting and there wasn't much on the page except a short description. You'll want to go through, write compelling information as to why your service is the best and why people would be fools not to purchase from you, then format it in a way that pulls people's attention down the page. You don't want to add a wall of text because many people online will get what's called "readers fatigue" and the ones who are used to this will see the page and instantly close it because they know what is in store for them. To avoid readers fatigue you will need to use captivating titles that draw people in, write short paragraphs that are not longer than 3 sentences, use Bold/Italics/Underline when necessary, use examples of previous work (if possible), and add reviews to your service descriptions from previous buyers here or from other platforms. You can use any positive review you want on your service, it just has to be yours, and you will want to remove any branding that might get you in trouble later on lol. As for advertising and bumping, you can bump your services for free every 12 hours as long as you've been acquiring free bumps from completing a service on time, participating here in the community discussions area, and various other things around the marketplace. You can also purchase bumps, which aren't expensive, and use them every 12 hours the same as a free bump. When you bump your service it will go to the top of its category and gradually fall down as other services are created or bumped. You can always pay for a category feature, and keep your service stuck to the top of its category for 31 days, but that's costs a little more than how much you'd be paying for bumps. You'll get a lot more views on your service, and if you interlinked your other services within the description of your advertised service, you will be able to share traffic between them and increase your sales even more. You can purchase a homepage featured advertisement for your service, but this tends to cost a bit more since it's now on a bidding system, and the highest bidder will get the position. The homepage feature is much more expensive because it puts your service in front of hundreds of thousands of potential customers who will look at your headline, click through to view your service, and purchase from you if they think you're the best of the best and they can't live without your skills. The homepage feature option is a very competitive field because a lot of top sellers know it will bring in a massive amount of profit, so be sure to think of this option later on down the road when you're pulling in more sales.
Are you sure you want to delete this post?