sorted.........:)

should it all be in one query?
You can do it in 2 steps:

1. SELECT room_Type FROM your_table_name WHERE day_Num >= '25' and day_Num <= '27' and qty = '0';

Then analize this query result in prog. language that you use, create variables with values "double" and "ensuite". Use this variables to construct the second query.

2. SELECT * FROM your_table_name WHERE room_Type != 'double' and room_Type != 'ensuite' ORDER BY qty LIMIT 1