Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Execution timeout expired.
Select 10 AS Average_Rating,
1000 AS Vote_Count,
h.HauntName, h.City, h.hauntedHouseId
From HauntedHouse h
Where h.HauntedHouseId IN (0,1,14,39,100,102,143,229,250,266,293,325,367,476,559,620,626,743,793,811,839,853,971,1066,1091,1167,1169,1238,1253,1291,1292,1547)
And h.State = 'NM'
UNION
Select Avg(v.Rating) AS Average_Rating,
Count(v.HauntedHouseId) AS Vote_Count,
h.HauntName, h.City, h.hauntedHouseId
From Voting v, HauntedHouse h
Where v.HauntedHouseId = h.HauntedHouseId
And h.HauntedHouseId NOT IN (0,1,14,39,100,102,143,229,250,266,293,325,367,476,559,620,626,743,793,811,839,853,971,1066,1091,1167,1169,1238,1253,1291,1292,1547)
And h.Approved = 1
And v.Confirmed = 1
And h.State = 'NM'
And v.Rating NOT IN (0,1,2)
And v.VoteActive = 1
Group By h.HauntedHouseId, h.HauntName, h.City
UNION
Select 0 AS Average_Rating, 0 AS Vote_Count,
h.HauntName, h.City, h.hauntedHouseId
From HauntedHouse h
Where h.Approved = 1
And h.HauntedHouseId NOT IN
(Select DISTINCT h.HauntedHouseId
From Voting v, HauntedHouse h
Where v.HauntedHouseId = h.HauntedHouseId
And h.Approved = 1
And v.Confirmed = 1
And h.State = 'NM'
And v.VoteActive = 1)
And h.State = 'NM'
Order By Average_Rating DESC, Vote_Count DESC, HauntName
Haunted Houses in New Mexico | New Mexico Haunted Houses
Haunted House Directory: Haunted House Ratings is the best online directory for Halloween Haunted Houses!
From New York City to Dallas Fort Worth Texas, Atlanta Georgia to Los Angeles California, You Vote, We display the results!
|
|
|
 |