public static function get_query_relations($fields, $tables)
{
$relations = query::get_relations($fields);
$query_relation = array();
foreach ($relations as $relation) {
//build query relations
$field1 = "";
$field2 = "";
foreach ($fields as $field) {
if ($field->id * 1 === $relation->metadata_field_id1 * 1) {
$field1 = $field;
}
if ($field->id * 1 === $relation->metadata_field_id2 * 1) {
$field2 = $field;
}
}
$table1 = "";
$table2 = "";
foreach ($tables as $table) {
if ($table->id * 1 === $field1->metadata_table_id * 1) {
$table1 = $table;
}
if ($table->id * 1 === $field2->metadata_table_id * 1) {
$table2 = $table;
}
}
$query_relation[] = $table1->name . ".`" . $field1->name_in_table . "` = `" . $table2->name . "`." . $field2->name_in_table;
}
return $query_relation;
}
