See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
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
|SQL Select Query help||3||31|
|Help with stripping out character in SQL LEFT/RIGHT/REPLACE||2||12|
|Fixed Length SQL Query Question||3||9|
|How can I use one field instead of another in an SQL query when conditions apply||12||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!