karthik25
Level 1
Write the reason you're deleting this FAQ
Please don't say no one like to reveal.
If you can't it's fine. Google wont shut down.
So, I use online tools like Ahref, SEMRUSH. I have used scrapebox, but it was outdated version.
What about you guys?
Are you sure you want to delete this post?
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='28586' | 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='28586' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='568984' | 1 | SELECT * FROM seoclerks.members WHERE USERID='568984' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='30' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='30' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=568984 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=568984 | /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=28586 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=28586
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='28586' 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='28586' 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=187329 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=187329
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=187404 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=187404
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=188152 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=188152
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='28586' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='28586' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='28586' AND status='1' AND (question like '% Famous SEO tools here?%' OR question like '%Famous%' OR question like '%tools%' OR question like '%here?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='28586' AND status='1'
AND (question like '% Famous SEO tools here?%' OR question like '%Famous%' OR question like '%tools%' OR question like '%here?%')
-- 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='43' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='43' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='17847' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17847' 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='2741' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2741' 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=28586%' 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=28586%'
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 seoclerks.members WHERE USERID='809246.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='809246.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 |
TommyCarey
I've also had Xrumer and SEnuke but haven't used them in the longest time. I actually have a lifetime license for SEnuke and still don't use it lol
Tools I use Daily and Weekly:
Ahrefs - For research
Adwords - To get instant traffic
Adwords Keyword Planner - For keyword research
Bing Ads - To get instant traffic
Google Trends - Just to be sure a keyword has the potential to send traffic for a long time.
Google Analytics - To monitor my traffic and see where it's coming from and what it's doing
GTMetrix - To help me get a new site optimized fully
YOAST or All In One SEO plugins - Used for on page optimization of a WordPress website
SimilarWeb - Used when I have an ad on one site and I want to duplicate it on similar sites.
SpyFu - Used when I want to see what my competitors are ranking for.
BuzzSumo - It's like Google Alerts on steroids lol
Above is the list I can think of off the top of my head. I'm sure there are some more free services and paid ones that I use from time to time, but I just can't think of any others lol. Ahrefs and SEMrush are definitely awesome to use. I also have a few copies of scrapebox but I haven't used them in about 2 years :( I've also had Xrumer and SEnuke but haven't used them in the longest time. I actually have a lifetime license for SEnuke and still don't use it lol :D [size=100][b]Tools I use Daily and Weekly:[/b][/size] [b][u]Ahrefs -[/u][/b] For research [u][b]Adwords -[/b][/u] To get instant traffic [u][b]Adwords Keyword Planner -[/b][/u] For keyword research [u][b]Bing Ads -[/b][/u] To get instant traffic [u][b]Google Trends -[/b][/u] Just to be sure a keyword has the potential to send traffic for a long time. [u][b]Google Analytics -[/b][/u] To monitor my traffic and see where it's coming from and what it's doing [u][b]GTMetrix -[/b][/u] To help me get a new site optimized fully [u][b]YOAST or All In One SEO plugins -[/b][/u] Used for on page optimization of a WordPress website [u][b]SimilarWeb -[/b][/u] Used when I have an ad on one site and I want to duplicate it on similar sites. [u][b]SpyFu -[/b][/u] Used when I want to see what my competitors are ranking for. [u][b]BuzzSumo -[/b][/u] It's like Google Alerts on steroids lol Above is the list I can think of off the top of my head. I'm sure there are some more free services and paid ones that I use from time to time, but I just can't think of any others lol.
Are you sure you want to delete this post?