SELECT total ,lkh_address_email ,min(o.id) as order_id ,from_unixtime(o.date) FROM `orders` AS o LEFT JOIN users AS u ON o.user_id = u.id WHERE o.date > 1446336000 AND NOT EXISTS(SELECT * FROM orders WHERE user_id = o.user_id AND date < 1446336000 ) GROUP BY o.user_id SELECT total ,u.lkh_address_email ,min(o.id) as order_id ,from_unixtime(o.date) u.lkh_short_customer_name u.customer_id FROM `orders` AS o LEFT JOIN users AS u ON o.user_id = u.id WHERE (o.date > 1414800000 AND o.date < 1427155200) AND NOT EXISTS(SELECT * FROM orders WHERE user_id = o.user_id AND date < 1414800000 ) GROUP BY o.user_id

http://dba.stackexchange.com/questions/24908/select-limit-1-per-column-value

SELECT total ,u.lkh_address_email ,min(o.id) as order_id ,from_unixtime(o.date) ,u.lkh_short_customer_name ,u.customer_id ,f.invoice FROM `orders` AS o LEFT JOIN users AS u ON o.user_id = u.id LEFT JOIN customer_firstinvoice AS f ON u.lkh_short_customer_name = f.customer WHERE (o.date > 1446336000) AND NOT EXISTS(SELECT * FROM orders WHERE user_id = o.user_id AND date < 1446336000 ) AND (UNIX_TIMESTAMP(STR_TO_DATE(f.invoice, '%Y%m%d')) > o.date) GROUP BY o.user_id SELECT total ,u.lkh_address_email ,min(o.id) as order_id ,from_unixtime(o.date) ,u.lkh_short_customer_name ,u.customer_id ,f.invoice FROM `orders` AS o LEFT JOIN users AS u ON o.user_id = u.id LEFT JOIN customer_firstinvoice AS f ON u.lkh_short_customer_name = f.customer WHERE (o.date > 1414800000 AND o.date < 1427155200) AND NOT EXISTS(SELECT * FROM orders WHERE user_id = o.user_id AND date < 1414800000 ) AND (UNIX_TIMESTAMP(STR_TO_DATE(f.invoice, '%Y%m%d')) > o.date) GROUP BY o.user_id 24.03.16

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024