URL: Http://www.jobbporten.se/sok-jobb/kontor.htm?d=1 RemoteAddr: RemoteHost: Host: www.jobbporten.se Form: sok-jobb Felmeddelande: Kan inte öppna: SELECT distinct top 1 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 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 ) WHERE a.datuminlagd<getdate() and a.inaktiv <> 1 order by a.plus desc, a.sorteringsordning, a.datuminlagd desc Params: d=1 design=jobbportense form=sok-jobb urlparam1=kontor urlparams=kontor urlparamcount=1 SprakID=7 SiteID=7 hg=4 sqlcount0=1 hgnamn=kontor Tid: 2017-07-22 22:37:39 URL: /sok-jobb/kontor.htm FormParams: Hidden: _state=HEX09000000t62lsokr65s0400000001000000 Cookie: QueryFields: 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/kontor.htm PathTranslated: C:\Inetpub\wwwroot\jobbportenSE\sok-jobb\kontor.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/kontor.htm ServerPort: 80 InternalPathInfo: /sok-jobb/kontor.htm InternalScriptName: /sok-jobb/kontor.htm Version: 0611221846 Files.count: 0