Chyba SQL<br /><br /><p>
		select
			h.id, 
			h.id_menu, 
			h.id_up, 
			h.sort, 
			h.type, 
			h.module,
			date_format(h.date,'%d.%m. %Y')date_f,
			id_user,
			l.title, 
			l.description, 
			l.keyword,
			u.url,
			c.id_foto, 
			f.uniq_name, 
			f.f_ext,
			d.data 
		from	
			s_headers AS h
					  LEFT OUTER JOIN s_headers_lang l ON h.id = l.id_header
					  LEFT OUTER JOIN s_headers_url u ON h.id = u.id_header
					  LEFT OUTER JOIN s_control_data d ON h.id = d.id_header
					  LEFT OUTER JOIN s_control_fotos c  ON h.id = c.id_header and c.id_foto = (select id_foto from s_control_fotos where id_header = h.id order by main desc limit 1)
					  LEFT OUTER JOIN s_store_fotos f ON f.id = c.id_foto
		where 
			(h.id_up=1540)
			AND (l.lang = 'cz')
			AND (d.lang = 'cz')
			AND h.type = 'page'
			AND h.public = 1
			AND ((h.date >= 'all-01-01') AND (h.date <= 'all-12-31'))
			group by h.id
			order by h.sort, h.date desc, h.id desc
			
	</p>Incorrect DATE value: 'all-01-01'