Chillcode

Hi @dngraphisme Go to Shop Parameters->Product configuration and check discounts per product not per combination and try again.

Hi, As i understand what PS is doing is taking in consideration the specific price for combination and ignoring the all combinations one? I think PS will always do that...

You can also add the price per each combination, so then you really get control of each specific price. What I usually do is create a specific price per each...

hi @cruftex In MariaDB, you can use aliases when performing a delete statement by following this syntax: `docker exec -it temptest mysql --password=my-secret-pw mysql -e 'delete xy from slow_log xy...

Hi @cruftex MariaDB uses the same documentation, also from the link you posted: `Any of SQL expression that can be calculated from a single row fields is allowed. Subqueries are...

Here you have more info related to this: https://github.com/doctrine/dbal/pull/4472 https://github.com/doctrine/dbal/issues/4448 https://github.com/doctrine/dbal/issues/2297

@cruftex If the following command works on your MariaDB there is no much left to say about this, and it means alias are valid to use: `docker exec -it temptest...

The issue reported, as mentioned is because this code: ``` private function removeRestrictionsByName(CartRuleId $cartRuleId, string $entityName) { $this->connection->createQueryBuilder() ->delete($this->dbPrefix . 'cart_rule_' . $entityName, 'crc') ->where('crc.id_cart_rule = :cartRuleId') ->setParameter('cartRuleId', $cartRuleId->getValue()) ->execute()...

Yes, also this one: [removeRestrictedCartRules](https://github.com/PrestaShop/PrestaShop/blob/45bea4e71205f7d85fc2a0c56606c84bd052dda3/src/Adapter/CartRule/Repository/CartRuleRepository.php#L433-L441) Searched through all PS code and those are the only ones using alias. Thanks @nicosomb

Make sure to delete the alias from the where clause also. Thanks!