MikeQ
Level 1
Write the reason you're deleting this FAQ
What I think is on-page optimization is very important..
So apart from 500 word article, there are many things, I need your contribution to complete the list..
For example
Highlighting important terms
Keyword Density
Heading Tags
Meta Data
Anchor text (related web page within your site)
Linking some authority site on your page (like Wikipedia)
Table
Graph
Image
Diagram
List
Text Color
Text Size
Special Characters
Related Posts
And what?
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='15684' | 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='15684' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='53446' | 1 | SELECT * FROM seoclerks.members WHERE USERID='53446' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=53446 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=53446 | /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=15684 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=15684
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='15684' 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='15684' 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=84389 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=84389
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=84390 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=84390
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='15684' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='15684' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='15684' AND status='1' AND (question like '%I list on-page optimization factors...%' OR question like '%list%' OR question like '%on-page%' OR question like '%optimization%' OR question like '%factors...%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='15684' AND status='1'
AND (question like '%I list on-page optimization factors...%' OR question like '%list%' OR question like '%on-page%' OR question like '%optimization%' OR question like '%factors...%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='5097' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='5097' 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 seoclerks.members WHERE USERID='873' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='873' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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=15684%' 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=15684%'
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='315856.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='315856.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 |
| Avg Time | Count | SQL | Max | Min |
plansmm
For on-page SEO, here's what you gonna do:
- Your main keyword must be present in the website's title tag, meta description (main keyword must be mentioned twice), and meta tags (you can do that with All-in-one SEO Wordpress plugin)
- Your main keyword must be present in your blog post's title
- Your main keyword must be present within the first and last 100 characters of your article or blog post
- Your main keyword must have a limit of 2% to 3% density, in which the number of main keyword mentions may vary on how many words do you have in an article or blog post. You can Google about calculating the keyword density
- Your main keyword must be present in your H1, H2 and H3 tags
- Within the article, your main keyword/s must have at least one bold, italic, underline, highlighted with hyperlink within your website, and highlighted with hyperlink that redirects them to an external source
- If you have an image within your blog post, insert your main keyword there in the ALT section of the image HTML (in Wordpress, you can switch the content section to HTML if you want)
- Don't just stick to your main keyword, you should have LSI keywords as well that are related to your main keyword (Google about LSI keywords)
- Don't put too much ads in your blog
- Most importantly, your article or blog post must be originally written and not copied from elsewhere.
- Your article or blog post must be more than 500 words Here's a simple understanding about both of them. On-page SEO is where you optimize your website within by doing SEO in your website's content, and off-page SEO is where you optimize your website outside of it by building relevant links. For on-page SEO, here's what you gonna do: - Your main keyword must be present in the website's title tag, meta description (main keyword must be mentioned twice), and meta tags (you can do that with All-in-one SEO Wordpress plugin) - Your main keyword must be present in your blog post's title - Your main keyword must be present within the first and last 100 characters of your article or blog post - Your main keyword must have a limit of 2% to 3% density, in which the number of main keyword mentions may vary on how many words do you have in an article or blog post. You can Google about calculating the keyword density - Your main keyword must be present in your H1, H2 and H3 tags - Within the article, your main keyword/s must have at least one bold, italic, underline, highlighted with hyperlink within your website, and highlighted with hyperlink that redirects them to an external source - If you have an image within your blog post, insert your main keyword there in the ALT section of the image HTML (in Wordpress, you can switch the content section to HTML if you want) - Don't just stick to your main keyword, you should have LSI keywords as well that are related to your main keyword (Google about LSI keywords) - Don't put too much ads in your blog - Most importantly, your article or blog post must be originally written and not copied from elsewhere. - Your article or blog post must be more than 500 words
Are you sure you want to delete this post?