Lynne
Level 1
Write the reason you're deleting this FAQ
Topseos.com has just released the Top 100 Social Media Marketing Companies and Services on their website today.
Oh man checking out some of the stats for those websites is just insane! Imagine your online marketing business earning that sort of income and having those high profile clients!
How would you like to make it onto this list?
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='19344' | 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='19344' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='306632' | 1 | SELECT * FROM seoclerks.members WHERE USERID='306632' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=306632 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=306632 | /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=19344 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=19344
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19344' 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='19344' 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=106368 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=106368
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=188352 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=188352
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='19344' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='19344' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='19344' AND status='1' AND (question like '%Topseos released social media marketing services websites!%' OR question like '%Topseos%' OR question like '%released%' OR question like '%social%' OR question like '%media%' OR question like '%marketing%' OR question like '%services%' OR question like '%websites!%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='19344' AND status='1'
AND (question like '%Topseos released social media marketing services websites!%' OR question like '%Topseos%' OR question like '%released%' OR question like '%social%' OR question like '%media%' OR question like '%marketing%' OR question like '%services%' OR question like '%websites!%')
-- 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='3080' limit 1 | 1 | SELECT 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 seoclerks.members WHERE USERID='2875' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2875' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1490' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' 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=19344%' 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=19344%'
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 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
But who knows, they could actually be making millions selling likes lol
In all seriousness, there are some really good companies out there, but I never really see them end up on the lists for topseos. I was actually thinking about making a competitor to topseos.com and listing all my services in the top 10 so that I would show authority and proven results lol. I always wondered if topseos has done the same thing or if they get a commission from the sales it refers to the top websites. I've seen topseos on adwords plenty of times so they're making revenue some how. They possibly have investors or they have other ventures that funds their marketing, but who knows lol.
If I could get my company on there, I definitely wouldn't be able to contend in the profits section since I don't make millions a year lol. I know I can contend with them on their services and pricing, but getting noticed enough to actually get on that list is tough. I've actually tried getting on that list and the amount of info you have to submit to a random person makes it feel like they're just trying to steal your identity or take over you business and push you out
If the list is 100% accurate and truthful, I wonder how many clients are gained by the top companies just for being on these lists. It has to be a good amount since topseos gets a decent amount of traffic. The validity of thoses lists have me thinking that people are inflating their numbers lol :D But who knows, they could actually be making millions selling likes lol :D In all seriousness, there are some really good companies out there, but I never really see them end up on the lists for topseos. I was actually thinking about making a competitor to topseos.com and listing all my services in the top 10 so that I would show authority and proven results lol. I always wondered if topseos has done the same thing or if they get a commission from the sales it refers to the top websites. I've seen topseos on adwords plenty of times so they're making revenue some how. They possibly have investors or they have other ventures that funds their marketing, but who knows lol. If I could get my company on there, I definitely wouldn't be able to contend in the profits section since I don't make millions a year lol. I know I can contend with them on their services and pricing, but getting noticed enough to actually get on that list is tough. I've actually tried getting on that list and the amount of info you have to submit to a random person makes it feel like they're just trying to steal your identity or take over you business and push you out :D If the list is 100% accurate and truthful, I wonder how many clients are gained by the top companies just for being on these lists. It has to be a good amount since topseos gets a decent amount of traffic.
Are you sure you want to delete this post?