On what Basis Services trends on Seoclerks ?

TopSEO4you Level 3

August 30, 2016, 12:12 am

Write the reason you're deleting this FAQ

On what Basis Services trends on Seoclerks ?

Hello
I want to know On what Basis Services trends on Seoclerks
Bumping your service also goes in trending section ?

Comments

Please login or sign up to leave a comment

Join

Everett

Very good question, TopSEO4you! From my understanding, it appears that the trending tab displays services that are most purchased daily, weekly and monthly. If you haven't noticed, a lot of featured services appear in the trending tab, along with popular services by popular and established marketplace sellers.

I've been trying to get on a trending list, to help increase sales for my own services, but I don't think my services get sold enough to make the cut. I'm unsure of how many orders you would need for it to be considered as "trending" that may be a question you'll need to ask the support team if they are willing to disclose.

10 years ago

Are you sure you want to delete this post?

Lynne

I don't think that the bumps count directly towards trending, no.

Trending would be the most popular services so certainly the most sold services would make the trending list. So if you bump your services and make more sales that could in turn influence your chances of getting onto the trending list.

I'm not sure if services that are looked at a lot make the list or not, but I think most likely it is just sales amounts that get you into the trending list.

10 years ago

Are you sure you want to delete this post?

Cristian

Wow. I wasn't aware there was a trending section! Guess I missed that news. Seems like the week as well as month sections are dominated by featured services, at least on top positions.

10 years ago

Are you sure you want to delete this post?

EliteWriter

I hadn't noticed it either. I think that the services that managed to make it in the trending section are probably the ones that got most orders within that day, week or month. I do not think that bumping a service will have any effect on this. It would be nice to know how one could make it to the trending services, maybe there is a minimum number of orders one needs to get. Or is it based on how many likes, or maybe number of views a service gets?

10 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.106678	1	SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Seelisting%' OR A.skills LIKE '%Seelisting%')	0.106678	0.106678

SEOClerks

On what Basis Services trends on Seoclerks ?

On what Basis Services trends on Seoclerks ?

Comments

Please login or sign up to leave a comment

Everett

Lynne

Cristian

EliteWriter

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='19294'	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='19294'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='479127'	1	SELECT * FROM seoclerks.members WHERE USERID='479127'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=479127	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=479127	/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=19294 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=19294 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19294' 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='19294' 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=106095 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=106095 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=106105 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=106105 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=106264 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=106264 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=106403 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=106403 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='19294'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='19294'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='19294' AND status='1' AND (question like '%On Basis Services trends Seoclerks ?%' OR question like '%Basis%' OR question like '%Services%' OR question like '%trends%' OR question like '%Seoclerks%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='19294' AND status='1' AND (question like '%On Basis Services trends Seoclerks ?%' OR question like '%Basis%' OR question like '%Services%' OR question like '%trends%' 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='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='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='3446' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3446' 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=19294%' 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=19294%' 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='2951.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='306632.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='134.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='212316.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='212316.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()