| 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='29365' | 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='29365'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='863560' | 1 | SELECT * FROM seoclerks.members WHERE USERID='863560'
| /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=863560 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=863560
| /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=29365 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=29365
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29365' 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='29365' 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=188747 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=188747
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29365' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29365'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='29365' AND status='1' AND (question like '%I Spanish language site Colombia ..........should I seek Spanish Language SEO services %' OR question like '%Spanish%' OR question like '%language%' OR question like '%site%' OR question like '%Colombia%' OR question like '%..........should%' OR question like '%seek%' OR question like '%Spanish%' OR question like '%Language%' OR question like '%services%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29365' AND status='1'
AND (question like '%I Spanish language site Colombia ..........should I seek Spanish Language SEO services %' OR question like '%Spanish%' OR question like '%language%' OR question like '%site%' OR question like '%Colombia%' OR question like '%..........should%' OR question like '%seek%' OR question like '%Spanish%' OR question like '%Language%' OR question like '%services%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' 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 seoclerks.members WHERE USERID='297' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='297' 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=29365%' 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=29365%'
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
Seeking sites in spanish to get your links on will help you a lot if they're related to SEO. You can also get your links on high DA sites that will help you boost your rankings globally and target local businesses to boost your local rankings.
Never turn away a good link even if it's not related to your niche or is in a different language lol
The rule of thumb is to get high quality content on 3rd party sites that are related to yours. Since you're running an SEO service in Columbia then you'll want to get your backlinks from those types of websites, but that's easier said than done. Since the sites you're targeting are aware of how SEO works, and they're likely selling the same thing, you likely won't get a link from them. Instead, you should target web design companies in Columbia, marketing blogs in Columbia, and anything else that is similar to the SEO niche where you can find it. As long as is relatable, you're getting quality content and backlinks on their pages, then you should be good to go
Try avoiding the use of any software to build links but you can use software to find the links and then do some manual outreach. i like using Scrapebox to find links and then I'll contact the blog or website owners about submitting guest posts for them in exchange for a backlink. They get high quality content that would normally cost them $100-$200 on any marketplace and I'm getting a lifetime backlink that will help boost my rankings over time. The longer you do this, the more benefit you will gain, and the higher your rankings will go.
Remember, SEO compiles and the more quality work you do for your pages the better it will be in the long run. Don't take any shortcuts or buy into "#1 rankings guaranteed" type pitches because it could seriously hurt the work you've been doing already
Are you sure you want to delete this post?