URL: Http://www.medrek.dk/job/SOSU-assistenter/Øvrige/Grønland.htm? RemoteAddr: 54.226.148.122 RemoteHost: 54.226.148.122 Host: www.medrek.dk Form: job 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 = 2 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=job urlparam1=SOSU-assistenter urlparam2=Øvrige urlparam3=Grønland urlparams=SOSU-assistenter/Øvrige/Grønland urlparamcount=3 SprakID=2 SiteID=2 yg=3 yg_text=Øvrige yk=258 yk_text=SOSU-assistenter g=27 g_text=Grønland g_beskrivning=Grønland dointersect=T Tid: 2014-07-31 19:33:05 URL: /job/SOSU-assistenter/Øvrige/Grønland.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: /job/SOSU-assistenter/Øvrige/Grønland.htm PathTranslated: C:\Inetpub\wwwroot\medrekDK\job\SOSU-assistenter\Øvrige\Grønland.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: /job/SOSU-assistenter/Øvrige/Grønland.htm ServerPort: 80 InternalPathInfo: /job/SOSU-assistenter/Øvrige/Grønland.htm InternalScriptName: /job/SOSU-assistenter/Øvrige/Grønland.htm Version: 0611221846 Files.count: 0