select uutinen.id as id, uutinen.title as title, uutinen.date as date, uutinen.published as published, uutinen.galleria_id as galleria_id, uutinen.file_loc as file_loc, uutinen.video as video from uutinen where published <= now() and date <= now() order by date desc, published desc limit 4
Voit lähestyä meitä myös oheisen palautelomakkeen kautta.
Vastaamme saatuun viestiin mahdollisimman pian!
Seuraava kotiottelu
select ottelu.id as id, ottelu.date_time as date_time, ottelu.published as published, ottelu.location as location, ottelu.home_team as home_team, ottelu.away_team as away_team, ottelu.result as result, ottelu.extra_info as extra_info, ottelu.uutinen_id as uutinen_id, ottelu.galleria_id as galleria_id, ottelu.video_id as video_id from ottelu where date_time > now() and home_team = 'Honka' order by date_time limit 1
select ottelu.id as id, ottelu.date_time as date_time, ottelu.published as published, ottelu.location as location, ottelu.home_team as home_team, ottelu.away_team as away_team, ottelu.result as result, ottelu.extra_info as extra_info, ottelu.uutinen_id as uutinen_id, ottelu.galleria_id as galleria_id, ottelu.video_id as video_id, day(date_time) as day from ottelu where month(date_time) = month(now()) and date_time > '2010-07-01' order by date_time