|
|
|
|
Uusimmat jutut
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 4Kaikki kauden 2009-2010 uutiset
select galleria.id as id, galleria.title as title, galleria.date as date, galleria.published as published, galleria.include_html as include_html, galleria.file_path as file_path from galleria where published < now() order by date desc, published desc 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 from ottelu where date_time > now() and home_team = 'Honka' order by date_time limit 1
Tilaa liput täältä
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
Syyskuu 2010
| M | T | K | T | P | L | S |
|---|
| 1 | 2 | 3 | 4 | 5 |
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 |
|
|
|
|
