order-summary.sql

SELECT o.id_order,
       d.id_design,
       d.id_product,
       fl.label                              as label,
       layer_lang.label                      as selected,
       CONCAT('https://myshop/', dp.preview) as image
FROM `pr_orders` o
         JOIN `pr_productdesigner_design` d ON o.id_cart = d.id_cart
         JOIN pr_customized_data cd ON cd.value = d.id_design
         JOIN pr_customization c ON c.id_customization = cd.id_customization AND c.in_cart
         JOIN `pr_productdesigner_design_layer` dl ON dl.id_design = d.id_design
         JOIN `pr_productdesigner_layer_group` lg ON lg.id_layer_group = dl.id_layer_group
         JOIN `pr_productdesigner_layer_group_lang` lg_lang
              ON lg_lang.id_layer_group = lg.id_layer_group AND lg_lang.id_lang = 1
         JOIN `pr_productdesigner_layer` layer ON layer.id_layer = dl.id_layer
         JOIN `pr_productdesigner_layer_lang` layer_lang
              ON layer_lang.id_layer = layer.id_layer AND layer_lang.id_lang = 1
         LEFT JOIN `pr_productdesigner_design_preview` dp ON dp.id_design = d.id_design
         LEFT JOIN pr_dynamicproduct_field f ON f.id_product = d.id_product AND f.name = lg_lang.label
         LEFT JOIN pr_dynamicproduct_field_lang fl ON fl.id_field = f.id_field AND fl.id_lang = 1
WHERE o.id_order = 768;