public function loadDataFromDatabaseEntries($section, $entry_ids)
{
try {
$data = parent::loadDataFromDatabaseEntries($section, $entry_ids);
$result = array();
$ids = array();
foreach ($data as $entry) {
if (is_null($entry->relation_id)) {
continue;
}
$ids[] = $entry->relation_id;
}
foreach ($this->{'related-fields'} as $related) {
$rows = Symphony::Database()->query("\n\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t`e`.*, r.entry_id AS `entry_id`, r.relation_id AS `relation_id`\n\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t`tbl_data_%s_%s` AS `e`\n\t\t\t\t\t\t\tLEFT OUTER JOIN\n\t\t\t\t\t\t\t\t`tbl_data_%s_%s` AS `r` ON (e.entry_id = r.relation_id)\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\te.entry_id IN (%s)\n\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\tr.entry_id IN (%s)\n\t\t\t\t\t\t", array($related[0], $related[1], $section, $this->{'element-name'}, implode(',', $ids), implode(',', $entry_ids)));
foreach ($rows as $r) {
$r->relation_field = $related;
$result[] = $r;
}
}
} catch (DatabaseException $e) {
$result = array();
}
return $result;
}
