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