geetanegi46
Level 1
Write the reason you're deleting this FAQ
Hello.. I am very new freelancer in this website.. But not able to complete my profile properly.. Pls help & suggest me that how can i complete my profile so that i will get more work.. My area of work are:- Data Entry, Form Filing work, Online typing, jpeg or pdf to word or excel conversion.
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| 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='28779' | 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='28779' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='805892' | 1 | SELECT * FROM seoclerks.members WHERE USERID='805892' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=805892 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=805892 | /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=28779 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=28779
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='28779' 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='28779' 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=187614 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=187614
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=187840 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=187840
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='28779' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='28779' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='28779' AND status='1' AND (question like '%How attractive profile data entry & virtual assistant work?%' OR question like '%attractive%' OR question like '%profile%' OR question like '%data%' OR question like '%entry%' OR question like '%&%' OR question like '%virtual%' OR question like '%assistant%' OR question like '%work?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='28779' AND status='1'
AND (question like '%How attractive profile data entry & virtual assistant work?%' OR question like '%attractive%' OR question like '%profile%' OR question like '%data%' OR question like '%entry%' OR question like '%&%' OR question like '%virtual%' OR question like '%assistant%' OR question like '%work?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='43' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='43' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='4245' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4245' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| 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='873' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='873' 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=28779%' 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=28779%'
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='839254.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='839254.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
First off you will need to put up some services that show your skills. I would suggest to put up one service for each of your skills so you can spread them out and possibly share traffic between them. After you have your service up, you'll need to go through and format them to be sure they look great because no one wants to buy from a service that looks like it was slapped together. If you have the funds I would highly suggest a category feature or even a homepage feature to bring in immediate customers and sales.
What to focus on...
Your Services
Set up one service for each of your skills. So do a data entry service, a service for form filling, a typing service (be sure they know this isn't an article writing service), a jpeg to Word or Excel service, and a png to Word or Excel service.
This will give you five services starting off and you will be able to target a few different categories with this skill set. Spreading your skills across multiple categories will bring in customers from all over the marketplace and increase the chances of capturing a sale.
Formatting your descriptions
No one wants to buy from a service provider who hasn't taken the time to make their services look visually appealing. This is why you will need to take some time to format your content so it looks nice. You can use bold, italics, underlines, quotes, and even add images to your descriptions to make them look great.
The better your service looks at a first glance, the better the chances are of selling it, so be sure to take your time on this because it will help you out in the long run.
Cross-Selling
This is a little trick a lot of top sellers are using to boost their sales because it works pretty well. All you'll have to do is put links in your service description that lead to another service of yours. It's customary to put these links after the service description so your readers/customers don't lose focus on what they might buy. Let them get through the entire service description and let them stumble upon your other services linked at the bottom of the description. They might buy the service and go back to buy your other ones, but you may not get that additional sale if you're not cross-selling
Advertising your services
This is a sure-fire way of boosting your sales because people will see your services immediately. You have to pay to feature your services, and it can get expensive if you want a homepage feature, but it's definitely worth it if you have a few reviews under your belt already.
A homepage feature is on a bidding system, which is why it can get expensive, and that's why I would suggest starting out with a category feature. You will not have as much competition in the category feature, which is why I love them, but you will get slightly less traffic since there aren't as many people browsing through each of the categories one by one. Hi there, First off you will need to put up some services that show your skills. I would suggest to put up one service for each of your skills so you can spread them out and possibly share traffic between them. After you have your service up, you'll need to go through and format them to be sure they look great because no one wants to buy from a service that looks like it was slapped together. If you have the funds I would highly suggest a category feature or even a homepage feature to bring in immediate customers and sales. What to focus on... [size=150][u][b]Your Services[/b][/u][/size] Set up one service for each of your skills. So do a data entry service, a service for form filling, a typing service (be sure they know this isn't an article writing service), a jpeg to Word or Excel service, and a png to Word or Excel service. This will give you five services starting off and you will be able to target a few different categories with this skill set. Spreading your skills across multiple categories will bring in customers from all over the marketplace and increase the chances of capturing a sale. [size=150][u][b]Formatting your descriptions[/b][/u][/size] No one wants to buy from a service provider who hasn't taken the time to make their services look visually appealing. This is why you will need to take some time to format your content so it looks nice. You can use bold, italics, underlines, quotes, and even add images to your descriptions to make them look great. The better your service looks at a first glance, the better the chances are of selling it, so be sure to take your time on this because it will help you out in the long run. [size=150][u][b]Cross-Selling[/b][/u][/size] This is a little trick a lot of top sellers are using to boost their sales because it works pretty well. All you'll have to do is put links in your service description that lead to another service of yours. It's customary to put these links after the service description so your readers/customers don't lose focus on what they might buy. Let them get through the entire service description and let them stumble upon your other services linked at the bottom of the description. They might buy the service and go back to buy your other ones, but you may not get that additional sale if you're not cross-selling :) [u][size=150][b]Advertising your services[/b][/size][/u] This is a sure-fire way of boosting your sales because people will see your services immediately. You have to pay to feature your services, and it can get expensive if you want a homepage feature, but it's definitely worth it if you have a few reviews under your belt already. A homepage feature is on a bidding system, which is why it can get expensive, and that's why I would suggest starting out with a category feature. You will not have as much competition in the category feature, which is why I love them, but you will get slightly less traffic since there aren't as many people browsing through each of the categories one by one.
Are you sure you want to delete this post?