Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
SELECT customers_name, customers_telephone, GROUP_CONCAT(products_name, ' ', LEFT(products_options_values, 4) SEPARATOR ' - ') AS products_bought FROM orders LEFT JOIN orders_products ON orders.orders_id = orders_products.orders_id LEFT JOIN cc ON orders_products.orders_id = cc.order_id LEFT JOIN orders_products_attributes ON cc.order_id = orders_products_attributes.orders_id WHERE cc.payment_status = 'completed' AND orders.orders_id >10000 GROUP BY customers_name
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!