| 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='29167' | 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='29167'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='855096' | 1 | SELECT * FROM seoclerks.members WHERE USERID='855096'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=855096 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=855096
| /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=29167 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=29167
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29167' 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='29167' 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=188407 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=188407
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=188411 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=188411
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29167' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29167'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='29167' AND status='1' AND (question like '%9 tips awesome SEO-friendly blog post%' OR question like '%tips%' OR question like '%awesome%' OR question like '%SEO-friendly%' OR question like '%blog%' OR question like '%post%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29167' AND status='1'
AND (question like '%9 tips awesome SEO-friendly blog post%' OR question like '%tips%' OR question like '%awesome%' OR question like '%SEO-friendly%' OR question like '%blog%' OR question like '%post%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='147' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='1364' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1364' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='7' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='7' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='6070' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6070' 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=29167%' 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=29167%'
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='855096.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='855096.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()
|
TommyCarey
Using keywords in your headings is nice to do, no matter if it's your H1 or H6, because the search engines will love that. You're telling people what they're about to read and you're letting the search engines know the importance of that section on your website or blog post
The length of the article will always vary depending on where it's going on your website, but for blog posts, you'll want to take your time and write a decent amount of content in order to please the readers as well as the search engines. I try to keep my blog posts over 1,000 words and I try to target 2,000+ words so I'm sure the content is informative and keeps people on my pages longer lol
Interlinking to previous content is a big thing if you want all of your pages to get indexed. You're basically backlinking your own blog posts and giving the search engines a path to see all of your content. There are Wordpress plugins that allow you to type in a keyword, add a blog post URL, and it will turn that word into a hyperlink to that specific page so you don't have to worry about going through and interlinking every single article. I've used it many times, and love it, but I can't remember the name lol.
This discussion was well written, I just wish you had written it yourself :'( I totally agree with the "Think Before You Write" part of this, as well as many others because when I'm writing content for my websites or a client I will always write down a basic structure of the article I have in mind and expand on key points. I prefer using smaller paragraphs, 2-3 sentences long because they don't get readers fatigued and they are able to stick on the page longer than if I wrote a legitimate paragraph with 5-6 sentences. Using keywords in your headings is nice to do, no matter if it's your H1 or H6, because the search engines will love that. You're telling people what they're about to read and you're letting the search engines know the importance of that section on your website or blog post :D The length of the article will always vary depending on where it's going on your website, but for blog posts, you'll want to take your time and write a decent amount of content in order to please the readers as well as the search engines. I try to keep my blog posts over 1,000 words and I try to target 2,000+ words so I'm sure the content is informative and keeps people on my pages longer lol :D Interlinking to previous content is a big thing if you want all of your pages to get indexed. You're basically backlinking your own blog posts and giving the search engines a path to see all of your content. There are Wordpress plugins that allow you to type in a keyword, add a blog post URL, and it will turn that word into a hyperlink to that specific page so you don't have to worry about going through and interlinking every single article. I've used it many times, and love it, but I can't remember the name lol. This discussion was well written, I just wish you had written it yourself :'(
Are you sure you want to delete this post?