m (610): Kielikahvila Maunulan kirjastossa keskiviikkoisin klo 11 / 2010-09-08 - 2010-12-08
s (611): Maunulan keskustan alueen ja Pakilantien suunnitelmat/2010-09-23 (17-19)
s (609): Aluefoorumi: Maunulan täydennysrakentamisen lähtökohdat ja ideat/2010-09-27 (18-20)
s (601): Kaupunginvaltuutetut tentattavana Saunabaarilla/2010-10-11 (18-20)
array (
'countall' => 4,
'counts' => 3,
'countm' => 1,
'requested_offsetdate' => '2010-09-03',
'real_offsetdate' => '2010-09-08',
'real_limitdate' => 0,
'direction' => 'ff',
'limit' => 10,
'eventid' =>
array (
0 => '610',
1 => '611',
2 => '609',
3 => '601',
),
's_greatest_start' => '2010-10-11',
's_earliest_start' => '2010-09-23',
's_smallest_end' => '2010-09-23',
's_greatest_end' => '2010-10-11',
'm_greatest_start' => '2010-09-08',
'm_earliest_start' => '2010-09-08',
'm_smallest_end' => '2010-12-08',
'm_greatest_end' => '2010-12-08',
)
----
string(661) "/ 1283893200 / 2010-09-07
/ / 0 / 1970-01-01
SELECT s.id_e as id_e,UNIX_TIMESTAMP(MAX(e_date)) as maxdate,UNIX_TIMESTAMP(MIN(e_date)) as mindate,a2.url as atturl,a2.substitute as attsubstitute,dpposition_name,dpposition_street,dpposition_lon,dpposition_lat,dpposition_zoom FROM jos_dpcal_schedule s LEFT JOIN jos_dpcal_date d ON s.id_d=d.id_d LEFT JOIN jos_dpcal_event ev ON s.id_e=ev.id_e LEFT JOIN jos_dpposition pos ON ev.dpposition_id=pos.dpposition_id LEFT JOIN jos_dpcal_event_attachment a1 ON s.id_e=a1.id_e LEFT JOIN jos_dpcal_attachment a2 ON a1.id_a=a2.id_a WHERE s.id_e IN (610,611,609,601) GROUP BY s.id_e ORDER BY mindate ASC"