SELECT
t.transaction_id, IFNULL(payments.trans_count, 0) AS trans_count,
CONCAT(cl.firstName, ' ', cl.lastName) as full, t.transaction_no,
COUNT(p.model_id) as qty, ps.unitPrice, ps.promoPrice, COUNT(p.qr_code) as stock,
	SUM(ps.unitPrice) as one, SUM(ps.promoPrice) as two, t.transaction_date, t.skip,
    payments.payment_method, payments.bank_name, payments.check_no, payments.check_date, payments.payment_amount
FROM transactions as t
LEFT JOIN product_sales as ps ON t.transaction_no = ps.transaction_no
LEFT JOIN product as p ON ps.product_id = p.product_id
LEFT JOIN (
	SELECT COUNT(pay.transaction_id) AS trans_count, pay.transaction_id, pay.payment_method, pay.bank_name, pay.check_no, pay.check_date, pay.payment_amount
	FROM payments as pay
	GROUP BY pay.transaction_id
) payments ON payments.transaction_id = t.transaction_id
LEFT JOIN client as cl ON t.client_id = cl.client_id
WHERE p.prod_active = 1 AND p.prod_status = 1 AND p.prod_owned = 1 AND p.tran_status = 1 AND ps.status = 1
AND p.model_id = 1 AND p.container_id = 1
GROUP BY t.transaction_id