URL: Http://www.jobbporten.se/sok-jobb/medicin-vard-omsorg/norge.htm?yk=11276&d=1 RemoteAddr: 54.81.166.199 RemoteHost: 54.81.166.199 Host: www.jobbporten.se Form: sok-jobb Felmeddelande: Kan inte öppna: SELECT distinct top 20 a.Rubrik, ar.Namn, a.plus, ar.Logotypfilnamn as Logotyp, case aas.namn when null then s.frannamn else aas.namn end as 'Från', dbo.fDate(a.Datuminlagd) as Datuminlagd, a.AnnonsID, a.OrginalSite, a.AnnatAnnonsID, substring(a.AgBeskrivning,1,350) as AgBeskrivning, substring(a.beskrivning,1,1500) as Beskrivning, a.url as url, a.sorteringsordning, aas.lankinnanid, aas.lankefterid FROM Annonser a with (nolock) JOIN Arbetsgivare ar with (nolock) ON a.ArbetsgivarID = ar.ArbetsgivarID JOIN AnnonserSiter ao with (nolock) ON a.AnnonsID=ao.AnnonsID and ao.siteid in (7) left outer JOIN Siter s on a.orginalsite=s.siteid join AndraAnnonsSiter aas on a.orginalsite=aas.id join annonseryrkeskategorier anyk with (nolock) on anyk.annonsid = a.annonsid join yrkeskategorier yk with (nolock) on anyk.yrkeskategoriid = yk.yrkeskategoriid and yk.yrkeskategoriid in ( :yk ) join yrkesgrupper yg with (nolock) on yk.yrkesgruppid = yg.yrkesgruppid join yrkeshuvudgruppyrkesgrupp hgyg with (nolock) on yg.yrkesgruppid = hgyg.yrkesgruppid and hgyg.yrkeshuvudgruppid in ( :hg ) join annonsergeografi ag with (nolock) on a.annonsid = ag.annonsid join geografinamngeografi gng with (nolock) on ag.geografiid = gng.geografiid and geografinamnid in ( :g ) WHERE a.datuminlagd<getdate() and a.inaktiv <> 1 order by a.plus desc, a.sorteringsordning, a.datuminlagd desc Params: yk=11276 d=1 design=jobbportense form=sok-jobb urlparam1=medicin-vard-omsorg urlparam2=norge urlparams=medicin-vard-omsorg/norge urlparamcount=2 SprakID=7 SiteID=7 hg=9 g=533 sqlcount0=46 hgnamn=medicin-vard-omsorg gnamn=norge Tid: 2014-11-25 23:51:12 URL: /sok-jobb/medicin-vard-omsorg/norge.htm FormParams: Hidden: _state=HEX09000000t62lsokr65s0400000001000000 Cookie: QueryFields: yk=11276 d=1 Method: GET UserAgent: CCBot/2.0 (http://commoncrawl.org/faq/) Date: 1899-12-29 ContentFields: CookieFields: ProtocolVersion: HTTP/1.0 PathInfo: /sok-jobb/medicin-vard-omsorg/norge.htm PathTranslated: C:\Inetpub\wwwroot\jobbportenSE\sok-jobb\medicin-vard-omsorg\norge.htm Authorization: CacheControl: Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 From: IfModifiedSince: 1899-12-29 Referer: ContentEncoding: ContentType: ContentLength: 0 ContentVersion: Content: Connection: DerivedFrom: Expires: 1899-12-29 Title: ScriptName: /sok-jobb/medicin-vard-omsorg/norge.htm ServerPort: 80 InternalPathInfo: /sok-jobb/medicin-vard-omsorg/norge.htm InternalScriptName: /sok-jobb/medicin-vard-omsorg/norge.htm Version: 0611221846 Files.count: 0