SELECT
  `o`.`id`                                               AS `id`,
  concat(`ud`.`name`, ' ', `ud`.`surname`)               AS `user`,
  `ud`.`name`                                            AS `name`,
  `ud`.`surname`                                         AS `surname`,
  `u`.`email`                                            AS `email`,
  `o`.`orderDate`                                        AS `orderDate`,
  `o`.`lastUpdate`                                       AS `lastUpdate`,
  concat(`ol`.`productId`, '-', `ol`.`productVariantId`) AS `product`,
  `s`.`title`                                            AS `shop`,
  `os`.`title`                                           AS `status`,
  `o`.`status`                                           AS `statusCode`,
  `opm`.`name`                                           AS `payment`,
  `ols`.`title`                                          AS `orderLineStatus`,
  `pb`.`name`                                            AS `productBrand`
FROM ((((((((((`Order` `o`
  JOIN `User` `u`) JOIN `UserDetails` `ud`) JOIN `OrderPaymentMethod` `opm`) JOIN `OrderStatus` `os`) JOIN
  `OrderStatusTranslation` `oshl`) JOIN `OrderLine` `ol`) JOIN `Shop` `s`) JOIN `OrderLineStatus` `ols`) JOIN
  `Product` `p`) JOIN `ProductBrand` `pb`)
WHERE ((`o`.`userId` = `u`.`id`) AND (`ud`.`userId` = `u`.`id`) AND (`o`.`orderPaymentMethodId` = `opm`.`id`) AND
       (`o`.`status` = `os`.`code`) AND (`o`.`status` LIKE 'ORD%') AND (`oshl`.`orderStatusId` = `os`.`id`) AND
       (`ol`.`orderId` = `o`.`id`) AND (`s`.`id` = `ol`.`shopId`) AND (`ol`.`productId` = `p`.`id`) AND
       (`ol`.`productVariantId` = `p`.`productVariantId`) AND (`p`.`productBrandId` = `pb`.`id`) AND
       (`ol`.`status` = convert(`ols`.`code` USING utf8)))