SEOClerks

social media service reject



Write the reason you're deleting this FAQ

social media service reject

Whenever I sell the service of social media, it gets rejected, what should I do to put social media service

Comments

Please login or sign up to leave a comment

Join
TommyCarey
A majority of social media services aren't allowed here due to legal reasons. Ionicware, the company that owns this marketplace, was being targeted by the bigger social media platforms for letting freelancers sell services that artificially boosted someone's profile. This means they were targeting sellers that were providing likes, follows, tweets, retweets, pins, etc. and instead of Ionicware fighting a very expensive legal battle, one the would have lost, they decided to remove the option to sell social media services like the one you're trying to sell here.

There are bigger platforms, similar to this one, that have plenty of social media services for sale and the big platforms turn a blind eye towards them since these other marketplaces spend millions each year on advertising. They don't fight with them because that's one big revenue stream taken away if the other marketplace decides to not use that advertising option any longer because they're being micro-managed by the social media platform.

The same thing goes with Adwords and Google turns a blind eye to businesses that are spending astronomical amounts for ads. The website being advertised could clearly break the rules and it will get overlooked, but if you were to duplicate their site and run the same ads you would notice a ban relatively quickly.

This happens all over the internet, as well as the world, and the conclusion is that it's all about money. The more money you're giving to a company for ads, the more likely they'll look away when you break a rule, and that's a sad thing because of smaller marketplaces on the rise are being stifled before they achieve true greatness.

The thing that really sucks is that there are so many places to advertise and each of them does this. If you can spend millions a year on ads, you can promote whatever you want as long as it's not blatantly breaking the rules, and that's one way the rich are getting richer.



Are you sure you want to delete this post?

Maria02
Whenever I sell the service of social media, it gets rejected, what should I do to put social media service
same my services

I wanted to know if I could do the service of his social media and YouTube video view.Every day I have to create a new service.
In fact, social media works can not be dropped or stopped?
General Chat Chat LoungMy service has been active for a few months. It is not known why they were removed.



Are you sure you want to delete this post?

HenryNine
I know this Community's staff will highly disapprove of my suggestion but I would like to let you know that if you are so much into social media, I mean the services you provide are only related to that particular niche, then you should try your luck elsewhere, there are many alternatives out there, this is simply not the right place to do it, just as you have been clearly explained to before.



Are you sure you want to delete this post?

Order Now
Process Time: 0.049405813217163

Possible Duplicate queries found!
MatchCountSQLScript
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='29552'1SELECT 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='29552'

/opt/clerks-staging/docroot/viewfaq.php 496 () ()

SELECT * FROM seoclerks.members WHERE USERID='840155'1SELECT * FROM seoclerks.members WHERE USERID='840155'

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM seoclerks.members WHERE USERID=8401551SELECT googleplus_profile FROM seoclerks.members WHERE USERID=840155

/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=29552 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=29552 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29552' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='29552' 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=189075 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=189075 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=189085 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=189085 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=189553 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=189553 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

UPDATE questions SET total_views = total_views + 1 WHERE quesid='29552'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='29552'

/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

SELECT * FROM questions WHERE quesid!='29552' AND status='1' AND (question like '%social media service reject%' OR question like '%social%' OR question like '%media%' OR question like '%service%' OR question like '%reject%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='29552' AND status='1' AND (question like '%social media service reject%' OR question like '%social%' OR question like '%media%' OR question like '%service%' OR question like '%reject%') -- ORDER BY RAND() LIMIT 15

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM seoclerks.members WHERE USERID='4245' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='4245' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='6896' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='6896' 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 11SELECT 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 seoclerks.members WHERE USERID='1159' limit 11SELECT 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='3080' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3080' 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=29552%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=29552%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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'1SELECT 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='718889.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='718889.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='719539.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='719539.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

select * from categories_faq order by name asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin
0.6376522SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.viewcount desc LIMIT 0,400.3459110.291741

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.3188262SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.viewcount desc LIMIT 0,400.3459110.291741
0.2218071SELECT 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 0.2218070.221807