Someone

SELECT cgs_order.*, cgs_payments.Status as payment_status
	FROM cgs_order
		LEFT JOIN cgs_payments ON cgs_order.reference=cgs_payments.VendorTxCode 	
	WHERE cgs_order.status = '1' ORDER BY cgs_order.status