backpage4u
Level 3
Write the reason you're deleting this FAQ
I think seoclerks is not much popular as fiverr. i am seeing since 6months and more. not getting orders much more each month.
only 2 or 3 orders getting. dont know whats going on.
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='30335' | 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='30335' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='22379' | 1 | SELECT * FROM seoclerks.members WHERE USERID='22379' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=22379 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=22379 | /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=30335 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=30335
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='30335' 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='30335' 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=190731 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=190731
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=190757 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=190757
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='30335' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='30335' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='30335' AND status='1' AND (question like '%Not order month.%' OR question like '%order%' OR question like '%month.%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='30335' AND status='1'
AND (question like '%Not order month.%' OR question like '%order%' OR question like '%month.%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='2513' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2513' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2077' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2077' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='4277' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4277' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='4022' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4022' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3881' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3881' 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=30335%' 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=30335%'
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='147.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='931434.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='931434.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 |
Beverly
Before we fall into vague and unsubstantiated comparisons of online marketplaces, let's start by taking a look at your own fault in this issue.
As a seller, there's a lot of little things you can do to improve your chances of being found by buyers.
- Make sure your services are posted in the correct category.
Just checking into this issue, I saw that you are posting in the banner ads and traffic category.
https://www.seoclerk.com/Traffic/2...ssified-websites
For instance, this service, which you posted in traffic which is wholly unrelated to 'post your ad on high pr classified websites'. A buyer who is visiting the traffic category doesn't want their ad posted online, they want guaranteed traffic.
- post in a popular category such as link building, other press release or even social media. These categories receive substantially more traffic from buyers. If your service is even remotely related, there's a better chance of being found rather than under traffic (unrelated( or banner ads (low traffic category).
- consider a username change. The username backpage4u is not really the best option for a seller offering classified ad posting.
See https://en.wikipedia.org/wiki/Backpage
The backpage website has a bad reputation. You won't really want to associate with a site that was under criminal investigation by Federal Bureau of Investigation, the United States Postal Inspection Service, the United States Department of Justice,[3] the Internal Revenue Service Criminal Investigator Division. If I'm understanding correctly the backpage site was shut down already. So your name is not that relevant to what you're selling anymore.
A better choice might be ClassifiedAds or AdSeller. Let me know if you need help with a username change and I'll be happy to assist.
- boost (bump) your services often. I checked this just now and it appears that you last boosted your services on June 9 and then June 13. You should be boosting your services daily. You can earn free boosts just by logging in, delivering orders on time, posting a new Community Discussion (such as you've done here.
You are offering a very unique service, classified ad posting, that not a lot of other sellers are offering. So you have a good deal going there. You are the big fish in a small pond, as I always say.
Though you still need work on your service descriptions. Currently on this service, you are using barely a paragraph of information,
https://www.seoclerk.com/Traffic/1...assified-website
You should be posting screenshot/images of rave reviews received from other buyers. This will help to establish the 'trust factor' with
your potential buyer.
- Market your services off site. Don't wait for buyers. Find where your buyers are and go to them. Your potential buyer wants classified ads, so that's where you should be promoting. Place free ads there to advertise your classified ad posting service. Purchase a banner on a classified ad posting site. The visitors to those sites will likely appreciate the opportunity to purchase mass posting services for such a great price. Hi backpage4u. my name is Beverly, from SEOClerk.com support. I'm happy to comment on your issue and hopefully something i'm saying will be of assistance to you. Before we fall into vague and unsubstantiated comparisons of online marketplaces, let's start by taking a look at your own fault in this issue. As a seller, there's a lot of little things you can do to improve your chances of being found by buyers. - Make sure your services are posted in the correct category. Just checking into this issue, I saw that you are posting in the banner ads and traffic category. [url=https://www.seoclerk.com/Traffic/255271/I-will-post-Your-ads-on-different-high-pr-classified-websites]https://www.seoclerk.com/Traffic/255271/I-will-post-Your-ads-on-different-high-pr-classified-websites[/url] For instance, this service, which you posted in traffic which is wholly unrelated to 'post your ad on high pr classified websites'. A buyer who is visiting the traffic category doesn't want their ad posted online, they want guaranteed traffic. - post in a popular category such as link building, other press release or even social media. These categories receive substantially more traffic from buyers. If your service is even remotely related, there's a better chance of being found rather than under traffic (unrelated( or banner ads (low traffic category). - consider a username change. The username backpage4u is not really the best option for a seller offering classified ad posting. See [url=https://en.wikipedia.org/wiki/Backpage]https://en.wikipedia.org/wiki/Backpage[/url] The backpage website has a bad reputation. You won't really want to associate with a site that was under criminal investigation by Federal Bureau of Investigation, the United States Postal Inspection Service, the United States Department of Justice,[url=https://en.wikipedia.org/wiki/Backpage#cite_note-3][3][/url] the Internal Revenue Service Criminal Investigator Division. If I'm understanding correctly the backpage site was shut down already. So your name is not that relevant to what you're selling anymore. A better choice might be ClassifiedAds or AdSeller. Let me know if you need help with a username change and I'll be happy to assist. - boost (bump) your services often. I checked this just now and it appears that you last boosted your services on June 9 and then June 13. You should be boosting your services daily. You can earn free boosts just by logging in, delivering orders on time, posting a new Community Discussion (such as you've done here. You are offering a very unique service, classified ad posting, that not a lot of other sellers are offering. So you have a good deal going there. You are the big fish in a small pond, as I always say. Though you still need work on your service descriptions. Currently on this service, you are using barely a paragraph of information, [url=https://www.seoclerk.com/Traffic/156618/Post-Your-Ad-100-Times-on-High-PR-USA-Classified-website]https://www.seoclerk.com/Traffic/156618/Post-Your-Ad-100-Times-on-High-PR-USA-Classified-website[/url] You should be posting screenshot/images of rave reviews received from other buyers. This will help to establish the 'trust factor' with your potential buyer. - Market your services off site. Don't wait for buyers. Find where your buyers are and go to them. Your potential buyer wants classified ads, so that's where you should be promoting. Place free ads there to advertise your classified ad posting service. Purchase a banner on a classified ad posting site. The visitors to those sites will likely appreciate the opportunity to purchase mass posting services for such a great price.
Are you sure you want to delete this post?