URL: Http://www.medrek.se/jobb/Tandvård/Estland.htm?

RemoteAddr: 38.107.179.214
RemoteHost: 38.107.179.214

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 distinct 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 
(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=Tandvård
urlparam2=Estland
urlparams=Tandvård/Estland
urlparamcount=2
SprakID=1
SiteID=1
yg=16
yg_text=Tandvård
g=101
g_text=Estland
g_beskrivning=Estland
dointersect=T

Tid: 2012-05-27 02:01:33
URL: /jobb/Tandvård/Estland.htm
FormParams: 
Hidden: 
Cookie: 
QueryFields: 
Method: GET
UserAgent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Date: 1899-12-29
ContentFields: 
CookieFields: 
ProtocolVersion: HTTP/1.1
PathInfo: /jobb/Tandvård/Estland.htm
PathTranslated: C:\Inetpub\wwwroot\medrekSE\jobb\Tandvård\Estland.htm
Authorization: 
CacheControl: no-cache
Accept: text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
From: 
IfModifiedSince: 1899-12-29
Referer: 
ContentEncoding: 
ContentType: 
ContentLength: 0
ContentVersion: 
Content: 
Connection: close
DerivedFrom: 
Expires: 1899-12-29
Title: 
ScriptName: /jobb/Tandvård/Estland.htm
ServerPort: 80
InternalPathInfo: /jobb/Tandvård/Estland.htm
InternalScriptName: /jobb/Tandvård/Estland.htm
Version: 0611221846
Files.count: 0