Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
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
|free version of MSSQL for over 10GB DB||19||60|
|How do I subtract date and time within a same column in SQL||4||36|
|How to update the value of duplicated records (except latest one)||2||18|
|Querying data from 3 SQL tables||2||31|