WordPress database error: [Table 'wp_bas_refer' is marked as crashed and should be repaired]
SELECT referer_id FROM wp_bas_refer WHERE referer_string = '';

WordPress database error: [Duplicate entry '187469' for key 1]
INSERT INTO wp_bas_refer (referer_string) VALUES ('');

WordPress database error: [Table 'wp_bas_ua' is marked as crashed and should be repaired]
SELECT ua_id FROM wp_bas_ua WHERE ua_string = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)';

WordPress database error: [Duplicate entry '189021' for key 1]
INSERT INTO wp_bas_ua (ua_string) VALUES ('CCBot/1.0 (+http://www.commoncrawl.org/bot.html)');

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1568, , '2010-09-08 02:27:52')' at line 1]
INSERT INTO wp_bas_visitors (visit_ip, referer, osystem, useragent, lasthere) VALUES (644595567, , 1568, , '2010-09-08 02:27:52');

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND referer = referer_id AND osystem = os_id AND useragent = ua_id' at line 1]
SELECT * FROM wp_bas_visitors, wp_bas_refer, wp_bas_ua, wp_bas_os WHERE visit_id = AND referer = referer_id AND osystem = os_id AND useragent = ua_id

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '2010-09-08 02:27:52', 0, 1000)' at line 1]
INSERT INTO wp_bas_log (visit, stamp, outbound, page) VALUES (, '2010-09-08 02:27:52', 0, 1000);

Where have I Been?? New SEO Job in Norway! » SEO Bomb Blog

Where have I Been?? New SEO Job in Norway!

Filed Under: SEO

So yeah, This blog haven’t recived a lot of attention lately. The reason is that I moved back to Norway and started working for the best SEO company there, so my time as SEO in the gambling industry and Bodog is probably over. Unless, of course some one hires my new company to work with them.

It was kinda funny, cause before I left Vancouver, I sent an email to a handful, carefully selected SEO companies in Norway - all of which I got an interview with, and I ended up with two great offers as senior SEO dude. Both companies were on the top of my list, namely Synlighet and Online Services.

I chose Synlighet as they simply gave me the best offer, and they seem to be a really great bunch of guys - and girls.

But I am amazed at both how little knowledge many of these so-called SEO companies in Norway have. Some of them even have to resolve to PPC ads in Google to even be visible on the Norwegian SEO terms - and we’re talking about as little as 143 000 competing pages in the SERPS!

And that’s very typical fo rthe Norwegian market - so few competing sites, going from the extremely competitive search market as online gambling, it will almost seem like a walk in the park. At least some times.

And that may in fact be one of the main reason why many Norwegian SEOs arent exactly super skilled - lack of competition and experience.

Anyway…I promise I’ll try and update more often, so hang in there. One thing I am thinking about writing an article about is how to optimize and automate basically everything for an apartment rantal site. The same strategy can be used for virtually any database driven solution, like an online store.

The Rentsline project was done together with my buddy Denis Sjuhduzlk..Shuhppalo..Sh….I can never get his last name right (same goes for most people with both my first and last name, thus my nickname Sweater).

Regardless difficulties with pronouncing names, Denis is an incredibly talented guy, and he’s got his own blog up and running here, with some imagery and sample logos for the Rentsline site.

Sverre Sjøthun

Digg this entry! Delicious this!

No Comments so far
Leave a comment

TrackBack URI

Leave a comment
Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

(required)

(required)





Syndicate this site
Syndicate this site using RSS   Add this Feed to My Yahoo! Add this Feed to Bloglines!   Add this Feed to My MSN!    Add this Feed to Google Reader! Add this site to Delicious   Add this to Furl
Search SEO Bomb Blog


Recent SEO Bomb Blog posts

SEO Bomb på norsk - Søkemotoroptimalisering