SASOFT
Level 3
Write the reason you're deleting this FAQ
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='29104' | 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='29104' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='792333' | 1 | SELECT * FROM seoclerks.members WHERE USERID='792333' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=792333 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=792333 | /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=29104 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=29104
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29104' 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='29104' 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=188293 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=188293
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=188304 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=188304
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=188305 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=188305
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=188280 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=188280
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29104' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29104' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29104' AND status='1' AND (question like '%Three methods Increase selling SEOCLERKs %' OR question like '%Three%' OR question like '%methods%' OR question like '%Increase%' OR question like '%selling%' OR question like '%SEOCLERKs%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29104' AND status='1'
AND (question like '%Three methods Increase selling SEOCLERKs %' OR question like '%Three%' OR question like '%methods%' OR question like '%Increase%' OR question like '%selling%' OR question like '%SEOCLERKs%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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 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='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='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='957' limit 1 | 1 | SELECT 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=29104%' 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=29104%'
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='792333.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='792333.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
Not everyone is looking for the bottom dollar service to get top rankings, because they know it doesn't work like that, and this is why they don't mind paying a little extra for better work.
I write 500+ word articles starting at $25 and I get plenty of sales from people who know that high quality content is 1,000x better than any sort of spun article that was done by software in 5 seconds lol.
2. Bonuses and Discounts definitely work!
I do this with my add-ons in order to get people thinking "If I pay a little extra I can get twice as much!" and it works well. I'll use my writing service as an example:
Base Service - 500 words for $25
Add on 1 = Add 500 words for $22
Add on 2 = Add1,000 words for $40
Add on 3 = Add 1,500 words for $55
Add on 4 = Add 2,000 words for $60
If you look at it, you may think it's super expensive, but if you were to get the base service for $25 it comes out to $0.05 per word. Now, if a buyer was to select Add On #4 giving them an additional 2,000 words for $60, the total cost per word would come out to $0.034 per word, which is where the discounts come into play
If someone were to purchase my base service and all of the add ons, it would come out to $0.036 per word, which isn't much considering I'm a professional content writer for dozens of websites lol
@Rehiga
I think he means you need to optimize your services so they show more to the people on the front page, as well as in your category, if you want to generate more sales. You will also need to work on your formatting, interlinking, and adding the right images and reviews to your services so people know you're legitimate and not some fly by night type of service that will be gone tomorrow.
- Tommy 1. People don't mind high prices if the service is high quality Not everyone is looking for the bottom dollar service to get top rankings, because they know it doesn't work like that, and this is why they don't mind paying a little extra for better work. I write 500+ word articles starting at $25 and I get plenty of sales from people who know that high quality content is 1,000x better than any sort of spun article that was done by software in 5 seconds lol. 2. Bonuses and Discounts definitely work! I do this with my add-ons in order to get people thinking "If I pay a little extra I can get twice as much!" and it works well. I'll use my writing service as an example: Base Service - 500 words for $25 Add on 1 = Add 500 words for $22 Add on 2 = Add1,000 words for $40 Add on 3 = Add 1,500 words for $55 Add on 4 = Add 2,000 words for $60 If you look at it, you may think it's super expensive, but if you were to get the base service for $25 it comes out to $0.05 per word. Now, if a buyer was to select Add On #4 giving them an additional 2,000 words for $60, the total cost per word would come out to $0.034 per word, which is where the discounts come into play :) If someone were to purchase my base service and all of the add ons, it would come out to $0.036 per word, which isn't much considering I'm a professional content writer for dozens of websites lol :D I know some writers who won't go under $0.15 per word, which is 4x to 5x than what I charge on here haha. @[url=https://www.seoclerks.com/user/rehiga]Rehiga[/url] [quote][i]Nice Tips, But I Have One Question What is the mean of Point 1? [color=#999999][size=85]1. Improve your services as much as possible. In this way, you will put your service on the first page, which will increase your chances of making a sale.[/size][/color][/i][/quote]I think he means you need to optimize your services so they show more to the people on the front page, as well as in your category, if you want to generate more sales. You will also need to work on your formatting, interlinking, and adding the right images and reviews to your services so people know you're legitimate and not some fly by night type of service that will be gone tomorrow. - Tommy
Are you sure you want to delete this post?