public static function get_meta_relations_1($metadata_id, $metadata_id1)
{
global $dbconnection;
$query = "select \n metadata_relation.metadata_field_id1,\n metadata_relation.metadata_field_id2\n from \n metadata_relation, \n metadata_table as metadata_table1, \n metadata_field as metadata_field1, \n metadata_table as metadata_table2, \n metadata_field as metadata_field2\n where \n metadata_relation.metadata_field_id1 = metadata_field1.id and \n metadata_field1.metadata_table_id = metadata_table1.id and \n metadata_table1.metadata_id = {$metadata_id} and \n metadata_relation.metadata_field_id2 = metadata_field2.id and \n metadata_field2.metadata_table_id = metadata_table2.id and \n metadata_table2.metadata_id = {$metadata_id1}\n ";
$result = $dbconnection->do_query_meta_response($query);
$fields = array();
while ($myrow = mysql_fetch_array($result)) {
$fields[] = array($myrow["metadata_field_id1"], $myrow["metadata_field_id2"]);
}
$relations = array();
foreach ($fields as $field) {
$relations[] = query::get_meta_relations_2($field[0]) . " = " . query::get_meta_relations_2($field[1]);
}
return $relations;
}
