m (254): Lainaa liikuntavälineitä maksutta Herttoniemessä ja Roihuvuoressa / 2010-09-04 - 2020-12-29
m (529): NA Hertsika / 2010-09-04 - 2011-01-31
m (521): Herttoniemen kyläjuhlat / 2010-09-04 - 2010-09-05
s (614): Vasemmisto pyöräilee hiilineutraalin Helsingin puolesta/2010-09-04 (11-16)
m (591): Muskarit aloittavat syyskuussa Herttoniemen leikkipuistossa / 2010-09-09 - 2010-12-09
m (594): SPR Ystävätoiminnan peruskurssi / 2010-09-13 - 2010-09-23
array (
'countall' => 6,
'counts' => 1,
'countm' => 5,
'requested_offsetdate' => '2010-09-04',
'real_offsetdate' => '2010-09-04',
'real_limitdate' => 0,
'direction' => 'ff',
'limit' => 10,
'eventid' =>
array (
0 => '614',
1 => '521',
2 => '529',
3 => '254',
4 => '591',
5 => '594',
),
's_greatest_start' => '2010-09-04',
's_earliest_start' => '2010-09-04',
's_smallest_end' => '2010-09-04',
's_greatest_end' => '2010-09-04',
'm_greatest_start' => '2010-09-13',
'm_earliest_start' => '2010-09-04',
'm_smallest_end' => '2010-09-05',
'm_greatest_end' => '2020-12-29',
)
----
string(669) "/ 1283547600 / 2010-09-03
/ / 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 (614,521,529,254,591,594) GROUP BY s.id_e ORDER BY mindate ASC"