Avinashjaware
Level 1
Write the reason you're deleting this FAQ
I want work as data entry and excel and Account Payable. Can you someone help me in this regard because I am new to seoclerk site.
you are correct
Well talk :) you are correct
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?
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='28790' | 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='28790' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='815187' | 1 | SELECT * FROM seoclerks.members WHERE USERID='815187' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=815187 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=815187 | /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=28790 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=28790
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='28790' 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='28790' 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=187620 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=187620
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=187621 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=187621
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=187625 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=187625
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=187626 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=187626
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=187629 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=187629
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='28790' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='28790' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='28790' AND status='1' AND (question like '%I seoclerk site.%' OR question like '%seoclerk%' OR question like '%site.%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='28790' AND status='1'
AND (question like '%I seoclerk site.%' OR question like '%seoclerk%' OR question like '%site.%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1159' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1159' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3160' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3160' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=28790%' 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=28790%'
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='561850.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='561850.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='12847.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='12847.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='815309.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='815309.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='699383.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='699383.png' | /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
You'll need to set up some services that show your skills so people can start to purchase from you. I see you joined about a week ago and don't have a single service up and running yet, how come?
What you need to do is type up an enticing title that says what you're going to do, but don't give away too much info. After that, you'll need to write up, and format, a good looking description that goes into detail about your services. You don't want to just write a huge article about your skills, you'll want to break it down into sections so people don't get bored going down the page as they read.
I've said this numerous times, you'll need to use the text editor to add bold, italics, underlines, change your fonts, increase the size of your font, add images, add quotes, and much more. The more visually appealing your service looks, the easier it will be to sell, and that means more money in your pocket
If you have some orders from previous websites then take screenshots of the positive reviews and add them to your service descriptions. You'll want to remove any branding from the screenshots you're adding so they get approved, but that's not difficult. You can use Gyazo or Monosnap to get awesome looking shots and then insert them to your service. Gyazo and Monosnap are free if you were wondering
After you get all of this set up you will need to undercut your competitors and price your service equal or a little less than what they are selling for. This will get you your initial sales because everyone likes to save money. Then you will need to take those profits and purchase a category featured position for your best selling service. This will bring even more traffic to your service because it will be placed at the top of the category you're in for 31 days. You won't have to worry about bumps, your service will stick to the top of the category, and all you have to worry about is getting the work done from the sales that come in
I would recommend purchasing a homepage featured spot but they are pretty expensive. You'll definitely make your money back with that type of featured position, but you need to shell out the money before getting any sales, which a lot of people can't do. If you can afford to pay for the homepage featured spot I would still wait until you have 10+ positive reviews on your service because people want to purchase from a seller who has already done great work for others.
I hope that helps you out a little
- Tommy
https://www.seoclerks.com/user/TommyCarey Hey there :) You'll need to set up some services that show your skills so people can start to purchase from you. I see you joined about a week ago and don't have a single service up and running yet, how come? What you need to do is type up an enticing title that says what you're going to do, but don't give away too much info. After that, you'll need to write up, and format, a good looking description that goes into detail about your services. You don't want to just write a huge article about your skills, you'll want to break it down into sections so people don't get bored going down the page as they read. I've said this numerous times, you'll need to use the text editor to add bold, italics, underlines, change your fonts, increase the size of your font, add images, add quotes, and much more. The more visually appealing your service looks, the easier it will be to sell, and that means more money in your pocket :) If you have some orders from previous websites then take screenshots of the positive reviews and add them to your service descriptions. You'll want to remove any branding from the screenshots you're adding so they get approved, but that's not difficult. You can use Gyazo or Monosnap to get awesome looking shots and then insert them to your service. Gyazo and Monosnap are free if you were wondering :) After you get all of this set up you will need to undercut your competitors and price your service equal or a little less than what they are selling for. This will get you your initial sales because everyone likes to save money. Then you will need to take those profits and purchase a category featured position for your best selling service. This will bring even more traffic to your service because it will be placed at the top of the category you're in for 31 days. You won't have to worry about bumps, your service will stick to the top of the category, and all you have to worry about is getting the work done from the sales that come in :) I would recommend purchasing a homepage featured spot but they are pretty expensive. You'll definitely make your money back with that type of featured position, but you need to shell out the money before getting any sales, which a lot of people can't do. If you can afford to pay for the homepage featured spot I would still wait until you have 10+ positive reviews on your service because people want to purchase from a seller who has already done great work for others. I hope that helps you out a little :) - Tommy [url=https://www.seoclerks.com/user/TommyCarey ]https://www.seoclerks.com/user/TommyCarey [/url]
Are you sure you want to delete this post?