SELECT 
		stream_rate_tbl.value 	AS media_stream_rate, 
		media_type_tbl.value 	AS media_type, 
		channel.channel_id,
		channel.media_type		as media_type_short 
	FROM 
		channel, common_values AS stream_rate_tbl, common_values AS media_type_tbl 
	WHERE 
		station_id=2944 AND stream_rate_tbl.name=channel.media_stream_rate AND media_type_tbl.name=channel.media_type 
	LIMIT 0,1
<BR>
Table './newrt/channel' is marked as crashed and should be repaired