URL: Http://www.medrek.se/jobb/undersköterska/övriga/karlskrona.htm? RemoteAddr: 54.83.231.24 RemoteHost: 54.83.231.24 Host: www.medrek.se Form: jobb Felmeddelande: Kan inte öppna: SELECT count(a.annonsid), sum(a.antalplatser) FROM Annonser a with (nolock) where a.annonsid in (select a.annonsid from annonser a with (nolock) JOIN Arbetsgivare ar ON a.ArbetsgivarID = ar.ArbetsgivarID left outer join anvandarefavoritannonser fa on a.annonsid = fa.annonsid JOIN AnnonserSiter ao on a.AnnonsID = ao.AnnonsID and ao.SiteID = 1 WHERE a.datuminlagd<getdate() and a.inaktiv=0 and a.skoljobb = 1 and a.annonsid in ( select annonsid from annonseryrkeskategorier with (nolock) where yrkeskategoriid in ( :yk ) and select annonsid from annonseryrkeskategorier with (nolock) where yrkeskategoriid in (select yrkeskategoriid from yrkeskategorier with (nolock) where yrkesgruppid in ( :yg )) intersect select annonsid from annonserord with (nolock) where ordid in (select id from ord with (nolock) where ord like :sokordlike1 ) )) Params: design=medrekdesign form=jobb urlparam1=undersköterska urlparam2=övriga urlparam3=karlskrona urlparams=undersköterska/övriga/karlskrona urlparamcount=3 SprakID=1 SiteID=1 g_beskrivning=Karlskrona yg=0 yg_text=övriga yk=8 yk_text=undersköterska soktext=karlskrona dointersect=T Tid: 2014-07-22 09:18:50 URL: /jobb/undersköterska/övriga/karlskrona.htm FormParams: Hidden: Cookie: QueryFields: Method: GET UserAgent: CCBot/2.0 (http://commoncrawl.org/faq/) Date: 1899-12-29 ContentFields: CookieFields: ProtocolVersion: HTTP/1.0 PathInfo: /jobb/undersköterska/övriga/karlskrona.htm PathTranslated: C:\Inetpub\wwwroot\medrekSE\jobb\undersköterska\övriga\karlskrona.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: /jobb/undersköterska/övriga/karlskrona.htm ServerPort: 80 InternalPathInfo: /jobb/undersköterska/övriga/karlskrona.htm InternalScriptName: /jobb/undersköterska/övriga/karlskrona.htm Version: 0611221846 Files.count: 0