Features services Stay On Homepage

hafiz3143 Level 3

October 19, 2019, 6:03 am

Write the reason you're deleting this FAQ

Features services Stay On Homepage

Hi I have Try Two Times Buy Paid Bumps But No orders I want to if I buy 50 Dollars Feature Service Then My Service Show On Home Page ?

Comments

Please login or sign up to leave a comment

Join

rehiga

Your Service won't Show up on a Home page.
To make your service in the SEOClerks homepage
Please check this Link: https://www.seoclerk.com/Other/303...vice-for-1-Month

Thank You
Your Sincerely, Rehiga

6 years ago

Are you sure you want to delete this post?

sahupurna

$50 only for featuring on your category page, to make feature on home page you need to buy home page feature service at $1500/month. This service was $500 previously and now this month it's price hiked 3 times. Before taking premium service be ready to deliver each order on correct time. Since when you feature on home page you will definitely get orders and must fix higher price since you already invested $1500 in a month.

6 years ago

Are you sure you want to delete this post?

TommyCarey

Hey hafiz,

What you're talking about is the category featured advertisement that will put your service on top of your category for 31 days and pull in customers. It's much cheaper than the homepage feature, which is $1,500+ right now, and I tend to prefer the category feature more than the homepage feature because the ROI is much less stressful lol

I've never actually advertised on the homepage because I thought it was too expensive for what I was doing and now it's far out of my reach at $1,500+ lol. I tend to stick with the category feature and using free and paid bumps when I'm not advertising. This brings in a steady amount of customers each month and it's just enough to keep me selling here

I might try out a paid homepage featured spot if I want to spend $1,500 but for right now I'll stick with the category feature.

The best thing about a category featured spot is that the people who happen to come across your services are the ones who are already looking for what you're selling. When you advertise on the homepage you're putting your service in front of absolutely everyone that comes to the site and not everyone is looking for what you have for sale. Most people come here for specific things like SEO, SEM, Content Writing, Logo Design, etc. and they tend to avoid sifting through the homepage and go right to the category they're interested in.

6 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.692235	1	SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (53) AND gtags like'%youtbe%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.692235	0.692235
0.096191	1	SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Coverphoto%') ORDER BY total_recommendations desc LIMIT 0,40	0.096191	0.096191

SEOClerks

Features services Stay On Homepage

Features services Stay On Homepage

Comments

Please login or sign up to leave a comment

rehiga

sahupurna

TommyCarey

Invalid SQL

Expensive SQL

Suspicious SQL

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='29314'	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='29314'	/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=29314 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=29314 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29314' 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='29314' 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=188650 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=188650 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=188666 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=188666 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=188723 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=188723 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='29314'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='29314'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='29314' AND status='1' AND (question like '%Features services Stay Homepage%' OR question like '%Features%' OR question like '%services%' OR question like '%Stay%' OR question like '%Homepage%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='29314' AND status='1' AND (question like '%Features services Stay Homepage%' OR question like '%Features%' OR question like '%services%' OR question like '%Stay%' OR question like '%Homepage%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='9399' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='9399' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='17457' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17457' 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='17031' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' 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=29314%' 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=29314%' 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='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 seoclerks.members WHERE USERID='812751.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='812751.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
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 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()