URL: Http://www.medrek.se/jobb/Lediga vikariat/Sjuksköterska/Stockholm.htm? RemoteAddr: 54.91.47.154 RemoteHost: 54.91.47.154 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 annonsergeografi with (nolock) where geografiid in (select geografiid from geografinamngeografi with (nolock) where geografinamnid in ( :g )) )) Params: design=medrekdesign form=jobb urlparam1=Lediga vikariat urlparam2=Sjuksköterska urlparam3=Stockholm urlparams=Lediga vikariat/Sjuksköterska/Stockholm urlparamcount=3 SprakID=1 SiteID=1 yg=2 yg_text=Sjuksköterska yk=1089 yk_text=Lediga vikariat g=12 g_text=Stockholm g_beskrivning=Stockholm dointersect=T Tid: 2014-10-31 21:27:11 URL: /jobb/Lediga vikariat/Sjuksköterska/Stockholm.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/Lediga vikariat/Sjuksköterska/Stockholm.htm PathTranslated: C:\Inetpub\wwwroot\medrekSE\jobb\Lediga vikariat\Sjuksköterska\Stockholm.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/Lediga vikariat/Sjuksköterska/Stockholm.htm ServerPort: 80 InternalPathInfo: /jobb/Lediga vikariat/Sjuksköterska/Stockholm.htm InternalScriptName: /jobb/Lediga vikariat/Sjuksköterska/Stockholm.htm Version: 0611221846 Files.count: 0