dnd 5e – In D&D 5e is there a spell or ability that mimics the D&D 2e Priest spell Combine?

There is no such feature in 5th Edition.

I can’t properly prove this to you. But you can read through all of the class and subclass features of the 5e Cleric here and you will not find anything like this.

Additionally, there are no feats or magic items that interact with the cleric’s turn undead class feature in the way you are asking about.

Further, I am certain there are no abilities in 5e that allow you to temporarily increase your level or treat your level as though it was increased temporarily. Again, there is no way to prove this to you other than to say “go read all the source books, and note that no such feature exists.”

design – Best Architectural practices to combine Elasticsearch and Redis with MySQL


Multi-tenancy in 3 different layer

Database: MySQL with multi database (database per tenant)

Indexer: Elasticsearch

Queue and Database load helper: Redis


  1. We have chosen to work with database per tenant Architecture.
    However I Wonder How can I use this method in combination of Elasticsearch.
    Elasticsearch for Handling Data indexing for each tenant that might be used for some specific search functions cross tenants (Talking about millions of records for example 10000 tenant with 100-120 users in their table)
    but heavily used for each tenant search in its own data (Some of table in tenant database might reach to approximately 5 billion record for example tenant’s user log history)


1.1 What is the best way (In our case) to handle multi-tenancy with multi-database design to use Elasticsearch as the search engine behind our application?
1.2 What are the best tools and practices in designing an indexer system(any kind) and to have searching capability in billions of records?


  1. How can I use Redis in application level to support MySQL for Read/Write(Mostly Write) situation to queuing insert functions and calculation of some real-time changes without pushing load on MySQL server?


2.1 How can I use Redis in combination of multi-database system (Partitioning, clustering, etc.) to reach the best out of the box performance in application level?

2.2 what are the best solutions to mix Redis with such a system I have mentioned above?

grid – If it’s possible to combine plain and hierarchical view together?

I’m facing the issue of data representation. On the same page, it’s possible to view both plain and tree structure. It’s ok (tbh no, but we can live with it for a while), but when it comes to new object creation it feels like a duplication as it appears in two places.

  1. As nested object
  2. As an object in the list

Any idea how to solve it? How to get rid of the feeling of duplicated object? Keeping the plain and tree structure on the same page?


short gif

domain driven design – Pattern to combine orders from different systems

We have a legacy order system and a new order system that are both currently active. The legacy order system takes ‘offline’ orders still, the new order system handles ‘online’ orders but uses the legacy order system for operations, so the legacy system has both offline and online orders. Eventually, the new system will handle all orders, but won’t have historical orders in it.

I need a solution that can source order information from both systems and display in a single ‘my orders’ view for customers. There are a number of cases/rules where the source of the data depends on how the order was created, e.g. the delivery address will come from the legacy system if it was an offline order, but the new system if it was an online order, the billing entity will always come from the legacy system.

As we move functionality these rules will change, i.e. for certain types of offline orders, the delivery address needs to come from the new system regardless of origin.

In some cases, the data may not be in the legacy system, so will be blank, but populated in the new system, so we need defaults and/or fallback (“if not in legacy system, find in new system”) behaviour for some data, e.g. products.

Is there a design pattern for this type of aggregation of two sources of data that would minimise future development required as we shift the ‘source of truth’?

How combine these queries

Hi All,
Here are queries,
"select * from product WHERE LastName like concat(?, '%')"
"Select concat(FirstName, ' ' , LastName) as FullName, Product_id from Customer join product where customerId = id"
Above both queries working individually fine when I tried to combine these, I can't get any results.
I want to combine the above two queries, where the user gives input "Full Name" and it should display the result.

My second question is how to populate match results, I mean when users…

How combine these queries

magento2.3 – convert sql query to magento addFieldToFilter combine OR and AND

You can convert me this sql I did not arrive at combined OR and AND at the same time

SELECT * FROM sales_order AS main_table,
sales_order_payment AS sop
WHERE ((status = ‘processing’) Or
((status = ‘pending’) and (sop.method = ‘chekmo’) ))
AND (updated_at >= ‘2020-06-19 18:24:59’)

Please, can someone help or suggest anything?

laravel 5 – Combine array based on key in php

I want to combine 2 array in a array where matched item will set under a common array key. Here all items with same category will go under corresponding category.

$categories = category::where('cat_flag','Y')->pluck('id')->toArray();
$items = item::where('item_flag','Y')->get(('item_name','cat_id'))->toArray();

I want to format those into one array like below

$formatedArray = (

I have tried with this. I am realizing it’s not correct but could not made any solution how to achieve my goal.

$formatedArray = ();

        foreach ($categories as $cat){
            foreach ($items as $itm) {
                $formatedArray( $cat->id ) = $itm;

google sheets – Combine multiple tables into one table by matching the headers

I have two tables with the same header name. From this table I want to combine the data into
one into one table by matching the header names.

The matching header names are “Link”, “Review Date”, “Review Author”, “Review Remarks”.
The logic to combine data with these conditions that I catch like this:

#Search for column positions with a combination of REGEXMATCH:

=ArrayFormula(IF(REGEXMATCH('Multiple Table'!A2:Z2,"Link|ReviewsDate|ReviewsAuthor|ReviewsRemarks")=TRUE,COLUMN('Multiple Table'!A2:Z2),""))

#Change the column into a range with ADDRESS formula :

=ArrayFormula(IF(REGEXMATCH('Multiple Table'!A2:Z2,"Link|ReviewsDate|ReviewsAuthor|ReviewsRemarks")=TRUE,ADDRESS(2,COLUMN('Multiple Table'!A2:Z2)),""))

#Looking for a range with a multiple of four,
The range that should be taken is A2:D, F2:D

#Then to combine the data just enter the range A2:D and F2:D into the QUERY formula.

For the third step, I’m still confused about the formulation.

So I used a formula that wasn’t dynamic yet, like this:

= QUERY ({'Multiple Tables'! A3: E; 'Multiple Tables'! F3: J}, "SELECT Col1, Col2, Col3, Col5 WHERE Col1 <> ''")

Spreadsheet File.

entities – Combine fields from many nodes within a custom controller (Drupal 8 or 9)

I’m going this route as I can’t get a view to behave as needed.

In simple terms I have

content type 1 containing custom field 1 with a custom formatter

content type 2 containing custom field 2 with a custom formatter

content type 3 containing custom field 3 with a custom formatter

Each node will display correctly using the formatter if the node is viewed directly so I’m happy with that, however for some of the pages I need to display I need to use all (or partial) content from these content types as a single “entity”. What I’m trying to do is generate a response that in effect wrap the output of all 3 sets of fields into a single output that can then be pushed back into Drupal’s normal page processing so that other modules can work on the aggregated output before the HTML rendering phase. Additionally, if possible I’d like to be able to use different formatters other than the field default for the fields depending on the use context so a web page used the default formatter, a rest feed used formatter 2, an XML feed used formatter 3

I’m using Drupal 8.9 but will soon be going 9

Combine Multiple Minimal Perfect Hashing

I’m building some Minimal Perfect Hash from multiple datasets using the CHD algorithm

I would like to know if there exists a "smart" way to combine all the different MPH obtained from previous steps and use them to build a new one at minimal cost.