Úprava MySQL dotazu – Subquery returns more than 1 row

5. 12. 2015 10:47:13

Zdravím,

na localhostu, kde dotaz funguje, jsem si vytvořil mysql dotaz pro výpis hotelů a termínů v jednotlivých zemích. Na ostré mi mysql hlásí chybu: Subquery returns more than 1 row

Dokáže někdo upravit dotaz, aby fungoval správně? Jedná se o složený dotaz hned za prvním FROM

select 
	SQL_CALC_FOUND_ROWS t.id as t_id,
		date_format(t.date_from,"%e.%c.") as date_f,
		t.date_from,
		date_format(t.date_to,"%e.%c. %Y") as date_t,
		t.days,
		t.price,
		t.food,
		t.transport,
		t.discount,
		t.last_minute,
		t.id_hotel,
		t.days,
		t.url as t_url,
		h.id as h_id,
		h.name as h_name,
		h.main_image,
		h.stars,
		h.rating,
		h.rating_count,
		h.area,
		h.area_url,
		h.min_price,
		(select count(id) from tours where id_hotel = h.id) as count_tours
from 
		(select       h2.id,
			        h2.name,
				h2.main_image,
				h2.stars,
				h2.rating,
				h2.rating_count,
				h2.area,
				h2.area_url,
				h2.min_price,
				c2.id as cat_id,
				c2.name as c_name,
				c2.url as c_url,
				c2.level 
                 from 
                     hotels h2 
                     join 
                         categories_hotels ch2 on h2.id = ch2.id_hotel 
                     join categories c2 on ch2.id_category = c2.id where c2.id = 1 
                     order by h2.id desc limit 1,15) h 
	left join 
		tours t on h.id = t.id_hotel and t.id<=ifnull((select t2.id from tours t2 where t.id_hotel=t2.id_hotel order by t2.date_from desc limit 1,2),t.id) 
order by 
	h.id desc

5. 12. 2015 10:47:13