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; }