| 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='10132' | 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='10132'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='4987' | 1 | SELECT * FROM seoclerks.members WHERE USERID='4987'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=4987 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=4987
| /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=10132 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=10132
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10132' 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='10132' 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=39605 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=39605
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='10132' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='10132'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='10132' AND status='1' AND (question like '%Is Meta Tag Description useful?%' OR question like '%Meta%' OR question like '%Description%' OR question like '%useful?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='10132' AND status='1'
AND (question like '%Is Meta Tag Description useful?%' OR question like '%Meta%' OR question like '%Description%' OR question like '%useful?%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='337' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='337' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='1677' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1677' 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='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=10132%' 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=10132%'
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()
|
TommyCarey
By doing this I can normally get ranked for lower difficulty keywords fairly easy. For the higher, more difficult, keywords it takes more than a little trick here and there. You'll have to sit down and write, or type up, a detailed plan of attack with a timeline and stick to it.
The meta description tag is there for the search engine spiders to come in and see exactly what your website is about. If you add the wrong keywords and text to your description tag you're most likely just going to be kicking yourself later on down the road. Set your meta description tag right the first time and it will treat you well for years down the road, unless you want to change it for some reason.
Whenever I'm using a meta description tag I'll always get my keyword in there once or twice, like I said previously. I'll also focus on my title tag as well because it's like a one two punch to the search engine spiders and really lets them know what your website is about. If I'm trying to brand my website right off the start I'll also throw my domain into the title and description tags just so I'm almost guaranteed to show up when I search for my business name in a week or so after the search engines start to show me some love
Thanks,
Razzy Whenever I'm using a description tag I always try to get my keywords in there once or twice just in case Google, Yahoo! or Bing use my tag as what's shown in the search results ;) By doing this I can normally get ranked for lower difficulty keywords fairly easy. For the higher, more difficult, keywords it takes more than a little trick here and there. You'll have to sit down and write, or type up, a detailed plan of attack with a timeline and stick to it. The meta description tag is there for the search engine spiders to come in and see exactly what your website is about. If you add the wrong keywords and text to your description tag you're most likely just going to be kicking yourself later on down the road. Set your meta description tag right the first time and it will treat you well for years down the road, unless you want to change it for some reason. Whenever I'm using a meta description tag I'll always get my keyword in there once or twice, like I said previously. I'll also focus on my title tag as well because it's like a one two punch to the search engine spiders and really lets them know what your website is about. If I'm trying to brand my website right off the start I'll also throw my domain into the title and description tags just so I'm almost guaranteed to show up when I search for my business name in a week or so after the search engines start to show me some love :D Thanks, Razzy
Are you sure you want to delete this post?